Product Sync.
Opencart products: 30
Input products: 100
NEW: 201527321
NEW: 201527421
NEW: 201527721
NEW: 201535261
UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:
NEW: 202101886
NEW: 204506524
NEW: 204506624
NEW: 204506724
NEW: 204506824
NEW: 204506924
NEW: 204508628
NEW: 204508728
NEW: 204508828
NEW: 204508928
NEW: 204509428
NEW: 204509628
NEW: 204509728
NEW: 204511528
NEW: 204511628
NEW: 204511728
NEW: 206670421
NEW: 207201598
NEW: 208108499
NEW: 208703867
NEW: 208705467
NEW: 210550099
NEW: 210550299
NEW: 210550499
NEW: 210550699
NEW: 210550899
NEW: 210551099
NEW: 210562299
NEW: 210563499
NEW: 210563699
NEW: 211506100
NEW: 211506200
NEW: 211506300
NEW: 211506400
NEW: 211506500
NEW: 211506700
NEW: 211507200
NEW: 211507300
NEW: 211507400
NEW: 211510800
NEW: 211510900
NEW: 211511000
NEW: 211511500
NEW: 211511600
NEW: 211517600
NEW: 211549500
NEW: 211576100
NEW: 211690351
NEW: 211690451
NEW: 211690551
NEW: 211690651
NEW: 211690751
NEW: 211690951
NEW: 211691051
NEW: 211691151
NEW: 211691651
NEW: 211692051
NEW: 211694751
NEW: 211695528
NEW: 211810076
NEW: 211810176
NEW: 211810276
NEW: 211810376
NEW: 211810476
NEW: 211810576
NEW: 211810676
NEW: 211810776
NEW: 211810876
NEW: 211810976
NEW: 211811076
NEW: 211823776
NEW: 211823976
NEW: 211824176
NEW: 211824751
NEW: 211853599
NEW: 212112567
NEW: 212120628
NEW: 212121571
NEW: 212121671
NEW: 212137028
NEW: 212137228
NEW: 212137328
NEW: 212137428
NEW: 212180440
NEW: 215267200
NEW: 215267500
NEW: 215274100
NEW: 215274200
NEW: 215277900
NEW: 215278000
NEW: 215278100
NEW: 215278200
NEW: 215278300
NEW: 215288600
Ok.
Product Option Sync.
Opencart products: 30
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 = 27391
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '201863198 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 942
UPDATE oc_option_value_description
SET
name = '201863198 - AGUAR ECOLINE TALENS 25-30 ML BCO'
WHERE
option_value_id = 942
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
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 = 384,
product_id = 27391,
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 - AGUAR ECOLINE TALENS 25-30 ML OURO'
WHERE
option_value_id = 943
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
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 = 384,
product_id = 27391,
option_id = 17,
option_value_id = 943,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.