Product Sync.
Opencart products: 30
Input products: 100
NEW: 102332399
NEW: 102332499
NEW: 102332599
NEW: 102332699
NEW: 102332799
NEW: 102332899
NEW: 102332999
NEW: 102333099
NEW: 102333199
NEW: 102333299
NEW: 102333399
NEW: 102333499
NEW: 102333599
NEW: 102333699
NEW: 102333799
NEW: 102333899
NEW: 102333999
NEW: 102334099
NEW: 102334199
NEW: 102334299
NEW: 102334399
NEW: 102334499
NEW: 102334599
NEW: 102334699
NEW: 102334799
NEW: 102334899
NEW: 102334999
NEW: 102335099
NEW: 102335199
NEW: 102335299
NEW: 102335399
NEW: 102335499
NEW: 102335599
NEW: 102335699
NEW: 102335799
NEW: 102335899
NEW: 102335999
NEW: 102336099
NEW: 102336199
NEW: 102336299
NEW: 102336399
NEW: 102336499
NEW: 102336599
NEW: 102336699
NEW: 102336799
NEW: 102336899
NEW: 102336999
NEW: 102337099
NEW: 102337199
NEW: 102337299
NEW: 102337399
NEW: 102337499
NEW: 102337599
NEW: 102337699
NEW: 102337799
NEW: 102337899
NEW: 102337999
NEW: 102338099
NEW: 102338199
NEW: 102338299
NEW: 102338399
NEW: 102338499
NEW: 102338599
NEW: 102338699
NEW: 102338799
NEW: 102338899
NEW: 102338999
UPDATING: Cotman W&N Pastilha
Product ID: 27395
Image file:
NEW: 102339199
NEW: 102339299
NEW: 102339399
NEW: 102339499
NEW: 102339599
NEW: 102339699
NEW: 102339799
NEW: 102339899
NEW: 102339999
UPDATING: Amsterdam 120ml
Product ID: 27385
Image file: Amsterdam 120ml.jpg
NEW: 102340499
NEW: 102340599
NEW: 102340699
NEW: 102340799
NEW: 102340899
NEW: 102340999
NEW: 102341099
NEW: 102341199
NEW: 102341299
UPDATING: Galeria W&N 250ml
Product ID: 27392
Image file:
NEW: 102341499
NEW: 102341599
NEW: 102341699
NEW: 102341799
NEW: 102341899
NEW: 102341999
NEW: 102342099
NEW: 102342199
NEW: 102342299
NEW: 102342399
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 = 27395
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102339099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1917
UPDATE oc_option_value_description
SET
name = '102339099 - AGUAR W&N COTMAN PASTILHA CADMIUM RED PALE HUE 103'
WHERE
option_value_id = 1917
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 388
AND product_id = 27395
AND option_id = 17
AND option_value_id = 1917
DELETE FROM oc_product
WHERE
model = '102339099'
INSERT INTO oc_product_option_value
SET
product_option_id = 388,
product_id = 27395,
option_id = 17,
option_value_id = 1917,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27385
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1918
UPDATE oc_option_value_description
SET
name = '102340099 - ACRIL AMST 120 ML BURGUNDY 075'
WHERE
option_value_id = 1918
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1918
DELETE FROM oc_product
WHERE
model = '102340099'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1918,
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 '102340199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1919
UPDATE oc_option_value_description
SET
name = '102340199 - ACRIL AMST 120 ML COPPER 214'
WHERE
option_value_id = 1919
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1919
DELETE FROM oc_product
WHERE
model = '102340199'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1919,
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 '102340299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1920
UPDATE oc_option_value_description
SET
name = '102340299 - ACRIL AMST 120 ML FLESH TINT 257'
WHERE
option_value_id = 1920
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1920
DELETE FROM oc_product
WHERE
model = '102340299'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1920,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
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 '102341399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1921
UPDATE oc_option_value_description
SET
name = '102341399 - ACRIL GALERIA W&N 250ML LAMP BLACK 337'
WHERE
option_value_id = 1921
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 = 1921
DELETE FROM oc_product
WHERE
model = '102341399'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1921,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.