Set the stock to 0 for all product combinations that do not have an image Safety step: preview affected rows with a SELECT
|
|
SELECT sa.id_product, sa.id_product_attribute FROM ps_stock_available sa JOIN ps_product_attribute pa ON pa.id_product_attribute = sa.id_product_attribute LEFT JOIN ps_product_attribute_image pai ON pai.id_product_attribute = pa.id_product_attribute WHERE pai.id_image IS NULL AND sa.id_product_attribute <> 0; |
Correct UPDATE query: set stock to 0 for combinations without an image
|
|
UPDATE ps_stock_available sa JOIN ps_product_attribute pa ON pa.id_product_attribute = sa.id_product_attribute LEFT JOIN ps_product_attribute_image pai ON pai.id_product_attribute = pa.id_product_attribute SET sa.quantity = 0, sa.out_of_stock = 0 WHERE pai.id_image IS NULL AND sa.id_product_attribute <> 0; |
How to Find Lire la suite