Product Sync.
Opencart products: 28
Input products: 100
NEW: 101397899
NEW: 101397999
NEW: 101398099
NEW: 101398199
NEW: 101398299
NEW: 101398399
NEW: 101398499
NEW: 101398599
NEW: 101398699
NEW: 101398799
NEW: 101398899
NEW: 101398999
NEW: 101399099
NEW: 101399199
NEW: 101399299
NEW: 101399399
NEW: 101399499
NEW: 101399599
NEW: 101399699
NEW: 101399799
NEW: 101399899
NEW: 101399999
NEW: 101400099
NEW: 101400199
NEW: 101400299
NEW: 101400399
NEW: 101400499
NEW: 101400599
NEW: 101400699
NEW: 101400799
NEW: 101400899
NEW: 101400999
NEW: 101401099
NEW: 101401199
NEW: 101401299
NEW: 101401399
NEW: 101401499
NEW: 101401599
NEW: 101401699
NEW: 101401799
NEW: 101401899
NEW: 101401999
NEW: 101402099
NEW: 101402199
NEW: 101402299
NEW: 101402399
NEW: 101402499
NEW: 101402599
NEW: 101402699
NEW: 101402799
NEW: 101402899
NEW: 101402999
NEW: 101403099
NEW: 101403199
NEW: 101403299
NEW: 101403399
NEW: 101403499
NEW: 101403599
NEW: 101403699
NEW: 101403799
NEW: 101403899
NEW: 101403999
NEW: 101404099
NEW: 101404199
NEW: 101404299
NEW: 101404399
NEW: 101404499
NEW: 101404599
NEW: 101404699
NEW: 101404799
NEW: 101404899
NEW: 101404999
NEW: 101405099
NEW: 101405199
NEW: 101405299
NEW: 101405399
NEW: 101405599
NEW: 101405699
NEW: 101405799
NEW: 101405899
NEW: 101405999
NEW: 101406099
NEW: 101406199
NEW: 101406299
NEW: 101406399
NEW: 101406599
NEW: 101406699
NEW: 101406799
NEW: 101406899
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 101407099
NEW: 101407199
NEW: 101407299
NEW: 101407399
NEW: 101407499
NEW: 101407699
NEW: 101407899
NEW: 101407999
NEW: 101408099
Ok.
Product Option Sync.
Opencart products: 28
Input products: 100
SELECT option_id FROM oc_option_description
WHERE
NAME = 'Opção'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27382
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101406999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1766
UPDATE oc_option_value_description
SET
name = '101406999 - CXA CARTAO AGUAR W&N ECON C/12 TUBOS DE 12ML + ACESS'
WHERE
option_value_id = 1766
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1766
DELETE FROM oc_product
WHERE
model = '101406999'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1766,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101407599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1767
UPDATE oc_option_value_description
SET
name = '101407599 - CXA ACRILICO V GOGH ANIVERSARIO 12 TB 40ML'
WHERE
option_value_id = 1767
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1767
DELETE FROM oc_product
WHERE
model = '101407599'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1767,
quantity = 1,
subtract = 1,
price = 32.764,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.