Product Sync.
Opencart products: 90
Input products: 100
NEW: 101020199
NEW: 101020299
NEW: 101020399
NEW: 101020499
NEW: 101020599
NEW: 101020699
NEW: 101020799
NEW: 101020899
NEW: 101020999
NEW: 101021099
NEW: 101021199
NEW: 101021299
NEW: 101021399
NEW: 101021499
NEW: 101021599
NEW: 101021699
NEW: 101021799
NEW: 101021899
NEW: 101021999
NEW: 101022099
NEW: 101022199
NEW: 101022299
NEW: 101022399
NEW: 101022499
NEW: 101022599
NEW: 101022699
NEW: 101022799
NEW: 101022899
NEW: 101022999
NEW: 101023099
NEW: 101023199
NEW: 101023299
NEW: 101023399
NEW: 101023499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101023499 - %'
)
NEW: 101023599
NEW: Goma Laca Inart
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Goma Laca Inart - %'
)
NEW: 101023799
NEW: Tinta da China Sennelier
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta da China Sennelier - %'
)
NEW: 101024099
NEW: 101024199
NEW: 101024299
NEW: 101024399
NEW: 101024499
NEW: 101024599
NEW: 101024699
NEW: 101024799
NEW: 101024899
NEW: 101024999
NEW: 101025099
NEW: 101025199
NEW: 101025299
NEW: 101025399
NEW: 101025499
NEW: 101025599
NEW: 101025699
NEW: 101025799
NEW: 101025899
NEW: 101025999
NEW: 101026099
NEW: 101026199
NEW: 101026299
NEW: 101026399
NEW: 101026499
NEW: 101026599
NEW: 101026699
NEW: 101026799
NEW: 101026899
NEW: 101026999
NEW: 101027099
NEW: 101027199
NEW: 101027299
NEW: 101027399
NEW: 101027499
NEW: 101027599
NEW: 101027699
NEW: 101027799
NEW: 101027899
NEW: 101027999
NEW: 101028099
NEW: 101028199
NEW: 101028299
NEW: 101028399
NEW: 101028499
NEW: 101028599
NEW: 101028699
NEW: 101028799
NEW: 101028899
NEW: 101028999
NEW: 101029099
NEW: 101029199
NEW: 101029299
NEW: 101029399
NEW: 101029499
NEW: 101029599
NEW: 101029699
NEW: 101029799
NEW: 101029899
NEW: 101029999
NEW: 101030099
Ok.
Product Option Sync.
Opencart products: 93
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 = 27489
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27489,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101023699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101023699.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3475 AS option_value_id,
language_id,
17 AS option_id,
'101023699 - Goma Laca Inart Incolor 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 459
AND product_id = 27489
AND option_id = 17
AND option_value_id = 3475
DELETE FROM oc_product
WHERE
model = '101023699'
INSERT INTO oc_product_option_value
SET
product_option_id = 459,
product_id = 27489,
option_id = 17,
option_value_id = 3475,
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 = 27490
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27490,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101023899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101023899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3476 AS option_value_id,
language_id,
17 AS option_id,
'101023899 - Tinta da China Sennelier 30 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 460
AND product_id = 27490
AND option_id = 17
AND option_value_id = 3476
DELETE FROM oc_product
WHERE
model = '101023899'
INSERT INTO oc_product_option_value
SET
product_option_id = 460,
product_id = 27490,
option_id = 17,
option_value_id = 3476,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101023999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3477 AS option_value_id,
language_id,
17 AS option_id,
'101023999 - Tinta da China Sennelier 125 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 460
AND product_id = 27490
AND option_id = 17
AND option_value_id = 3477
DELETE FROM oc_product
WHERE
model = '101023999'
INSERT INTO oc_product_option_value
SET
product_option_id = 460,
product_id = 27490,
option_id = 17,
option_value_id = 3477,
quantity = 1,
subtract = 1,
price = 4.756,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.