Product Sync.
Opencart products: 26
Input products: 100
NEW: 101235899
NEW: 101235999
NEW: 101236099
NEW: 101236199
NEW: 101236299
NEW: 101236399
NEW: 101236499
NEW: 101236599
NEW: 101236699
NEW: 101236799
NEW: 101236899
NEW: 101236999
NEW: 101237099
NEW: 101237199
NEW: 101237299
NEW: 101237399
NEW: 101237499
NEW: 101237599
NEW: 101237699
NEW: 101237799
NEW: 101237899
NEW: 101237999
NEW: 101238099
NEW: 101238199
NEW: 101238299
NEW: 101238399
NEW: 101238499
NEW: 101238599
NEW: 101238699
NEW: 101238799
NEW: 101238899
NEW: 101238999
NEW: 101239099
NEW: 101239199
NEW: 101239299
NEW: 101239399
NEW: 101239499
NEW: 101239599
NEW: 101239699
NEW: 101239799
NEW: 101239899
NEW: 101239999
NEW: 101240099
NEW: 101240199
NEW: 101240299
NEW: 101240399
NEW: 101240499
NEW: 101240599
NEW: 101240699
NEW: 101240799
NEW: 101240899
NEW: 101240999
NEW: 101241099
NEW: 101241199
NEW: 101241299
NEW: 101241399
NEW: 101241499
NEW: 101241599
NEW: 101241699
NEW: 101241799
NEW: 101241899
NEW: 101241999
NEW: 101242099
NEW: 101242199
NEW: 101242299
NEW: 101242399
NEW: 101242499
NEW: 101242599
NEW: 101242699
NEW: 101242799
NEW: 101242899
NEW: 101242999
NEW: 101243099
NEW: 101243199
NEW: 101243299
NEW: 101243399
NEW: 101243499
NEW: 101243599
NEW: 101243699
NEW: 101243799
NEW: 101243899
NEW: 101243999
NEW: 101244099
UPDATING: Galeria W&N 250ml
Product ID: 27392
Image file:
NEW: 101244499
NEW: 101244599
NEW: 101244699
NEW: 101244799
NEW: 101244899
NEW: 101244999
NEW: 101245099
NEW: 101245199
NEW: 101245299
NEW: 101245399
NEW: 101245499
NEW: 101245599
NEW: 101245699
NEW: 101245799
Ok.
Product Option Sync.
Opencart products: 26
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 = 27392
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101244199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1511
UPDATE oc_option_value_description
SET
name = '101244199 - ACRIL GALERIA W&N 250ML PERM ROSE 502'
WHERE
option_value_id = 1511
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1511
DELETE FROM oc_product
WHERE
model = '101244199'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1511,
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 '101244299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1512
UPDATE oc_option_value_description
SET
name = '101244299 - ACRIL GALERIA W&N 250ML VANDYKE BROWN'
WHERE
option_value_id = 1512
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1512
DELETE FROM oc_product
WHERE
model = '101244299'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1512,
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 '101244399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1513
UPDATE oc_option_value_description
SET
name = '101244399 - ACRIL GALERIA W&N 250ML VERMILION 682'
WHERE
option_value_id = 1513
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1513
DELETE FROM oc_product
WHERE
model = '101244399'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1513,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.