Product Sync.
Opencart products: 164
Input products: 100
NEW: 102191799
NEW: 102191899
NEW: 102191999
NEW: 102192099
NEW: 102192199
NEW: 102192299
NEW: 102192399
NEW: 102192499
NEW: 102192599
NEW: 102192699
NEW: 102192799
NEW: 102192899
NEW: 102192999
NEW: 102193099
NEW: 102193199
NEW: 102193299
NEW: 102193399
NEW: 102193499
NEW: 102193599
NEW: 102193699
NEW: 102193799
NEW: 102193899
NEW: 102193999
NEW: 102194099
NEW: 102194199
NEW: 102194299
NEW: 102194399
NEW: 102194499
NEW: 102194599
NEW: 102194699
NEW: 102194799
NEW: 102194899
NEW: 102194999
NEW: 102195099
NEW: 102195199
NEW: 102195299
NEW: Terebentina Rectificada Inart
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Terebentina Rectificada Inart - %'
)
UPDATING: Diluente sem Cheiro Inart
Product ID: 27444
Image file:
NEW: 102195699
NEW: 102195799
NEW: 102195899
NEW: 102195999
NEW: 102196099
NEW: 102196199
NEW: 102196299
NEW: 102196399
NEW: 102196499
NEW: 102196599
NEW: 102196699
NEW: 102196799
NEW: 102196899
NEW: 102196999
NEW: 102197099
NEW: 102197199
NEW: 102197299
NEW: 102197399
NEW: 102197499
NEW: 102197599
NEW: 102197699
NEW: 102197799
UPDATING: Folha Ouro e Prata Pébéo 14 x 14 cm Caixa com 25 Folhas
Product ID: 27440
Image file:
NEW: 102198099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102198099 - %'
)
NEW: 102198199
NEW: 102198299
NEW: 102198399
NEW: 102198499
NEW: 102198599
NEW: 102198699
NEW: 102198799
NEW: 102198899
NEW: 102198999
NEW: 102199099
NEW: 102199199
NEW: 102199299
NEW: 102199399
NEW: 102199499
NEW: 102199599
NEW: 102199699
NEW: 102199799
NEW: 102199899
NEW: 102199999
NEW: 102200099
NEW: 102200199
NEW: 102200299
NEW: 102200399
NEW: 102200499
NEW: 102200599
NEW: 102200699
NEW: 102200799
NEW: 102200899
NEW: 102200999
NEW: 102201099
NEW: 102201199
NEW: 102201299
NEW: 102201399
NEW: 102201499
NEW: 102201599
NEW: 102201699
Ok.
Product Option Sync.
Opencart products: 166
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 = 27562
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27562,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102195399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/102195399.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3681 AS option_value_id,
language_id,
17 AS option_id,
'102195399 - Terebentina Rectificada Inart 500 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 497
AND product_id = 27562
AND option_id = 17
AND option_value_id = 3681
DELETE FROM oc_product
WHERE
model = '102195399'
INSERT INTO oc_product_option_value
SET
product_option_id = 497,
product_id = 27562,
option_id = 17,
option_value_id = 3681,
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 '102195499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3682 AS option_value_id,
language_id,
17 AS option_id,
'102195499 - Terebentina Rectificada Inart 1000 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 497
AND product_id = 27562
AND option_id = 17
AND option_value_id = 3682
DELETE FROM oc_product
WHERE
model = '102195499'
INSERT INTO oc_product_option_value
SET
product_option_id = 497,
product_id = 27562,
option_id = 17,
option_value_id = 3682,
quantity = 1,
subtract = 1,
price = 6.952,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27444
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102195599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/102195599.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3683 AS option_value_id,
language_id,
17 AS option_id,
'102195599 - Diluente sem Cheiro Inart 250 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 = 3683
DELETE FROM oc_product
WHERE
model = '102195599'
INSERT INTO oc_product_option_value
SET
product_option_id = 423,
product_id = 27444,
option_id = 17,
option_value_id = 3683,
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 = 27440
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102197899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3684 AS option_value_id,
language_id,
17 AS option_id,
'102197899 - Folha Ouro Pébéo 14 x 14 cm Caixa com 25 Folhas' 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 = 3684
DELETE FROM oc_product
WHERE
model = '102197899'
INSERT INTO oc_product_option_value
SET
product_option_id = 421,
product_id = 27440,
option_id = 17,
option_value_id = 3684,
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 '102197999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3685 AS option_value_id,
language_id,
17 AS option_id,
'102197999 - Folha Prata Pébéo 14 x 14 cm Caixa com 25 Folhas' 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 = 3685
DELETE FROM oc_product
WHERE
model = '102197999'
INSERT INTO oc_product_option_value
SET
product_option_id = 421,
product_id = 27440,
option_id = 17,
option_value_id = 3685,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.