Product Sync.
Opencart products: 42
Input products: 100
NEW: 100242499
NEW: 100242599
NEW: 100242699
NEW: 100242799
NEW: 100242899
NEW: 100242999
NEW: 100243099
NEW: 100243199
NEW: 100243299
NEW: 100243399
NEW: 100243499
NEW: 100243599
NEW: 100243699
NEW: 100243799
NEW: 100243899
NEW: 100243999
NEW: 100244099
NEW: 100244199
NEW: 100244299
NEW: 100244399
NEW: 100244499
NEW: 100244599
NEW: 100244699
NEW: 100244799
NEW: 100244899
NEW: 100244999
NEW: 100245099
NEW: 100245199
NEW: 100245299
NEW: 100245399
NEW: 100245499
NEW: 100245599
NEW: 100245699
NEW: 100245799
NEW: 100245899
NEW: 100245999
NEW: Folha Ouro e Prata Pébéo 14 x 14 cm Caixa com 25 Folhas
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Folha Ouro e Prata Pébéo 14 x 14 cm Caixa com 25 Folhas - %'
)
NEW: 100246199
NEW: Óleo de Linho Inart
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Óleo de Linho Inart - %'
)
NEW: 100246399
NEW: 100246499
NEW: 100246599
NEW: 100246699
NEW: 100246799
NEW: 100246899
NEW: 100246999
NEW: 100247099
NEW: 100247199
NEW: 100247299
NEW: 100247399
NEW: 100247499
NEW: 100247599
NEW: 100247699
NEW: 100247799
NEW: 100247899
NEW: 100247999
NEW: 100248099
NEW: 100248199
NEW: 100248299
NEW: 100248399
NEW: 100248499
NEW: 100248599
NEW: 100248699
NEW: 100248799
NEW: 100248899
NEW: 100248999
NEW: 100249099
NEW: 100249199
NEW: 100249299
NEW: 100249399
NEW: 100249499
NEW: 100249599
NEW: 100249699
NEW: 100249799
NEW: 100249899
NEW: 100249999
NEW: 100250099
NEW: 100250199
NEW: 100250299
NEW: 100250399
NEW: 100250499
NEW: 100250599
NEW: 100250699
NEW: 100250799
NEW: 100250899
NEW: 100250999
NEW: 100251099
NEW: 100251199
NEW: 100251299
NEW: 100251399
NEW: 100251499
NEW: 100251599
NEW: 100251699
NEW: 100251799
NEW: 100251899
NEW: 100251999
NEW: 100252099
NEW: 100252199
NEW: 100252299
NEW: 100252399
Ok.
Product Option Sync.
Opencart products: 44
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 = 27440
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27440,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100246099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3262 AS option_value_id,
language_id,
17 AS option_id,
'100246099 - Mordente para Folha Ouro 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 421
AND product_id = 27440
AND option_id = 17
AND option_value_id = 3262
DELETE FROM oc_product
WHERE
model = '100246099'
INSERT INTO oc_product_option_value
SET
product_option_id = 421,
product_id = 27440,
option_id = 17,
option_value_id = 3262,
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 = 27441
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27441,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100246299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/100246299.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3263 AS option_value_id,
language_id,
17 AS option_id,
'100246299 - Óleo Linho Inart Clarificado 250ML' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 422
AND product_id = 27441
AND option_id = 17
AND option_value_id = 3263
DELETE FROM oc_product
WHERE
model = '100246299'
INSERT INTO oc_product_option_value
SET
product_option_id = 422,
product_id = 27441,
option_id = 17,
option_value_id = 3263,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.