Product Sync.
Opencart products: 127
Input products: 1
UPDATING: Van Gogh 40ml
Product ID: 27115
Image file: Van Gogh 40ml.jpg
Ok.
Product Option Sync.
Opencart products: 127
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 = 27115
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479835999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1248
UPDATE oc_option_value_description
SET
name = '479835999 - ACRIL VAN GOGH T9-40ML AZL PRUSIA FTALO'
WHERE
option_value_id = 1248
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 277
AND product_id = 27115
AND option_id = 15
AND option_value_id = 1248
DELETE FROM oc_product
WHERE
model = '479835999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 277
AND product_id = 27115
AND option_id = 15
AND option_value_id = 1248
Ok.