Product Sync.
Opencart products: 34
Input products: 100
NEW: 100161699
NEW: 100161799
NEW: 100161899
NEW: 100161999
NEW: 100162099
NEW: 100162199
NEW: 100162299
NEW: 100162399
NEW: 100162499
NEW: 100162599
NEW: 100162699
NEW: 100162799
NEW: 100162899
NEW: 100162999
NEW: 100163099
NEW: 100163199
NEW: 100163299
NEW: 100163399
NEW: 100163499
NEW: 100163599
NEW: 100163699
NEW: 100163799
NEW: 100163899
NEW: 100163999
NEW: 100164099
NEW: 100164199
NEW: 100164299
NEW: 100164399
NEW: 100164499
UPDATING: Guache Giotto Lavável 1000 ml
Product ID: 27422
Image file:
NEW: 100164699
NEW: 100164799
NEW: 100164899
NEW: 100164999
NEW: 100165099
NEW: 100165199
NEW: 100165299
NEW: 100165399
NEW: 100165499
NEW: 100165599
NEW: 100165699
NEW: 100165799
NEW: 100165899
NEW: 100165999
NEW: 100166099
NEW: 100166199
NEW: 100166299
NEW: 100166399
NEW: 100166499
NEW: 100166599
NEW: 100166699
NEW: 100166799
NEW: 100166899
NEW: 100166999
NEW: 100167099
NEW: 100167199
NEW: 100167299
NEW: 100167399
NEW: 100167499
NEW: 100167599
NEW: 100167699
NEW: 100167799
NEW: 100167899
NEW: 100167999
NEW: 100168099
NEW: 100168199
NEW: 100168299
NEW: 100168399
NEW: 100168499
NEW: 100168599
NEW: 100168799
NEW: 100168899
NEW: 100168999
NEW: 100169099
NEW: 100169199
NEW: 100169299
NEW: 100169399
NEW: 100169499
NEW: 100169599
NEW: 100169699
NEW: 100169799
NEW: 100169899
NEW: 100169999
NEW: 100170099
NEW: 100170199
NEW: 100170299
NEW: 100170399
NEW: 100170499
NEW: 100170599
NEW: 100170699
NEW: 100170799
NEW: 100170899
NEW: 100170999
NEW: 100171099
NEW: 100171199
NEW: 100171299
NEW: 100171399
NEW: 100171499
NEW: 100171599
Ok.
Product Option Sync.
Opencart products: 34
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 = 27422
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100164599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3250 AS option_value_id,
language_id,
17 AS option_id,
'100164599 - Guache Giotto Lavável 1000 ml Verde' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3250
DELETE FROM oc_product
WHERE
model = '100164599'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3250,
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 '100168699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3251 AS option_value_id,
language_id,
17 AS option_id,
'100168699 - Guache Giotto Lavável 1000 ml Castanho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3251
DELETE FROM oc_product
WHERE
model = '100168699'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3251,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.