Product Sync.
Opencart products: 23
Input products: 100
NEW: 100555799
NEW: 100555899
NEW: 100555999
NEW: 100556099
NEW: 100556199
NEW: 100556299
NEW: 100556399
NEW: 100556499
NEW: 100556599
NEW: 100556699
NEW: 100556799
NEW: 100556899
NEW: 100556999
NEW: 100557099
NEW: 100557199
NEW: 100557299
NEW: 100557399
NEW: 100557499
NEW: 100557599
NEW: 100557699
NEW: 100557999
NEW: 100558099
NEW: 100558199
NEW: 100558299
NEW: 100558399
NEW: 100558499
NEW: 100558599
NEW: 100558699
NEW: 100558799
NEW: 100558899
NEW: 100558999
NEW: 100559099
NEW: 100559199
NEW: 100559299
NEW: 100559399
NEW: 100559499
NEW: 100559599
NEW: 100559699
NEW: 100559799
NEW: 100559899
NEW: 100559999
NEW: 100560099
NEW: 100560199
NEW: 100560299
NEW: 100560399
NEW: 100560499
NEW: 100560599
NEW: 100560699
NEW: 100560799
NEW: 100560899
NEW: 100560999
NEW: 100561099
NEW: 100561199
UPDATING: Giotto 500ml
Product ID: 27389
Image file: Giotto 500ml.jpg
NEW: 100561999
NEW: 100562099
NEW: 100562199
NEW: 100562299
NEW: 100562399
NEW: 100562499
NEW: 100562599
NEW: 100562699
NEW: 100562799
NEW: 100562899
NEW: 100562999
NEW: 100563099
NEW: 100563199
NEW: 100563299
NEW: 100563399
NEW: 100563499
NEW: 100563599
NEW: 100563699
NEW: 100563799
NEW: 100563899
NEW: 100563999
NEW: 100564099
NEW: 100564199
NEW: 100564299
NEW: 100564399
NEW: 100564499
NEW: 100564599
NEW: 100564699
NEW: 100564799
NEW: 100564899
NEW: 100564999
NEW: 100565099
NEW: 100565199
NEW: 100565299
NEW: 100565399
NEW: 100565499
NEW: 100565599
NEW: 100565699
NEW: 100565799
NEW: 100565899
Ok.
Product Option Sync.
Opencart products: 23
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 '100561299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1755
UPDATE oc_option_value_description
SET
name = '100561299 - GUACHE GIOT REF 532807 VERM 500ML'
WHERE
option_value_id = 1755
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 = 1755
DELETE FROM oc_product
WHERE
model = '100561299'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1755,
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 '100561399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1756
UPDATE oc_option_value_description
SET
name = '100561399 - GUACHE GIOT REF 532808 SCARL 500ML'
WHERE
option_value_id = 1756
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 = 1756
DELETE FROM oc_product
WHERE
model = '100561399'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1756,
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 '100561499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1757
UPDATE oc_option_value_description
SET
name = '100561499 - GUACHE GIOT REF 532810 MAG 500ML'
WHERE
option_value_id = 1757
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 = 1757
DELETE FROM oc_product
WHERE
model = '100561499'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1757,
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 '100561599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1758
UPDATE oc_option_value_description
SET
name = '100561599 - GUACHE GIOT REF 532813 VRD ESM 500ML'
WHERE
option_value_id = 1758
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 = 1758
DELETE FROM oc_product
WHERE
model = '100561599'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1758,
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 '100561699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1759
UPDATE oc_option_value_description
SET
name = '100561699 - GUACHE GIOT REF 532818 AZL TURQ 500ML'
WHERE
option_value_id = 1759
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 = 1759
DELETE FROM oc_product
WHERE
model = '100561699'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1759,
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 '100561799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1760
UPDATE oc_option_value_description
SET
name = '100561799 - GUACHE GIOT REF 532819 VIOLET 500ML'
WHERE
option_value_id = 1760
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 = 1760
DELETE FROM oc_product
WHERE
model = '100561799'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1760,
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 '100561899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1761
UPDATE oc_option_value_description
SET
name = '100561899 - GUACHE GIOT REF 532825 TERRA SIEN 500ML'
WHERE
option_value_id = 1761
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 = 1761
DELETE FROM oc_product
WHERE
model = '100561899'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1761,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.