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
INSERT INTO oc_product_option
SET
product_id = 27115,
option_id = 15,
value = '',
required = 1
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 y'
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'
INSERT INTO oc_product_option_value
SET
product_option_id = 277,
product_id = 27115,
option_id = 15,
option_value_id = 1248,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.