Product Sync.
Opencart products: 19
Input products: 100
NEW: 100303199
NEW: 100303299
NEW: 100303399
NEW: 100303499
NEW: 100303599
NEW: 100303699
NEW: 100303799
NEW: 100303899
NEW: 100303999
NEW: 100304099
NEW: 100304199
NEW: 100304299
NEW: 100304399
NEW: 100304499
NEW: 100304599
NEW: 100304699
NEW: 100304799
NEW: 100304899
NEW: 100304999
NEW: 100305099
NEW: 100305199
NEW: 100305299
NEW: 100305399
NEW: 100305499
NEW: 100305599
NEW: 100305699
NEW: 100305799
NEW: 100305899
NEW: 100305999
NEW: 100306099
NEW: 100306199
NEW: 100306299
NEW: 100306399
NEW: 100306499
NEW: 100306599
NEW: 100306699
NEW: 100306799
NEW: 100306899
NEW: 100306999
NEW: 100307099
NEW: 100307199
NEW: 100307299
NEW: 100307399
NEW: 100307499
NEW: 100307599
NEW: 100307699
NEW: 100307799
NEW: 100307899
NEW: 100307999
NEW: 100308099
NEW: 100308199
NEW: 100308299
UPDATING: Giotto 500ml
Product ID: 27389
Image file: Giotto 500ml.jpg
NEW: 100309399
NEW: 100309499
NEW: 100309599
NEW: 100309699
NEW: 100309799
NEW: 100309899
NEW: 100309999
NEW: 100310099
NEW: 100310199
NEW: 100310299
NEW: 100310399
NEW: 100310499
NEW: 100310599
NEW: 100310699
NEW: 100310799
NEW: 100310899
NEW: 100310999
NEW: 100311099
NEW: 100311199
NEW: 100311299
NEW: 100311399
NEW: 100311499
NEW: 100311599
NEW: 100311699
NEW: 100311799
NEW: 100311899
NEW: 100311999
NEW: 100312099
NEW: 100312199
NEW: 100312299
NEW: 100312399
NEW: 100312499
NEW: 100312599
NEW: 100312699
NEW: 100312799
NEW: 100312899
NEW: 100312999
NEW: 100313099
Ok.
Product Option Sync.
Opencart products: 19
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 = 27389
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1742
UPDATE oc_option_value_description
SET
name = '100308399 - GUACHE GIOT REF 532801 BCO 500ML'
WHERE
option_value_id = 1742
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1742
DELETE FROM oc_product
WHERE
model = '100308399'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1742,
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 '100308499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1743
UPDATE oc_option_value_description
SET
name = '100308499 - GUACHE GIOT REF 532815 AZ PRIM 500ML'
WHERE
option_value_id = 1743
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1743
DELETE FROM oc_product
WHERE
model = '100308499'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1743,
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 '100308599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1744
UPDATE oc_option_value_description
SET
name = '100308599 - GUACHE GIOT REF 532802 AMA PRIM 500ML'
WHERE
option_value_id = 1744
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1744
DELETE FROM oc_product
WHERE
model = '100308599'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1744,
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 '100308699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1745
UPDATE oc_option_value_description
SET
name = '100308699 - GUACHE GIOT REF 532811 VRD CINNABAR 500ML'
WHERE
option_value_id = 1745
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1745
DELETE FROM oc_product
WHERE
model = '100308699'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1745,
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 '100308799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1746
UPDATE oc_option_value_description
SET
name = '100308799 - GUACHE GIOT REF 532805 LAR 500ML'
WHERE
option_value_id = 1746
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1746
DELETE FROM oc_product
WHERE
model = '100308799'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1746,
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 '100308899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1747
UPDATE oc_option_value_description
SET
name = '100308899 - GUACHE GIOT REF 532812 VRD 500ML'
WHERE
option_value_id = 1747
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1747
DELETE FROM oc_product
WHERE
model = '100308899'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1747,
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 '100308999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1748
UPDATE oc_option_value_description
SET
name = '100308999 - GUACHE GIOT REF 532817 AZL ULTRAM 500ML'
WHERE
option_value_id = 1748
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1748
DELETE FROM oc_product
WHERE
model = '100308999'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1748,
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 '100309099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1749
UPDATE oc_option_value_description
SET
name = '100309099 - GUACHE GIOT REF 532828 CAST 500ML'
WHERE
option_value_id = 1749
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1749
DELETE FROM oc_product
WHERE
model = '100309099'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1749,
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 '100309199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1750
UPDATE oc_option_value_description
SET
name = '100309199 - GUACHE GIOT REF 532803 AMA ESC 500ML'
WHERE
option_value_id = 1750
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1750
DELETE FROM oc_product
WHERE
model = '100309199'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1750,
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 '100309299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1751
UPDATE oc_option_value_description
SET
name = '100309299 - GUACHE GIOT REF 532824 PRT500ML'
WHERE
option_value_id = 1751
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1751
DELETE FROM oc_product
WHERE
model = '100309299'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1751,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.