Product Sync.
Opencart products: 26
Input products: 100
NEW: 101205599
NEW: 101205699
NEW: 101205799
NEW: 101205899
NEW: 101205999
NEW: 101206099
NEW: 101206199
NEW: 101206299
NEW: 101206399
NEW: 101206499
NEW: 101206599
NEW: 101206699
NEW: 101206799
NEW: 101206899
NEW: 101206999
NEW: 101207099
NEW: 101207199
NEW: 101207299
NEW: 101207399
NEW: 101207499
NEW: 101207599
NEW: 101207699
NEW: 101207799
NEW: 101207899
NEW: 101207999
NEW: 101208099
NEW: 101208199
NEW: 101208299
NEW: 101208399
NEW: 101208499
NEW: 101208599
NEW: 101208699
NEW: 101208799
NEW: 101208899
NEW: 101208999
NEW: 101209099
NEW: 101209199
NEW: 101209299
NEW: 101209399
NEW: 101209499
NEW: 101209599
NEW: 101209699
NEW: 101209799
NEW: 101209899
NEW: 101209999
NEW: 101210099
NEW: 101210199
NEW: 101210299
NEW: 101210399
UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:
NEW: 101210699
NEW: 101210799
NEW: 101210899
NEW: 101210999
NEW: 101211099
NEW: 101211199
NEW: 101211299
NEW: 101211399
NEW: 101211499
NEW: 101211599
NEW: 101211699
NEW: 101211799
NEW: 101211899
NEW: 101211999
NEW: 101212099
NEW: 101212199
NEW: 101212299
NEW: 101212399
NEW: 101212499
NEW: 101212599
NEW: 101212699
NEW: 101212799
NEW: 101212899
NEW: 101212999
NEW: 101213099
NEW: 101213199
NEW: 101213299
NEW: 101213399
NEW: 101213499
NEW: 101213599
NEW: 101213699
NEW: 101213799
NEW: 101213899
NEW: 101213999
NEW: 101214099
NEW: 101214199
NEW: 101214299
NEW: 101214399
NEW: 101214499
NEW: 101214599
NEW: 101214699
NEW: 101214799
NEW: 101214899
NEW: 101214999
NEW: 101215099
NEW: 101215199
NEW: 101215299
NEW: 101215399
NEW: 101215499
Ok.
Product Option Sync.
Opencart products: 26
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 '101210499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1526
UPDATE oc_option_value_description
SET
name = '101210499 - AGUAR ECOLINE TALENS 25-30 ML VDE BRZ'
WHERE
option_value_id = 1526
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 = 1526
DELETE FROM oc_product
WHERE
model = '101210499'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1526,
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 '101210599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1527
UPDATE oc_option_value_description
SET
name = '101210599 - AGUAR ECOLINE TALENS 25-30 ML VERM PASTEL'
WHERE
option_value_id = 1527
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 = 1527
DELETE FROM oc_product
WHERE
model = '101210599'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1527,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.