Product Sync.
Opencart products: 179
Input products: 100
NEW: 100909199
NEW: 100909299
NEW: 100909399
NEW: 100909499
NEW: 100909599
NEW: 100909699
NEW: 100909799
NEW: 100909899
NEW: 100909999
NEW: 100910099
NEW: 100910199
NEW: 100910299
NEW: 100910399
NEW: 100910499
NEW: 100910599
NEW: 100910699
NEW: 100910799
NEW: 100910899
NEW: 100910999
NEW: 100911099
NEW: 100911199
NEW: 100911299
NEW: 100911399
NEW: 100911499
NEW: 100911599
NEW: 100911699
NEW: 100911799
NEW: 100911899
NEW: 100911999
NEW: 100912099
NEW: 100912199
NEW: 100912299
NEW: 100912399
NEW: 100912499
NEW: 100912599
NEW: 100912699
NEW: 100912799
NEW: 100912899
UPDATING: Guache Giotto 1000 ml
Product ID: 27013
Image file:
NEW: 100913499
NEW: 100913599
NEW: 100913699
NEW: 100913799
NEW: 100913899
NEW: 100913999
NEW: 100914099
NEW: 100914199
NEW: 100914299
NEW: 100914399
NEW: 100914499
NEW: 100914599
NEW: 100914699
NEW: 100914799
NEW: 100914899
NEW: 100914999
NEW: 100915099
NEW: 100915199
NEW: 100915299
NEW: 100915399
NEW: 100915499
NEW: 100915599
NEW: 100915699
NEW: 100915799
NEW: 100915899
NEW: 100915999
NEW: 100916099
NEW: 100916199
NEW: 100916299
NEW: 100916399
NEW: 100916499
NEW: 100916599
NEW: 100916699
NEW: 100916799
NEW: 100916899
NEW: 100916999
NEW: 100917099
NEW: 100917199
NEW: 100917299
NEW: 100917399
NEW: 100917499
NEW: 100917599
NEW: 100917699
NEW: 100917799
NEW: 100917899
NEW: 100917999
NEW: 100918099
NEW: 100918199
NEW: 100918299
NEW: 100918399
NEW: 100918499
NEW: 100918599
NEW: 100918699
NEW: 100918799
NEW: 100918899
NEW: 100918999
NEW: 100919099
Ok.
Product Option Sync.
Opencart products: 179
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 = 27013
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100912999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2384
UPDATE oc_option_value_description
SET
name = '100912999 - Guache Giotto 1000 ml Branco'
WHERE
option_value_id = 2384
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2384
DELETE FROM oc_product
WHERE
model = '100912999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2384
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100913099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2385
UPDATE oc_option_value_description
SET
name = '100913099 - Guache Giotto 1000 ml Amarelo Primário'
WHERE
option_value_id = 2385
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2385
DELETE FROM oc_product
WHERE
model = '100913099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2385
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100913199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2386
UPDATE oc_option_value_description
SET
name = '100913199 - Guache Giotto 1000 ml Vermelho'
WHERE
option_value_id = 2386
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2386
DELETE FROM oc_product
WHERE
model = '100913199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2386
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100913299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2387
UPDATE oc_option_value_description
SET
name = '100913299 - Guache Giotto 1000 ml Azul Primário'
WHERE
option_value_id = 2387
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2387
DELETE FROM oc_product
WHERE
model = '100913299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2387
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100913399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2388
UPDATE oc_option_value_description
SET
name = '100913399 - Guache Giotto 1000 ml Preto'
WHERE
option_value_id = 2388
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2388
DELETE FROM oc_product
WHERE
model = '100913399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2388
Ok.