Product Sync.
Opencart products: 61
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
NEW: Tela Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tela Talens - %'
)
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: 27413
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: 62
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 = 27459
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27459,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100466199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3334 AS option_value_id,
language_id,
17 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 = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3334
DELETE FROM oc_product
WHERE
model = '100466199'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3334,
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 = 27413
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100471999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3335 AS option_value_id,
language_id,
17 AS option_id,
'100471999 - Guache Giotto 250 ml Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 3335
DELETE FROM oc_product
WHERE
model = '100471999'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 3335,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.