PRODUCTION ISSUE: Can entity.categoryId be overwritten in stead of appending it in the file upload

[RiekieB]

Similar products are returning incorrect recommendations (not similar at all) because, every time we upload a csv feed, it adds categories to the products.  Is there a way to overwrite entity.categoryId in stead of appending it to the file upload?  This is affecting our production environment.

[skandg43264764 · Accepted solution]

@RiekieB 

Categories is a cumulative field so values passed in this field keeps adding to it.

You need to remove the product from the catalog in order to get rid of the old value and then when the feed will be processed, only new values will start flowing in category field.

[RiekieB]

Thanks for your comment @skandg43264764. The problem is that it is thousands of products and you can only delete them one by one if you don't want to affect the recommendations by deleting the whole catalogue. It would have been nice if there was an easier way to do this and not impact production recommendations.