Dev information about category mapping via CSV

Internal only.

The other support/troubleshooting article - https://support.omnivore.com.au/how-to-bulk-category-mapping-using-a-csv

This FAQ has extra info from dev relating to fixes to do with bulk mapping.

This info is from Radu regarding cat mapping via csv.

It was after an issue was found and fixed.

Also see ticket 99112.

This info is from Ivan on ticket number 167291.

Made the following changes, adding FAQ needed due to this new behaviour.

Several things were going wrong here. First, the user was trying to upload 9000 product mappings at a time, which basically resulted in a database lock up, hence lack of mappings on products

Second, it kicked off a map products job regardless, which then fired off a full validate for all products for all marketplaces. Not a massive issue unless you're Go Slash with 134,000 products and you're trying to push them to Trade Me, which is slow as, bro.

Changes made:

Only does an incremental mapping for the products that have changed - let me know if that works or not, should do

Will reject files of greater than 5000 mappings

Will write into the site's audit log for Support to see, for the situation either way

Will only do it for the specified marketplace

Go Slash gets this pig-in-a-python issue every once in a while, and it's when their usual processing gets stopped in favour of a full product revalidate. This was causing that, and we now have a backlog of jobs. Can't kill them. The pig has to move through the python. There should be fewer pigs in that python in future.

avoid mapping for all products and for all active marketplaces since the user has just uploaded a set of mappings for a single marketplace

Limit to 5000 mappings maximum to avoid database lockup, and add audit alerting if failed