Product Sync.
Opencart products: 168
Input products: 100
NEW: 100555599
NEW: 100555699
NEW: 100555799
NEW: 100555899
NEW: 100555999
NEW: 100556099
NEW: 100556199
NEW: 100556299
NEW: 100556399
NEW: 100556499
NEW: 100556599
NEW: 100556699
NEW: 100556799
NEW: 100556899
NEW: 100556999
NEW: 100557099
NEW: 100557199
NEW: 100557299
NEW: 100557399
NEW: 100557499
NEW: 100557599
UPDATING: Tela Creatore 3D
Product ID: 27130
Image file:
NEW: 100557799
NEW: 100557899
NEW: 100557999
NEW: 100558099
NEW: 100558199
NEW: 100558299
NEW: 100558399
NEW: 100558499
NEW: 100558599
NEW: 100558699
NEW: 100558799
NEW: 100558899
NEW: 100558999
NEW: 100559099
NEW: 100559199
NEW: 100559299
NEW: 100559399
NEW: 100559499
NEW: 100559599
NEW: 100559699
NEW: 100559799
NEW: 100559899
NEW: 100559999
NEW: 100560099
NEW: 100560199
NEW: 100560299
NEW: 100560399
NEW: 100560499
NEW: 100560599
NEW: 100560699
NEW: 100560799
NEW: 100560899
NEW: 100560999
NEW: 100561099
NEW: 100561199
UPDATING: Guache Giotto 500 ml
Product ID: 27012
Image file:
NEW: 100561999
NEW: 100562099
NEW: 100562199
NEW: 100562299
NEW: 100562399
NEW: 100562499
NEW: 100562599
NEW: 100562699
NEW: 100562799
NEW: 100562899
NEW: 100562999
NEW: 100563099
NEW: 100563199
NEW: 100563299
NEW: 100563399
NEW: 100563499
NEW: 100563599
NEW: 100563699
NEW: 100563799
NEW: 100563899
NEW: 100563999
NEW: 100564099
NEW: 100564199
NEW: 100564299
NEW: 100564399
NEW: 100564499
NEW: 100564599
NEW: 100564699
NEW: 100564799
NEW: 100564899
NEW: 100564999
NEW: 100565099
NEW: 100565199
NEW: 100565299
NEW: 100565399
NEW: 100565499
Ok.
Product Option Sync.
Opencart products: 168
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 = 27130
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100557699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2358
UPDATE oc_option_value_description
SET
name = '100557699 - Tela Creatore 3D 100 x 120'
WHERE
option_value_id = 2358
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 284
AND product_id = 27130
AND option_id = 15
AND option_value_id = 2358
DELETE FROM oc_product
WHERE
model = '100557699'
INSERT INTO oc_product_option_value
SET
product_option_id = 284,
product_id = 27130,
option_id = 15,
option_value_id = 2358,
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 = 27012
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100561299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1755
UPDATE oc_option_value_description
SET
name = '100561299 - Guache Giotto 500 ml Vermelho'
WHERE
option_value_id = 1755
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1755
DELETE FROM oc_product
WHERE
model = '100561299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1755
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100561399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1756
UPDATE oc_option_value_description
SET
name = '100561399 - Guache Giotto 500 ml Vermelho Escarlate'
WHERE
option_value_id = 1756
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1756
DELETE FROM oc_product
WHERE
model = '100561399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1756
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100561499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1757
UPDATE oc_option_value_description
SET
name = '100561499 - Guache Giotto 500 ml Magenta'
WHERE
option_value_id = 1757
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1757
DELETE FROM oc_product
WHERE
model = '100561499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1757
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100561599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1758
UPDATE oc_option_value_description
SET
name = '100561599 - Guache Giotto 500 ml Verde Esmeralda'
WHERE
option_value_id = 1758
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1758
DELETE FROM oc_product
WHERE
model = '100561599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1758
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100561699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1759
UPDATE oc_option_value_description
SET
name = '100561699 - Guache Giotto 500 ml Azul Turquesa'
WHERE
option_value_id = 1759
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1759
DELETE FROM oc_product
WHERE
model = '100561699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1759
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100561799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1760
UPDATE oc_option_value_description
SET
name = '100561799 - Guache Giotto 500 ml Violeta'
WHERE
option_value_id = 1760
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1760
DELETE FROM oc_product
WHERE
model = '100561799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1760
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100561899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1761
UPDATE oc_option_value_description
SET
name = '100561899 - Guache Giotto 500 ml Terra Siena'
WHERE
option_value_id = 1761
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1761
DELETE FROM oc_product
WHERE
model = '100561899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1761
Ok.