Product Sync.
Opencart products: 250
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: 27144
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: 27141
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: 252
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 = 27239
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27239,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102195399 - %'
UPDATE oc_option_value
SET
image = 'catalog/102195399.jpg'
WHERE
option_value_id = 2628
UPDATE oc_option_value_description
SET
name = '102195399 - Terebentina Rectificada Inart 500 ml'
WHERE
option_value_id = 2628
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 336
AND product_id = 27239
AND option_id = 15
AND option_value_id = 2628
DELETE FROM oc_product
WHERE
model = '102195399'
INSERT INTO oc_product_option_value
SET
product_option_id = 336,
product_id = 27239,
option_id = 15,
option_value_id = 2628,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2629
UPDATE oc_option_value_description
SET
name = '102195499 - Terebentina Rectificada Inart 1000 ml'
WHERE
option_value_id = 2629
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 336
AND product_id = 27239
AND option_id = 15
AND option_value_id = 2629
DELETE FROM oc_product
WHERE
model = '102195499'
INSERT INTO oc_product_option_value
SET
product_option_id = 336,
product_id = 27239,
option_id = 15,
option_value_id = 2629,
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 = 27144
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102195599 - %'
UPDATE oc_option_value
SET
image = 'catalog/102195599.jpg'
WHERE
option_value_id = 2630
UPDATE oc_option_value_description
SET
name = '102195599 - Diluente sem Cheiro Inart 250 ml'
WHERE
option_value_id = 2630
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 291
AND product_id = 27144
AND option_id = 15
AND option_value_id = 2630
DELETE FROM oc_product
WHERE
model = '102195599'
INSERT INTO oc_product_option_value
SET
product_option_id = 291,
product_id = 27144,
option_id = 15,
option_value_id = 2630,
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 = 27141
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102197899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2631
UPDATE oc_option_value_description
SET
name = '102197899 - Folha Ouro Pébéo 14 x 14 cm Caixa com 25 Folhas'
WHERE
option_value_id = 2631
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 290
AND product_id = 27141
AND option_id = 15
AND option_value_id = 2631
DELETE FROM oc_product
WHERE
model = '102197899'
INSERT INTO oc_product_option_value
SET
product_option_id = 290,
product_id = 27141,
option_id = 15,
option_value_id = 2631,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2632
UPDATE oc_option_value_description
SET
name = '102197999 - Folha Prata Pébéo 14 x 14 cm Caixa com 25 Folhas'
WHERE
option_value_id = 2632
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 290
AND product_id = 27141
AND option_id = 15
AND option_value_id = 2632
DELETE FROM oc_product
WHERE
model = '102197999'
INSERT INTO oc_product_option_value
SET
product_option_id = 290,
product_id = 27141,
option_id = 15,
option_value_id = 2632,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.