Resolved comparison and automatic updating of the products

Hello,

I wanted to know if there is an automatic method that allows CSVI to compare the old with the new price list, eliminating the products that are not produced by us and instead updating the same products.

CSVI cannot do comparison but if it finds the required field values matching the records in the database it would just do an update else will create a new record. If you are looking for removing certain products, you can set Unpublish products before import to yes, So all the products are set to unpublished state before doing the import and when you do the import, the products in your import file will get published automatically. Then you can export products which are in unpublished state, add a field product_delete with value Y and import back, this will remove the products with unpublished state. Hope this is what you wanted to do.

Hello Tharuna, I make a list of what you have written hoping that he understood.
1) Should I put as unpublished (suspended) all items in the catalog.
2) Import the catalog with the option that the imported articles are published.
3) Items that have not been updated (because there are no more on the catalog) will remain unpublished and can then be deleted.
did I get it right ?
then I ask you:
1) which option must be activated in CSV improved because imported products being automatically published? Until now the catalog that I imported had always unpublished products.
2) The field product_delete, with value Yes, where it is inserted? In the template, in the catalog, where?

Thanks for the answers.

Hello,

1) Should I put as unpublished (suspended) all items in the catalog.

No, if you set the option Unpublish before import to yes in template on options tab, CSVI will change products to unpublished automatically before starting the import.

2) Import the catalog with the option that the imported articles are published.

By default during import CSVI will publish the products.

3) Items that have not been updated (because there are no more on the catalog) will remain unpublished and can then be deleted.
did I get it right ?

Yes, thats correct.

1) which option must be activated in CSV improved because imported products being automatically published?

As explained above, you set the option Unpublish before import to yes in template on options tab, CSVI will do the unpublish automatically before starting the import.

Until now the catalog that I imported had always unpublished products.

You may be having the field published set to 0 in your import file, I am not sure about this as you have not provided me your import file to check.

2) The field product_delete, with value Yes, where it is inserted? In the template, in the catalog, where?

It should be included in your import file. You can simply include it as Y instead of Yes.

Hello,

As explained above, you set the option Unpublish before import to yes in template on options tab, CSVI will do the unpublish automatically before starting the import.

you're referring to this option: Photos (Option_Tab) attached

You may be having the field published set to 0 in your import file, I am not sure about this as you have not provided me your import file to check.

you're referring to this option: Photos (Ordinamento) attached
The file that I use to import the products is attached to my first post


thanks Tharuna

Hello,

As explained above, you set the option Unpublish before import to yes in template on options tab, CSVI will do the unpublish automatically before starting the import.

you're referring to this option: Photos (Option_Tab) attached

Yes i was referring to this option. Set this to Yes and CSVI will automatically unpublish products before doing importing.

You may be having the field published set to 0 in your import file, I am not sure about this as you have not provided me your import file to check.

you're referring to this option: Photos (Ordinamento) attached
The file that I use to import the products is attached to my first post

No i didnt refer to the one in the Photos (Ordinamento). i checked your file and i dont see any field for publish or unpublish a product, by default during import CSVI will automatically publish the products which are in the import file. If that is not the case do send me your debug log and I will check.