Product Sync.
Opencart products: 31
Input products: 100
NEW: 102038299
NEW: 102038399
NEW: 102038499
NEW: 102038599
NEW: 102038699
NEW: 102038799
NEW: 102038899
NEW: 102038999
NEW: 102039099
NEW: 102039199
NEW: 102039299
NEW: 102039399
NEW: 102039499
NEW: 102039599
NEW: 102039699
NEW: 102039799
NEW: 102039899
NEW: 102039999
NEW: 102040099
NEW: 102040199
NEW: 102040299
NEW: 102040399
NEW: 102040499
NEW: 102040599
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 102040799
NEW: 102040899
NEW: 102040999
NEW: 102041099
NEW: 102041199
NEW: 102041299
NEW: 102041399
NEW: 102041499
NEW: 102041599
NEW: 102041699
NEW: 102041799
NEW: 102041899
NEW: 102041999
NEW: 102042099
NEW: 102042199
NEW: 102042299
NEW: 102042399
NEW: 102042499
NEW: 102042599
NEW: 102042699
NEW: 102042799
NEW: 102042899
NEW: 102043099
NEW: 102043199
NEW: 102043299
NEW: 102043399
NEW: 102043499
NEW: 102043699
NEW: 102043799
NEW: 102043899
NEW: 102043999
NEW: 102044099
NEW: 102044199
NEW: 102044299
NEW: 102044399
NEW: 102044499
NEW: 102044699
NEW: 102044799
NEW: 102044899
NEW: 102044999
NEW: 102045099
NEW: 102045199
NEW: 102045299
NEW: 102045399
NEW: 102045499
NEW: 102045599
NEW: 102045699
UPDATING: Giotto 7,5 e 10ml
Product ID: 27388
Image file: Giotto 7,5 e 10ml.jpg
UPDATING: Giotto 250ml
Product ID: 27384
Image file: Giotto 250ml.jpg
NEW: 102046699
NEW: 102046799
NEW: 102046899
NEW: 102046999
NEW: 102047099
NEW: 102047199
NEW: 102047299
NEW: 102047499
NEW: 102047599
UPDATING: Pelikan 10ml
Product ID: 27390
Image file: Pelikan 10ml.jpg
NEW: 102047799
NEW: 102047899
NEW: 102047999
NEW: 102048099
NEW: 102048199
NEW: 102048299
NEW: 102048399
NEW: 102048499
NEW: 102048599
Ok.
Product Option Sync.
Opencart products: 31
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 = 27382
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102040699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1685
UPDATE oc_option_value_description
SET
name = '102040699 - AGUAR TALENS 8ML CORES DIV'
WHERE
option_value_id = 1685
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1685
DELETE FROM oc_product
WHERE
model = '102040699'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1685,
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 = 27388
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102045799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1886
UPDATE oc_option_value_description
SET
name = '102045799 - GUACHE GIOT ESCOLAR 25ML C/6 UN + PINCEL'
WHERE
option_value_id = 1886
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1886
DELETE FROM oc_product
WHERE
model = '102045799'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1886,
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 = 27384
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102045899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1887
UPDATE oc_option_value_description
SET
name = '102045899 - GUACHE GIOT 250ML REF 530801 BCO'
WHERE
option_value_id = 1887
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1887
DELETE FROM oc_product
WHERE
model = '102045899'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1887,
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 '102045999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1888
UPDATE oc_option_value_description
SET
name = '102045999 - GUACHE GIOT 250ML REF 530802 AMA'
WHERE
option_value_id = 1888
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1888
DELETE FROM oc_product
WHERE
model = '102045999'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1888,
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 '102046099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1889
UPDATE oc_option_value_description
SET
name = '102046099 - GUACHE GIOT 250ML REF 530808 VERM ESC'
WHERE
option_value_id = 1889
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1889
DELETE FROM oc_product
WHERE
model = '102046099'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1889,
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 '102046199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1890
UPDATE oc_option_value_description
SET
name = '102046199 - GUACHE GIOT 250ML REF 530810 MAG'
WHERE
option_value_id = 1890
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1890
DELETE FROM oc_product
WHERE
model = '102046199'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1890,
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 '102046299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1891
UPDATE oc_option_value_description
SET
name = '102046299 - GUACHE GIOT 250ML REF 530812 VDE'
WHERE
option_value_id = 1891
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1891
DELETE FROM oc_product
WHERE
model = '102046299'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1891,
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 '102046399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1892
UPDATE oc_option_value_description
SET
name = '102046399 - GUACHE GIOT 250ML REF 530815 AZL CYAN'
WHERE
option_value_id = 1892
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1892
DELETE FROM oc_product
WHERE
model = '102046399'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1892,
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 '102046499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1893
UPDATE oc_option_value_description
SET
name = '102046499 - GUACHE GIOT 250ML REF 530824 PTO'
WHERE
option_value_id = 1893
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1893
DELETE FROM oc_product
WHERE
model = '102046499'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1893,
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 '102046599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1894
UPDATE oc_option_value_description
SET
name = '102046599 - GUACHE GIOT 250ML REF 530828 CAST'
WHERE
option_value_id = 1894
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1894
DELETE FROM oc_product
WHERE
model = '102046599'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1894,
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 = 27390
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102047699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1895
UPDATE oc_option_value_description
SET
name = '102047699 - GUACHE PELIKAN 10ML 740/3 CAST'
WHERE
option_value_id = 1895
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1895
DELETE FROM oc_product
WHERE
model = '102047699'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1895,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.