Product Sync.
Opencart products: 62
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: 27438
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: 62
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 = 27438
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100476699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3336 AS option_value_id,
language_id,
17 AS option_id,
'100476699 - Guache Giotto Bebé 250 ml Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3336
DELETE FROM oc_product
WHERE
model = '100476699'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3336,
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 '100476799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3337 AS option_value_id,
language_id,
17 AS option_id,
'100476799 - Guache Giotto Bebé 250 ml Amarelo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3337
DELETE FROM oc_product
WHERE
model = '100476799'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3337,
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 '100476899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3338 AS option_value_id,
language_id,
17 AS option_id,
'100476899 - Guache Giotto Bebé 250 ml Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3338
DELETE FROM oc_product
WHERE
model = '100476899'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3338,
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 '100476999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3339 AS option_value_id,
language_id,
17 AS option_id,
'100476999 - Guache Giotto Bebé 250 ml Verde' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3339
DELETE FROM oc_product
WHERE
model = '100476999'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3339,
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 '100477099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3340 AS option_value_id,
language_id,
17 AS option_id,
'100477099 - Guache Giotto Bebé 250 ml Prata' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3340
DELETE FROM oc_product
WHERE
model = '100477099'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3340,
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 '100477199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3341 AS option_value_id,
language_id,
17 AS option_id,
'100477199 - Guache Giotto Bebé 250 ml Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3341
DELETE FROM oc_product
WHERE
model = '100477199'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3341,
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 '100477299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3342 AS option_value_id,
language_id,
17 AS option_id,
'100477299 - Guache Giotto Bebé 250 ml Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3342
DELETE FROM oc_product
WHERE
model = '100477299'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3342,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.