[solved] SQL query for update stock

[electrical-store]

Hi

 

I am trying to update the stock on my website with SQL query but it is not working.

 

This is what I have:

 

 

UPDATE ps_product

SET

quantity = [{NewQuantity}],

date_upd = '[{dProcessedOn}]'

WHERE reference = '[{ChannelSKU}]';

--GO;--

UPDATE ps_product_attribute

SET

quantity = '[{NewQuantity}]'

WHERE reference = '[{ChannelSKU}]';

 

Can someone tell me what I am doing wrong.

 

Thanks in advance.

[vekia]

what prestashop version you use?

[electrical-store]

Hi

 

I am using the newest version and have solved the issue.

 

 

UPDATE

`ps_stock_available` AS sa

INNER JOIN `ps_product` AS p on p.id_product = sa.id_product

SET

sa.quantity = CONVERT('[{NewQuantity}]', signed integer),

p.quantity = CONVERT('[{NewQuantity}]', signed integer)

WHERE p.reference = '[{ChannelSKU}]'

--GO;--

UPDATE ps_product_attribute

SET

quantity = CONVERT('[{NewQuantity}]', signed integer)

WHERE reference = '[{ChannelSKU}]';

 

This seems to be working thanks.

[vekia]

hello

 

thanks for sharing the solution, i can go ahead and mark this thread as solved

 

regards