Product Sync.
Opencart products: 310
Input products: 1
NEW: Galeria W&N 120ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Galeria W&N 120ml - %'
)
Ok.
Product Option Sync.
Opencart products: 311
Input products: 1
SELECT option_id FROM oc_option_description
WHERE
NAME = 'Opção'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27708
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27708,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100009099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1032
UPDATE oc_option_value_description
SET
name = '100009099 - ACRIL GALER 120ML MARS BLACK Test'
WHERE
option_value_id = 1032
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 546
AND product_id = 27708
AND option_id = 17
AND option_value_id = 1032
DELETE FROM oc_product
WHERE
model = '100009099'
INSERT INTO oc_product_option_value
SET
product_option_id = 546,
product_id = 27708,
option_id = 17,
option_value_id = 1032,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.