Product Sync.
Opencart products: 30
Input products: 100
UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:
NEW: 101844099
NEW: 101844699
NEW: 101844799
NEW: 101844899
NEW: 101844999
NEW: 101845099
NEW: 101845199
NEW: 101845299
NEW: 101845399
NEW: 101845499
NEW: 101845599
NEW: 101845699
NEW: 101845799
NEW: 101845899
NEW: 101845999
NEW: 101846099
NEW: 101846199
NEW: 101846299
NEW: 101846399
NEW: 101846499
NEW: 101846599
NEW: 101846699
NEW: 101846799
NEW: 101846899
NEW: 101846999
NEW: 101847099
NEW: 101847199
NEW: 101847299
NEW: 101847399
NEW: 101847499
NEW: 101847599
NEW: 101847699
NEW: 101847799
NEW: 101847899
NEW: 101847999
NEW: 101848099
NEW: 101848199
NEW: 101848299
NEW: 101848399
NEW: 101848499
NEW: 101848599
NEW: 101848699
NEW: 101848799
NEW: 101848899
NEW: 101848999
NEW: 101849099
NEW: 101849199
NEW: 101849299
NEW: 101849399
NEW: 101849499
NEW: 101849599
NEW: 101849699
NEW: 101849799
NEW: 101849899
NEW: 101849999
NEW: 101850099
NEW: 101850199
NEW: 101850299
NEW: 101850399
NEW: 101850499
NEW: 101850599
NEW: 101850699
NEW: 101850799
NEW: 101850899
NEW: 101850999
NEW: 101851099
NEW: 101851199
NEW: 101851299
NEW: 101851399
NEW: 101851499
NEW: 101851599
NEW: 101851699
NEW: 101851899
NEW: 101851999
NEW: 101852099
NEW: 101852199
NEW: 101852299
NEW: 101852399
NEW: 101852499
NEW: 101852599
NEW: 101852699
NEW: 101852799
NEW: 101852899
NEW: 101852999
NEW: 101853099
NEW: 101853199
NEW: 101853299
NEW: 101853399
NEW: 101853499
NEW: 101853599
NEW: 101853699
NEW: 101853799
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 = 27391
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101843799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1533
UPDATE oc_option_value_description
SET
name = '101843799 - AGUAR ECOLINE TALENS 30 ML AMA OCRE 227'
WHERE
option_value_id = 1533
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1533
DELETE FROM oc_product
WHERE
model = '101843799'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1533,
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 '101843899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1534
UPDATE oc_option_value_description
SET
name = '101843899 - AGUAR ECOLINE TALENS 30 ML AMA ARENA 259'
WHERE
option_value_id = 1534
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1534
DELETE FROM oc_product
WHERE
model = '101843899'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1534,
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 '101843999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1535
UPDATE oc_option_value_description
SET
name = '101843999 - AGUAR ECOLINE TALENS 30 ML VIOL AZULADO 548'
WHERE
option_value_id = 1535
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1535
DELETE FROM oc_product
WHERE
model = '101843999'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1535,
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 '101844199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1536
UPDATE oc_option_value_description
SET
name = '101844199 - AGUAR ECOLINE TALENS 30 ML AZUL PASTEL 580'
WHERE
option_value_id = 1536
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1536
DELETE FROM oc_product
WHERE
model = '101844199'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1536,
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 '101844299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1537
UPDATE oc_option_value_description
SET
name = '101844299 - AGUAR ECOLINE TALENS 30 ML ROSA PASTEL 390'
WHERE
option_value_id = 1537
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1537
DELETE FROM oc_product
WHERE
model = '101844299'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1537,
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 '101844399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1538
UPDATE oc_option_value_description
SET
name = '101844399 - AGUAR ECOLINE TALENS 30 ML CZA ESC 706'
WHERE
option_value_id = 1538
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1538
DELETE FROM oc_product
WHERE
model = '101844399'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1538,
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 '101844499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1539
UPDATE oc_option_value_description
SET
name = '101844499 - AGUAR ECOLINE TALENS 30 ML CZA CALIDO 718'
WHERE
option_value_id = 1539
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1539
DELETE FROM oc_product
WHERE
model = '101844499'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1539,
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 '101844599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1540
UPDATE oc_option_value_description
SET
name = '101844599 - AGUAR ECOLINE TALENS 30 ML CHARTREUSE 233'
WHERE
option_value_id = 1540
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1540
DELETE FROM oc_product
WHERE
model = '101844599'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1540,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.