Product Sync.
Opencart products: 44
Input products: 100
NEW: 100252599
NEW: 100252699
NEW: 100252799
NEW: 100252999
NEW: 100253099
NEW: 100253199
NEW: 100253299
NEW: 100253399
NEW: 100253499
NEW: 100253599
NEW: 100253699
NEW: 100253799
NEW: 100253899
NEW: 100253999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100253999 - %'
)
NEW: 100254099
NEW: 100254199
NEW: 100254299
NEW: 100254399
NEW: 100254499
NEW: 100254599
NEW: 100254699
NEW: 100254799
NEW: 100254899
NEW: 100254999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100254999 - %'
)
NEW: 100255099
NEW: 100255199
NEW: 100255299
NEW: 100255399
NEW: 100255499
NEW: 100255599
NEW: Diluente sem Cheiro Inart
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Diluente sem Cheiro Inart - %'
)
NEW: 100255799
NEW: 100255899
NEW: 100255999
NEW: 100256099
NEW: 100256199
NEW: 100256299
NEW: 100256399
NEW: 100256499
NEW: 100256599
NEW: 100256699
NEW: 100256799
NEW: 100256899
NEW: 100256999
NEW: 100257099
NEW: 100257199
NEW: 100257299
NEW: 100257399
NEW: 100257499
NEW: 100257599
NEW: 100257699
NEW: 100257799
NEW: 100257899
NEW: 100257999
NEW: 100258099
NEW: 100258199
NEW: 100258299
NEW: 100258399
NEW: 100258499
NEW: 100258599
NEW: 100258699
NEW: 100258799
NEW: 100258899
NEW: 100258999
NEW: 100259099
NEW: 100259199
NEW: 100259299
NEW: 100259399
NEW: 100259499
NEW: 100259599
NEW: 100259699
NEW: 100259799
NEW: 100259899
NEW: 100259999
NEW: 100260099
NEW: 100260199
NEW: 100260299
NEW: 100260399
NEW: 100260499
NEW: 100260599
NEW: 100260699
NEW: 100260799
NEW: 100260899
NEW: 100260999
NEW: 100261099
NEW: 100261199
NEW: 100261299
NEW: 100261399
NEW: 100261499
NEW: 100261599
NEW: 100261699
NEW: 100261799
NEW: 100261899
NEW: 100261999
NEW: 100262099
NEW: 100262199
NEW: 100262299
NEW: 100262399
NEW: 100262499
NEW: 100262599
Ok.
Product Option Sync.
Opencart products: 47
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 = 27444
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27444,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100255699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3264 AS option_value_id,
language_id,
17 AS option_id,
'100255699 - Diluente sem Cheiro Inart 500 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 423
AND product_id = 27444
AND option_id = 17
AND option_value_id = 3264
DELETE FROM oc_product
WHERE
model = '100255699'
INSERT INTO oc_product_option_value
SET
product_option_id = 423,
product_id = 27444,
option_id = 17,
option_value_id = 3264,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.