event import

hi
I import 17000 products successfully. my problem is:
I want to automatically disable all existing products in my database before importing a new product file.
how to do it ?
Thank you

Topic

[ibratsiloModerator]

Hi, thanks for your question.

You can simply execute query which will update oro_product table and set status to all records as disabled. The simplest way will be to add this logic to some command or controller action and execute it when you need (before next import).

For automatic triggering this logic one of the options you can apply is to extend Oro\Bundle\ImportExportBundle\Controller\ImportExportController::importProcessAction and add your custom logic at the beginning.

Regarding event there are a lot different events in ImportExporBundle, but after small investigation I did not find which can fit your needs 100%. Because actually import is executed as delayed process and it is done on consumer level, so I did not find event which is triggered right after Import start.

But you certainly can use some, such as Oro\Bundle\ImportExportBundle\Event\StrategyEvent::PROCESS_BEFORE. Be aware that such event is triggered for each entity (import row) before processed so need to added some flag (property) which will guarantee update logic executes once.

[msalmi.kaisParticipant]

Thanks for your help.
I will try

[Author]

Replies