I know this thread seems a bit old, but to me it’s hot item.
First off, best wishes to you and the ones you love.
I’ve been working on this problem last year and now I’ve made a fresh start make it work.
I have the following code, which works fine for the combination quantities.
UPDATE `databasename`.`psh_product_attribute` ,
`databasename`.`StockJunck` SET `quantity` = `STOCK AMOUNT` WHERE `psh_product_attribute`.`reference` = `StockJunck`.`ARTICLE NR`;
UPDATE `databasename`.`psh_stock_available` ,
`databasename`.`psh_product_attribute` SET `psh_stock_available`.`quantity` = `psh_product_attribute`.`quantity` WHERE `psh_stock_available`.`id_product_attribute` = `psh_product_attribute`.`id_product_attribute`
(‘ StockJunck’ is a table I update with a downloadable csv-file)
However, as you stated, the total amount doesn’t seem to add up and PS isn’t repairing itself.
How can I integrate your solution into this code?
I would appreciate it very much.