Product Sync.
Opencart products: 56
Input products: 100
NEW: 100394099
NEW: Pincel Pelikan 25A
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Pelikan 25A - %'
)
NEW: 100394499
NEW: Tinta para Tecido Pébéo Setacolor
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta para Tecido Pébéo Setacolor - %'
)
NEW: 100394699
NEW: 100394799
NEW: 100394899
NEW: 100394999
NEW: 100395099
NEW: 100395199
NEW: 100395299
NEW: Cera Pébéo Gedeo para Dourar
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cera Pébéo Gedeo para Dourar - %'
)
NEW: 100395499
NEW: 100395599
NEW: 100395699
NEW: 100395799
NEW: 100395899
NEW: 100395999
NEW: 100396199
NEW: 100396299
NEW: 100396399
NEW: 100396499
NEW: 100396599
NEW: 100396699
NEW: 100396799
NEW: 100396899
NEW: 100396999
NEW: 100397099
NEW: 100397199
NEW: 100397299
NEW: 100397399
NEW: 100397499
NEW: 100397599
NEW: 100397699
NEW: 100397799
NEW: 100397899
NEW: 100397999
NEW: 100398099
NEW: 100398199
NEW: 100398299
NEW: 100398399
NEW: 100398499
NEW: 100398599
NEW: 100398699
NEW: 100398799
NEW: 100398899
NEW: 100398999
NEW: 100399099
NEW: 100399199
NEW: 100399299
NEW: 100399399
NEW: 100399499
NEW: 100399599
NEW: 100399699
NEW: 100399799
NEW: 100399899
NEW: 100399999
NEW: 100400099
NEW: 100400199
NEW: 100400299
NEW: 100400399
NEW: 100400499
NEW: 100400599
NEW: 100400699
NEW: 100400799
NEW: 100400899
NEW: 100400999
NEW: 100401099
NEW: 100401199
NEW: 100401299
NEW: 100401399
NEW: 100401499
NEW: 100401599
NEW: 100401699
NEW: 100401799
NEW: 100401899
NEW: 100401999
NEW: 100402099
NEW: 100402199
NEW: 100402299
NEW: 100402399
NEW: 100402499
NEW: 100402599
NEW: 100402699
NEW: 100402799
NEW: 100402899
NEW: 100402999
NEW: 100403099
NEW: 100403199
NEW: 100403299
NEW: 100403399
NEW: 100403499
NEW: 100403599
NEW: 100403699
NEW: 100403799
NEW: 100403899
NEW: 100403999
Ok.
Product Option Sync.
Opencart products: 59
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 = 27454
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27454,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100394199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3274 AS option_value_id,
language_id,
17 AS option_id,
'100394199 - Pincel Pelikan 25A N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3274
DELETE FROM oc_product
WHERE
model = '100394199'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3274,
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 '100394299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3275 AS option_value_id,
language_id,
17 AS option_id,
'100394299 - Pincel Pelikan 25A N4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3275
DELETE FROM oc_product
WHERE
model = '100394299'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3275,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100394399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3276 AS option_value_id,
language_id,
17 AS option_id,
'100394399 - Pincel Pelikan 25A N3' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3276
DELETE FROM oc_product
WHERE
model = '100394399'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3276,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27455
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27455,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100394599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3277 AS option_value_id,
language_id,
17 AS option_id,
'100394599 - \''Setacolor Opaco Amarelo Rico Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3277
DELETE FROM oc_product
WHERE
model = '100394599'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3277,
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 '100396099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3278 AS option_value_id,
language_id,
17 AS option_id,
'100396099 - Setacolor Opaco Preto Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3278
DELETE FROM oc_product
WHERE
model = '100396099'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3278,
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 = 27456
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27456,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100395399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3279 AS option_value_id,
language_id,
17 AS option_id,
'100395399 - Cera Pébéo Gedeo para Dourar 30 ml Prata' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 435
AND product_id = 27456
AND option_id = 17
AND option_value_id = 3279
DELETE FROM oc_product
WHERE
model = '100395399'
INSERT INTO oc_product_option_value
SET
product_option_id = 435,
product_id = 27456,
option_id = 17,
option_value_id = 3279,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.