Product Sync.
Opencart products: 161
Input products: 100
NEW: 100474899
NEW: 100474999
NEW: 100475099
NEW: 100475199
NEW: 100475299
NEW: 100475399
NEW: 100475499
NEW: 100475599
NEW: 100475699
NEW: 100475799
NEW: 100475899
NEW: 100475999
NEW: 100476099
NEW: 100476199
NEW: 100476299
NEW: 100476399
NEW: 100476499
NEW: 100476599
UPDATING: Guache Giotto Bebé 250 ml
Product ID: 27014
Image file:
NEW: 100477399
NEW: 100477499
NEW: 100477599
NEW: 100477699
NEW: 100477799
NEW: 100477899
NEW: 100477999
NEW: 100478099
NEW: 100478199
NEW: 100478299
NEW: 100478399
NEW: 100478499
NEW: 100478599
NEW: 100478699
NEW: 100478799
NEW: 100478899
NEW: 100478999
NEW: 100479099
NEW: 100479199
NEW: 100479299
NEW: 100479399
NEW: 100479499
NEW: 100479599
NEW: 100479699
NEW: 100479799
NEW: 100479899
NEW: 100479999
NEW: 100480099
NEW: 100480199
NEW: 100480299
NEW: 100480399
NEW: 100480499
NEW: 100480599
NEW: 100480699
NEW: 100480799
NEW: 100480899
NEW: 100480999
NEW: 100481099
NEW: 100481199
NEW: 100481299
NEW: 100481399
NEW: 100481499
NEW: 100481599
NEW: 100481699
NEW: 100481799
NEW: 100481899
NEW: 100481999
NEW: 100482099
NEW: 100482199
NEW: 100482299
NEW: 100482399
NEW: 100482499
NEW: 100482599
NEW: 100482699
NEW: 100482799
NEW: 100482899
NEW: 100482999
NEW: 100483099
NEW: 100483199
NEW: 100483299
NEW: 100483399
NEW: 100483499
NEW: 100483599
NEW: 100483699
NEW: 100483799
NEW: 100483899
NEW: 100483999
NEW: 100484099
NEW: 100484199
NEW: 100484299
NEW: 100484399
NEW: 100484499
NEW: 100484599
NEW: 100484699
NEW: 100484799
Ok.
Product Option Sync.
Opencart products: 161
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 = 27014
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100476699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2246
UPDATE oc_option_value_description
SET
name = '100476699 - Guache Giotto Bebé 250 ml Rosa'
WHERE
option_value_id = 2246
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2246
DELETE FROM oc_product
WHERE
model = '100476699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2246
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100476799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2247
UPDATE oc_option_value_description
SET
name = '100476799 - Guache Giotto Bebé 250 ml Amarelo'
WHERE
option_value_id = 2247
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2247
DELETE FROM oc_product
WHERE
model = '100476799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2247
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100476899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2248
UPDATE oc_option_value_description
SET
name = '100476899 - Guache Giotto Bebé 250 ml Branco'
WHERE
option_value_id = 2248
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2248
DELETE FROM oc_product
WHERE
model = '100476899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2248
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100476999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2249
UPDATE oc_option_value_description
SET
name = '100476999 - Guache Giotto Bebé 250 ml Verde'
WHERE
option_value_id = 2249
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2249
DELETE FROM oc_product
WHERE
model = '100476999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2249
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100477099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2250
UPDATE oc_option_value_description
SET
name = '100477099 - Guache Giotto Bebé 250 ml Prata'
WHERE
option_value_id = 2250
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2250
DELETE FROM oc_product
WHERE
model = '100477099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2250
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100477199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2251
UPDATE oc_option_value_description
SET
name = '100477199 - Guache Giotto Bebé 250 ml Preto'
WHERE
option_value_id = 2251
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2251
DELETE FROM oc_product
WHERE
model = '100477199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2251
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100477299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2252
UPDATE oc_option_value_description
SET
name = '100477299 - Guache Giotto Bebé 250 ml Vermelho'
WHERE
option_value_id = 2252
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2252
DELETE FROM oc_product
WHERE
model = '100477299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 83
AND product_id = 27014
AND option_id = 15
AND option_value_id = 2252
Ok.