Product Sync.
Opencart products: 99
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: 27431
Image file:
NEW: 101167699
NEW: 101167799
NEW: 101167899
NEW: 101167999
NEW: 101168099
UPDATING: Tela Creatore Premium
Product ID: 27433
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: 99
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 = 27431
AND option_id = 17
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 = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1555
DELETE FROM oc_product
WHERE
model = '101167399'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
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 = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1556
DELETE FROM oc_product
WHERE
model = '101167499'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
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 = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1557
DELETE FROM oc_product
WHERE
model = '101167599'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
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 = 27433
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101168199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3482 AS option_value_id,
language_id,
17 AS option_id,
'101168199 - Tela Creatore Premium 20 x 30' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3482
DELETE FROM oc_product
WHERE
model = '101168199'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3482,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3483 AS option_value_id,
language_id,
17 AS option_id,
'101168299 - Tela Creatore Premium 30 x 40' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3483
DELETE FROM oc_product
WHERE
model = '101168299'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3483,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3484 AS option_value_id,
language_id,
17 AS option_id,
'101168399 - Tela Creatore Premium 40 x 40' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3484
DELETE FROM oc_product
WHERE
model = '101168399'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3484,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3485 AS option_value_id,
language_id,
17 AS option_id,
'101168499 - Tela Creatore Premium 40 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3485
DELETE FROM oc_product
WHERE
model = '101168499'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3485,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3486 AS option_value_id,
language_id,
17 AS option_id,
'101168599 - Tela Creatore Premium 40 x 60' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3486
DELETE FROM oc_product
WHERE
model = '101168599'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3486,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3487 AS option_value_id,
language_id,
17 AS option_id,
'101168699 - Tela Creatore Premium 50 x 60' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3487
DELETE FROM oc_product
WHERE
model = '101168699'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3487,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3488 AS option_value_id,
language_id,
17 AS option_id,
'101168799 - Tela Creatore Premium 50 x 70' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3488
DELETE FROM oc_product
WHERE
model = '101168799'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3488,
quantity = 1,
subtract = 1,
price = 5.529,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.