Product Sync.
Opencart products: 86
Input products: 100
NEW: 100909199
NEW: 100909299
NEW: 100909399
NEW: 100909499
NEW: 100909599
NEW: 100909699
NEW: 100909799
NEW: 100909899
NEW: 100909999
NEW: 100910099
NEW: 100910199
NEW: 100910299
NEW: 100910399
NEW: 100910499
NEW: 100910599
NEW: 100910699
NEW: 100910799
NEW: 100910899
NEW: 100910999
NEW: 100911099
NEW: 100911199
NEW: 100911299
NEW: 100911399
NEW: 100911499
NEW: 100911599
NEW: 100911699
NEW: 100911799
NEW: 100911899
NEW: 100911999
NEW: 100912099
NEW: 100912199
NEW: 100912299
NEW: 100912399
NEW: 100912499
NEW: 100912599
NEW: 100912699
NEW: 100912799
NEW: 100912899
UPDATING: Guache Giotto 1000 ml
Product ID: 27437
Image file:
NEW: 100913499
NEW: 100913599
NEW: 100913699
NEW: 100913799
NEW: 100913899
NEW: 100913999
NEW: 100914099
NEW: 100914199
NEW: 100914299
NEW: 100914399
NEW: 100914499
NEW: 100914599
NEW: 100914699
NEW: 100914799
NEW: 100914899
NEW: 100914999
NEW: 100915099
NEW: 100915199
NEW: 100915299
NEW: 100915399
NEW: 100915499
NEW: 100915599
NEW: 100915699
NEW: 100915799
NEW: 100915899
NEW: 100915999
NEW: 100916099
NEW: 100916199
NEW: 100916299
NEW: 100916399
NEW: 100916499
NEW: 100916599
NEW: 100916699
NEW: 100916799
NEW: 100916899
NEW: 100916999
NEW: 100917099
NEW: 100917199
NEW: 100917299
NEW: 100917399
NEW: 100917499
NEW: 100917599
NEW: 100917699
NEW: 100917799
NEW: 100917899
NEW: 100917999
NEW: 100918099
NEW: 100918199
NEW: 100918299
NEW: 100918399
NEW: 100918499
NEW: 100918599
NEW: 100918699
NEW: 100918799
NEW: 100918899
NEW: 100918999
NEW: 100919099
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 = 27437
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100912999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3468 AS option_value_id,
language_id,
17 AS option_id,
'100912999 - Guache Giotto 1000 ml Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3468
DELETE FROM oc_product
WHERE
model = '100912999'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3468,
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 '100913099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3469 AS option_value_id,
language_id,
17 AS option_id,
'100913099 - Guache Giotto 1000 ml Amarelo Primário' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3469
DELETE FROM oc_product
WHERE
model = '100913099'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3469,
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 '100913199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3470 AS option_value_id,
language_id,
17 AS option_id,
'100913199 - Guache Giotto 1000 ml Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3470
DELETE FROM oc_product
WHERE
model = '100913199'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3470,
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 '100913299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3471 AS option_value_id,
language_id,
17 AS option_id,
'100913299 - Guache Giotto 1000 ml Azul Primário' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3471
DELETE FROM oc_product
WHERE
model = '100913299'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3471,
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 '100913399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3472 AS option_value_id,
language_id,
17 AS option_id,
'100913399 - Guache Giotto 1000 ml Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3472
DELETE FROM oc_product
WHERE
model = '100913399'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3472,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.