Hi!
Since I haven't had an answer to my topic since last friday --maybe because I added too many sub-topics to it in the late questions. I decided to post in separate topics.
Lately what I wanted to do was to update the products already in the database with additional categories --because almost all products belong to many categories (usually up to 3) and not just one.
So I analized the exported CSV file of a products which I added manually and had these 3 categories, and saw that the categories are expressed as these columns:
products.product_id
products_to_categories[1].product_id (same number that in "product.product_id")
products_to_categories[1].category_id (additional category 1)
products_to_categories[2].product_id (same number that in "product.product_id")
products_to_categories[2].category_id (additional category 2)
products_to_categories[3].product_id (same number that in "product.product_id")
products_to_categories[3].category_id (additional category 3)
But I get an error message, no matter if have the 1st column action set as update or as insert:
"
Total loaded: 6594. Updated: 0. Created: 3035. Errors: 3559
There are some errors. Show details
Warning: Update products. All columns are keys, update action is not allowed. Please use insert.
"
I tried with a CSV that had update in al cells of the 1st columns action.
Then I tried with a CSV that had insert in all cells of the 1st columns action.
I attach samples of both options.
Thanks!