Product Sync.
Opencart products: 161
Input products: 100
NEW: 100464799
NEW: 100464899
NEW: 100464999
NEW: 100465099
NEW: 100465199
NEW: 100465299
NEW: 100465399
NEW: 100465499
NEW: 100465599
NEW: 100465699
NEW: 100465799
NEW: 100465899
NEW: 100465999
NEW: 100466099
UPDATING: Tela Talens
Product ID: 27034
Image file:
NEW: 100466299
NEW: 100466399
NEW: 100466499
NEW: 100466599
NEW: 100466699
NEW: 100466799
NEW: 100466899
NEW: 100466999
NEW: 100467099
NEW: 100467199
NEW: 100467299
NEW: 100467399
NEW: 100467499
NEW: 100467599
NEW: 100467699
NEW: 100467799
NEW: 100467899
NEW: 100467999
NEW: 100468099
NEW: 100468199
NEW: 100468299
NEW: 100468399
NEW: 100468499
NEW: 100468599
NEW: 100468699
NEW: 100468799
NEW: 100468899
NEW: 100468999
NEW: 100469099
NEW: 100469199
NEW: 100469299
NEW: 100469399
NEW: 100469499
NEW: 100469599
NEW: 100469699
NEW: 100469799
NEW: 100469899
NEW: 100469999
NEW: 100470099
NEW: 100470199
NEW: 100470299
NEW: 100470399
NEW: 100470499
NEW: 100470599
NEW: 100470699
NEW: 100470799
NEW: 100470899
NEW: 100470999
NEW: 100471099
NEW: 100471199
NEW: 100471299
NEW: 100471399
NEW: 100471499
NEW: 100471599
NEW: 100471699
NEW: 100471799
NEW: 100471899
UPDATING: Guache Giotto Frasco 250 ml
Product ID: 26995
Image file:
NEW: 100472099
NEW: 100472199
NEW: 100472299
NEW: 100472399
NEW: 100472499
NEW: 100472599
NEW: 100472699
NEW: 100472799
NEW: 100472899
NEW: 100472999
NEW: 100473099
NEW: 100473199
NEW: 100473299
NEW: 100473399
NEW: 100473499
NEW: 100473599
NEW: 100473699
NEW: 100473799
NEW: 100473899
NEW: 100473999
NEW: 100474099
NEW: 100474199
NEW: 100474299
NEW: 100474399
NEW: 100474499
NEW: 100474599
NEW: 100474699
Ok.
Product Option Sync.
Opencart products: 161
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 = 27034
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100466199 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3176 AS option_value_id,
language_id,
15 AS option_id,
'100466199 - \''Tela Talens Banda Larga 60 x 60' AS name
FROM
oc_language
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 = 3176
DELETE FROM oc_product
WHERE
model = '100466199'
INSERT INTO oc_product_option_value
SET
product_option_id = 101,
product_id = 27034,
option_id = 15,
option_value_id = 3176,
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 = 26995
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100471999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2245
UPDATE oc_option_value_description
SET
name = '100471999 - Guache Giotto 250 ml Rosa'
WHERE
option_value_id = 2245
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 2245
DELETE FROM oc_product
WHERE
model = '100471999'
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 2245
Ok.