Product Sync.
Opencart products: 95
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
NEW: Tinta Óleo Talens Rembrandt 15 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Óleo Talens Rembrandt 15 ml - %'
)
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: 27459
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: 96
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 = 27493
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27493,
option_id = 17,
value = '',
required = 1
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 = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1764
DELETE FROM oc_product
WHERE
model = '101085799'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1764,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27459
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101087299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3480 AS option_value_id,
language_id,
17 AS option_id,
'101087299 - Tela Talens Banda Larga 100 x 160' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3480
DELETE FROM oc_product
WHERE
model = '101087299'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3480,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.