search

dweeves / magmi-git

Magmi GitHub
364 stars 307 forks source link

Remove product category associations #453

Open T4ngml opened 8 years ago

T4ngml commented 8 years ago

I'd like to remove products association to categories when these get inactive. I'd also like not to associate "Not visible indivually" products to any category at creation

I tried to do that by adding a column category_ids for which I send an empty value. It didn't work, so I also tried this by setting a category_reset column, with value 1. No more luck...

Do I miss something here ?

Thanks

dweeves commented 8 years ago

Hi,

to do so:

put a category_reset column (or generate it via value replacer) with value 1 inside.

It will remove the categories from product before assigning it.

It the category_ids is empty or not set , then it won't assign any categories to the product which is what you want.

2016-05-27 11:43 GMT+02:00 schwipps notifications@github.com:

I'd like to remove products association to categories when these get inactive. I'd also like not to associate "Not visible indivually" products to any category at creation

I tried to do that by adding a column category_ids for which I send an empty value. It didn't work, so I also tried this by setting a category_reset column, with value 1. No more luck...

Do I miss something here ?

Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dweeves/magmi-git/issues/453, or mute the thread https://github.com/notifications/unsubscribe/AB3Vq1AKzhPRlWfNJkjKNqEjIcYLWg9lks5qFrzLgaJpZM4IoVtN .

T4ngml commented 8 years ago

Thanks ! Once I've corrected my script, and updated magmi, this seems to work : the category are now correctly set/unset. However, it throws a warning at every single product I update with category_id : MAGMI_IGNORE : "Invalid category ids found for sku ...". Can I get rid of this warning ?

dweeves commented 8 years ago

if you remove category_id column, this won't happen. just that i supposed you use a value replacer formula to set __MAGMI_IGNORE__ for items with category_reset=1

2016-05-27 17:03 GMT+02:00 schwipps notifications@github.com:

Thanks ! Once I've corrected my script, and updated magmi, this seems to work : the category are now correctly set/unset. However, it throws a warning at every single product I update with category_id : _MAGMIIGNORE : "Invalid category ids found for sku ...". Can I get rid of this warning ?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dweeves/magmi-git/issues/453#issuecomment-222170350, or mute the thread https://github.com/notifications/unsubscribe/AB3VqxbKli0Hajdm-sKI0Uf8xfoYNADdks5qFwe-gaJpZM4IoVtN .

T4ngml commented 8 years ago

Well, it seems to throw warnings anyway.

Here is my file structure for product desactivation : "sku";"status";"category_reset" "347802";"2";"1"

I also tried with the default value setter instead of adding the category_reset in the csv. I tested it with a product for which the category already set or not. The result is the same.

Anyway, do these warning impact performance ?