Product Sync.
Opencart products: 220
Input products: 100
NEW: 102650999
NEW: 102651099
NEW: 102651199
NEW: 102651299
NEW: 102651399
NEW: 102651499
NEW: 102651599
NEW: 102651699
NEW: 102651799
NEW: 102651899
NEW: 102651999
NEW: 102652099
NEW: 102652199
NEW: 102652299
NEW: 102652399
NEW: 102652499
NEW: 102652599
NEW: 102652699
NEW: 102652799
NEW: 102652899
NEW: 102652999
NEW: 102653099
NEW: 102823899
NEW: 102919399
NEW: 102919499
NEW: 102919599
NEW: 102919699
NEW: 102919799
NEW: 102919899
NEW: 102919999
NEW: 102920099
NEW: 102920199
NEW: 102920299
NEW: 102920399
NEW: 10700099
NEW: 120513100
NEW: 120513500
NEW: 120514200
NEW: 120514700
NEW: 12056399
NEW: 121003000
NEW: 121110079
NEW: 121110479
NEW: 121111879
NEW: 121112679
NEW: 121113279
NEW: 122015699
NEW: 122053521
NEW: 122053821
NEW: 122055221
NEW: 122055321
NEW: 122055721
NEW: 122055921
NEW: 122056021
NEW: 140101200
NEW: 140101300
NEW: 140101700
NEW: 140102000
NEW: 142030199
NEW: 142500600
NEW: 142510200
NEW: 146501004
NEW: 149022699
NEW: 149035500
NEW: 149035800
NEW: 149036600
NEW: 149036799
NEW: 149036800
NEW: 149037500
NEW: 149037600
NEW: 149037800
NEW: 149039600
NEW: 149081799
NEW: 162542000
NEW: 170603699
NEW: 173022891
NEW: 173026298
NEW: 200604267
NEW: 200902061
NEW: 201515880
NEW: 201515980
NEW: 201516080
NEW: 201526921
NEW: 201527021
NEW: 201527121
NEW: 201527221
NEW: 201527321
NEW: 201527421
NEW: 201527721
NEW: 201535261
UPDATING: Aguarela Líquida Ecoline
Product ID: 27449
Image file:
NEW: 202101886
NEW: 204506524
NEW: 204506624
NEW: 204506724
NEW: 204506824
NEW: 204506924
NEW: 204508628
NEW: 204508728
Ok.
Product Option Sync.
Opencart products: 220
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 = 27449
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '201863198 - %'
UPDATE oc_option_value
SET
image = 'catalog/201863198.jpg'
WHERE
option_value_id = 942
UPDATE oc_option_value_description
SET
name = '201863198 - Aguarela Ecoline Talens 25 - 30 ml Branco'
WHERE
option_value_id = 942
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 942
DELETE FROM oc_product
WHERE
model = '201863198'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 942,
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 '201867898 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 943
UPDATE oc_option_value_description
SET
name = '201867898 - Aguarela Ecoline Talens 25 - 30 ml Ouro Ocre 231'
WHERE
option_value_id = 943
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 943
DELETE FROM oc_product
WHERE
model = '201867898'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 943,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.