Product Sync.
Opencart products: 23
Input products: 100
NEW: 100871099
NEW: 100871199
NEW: 100871299
NEW: 100871399
NEW: 100871499
NEW: 100871599
NEW: 100871699
NEW: 100871799
NEW: 100871899
NEW: 100871999
NEW: 100872099
NEW: 100872199
NEW: 100872299
NEW: 100872399
NEW: 100872499
NEW: 100872599
NEW: 100872699
NEW: 100872799
NEW: 100872899
NEW: 100872999
NEW: 100873099
NEW: 100873199
NEW: 100873299
NEW: 100873399
NEW: 100873499
NEW: 100873599
NEW: 100873699
NEW: 100873799
NEW: 100873899
NEW: 100873999
NEW: 100874099
NEW: 100874199
NEW: 100874299
NEW: 100874399
NEW: 100874499
NEW: 100874599
NEW: 100874699
NEW: 100874799
NEW: 100874899
NEW: 100874999
NEW: 100875099
NEW: 100875199
NEW: 100875299
NEW: 100875399
NEW: 100875499
NEW: 100875599
NEW: 100875699
NEW: 100875799
NEW: 100875899
NEW: 100875999
NEW: 100876099
NEW: 100876199
NEW: 100876299
NEW: 100876399
NEW: 100876499
NEW: 100876699
NEW: 100876799
NEW: 100876899
NEW: 100876999
NEW: 100877099
NEW: 100877199
NEW: 100877299
NEW: 100877399
NEW: 100877499
NEW: 100877599
NEW: 100877699
NEW: 100877899
NEW: 100877999
NEW: 100878099
NEW: 100878199
NEW: 100878299
NEW: 100878399
NEW: 100878499
NEW: 100878599
NEW: 100878699
NEW: 100878899
NEW: 100878999
NEW: 100879099
NEW: 100879199
NEW: 100879299
UPDATING: Pebeo Studio 100ml
Product ID: 27394
Image file: Pebeo Studio 100ml.jpg
NEW: 100879999
NEW: 100880099
NEW: 100880199
NEW: 100880299
NEW: 100880399
NEW: 100880499
NEW: 100880599
NEW: 100880699
NEW: 100880799
NEW: 100880899
NEW: 100880999
NEW: 100881099
NEW: 100881199
NEW: 100881299
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 = 27394
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100879399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1505
UPDATE oc_option_value_description
SET
name = '100879399 - ACRIL PEBEO STUD 100ML BEIGE TIT 065'
WHERE
option_value_id = 1505
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 387
AND product_id = 27394
AND option_id = 17
AND option_value_id = 1505
DELETE FROM oc_product
WHERE
model = '100879399'
INSERT INTO oc_product_option_value
SET
product_option_id = 387,
product_id = 27394,
option_id = 17,
option_value_id = 1505,
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 '100879499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1506
UPDATE oc_option_value_description
SET
name = '100879499 - ACRIL PEBEO STUD 100ML VDE TURQ 58'
WHERE
option_value_id = 1506
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 387
AND product_id = 27394
AND option_id = 17
AND option_value_id = 1506
DELETE FROM oc_product
WHERE
model = '100879499'
INSERT INTO oc_product_option_value
SET
product_option_id = 387,
product_id = 27394,
option_id = 17,
option_value_id = 1506,
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 '100879599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1507
UPDATE oc_option_value_description
SET
name = '100879599 - ACRIL PEBEO STUD 100ML VDE VER'
WHERE
option_value_id = 1507
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 387
AND product_id = 27394
AND option_id = 17
AND option_value_id = 1507
DELETE FROM oc_product
WHERE
model = '100879599'
INSERT INTO oc_product_option_value
SET
product_option_id = 387,
product_id = 27394,
option_id = 17,
option_value_id = 1507,
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 '100879699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1508
UPDATE oc_option_value_description
SET
name = '100879699 - ACRIL PEBEO STUD 100ML TERRA AMA 62'
WHERE
option_value_id = 1508
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 387
AND product_id = 27394
AND option_id = 17
AND option_value_id = 1508
DELETE FROM oc_product
WHERE
model = '100879699'
INSERT INTO oc_product_option_value
SET
product_option_id = 387,
product_id = 27394,
option_id = 17,
option_value_id = 1508,
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 '100879799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1509
UPDATE oc_option_value_description
SET
name = '100879799 - ACRIL PEBEO STUD 100ML INDIGO 057'
WHERE
option_value_id = 1509
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 387
AND product_id = 27394
AND option_id = 17
AND option_value_id = 1509
DELETE FROM oc_product
WHERE
model = '100879799'
INSERT INTO oc_product_option_value
SET
product_option_id = 387,
product_id = 27394,
option_id = 17,
option_value_id = 1509,
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 '100879899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1510
UPDATE oc_option_value_description
SET
name = '100879899 - ACRIL PEBEO STUD 100ML AMA LIM CLR 012'
WHERE
option_value_id = 1510
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 387
AND product_id = 27394
AND option_id = 17
AND option_value_id = 1510
DELETE FROM oc_product
WHERE
model = '100879899'
INSERT INTO oc_product_option_value
SET
product_option_id = 387,
product_id = 27394,
option_id = 17,
option_value_id = 1510,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.