update low_stock_date
作成日 差分は期限切れになりません
7 削除
| 行 | |
|---|---|
| 合計 | |
| 削除 | |
| 文字 | |
| 合計 | |
| 削除 | |
9 追加
| 行 | |
|---|---|
| 合計 | |
| 追加 | |
| 文字 | |
| 合計 | |
| 追加 | |
UPDATE `cataloginventory_stock_item`
UPDATE `cataloginventory_stock_item`
SET `low_stock_date` = IF((use_config_notify_stock_qty = 1
SET `low_stock_date` = IF((use_config_notify_stock_qty = 1
AND qty < 3)
AND qty < 3)
OR (use_config_notify_stock_qty = 0
OR (use_config_notify_stock_qty = 0
AND qty < notify_stock_qty), '2020-11-18 22:02:11', NULL)
AND qty < notify_stock_qty), '2020-11-18 22:25:38', NULL)
WHERE (website_id = 0
WHERE (website_id = 1)
AND ((use_config_manage_stock = 1
AND (product_id IN
AND 1 = 1)
OR (use_config_manage_stock = 0
AND manage_stock = 1))
AND product_id IN
(SELECT `catalog_product_entity`.`entity_id`
(SELECT `catalog_product_entity`.`entity_id`
FROM `catalog_product_entity`
FROM `catalog_product_entity`
WHERE (type_id IN('simple',
WHERE (type_id IN ('simple',
'virtual',
'virtual',
'downloadable'))))
'downloadable'))))
AND ((use_config_manage_stock = 0
AND manage_stock = 1)
OR use_config_manage_stock = 1)