I am importing multiple products using a csv file. The products have a Product Category that is already set up in the crm. When I import a product from csv with a Product Category that doesn’t exist, the system creates the new Product Category. How do I stop this?
For example if I have a product Nikon Camera which has been assigned to the Camera product category in SuiteCRM. If I import a Kodak Camera using a csv which has a product category of Photographic Equipment I want it to throw an error as the Photographic Equipment Category does not exist.
If you want to stick to CSV imports, then you could split things up into two files:
Product categories: A clean CSV with only the categories you want to create inside your CRM
Producs: A clean CSV with the correct categories which exist already and empty cells for those products without a category
Depending on how often you need to do this and how many records you have, I’d aim for an integration.
There, you’d be able to build up exactly the logic that you’re describing.
Check out my videos on SuiteCRM + n8n where I show similar things: