Product Sync.
Opencart products: 29
Input products: 100
NEW: 101661699
NEW: 101661799
NEW: 101661899
NEW: 101661999
NEW: 101662099
NEW: 101662199
NEW: 101662299
NEW: 101662399
NEW: 101662499
NEW: 101662599
NEW: 101662699
NEW: 101662799
NEW: 101662899
NEW: 101662999
NEW: 101663099
NEW: 101663199
NEW: 101663299
NEW: 101663399
NEW: 101663499
NEW: 101663599
NEW: 101663699
NEW: 101663799
NEW: 101663899
NEW: 101663999
NEW: 101664099
NEW: 101664199
NEW: 101664299
NEW: 101664399
NEW: 101664499
NEW: 101664599
NEW: 101664699
NEW: 101664799
NEW: 101664899
NEW: 101664999
NEW: 101665099
NEW: 101665199
NEW: 101665299
NEW: 101665399
NEW: 101665499
NEW: 101665599
NEW: 101665699
NEW: 101665799
NEW: 101665899
NEW: 101665999
NEW: 101666099
NEW: 101666199
NEW: 101666299
NEW: 101666399
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 101666799
NEW: 101666899
NEW: 101666999
NEW: 101667099
NEW: 101667199
NEW: 101667299
NEW: 101667399
NEW: 101667499
NEW: 101667599
NEW: 101667699
NEW: 101667799
NEW: 101667899
NEW: 101667999
NEW: 101668099
NEW: 101668199
NEW: 101668299
NEW: 101668399
NEW: 101668499
NEW: 101668599
NEW: 101668699
NEW: 101668799
NEW: 101668899
NEW: 101668999
NEW: 101669099
NEW: 101669199
NEW: 101669299
NEW: 101669399
NEW: 101669499
NEW: 101669599
NEW: 101669699
NEW: 101669799
NEW: 101669899
NEW: 101669999
NEW: 101670199
NEW: 101670299
NEW: 101670399
NEW: 101670499
NEW: 101670599
NEW: 101670699
NEW: 101670799
NEW: 101670899
NEW: 101670999
NEW: 101671099
NEW: 101671199
NEW: 101671299
NEW: 101671399
NEW: 101671499
NEW: 101671599
NEW: 101671699
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 '101666499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1815
UPDATE oc_option_value_description
SET
name = '101666499 - CX AGUAR W&N BARRA C/10'
WHERE
option_value_id = 1815
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 = 1815
DELETE FROM oc_product
WHERE
model = '101666499'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1815,
quantity = 1,
subtract = 1,
price = 12.683,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101666599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1816
UPDATE oc_option_value_description
SET
name = '101666599 - MARC AGUARELA W&N CX C/6'
WHERE
option_value_id = 1816
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 = 1816
DELETE FROM oc_product
WHERE
model = '101666599'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1816,
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 '101666699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1817
UPDATE oc_option_value_description
SET
name = '101666699 - MARC AGUARELA W&N CX C/12'
WHERE
option_value_id = 1817
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 = 1817
DELETE FROM oc_product
WHERE
model = '101666699'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1817,
quantity = 1,
subtract = 1,
price = 18.618,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.