Product Sync.
Opencart products: 150
Input products: 100
NEW: 100202099
NEW: 100202199
NEW: 100202299
NEW: 100202399
NEW: 100202499
NEW: 100202599
NEW: 100202699
NEW: 100202799
NEW: 100202899
NEW: 100202999
NEW: 100203099
NEW: 100203199
NEW: 100203299
NEW: 100203399
NEW: 100203499
NEW: 100203599
NEW: 100203699
NEW: 100203799
NEW: 100203899
NEW: 100203999
NEW: 100204099
NEW: 100204199
NEW: 100204299
NEW: 100204399
NEW: 100204499
NEW: 100204599
NEW: 100204699
NEW: 100204799
NEW: Tela Creatore Premium
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tela Creatore Premium - %'
)
NEW: 100204999
NEW: 100205099
NEW: 100205199
NEW: 100205299
NEW: 100205399
NEW: 100205499
NEW: 100205599
NEW: 100205699
NEW: 100205799
NEW: 100205899
NEW: 100205999
NEW: 100206099
NEW: 100206199
NEW: 100206299
NEW: 100206399
NEW: 100206499
NEW: 100206599
NEW: 100206699
NEW: 100206799
NEW: 100206899
NEW: 100206999
NEW: 100207099
NEW: 100207199
NEW: 100207299
NEW: 100207399
NEW: 100207499
NEW: 100207599
NEW: 100207699
NEW: 100207799
NEW: 100207899
UPDATING: Aguarela Winsor & Newton Cotman Tubo ou Pastilha
Product ID: 27010
Image file:
NEW: 100208099
NEW: 100208199
NEW: 100208299
NEW: 100208399
NEW: 100208499
NEW: 100208599
NEW: 100208699
NEW: 100208799
NEW: 100208899
NEW: 100208999
NEW: 100209099
NEW: 100209199
NEW: 100209299
NEW: 100209399
NEW: 100209499
NEW: 100209599
NEW: 100209699
NEW: 100209799
NEW: 100209899
NEW: 100209999
NEW: 100210099
NEW: 100210199
NEW: 100210299
NEW: 100210399
NEW: 100210499
NEW: 100210599
NEW: 100210699
NEW: 100210799
NEW: 100210899
NEW: 100210999
NEW: 100211099
NEW: 100211199
NEW: 100211299
NEW: 100211399
NEW: 100211499
NEW: 100211599
NEW: 100211699
NEW: 100211799
NEW: 100211899
NEW: 100211999
Ok.
Product Option Sync.
Opencart products: 151
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 = 27139
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27139,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100204899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2161
UPDATE oc_option_value_description
SET
name = '100204899 - Tela Creatore Premium 18 x 24'
WHERE
option_value_id = 2161
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2161
DELETE FROM oc_product
WHERE
model = '100204899'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2161,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100207999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 962
UPDATE oc_option_value_description
SET
name = '100207999 - Aguarela Winsor & Newton Cotman 8 ml Malva 398'
WHERE
option_value_id = 962
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 962
DELETE FROM oc_product
WHERE
model = '100207999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 962,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.