Product Sync.
Opencart products: 30
Input products: 100
NEW: 439900399
NEW: 440001099
NEW: 440001999
NEW: 440300399
NEW: 440305721
NEW: 440306421
NEW: 440306821
NEW: 440311399
NEW: 440312599
NEW: 440313428
NEW: 440313628
NEW: 440313828
NEW: 440316699
NEW: 440316799
NEW: 440317099
NEW: 440317399
NEW: 440317499
NEW: 440317599
NEW: 440317699
NEW: 440317799
NEW: 440317899
UPDATING: Pelikan 10ml
Product ID: 27390
Image file: Pelikan 10ml.jpg
NEW: 440326999
NEW: 440328099
NEW: 440328199
NEW: 440328299
NEW: 440328699
NEW: 440328899
NEW: 440328999
NEW: 440329499
NEW: 440329699
NEW: 440330099
NEW: 440330399
NEW: 440330699
NEW: 440330799
NEW: 440330899
NEW: 440331099
NEW: 440331399
NEW: 440331499
NEW: 440331699
NEW: 440331799
NEW: 440332299
NEW: 440332399
NEW: 440332499
NEW: 440500299
NEW: 440500499
NEW: 440500699
NEW: 440501099
NEW: 440501399
NEW: 440501499
NEW: 441300299
NEW: 441300399
NEW: 441302576
NEW: 441302676
NEW: 441639399
NEW: 443721799
NEW: 444100399
NEW: 444100499
NEW: 444100999
NEW: 444101099
NEW: 444101199
NEW: 444102899
NEW: 444107999
NEW: 444108199
NEW: 444311099
NEW: 444311499
NEW: 444315099
NEW: 444901899
NEW: 444902199
NEW: 445008199
NEW: 445100299
NEW: 445100699
NEW: 445100899
NEW: 445100999
NEW: 445101099
NEW: 445101299
NEW: 445101399
NEW: 445101499
NEW: 445113299
NEW: 445113899
NEW: 445115199
NEW: 445154599
NEW: 445200799
NEW: 445201067
NEW: 445201167
NEW: 445201367
NEW: 445201667
NEW: 445201699
NEW: 445201799
NEW: 445202261
NEW: 445203021
NEW: 445203199
NEW: 445203299
NEW: 445203399
NEW: 445203499
NEW: 445203521
NEW: 445203599
Ok.
Product Option Sync.
Opencart products: 30
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 = 27390
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '440324699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1941
UPDATE oc_option_value_description
SET
name = '440324699 - GUACHE PELIKAN 10ML 740/3 BCO'
WHERE
option_value_id = 1941
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1941
DELETE FROM oc_product
WHERE
model = '440324699'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1941,
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 '440325699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1942
UPDATE oc_option_value_description
SET
name = '440325699 - GUACHE PELIKAN 10ML VIOLETA COR 109'
WHERE
option_value_id = 1942
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1942
DELETE FROM oc_product
WHERE
model = '440325699'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1942,
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 '440325799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1943
UPDATE oc_option_value_description
SET
name = '440325799 - GUACHE PELIKAN 10ML 740/3 AMA'
WHERE
option_value_id = 1943
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1943
DELETE FROM oc_product
WHERE
model = '440325799'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1943,
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 '440325999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1944
UPDATE oc_option_value_description
SET
name = '440325999 - GUACHE PELIKAN 10ML 740/3 VERM'
WHERE
option_value_id = 1944
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1944
DELETE FROM oc_product
WHERE
model = '440325999'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1944,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.