After import, allow to delete missing products for a certain supplier only

After import, allow to delete missing products for a certain supplier only

Avatar image
Mar 28, 2016
Alessandro Flajs wrote
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
Avatar image
Mar 28, 2016
Alex Pryshlivskiy agent wrote
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)

Avatar image
Apr 20, 2016
Alessandro Flajs wrote
Hi Sergiy, I read now your answer!
Thank you very much for your suggestion!
Custom SQL is only in professional version, isn't it?
Avatar image
Apr 21, 2016
Alex Pryshlivskiy agent wrote

Good day, Alessandro!
Here it is a screenshot.

You need to select - Addons - Show Scheduled Tasks - Add task -

After that Select - "Automated Backup & Script Execution"

Create your Custom SQL to modify product status according to Add date or Modify date

Avatar image
Apr 21, 2016
Alessandro Flajs wrote
Thank you. But do I need professional version of Store Manager to do it?
Avatar image
Apr 21, 2016
Alex Pryshlivskiy agent wrote
yes, this option is available for PRO version of Store Manager of PrestaShop.
see screenshot
Apr 27, 2016
System wrote
Hello,

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