Product Sync.
Opencart products: 185
Input products: 100
NEW: 101080799
NEW: 101080899
NEW: 101080999
NEW: 101081099
NEW: 101081199
NEW: 101081299
NEW: 101081399
NEW: 101081499
NEW: 101081599
NEW: 101081699
NEW: 101081799
NEW: 101081899
NEW: 101081999
NEW: 101082099
NEW: 101082199
NEW: 101082299
NEW: 101082399
NEW: 101082499
NEW: 101082599
NEW: 101082699
NEW: 101082799
NEW: 101082899
NEW: 101082999
NEW: 101083099
NEW: 101083199
NEW: 101083299
NEW: 101083399
NEW: 101083499
NEW: 101083599
NEW: 101083699
NEW: 101083799
NEW: 101083899
NEW: 101083999
NEW: 101084099
NEW: 101084199
NEW: 101084299
NEW: 101084399
NEW: 101084499
NEW: 101084599
NEW: 101084699
NEW: 101084799
NEW: 101084899
NEW: 101084999
NEW: 101085099
NEW: 101085199
NEW: 101085299
NEW: 101085399
NEW: 101085499
NEW: 101085599
NEW: 101085699
UPDATING: Tinta Óleo Talens Rembrandt 15 ml
Product ID: 27057
Image file:
NEW: 101085899
NEW: 101085999
NEW: 101086099
NEW: 101086199
NEW: 101086299
NEW: 101086399
NEW: 101086499
NEW: 101086599
NEW: 101086699
NEW: 101086799
NEW: 101086899
NEW: 101086999
NEW: 101087099
NEW: 101087199
UPDATING: Tela Talens
Product ID: 27034
Image file:
NEW: 101087399
NEW: 101087499
NEW: 101087599
NEW: 101087699
NEW: 101087799
NEW: 101087899
NEW: 101087999
NEW: 101088099
NEW: 101088199
NEW: 101088299
NEW: 101088399
NEW: 101088499
NEW: 101088599
NEW: 101088699
NEW: 101088799
NEW: 101088899
NEW: 101088999
NEW: 101089099
NEW: 101089199
NEW: 101089299
NEW: 101089399
NEW: 101089499
NEW: 101089599
NEW: 101089699
NEW: 101089799
NEW: 101089899
NEW: 101089999
NEW: 101090099
NEW: 101090199
NEW: 101090299
NEW: 101090399
NEW: 101090499
NEW: 101090599
NEW: 101090699
Ok.
Product Option Sync.
Opencart products: 185
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 = 27057
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101085799 - %'
UPDATE oc_option_value
SET
image = 'catalog/101085799.jpg'
WHERE
option_value_id = 1764
UPDATE oc_option_value_description
SET
name = '101085799 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Asfalto (414)'
WHERE
option_value_id = 1764
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 122
AND product_id = 27057
AND option_id = 15
AND option_value_id = 1764
DELETE FROM oc_product
WHERE
model = '101085799'
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 = 122
AND product_id = 27057
AND option_id = 15
AND option_value_id = 1764
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27034
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101087299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2399
UPDATE oc_option_value_description
SET
name = '101087299 - Tela Talens Banda Larga 100 x 160'
WHERE
option_value_id = 2399
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2399
DELETE FROM oc_product
WHERE
model = '101087299'
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 = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2399
Ok.