Product Sync.
Opencart products: 86
Input products: 100
NEW: 100777799
NEW: 100777899
NEW: 100777999
NEW: 100778099
NEW: 100778199
NEW: 100778299
NEW: 100778399
NEW: 100778499
NEW: 100778599
NEW: 100778699
NEW: 100778799
NEW: 100778899
NEW: 100778999
NEW: 100779099
NEW: 100779199
NEW: 100779299
NEW: 100779399
NEW: 100779499
NEW: 100779599
NEW: 100779699
NEW: 100779799
NEW: 100779899
NEW: 100779999
NEW: 100780099
NEW: 100780199
NEW: 100780299
NEW: 100780399
NEW: 100780499
NEW: 100780599
NEW: 100780699
NEW: 100780799
NEW: 100780899
NEW: 100780999
NEW: 100781099
NEW: 100781199
NEW: 100781299
NEW: 100781399
NEW: 100781499
NEW: 100781599
NEW: 100781699
NEW: 100781799
NEW: 100781899
NEW: 100781999
NEW: 100782099
NEW: 100782199
NEW: 100782299
NEW: 100782399
NEW: 100782499
NEW: 100782599
NEW: 100782699
NEW: 100782799
NEW: 100782899
NEW: 100782999
NEW: 100783099
NEW: 100783199
NEW: 100783299
NEW: 100783399
NEW: 100783499
NEW: 100783599
NEW: 100783699
NEW: 100783799
NEW: 100783899
NEW: 100783999
NEW: 100784099
NEW: 100784199
NEW: 100784299
NEW: 100784399
NEW: 100784499
NEW: 100784599
NEW: 100784699
NEW: 100784799
NEW: 100784899
NEW: 100784999
NEW: 100785099
NEW: 100785199
NEW: 100785299
NEW: 100785399
NEW: 100785499
NEW: 100785599
NEW: 100785699
NEW: 100785799
NEW: 100785899
NEW: 100785999
UPDATING: Guache Giotto Lavável 500 ml
Product ID: 27482
Image file:
NEW: 100786899
NEW: 100786999
NEW: 100787099
NEW: 100787199
NEW: 100787299
NEW: 100787399
NEW: 100787499
NEW: 100787599
NEW: 100787699
Ok.
Product Option Sync.
Opencart products: 86
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 = 27482
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3457 AS option_value_id,
language_id,
17 AS option_id,
'100786099 - Guache Giotto 500 ml Lavável Verde Claro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3457
DELETE FROM oc_product
WHERE
model = '100786099'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3457,
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 '100786199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3458 AS option_value_id,
language_id,
17 AS option_id,
'100786199 - Guache Giotto 500 ml Lavável Verde Escuro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3458
DELETE FROM oc_product
WHERE
model = '100786199'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3458,
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 '100786299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3459 AS option_value_id,
language_id,
17 AS option_id,
'100786299 - Guache Giotto 500 ml Lavável Verde Esmeralda' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3459
DELETE FROM oc_product
WHERE
model = '100786299'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3459,
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 '100786399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3460 AS option_value_id,
language_id,
17 AS option_id,
'100786399 - Guache Giotto 500 ml Lavável Azul Cyan' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3460
DELETE FROM oc_product
WHERE
model = '100786399'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3460,
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 '100786499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3461 AS option_value_id,
language_id,
17 AS option_id,
'100786499 - Guache Giotto 500 ml Lavável Azul Ultramarino' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3461
DELETE FROM oc_product
WHERE
model = '100786499'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3461,
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 '100786599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3462 AS option_value_id,
language_id,
17 AS option_id,
'100786599 - Guache Giotto 500 ml Lavável Azul Turquesa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3462
DELETE FROM oc_product
WHERE
model = '100786599'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3462,
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 '100786699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3463 AS option_value_id,
language_id,
17 AS option_id,
'100786699 - Guache Giotto 500 ml Lavável Violeta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3463
DELETE FROM oc_product
WHERE
model = '100786699'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3463,
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 '100786799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3464 AS option_value_id,
language_id,
17 AS option_id,
'100786799 - Guache Giotto 500 ml Lavável Rosa Carne' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3464
DELETE FROM oc_product
WHERE
model = '100786799'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3464,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.