Product Sync.
Opencart products: 31
Input products: 100
NEW: 102210899
NEW: 102210999
NEW: 102211099
NEW: 102211199
NEW: 102211299
NEW: 102211399
NEW: 102211499
NEW: 102211599
NEW: 102211699
NEW: 102211799
NEW: 102211899
NEW: 102211999
NEW: 102212099
NEW: 102212199
NEW: 102212299
NEW: 102212399
NEW: 102212499
NEW: 102212599
NEW: 102212699
NEW: 102212799
NEW: 102212899
NEW: 102212999
NEW: 102213099
NEW: 102213199
NEW: 102213299
NEW: 102213399
NEW: 102213499
NEW: 102213599
NEW: 102213699
NEW: 102213799
NEW: 102213899
NEW: 102213999
NEW: 102214099
NEW: 102214199
NEW: 102214299
NEW: 102214399
NEW: 102214499
NEW: 102214599
NEW: 102214699
NEW: 102214799
NEW: 102214899
NEW: 102214999
NEW: 102215099
NEW: 102215199
NEW: 102215299
NEW: 102215399
NEW: 102215499
NEW: 102215599
NEW: 102215699
NEW: 102215799
NEW: 102215899
NEW: 102215999
NEW: 102216099
NEW: 102216199
NEW: 102216299
NEW: 102216399
NEW: 102216499
NEW: 102216599
NEW: 102216699
NEW: 102216799
NEW: 102216899
NEW: 102216999
NEW: 102217099
NEW: 102217199
NEW: 102217299
NEW: 102217399
NEW: 102217499
NEW: 102217599
NEW: 102217699
NEW: 102217799
NEW: 102217899
NEW: 102217999
NEW: 102218099
NEW: 102218199
NEW: 102218299
NEW: 102218399
NEW: 102218499
NEW: 102218599
NEW: 102218699
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 102219099
NEW: 102219199
NEW: 102219299
NEW: 102219399
NEW: 102219499
NEW: 102219599
NEW: 102219799
NEW: 102219999
NEW: 102220099
NEW: 102220199
NEW: 102220299
NEW: 102220599
NEW: 102220699
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 '102218799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1903
UPDATE oc_option_value_description
SET
name = '102218799 - CX AGUAR W&N ARTIST C/24 PASTILHAS'
WHERE
option_value_id = 1903
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 = 1903
DELETE FROM oc_product
WHERE
model = '102218799'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1903,
quantity = 1,
subtract = 1,
price = 77.236,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102218899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1904
UPDATE oc_option_value_description
SET
name = '102218899 - CX AGUAR REMBR EXTRA FINA C/48 PASTILHAS'
WHERE
option_value_id = 1904
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 = 1904
DELETE FROM oc_product
WHERE
model = '102218899'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1904,
quantity = 1,
subtract = 1,
price = 128.496,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102218999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1905
UPDATE oc_option_value_description
SET
name = '102218999 - CX AGUAR W&N COTMAN C/12 PASTILHAS'
WHERE
option_value_id = 1905
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 = 1905
DELETE FROM oc_product
WHERE
model = '102218999'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1905,
quantity = 1,
subtract = 1,
price = 11.423,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102219699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1906
UPDATE oc_option_value_description
SET
name = '102219699 - CXA AGUAR W&N COTMAN C/ 6TUB 12ML + LIVRO DICAS E TECN'
WHERE
option_value_id = 1906
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 = 1906
DELETE FROM oc_product
WHERE
model = '102219699'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1906,
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 '102219899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1907
UPDATE oc_option_value_description
SET
name = '102219899 - CXA ACRIL W&N GALERIA C/ 6TB 12ML + LIVRO DICAS E TECN'
WHERE
option_value_id = 1907
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 = 1907
DELETE FROM oc_product
WHERE
model = '102219899'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1907,
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 '102220399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1908
UPDATE oc_option_value_description
SET
name = '102220399 - CX MAD DR ACRIL GRADUATE'
WHERE
option_value_id = 1908
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 = 1908
DELETE FROM oc_product
WHERE
model = '102220399'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1908,
quantity = 1,
subtract = 1,
price = 17.073,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102220499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1909
UPDATE oc_option_value_description
SET
name = '102220499 - CAVAL COMBI MESA DR GRADUATE CX ACRIL + ACESSORIOS'
WHERE
option_value_id = 1909
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 = 1909
DELETE FROM oc_product
WHERE
model = '102220499'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1909,
quantity = 1,
subtract = 1,
price = 20.325,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102220799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1910
UPDATE oc_option_value_description
SET
name = '102220799 - CX CAVAL MESA DR GRADUATE ACRIL C/ACESS'
WHERE
option_value_id = 1910
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 = 1910
DELETE FROM oc_product
WHERE
model = '102220799'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1910,
quantity = 1,
subtract = 1,
price = 20.325,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.