Product Sync.
Opencart products: 29
Input products: 100
NEW: 101793199
NEW: 101793299
NEW: 101793399
NEW: 101793499
NEW: 101793599
NEW: 101793699
NEW: 101793799
NEW: 101793899
NEW: 101793999
NEW: 101794099
NEW: 101794199
NEW: 101794299
NEW: 101794399
NEW: 101794499
NEW: 101794599
NEW: 101794799
NEW: 101794899
NEW: 101794999
NEW: 101795099
NEW: 101795199
NEW: 101795299
NEW: 101795399
NEW: 101795499
NEW: 101795599
NEW: 101795699
NEW: 101795799
NEW: 101795899
NEW: 101795999
NEW: 101796099
NEW: 101796199
NEW: 101796299
NEW: 101796399
NEW: 101796499
NEW: 101796599
NEW: 101796699
NEW: 101796799
NEW: 101796899
NEW: 101796999
NEW: 101797099
NEW: 101797199
NEW: 101797299
NEW: 101797399
NEW: 101797499
NEW: 101797599
NEW: 101797699
NEW: 101797799
NEW: 101797899
NEW: 101797999
NEW: 101798099
NEW: 101798199
NEW: 101798299
NEW: 101798399
NEW: 101798499
NEW: 101798599
NEW: 101798699
NEW: 101798799
NEW: 101798899
NEW: 101798999
NEW: 101799099
NEW: 101799199
NEW: 101799299
NEW: 101799399
NEW: 101799499
NEW: 101799599
NEW: 101799699
NEW: 101799799
NEW: 101799899
NEW: 101799999
NEW: 101800099
NEW: 101800199
NEW: 101800299
NEW: 101800399
NEW: 101800499
NEW: 101800599
NEW: 101800699
NEW: 101800799
NEW: 101800899
NEW: 101800999
NEW: 101801099
NEW: 101801199
NEW: 101801299
NEW: 101801399
NEW: 101801499
NEW: 101801599
NEW: 101801699
NEW: 101801799
NEW: 101801899
NEW: 101801999
NEW: 101802099
NEW: 101802199
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 101802599
NEW: 101802699
NEW: 101802799
NEW: 101802899
NEW: 101802999
NEW: 101803099
NEW: 101803199
Ok.
Product Option Sync.
Opencart products: 29
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 '101802299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1818
UPDATE oc_option_value_description
SET
name = '101802299 - CXA AGUAR DR C/12 PASTILHAS'
WHERE
option_value_id = 1818
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 = 1818
DELETE FROM oc_product
WHERE
model = '101802299'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1818,
quantity = 1,
subtract = 1,
price = 8.049,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101802399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1819
UPDATE oc_option_value_description
SET
name = '101802399 - CXA AGUAR DR C/12 MEIAS PASTILHAS'
WHERE
option_value_id = 1819
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 = 1819
DELETE FROM oc_product
WHERE
model = '101802399'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1819,
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 '101802499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1820
UPDATE oc_option_value_description
SET
name = '101802499 - CXA AGUAR DR C/10 TUBOS'
WHERE
option_value_id = 1820
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 = 1820
DELETE FROM oc_product
WHERE
model = '101802499'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1820,
quantity = 1,
subtract = 1,
price = 19.553,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.