Product Sync.
Opencart products: 188
Input products: 100
NEW: 101161599
NEW: 101161699
NEW: 101161799
NEW: 101161899
NEW: 101161999
NEW: 101162099
NEW: 101162199
NEW: 101162299
NEW: 101162399
NEW: 101162499
NEW: 101162599
NEW: 101162699
NEW: 101162799
NEW: 101162899
NEW: 101162999
NEW: 101163099
NEW: 101163199
NEW: 101163299
NEW: 101163399
NEW: 101163499
NEW: 101163599
NEW: 101163699
NEW: 101163799
NEW: 101163899
NEW: 101163999
NEW: 101164099
NEW: 101164199
NEW: 101164299
NEW: 101164399
NEW: 101164499
NEW: 101164599
NEW: 101164699
NEW: 101164799
NEW: 101164899
NEW: 101164999
NEW: 101165099
NEW: 101165199
NEW: 101165299
NEW: 101165399
NEW: 101165499
NEW: 101165599
NEW: 101165699
NEW: 101165799
NEW: 101165899
NEW: 101165999
NEW: 101166099
NEW: 101166199
NEW: 101166299
NEW: 101166399
NEW: 101166499
NEW: 101166599
NEW: 101166699
NEW: 101166799
NEW: 101166899
NEW: 101166999
NEW: 101167099
NEW: 101167199
NEW: 101167299
UPDATING: Tinta Acrílica Winsor & Newton 60 ml
Product ID: 27009
Image file:
NEW: 101167699
NEW: 101167799
NEW: 101167899
NEW: 101167999
NEW: 101168099
UPDATING: Tela Creatore Premium
Product ID: 27139
Image file:
NEW: 101168899
NEW: 101168999
NEW: 101169099
NEW: 101169199
NEW: 101169299
NEW: 101169399
NEW: 101169499
NEW: 101169599
NEW: 101169699
NEW: 101169799
NEW: 101169899
NEW: 101169999
NEW: 101170099
NEW: 101170199
NEW: 101170299
NEW: 101170399
NEW: 101170499
NEW: 101170599
NEW: 101170699
NEW: 101170799
NEW: 101170899
NEW: 101170999
NEW: 101171099
NEW: 101171199
NEW: 101171299
NEW: 101171399
NEW: 101171499
Ok.
Product Option Sync.
Opencart products: 188
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101167399 - %'
UPDATE oc_option_value
SET
image = 'catalog/101167399.jpg'
WHERE
option_value_id = 1555
UPDATE oc_option_value_description
SET
name = '101167399 - Acrílico Winsor & Newton Galeria 60 ml Cor de Carne'
WHERE
option_value_id = 1555
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1555
DELETE FROM oc_product
WHERE
model = '101167399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1555,
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 '101167499 - %'
UPDATE oc_option_value
SET
image = 'catalog/101167499.jpg'
WHERE
option_value_id = 1556
UPDATE oc_option_value_description
SET
name = '101167499 - Acrílico Winsor & Newton Galeria 60 ml Azul Phtalo'
WHERE
option_value_id = 1556
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1556
DELETE FROM oc_product
WHERE
model = '101167499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1556,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101167599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1557
UPDATE oc_option_value_description
SET
name = '101167599 - Acrílico Winsor & Newton Galeria 60 ml Vermelho Ocre'
WHERE
option_value_id = 1557
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1557
DELETE FROM oc_product
WHERE
model = '101167599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1557,
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 = 27139
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101168199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2404
UPDATE oc_option_value_description
SET
name = '101168199 - Tela Creatore Premium 20 x 30'
WHERE
option_value_id = 2404
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2404
DELETE FROM oc_product
WHERE
model = '101168199'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2404,
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 '101168299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2405
UPDATE oc_option_value_description
SET
name = '101168299 - Tela Creatore Premium 30 x 40'
WHERE
option_value_id = 2405
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2405
DELETE FROM oc_product
WHERE
model = '101168299'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2405,
quantity = 1,
subtract = 1,
price = 1.22,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101168399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2406
UPDATE oc_option_value_description
SET
name = '101168399 - Tela Creatore Premium 40 x 40'
WHERE
option_value_id = 2406
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2406
DELETE FROM oc_product
WHERE
model = '101168399'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2406,
quantity = 1,
subtract = 1,
price = 2.195,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101168499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2407
UPDATE oc_option_value_description
SET
name = '101168499 - Tela Creatore Premium 40 x 50'
WHERE
option_value_id = 2407
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2407
DELETE FROM oc_product
WHERE
model = '101168499'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2407,
quantity = 1,
subtract = 1,
price = 2.561,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101168599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2408
UPDATE oc_option_value_description
SET
name = '101168599 - Tela Creatore Premium 40 x 60'
WHERE
option_value_id = 2408
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2408
DELETE FROM oc_product
WHERE
model = '101168599'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2408,
quantity = 1,
subtract = 1,
price = 3.415,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101168699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2409
UPDATE oc_option_value_description
SET
name = '101168699 - Tela Creatore Premium 50 x 60'
WHERE
option_value_id = 2409
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2409
DELETE FROM oc_product
WHERE
model = '101168699'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2409,
quantity = 1,
subtract = 1,
price = 3.903,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101168799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2410
UPDATE oc_option_value_description
SET
name = '101168799 - Tela Creatore Premium 50 x 70'
WHERE
option_value_id = 2410
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2410
DELETE FROM oc_product
WHERE
model = '101168799'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2410,
quantity = 1,
subtract = 1,
price = 5.529,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.