Help with datable triggers. Update ps_products after ps_stock_available has been updated.

[psyho997]

We do use linnworks to sync all the inventory in all our channels .

 

The problem is with their prestashop integration - it is very basic and does not work very well.

When the quantities are updated it is only updating  the ps_stock_available table for each SKU.

Unfortunately prestashop is keeping the "parent" price and quantity - summary quantity in table ps_products

 

I do need someone to create a trigger that will update the summary quantity in table ps_products after the ps_stock_available will be updated by linnworks.

 

Regards

Robert

 

[psyho997]

Problem solved with the proper script.

Thank you .