When a product is "out of stock", some suppliers don't list it in the csv anymore.
In the import process, if you flag the option "delete products not listed in the csv" all the products not listed in the csv are deleted from the database.
BUT it can generate problems if someone does multiple import (many suppliers and many csv files) because after the import also the products of the other suppliers will be deleted.
The right solution is to allow to delete missing products, but for a certain supplier only.
New
1 vote
Vote
Reply
6 Answers
Mar 28, 2016
Alex Pryshlivskiyagentwrote
Thanks for suggestion, Alessandro
In this case as a quick decision -
please tryto do the following:
------------------
1 - import CSV 1 with option - "do nothing"
1 - import CSV 2 with option - "do nothing"
2... import CSN -n.... etc.
last step - when last import will be finished - run auto execute SQL with scheduled task
you should use something like tihs -
Disable all products (set = 0) WHERE update date is not current ( this date from current import)
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
After import, allow to delete missing products for a certain supplier only
After import, allow to delete missing products for a certain supplier only