Product Sync.
Opencart products: 33
Input products: 100
NEW: 100151599
NEW: 100151699
NEW: 100151799
NEW: 100151899
NEW: 100151999
NEW: 100152099
NEW: 100152199
NEW: 100152299
NEW: 100152399
NEW: 100152499
NEW: 100152599
NEW: 100152699
NEW: 100152799
NEW: 100152899
NEW: 100152999
NEW: 100153099
NEW: 100153199
NEW: 100153299
NEW: 100153399
NEW: 100153499
NEW: 100153599
NEW: 100153699
NEW: 100153799
NEW: 100153899
NEW: 100153999
NEW: 100154099
NEW: 100154199
NEW: 100154299
NEW: 100154399
NEW: 100154499
NEW: 100154599
NEW: 100154699
NEW: 100154799
NEW: 100154899
NEW: 100154999
NEW: 100155099
NEW: 100155199
NEW: 100155299
NEW: 100155399
NEW: 100155499
NEW: 100155599
NEW: 100155699
NEW: 100155799
NEW: 100155899
NEW: 100155999
NEW: 100156099
NEW: 100156199
NEW: 100156299
NEW: 100156399
NEW: 100156499
NEW: 100156599
NEW: 100156699
NEW: 100156799
NEW: 100156899
NEW: 100156999
NEW: 100157099
NEW: 100157199
NEW: 100157299
NEW: 100157399
NEW: 100157499
NEW: 100157599
NEW: 100157699
NEW: 100157799
NEW: 100157899
NEW: 100157999
NEW: 100158099
NEW: 100158199
NEW: 100158299
NEW: Tinta Acrílica Winsor & Newton 60 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Acrílica Winsor & Newton 60 ml - %'
)
NEW: 100159399
NEW: 100159499
NEW: 100159599
NEW: 100159699
NEW: 100159799
NEW: 100159899
NEW: 100159999
NEW: 100160099
NEW: 100160199
NEW: 100160299
NEW: 100160399
NEW: 100160499
NEW: 100160599
NEW: 100160699
NEW: 100160799
UPDATING: Guache Giotto Lavável 1000 ml
Product ID: 27422
Image file:
NEW: 100160999
NEW: 100161099
NEW: 100161199
NEW: 100161299
NEW: 100161399
NEW: 100161499
Ok.
Product Option Sync.
Opencart products: 34
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 = 27431
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27431,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100158399 - %'
UPDATE oc_option_value
SET
image = 'catalog/100158399.jpg'
WHERE
option_value_id = 1152
UPDATE oc_option_value_description
SET
name = '100158399 - Acrílico Winsor & Newton Galeria 60 ml Titânio Buff'
WHERE
option_value_id = 1152
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1152
DELETE FROM oc_product
WHERE
model = '100158399'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1152,
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 '100158499 - %'
UPDATE oc_option_value
SET
image = 'catalog/100158499.jpg'
WHERE
option_value_id = 1153
UPDATE oc_option_value_description
SET
name = '100158499 - Acrílico Winsor & Newton Galeria 60 ml Terra Sienna Queimada Opaca'
WHERE
option_value_id = 1153
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1153
DELETE FROM oc_product
WHERE
model = '100158499'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1153,
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 '100158599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1154
UPDATE oc_option_value_description
SET
name = '100158599 - Acrílico Winsor & Newton Galeria 60 ml Vermelho Cádmio Médio'
WHERE
option_value_id = 1154
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1154
DELETE FROM oc_product
WHERE
model = '100158599'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1154,
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 '100158699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1155
UPDATE oc_option_value_description
SET
name = '100158699 - Acrílico Winsor & Newton Galeria 60 ml Amarelo Cádmio Médio'
WHERE
option_value_id = 1155
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1155
DELETE FROM oc_product
WHERE
model = '100158699'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1155,
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 '100158799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1156
UPDATE oc_option_value_description
SET
name = '100158799 - Acrílico Winsor & Newton Galeria 60 ml Azul Cobalto'
WHERE
option_value_id = 1156
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1156
DELETE FROM oc_product
WHERE
model = '100158799'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1156,
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 '100158899 - %'
UPDATE oc_option_value
SET
image = 'catalog/100158899.jpg'
WHERE
option_value_id = 1157
UPDATE oc_option_value_description
SET
name = '100158899 - Acrílico Winsor & Newton Galeria 60 ml Verde de Hooker'
WHERE
option_value_id = 1157
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1157
DELETE FROM oc_product
WHERE
model = '100158899'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1157,
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 '100158999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1158
UPDATE oc_option_value_description
SET
name = '100158999 - Acrílico Winsor & Newton Galeria 60 ml Preto Fumo'
WHERE
option_value_id = 1158
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1158
DELETE FROM oc_product
WHERE
model = '100158999'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1158,
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 '100159099 - %'
UPDATE oc_option_value
SET
image = 'catalog/100159099.jpg'
WHERE
option_value_id = 1159
UPDATE oc_option_value_description
SET
name = '100159099 - Acrílico Winsor & Newton Galeria 60 ml Carmim d\'' Alizarina Permanente'
WHERE
option_value_id = 1159
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1159
DELETE FROM oc_product
WHERE
model = '100159099'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1159,
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 '100159199 - %'
UPDATE oc_option_value
SET
image = 'catalog/100159199.jpg'
WHERE
option_value_id = 1160
UPDATE oc_option_value_description
SET
name = '100159199 - Acrílico Winsor & Newton Galeria 60 ml Terra Sienna Natural Opaca'
WHERE
option_value_id = 1160
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1160
DELETE FROM oc_product
WHERE
model = '100159199'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1160,
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 '100159299 - %'
UPDATE oc_option_value
SET
image = 'catalog/100159299.jpg'
WHERE
option_value_id = 1161
UPDATE oc_option_value_description
SET
name = '100159299 - Acrílico Winsor & Newton Galeria 60 ml Castanho Van Dyck'
WHERE
option_value_id = 1161
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 412
AND product_id = 27431
AND option_id = 17
AND option_value_id = 1161
DELETE FROM oc_product
WHERE
model = '100159299'
INSERT INTO oc_product_option_value
SET
product_option_id = 412,
product_id = 27431,
option_id = 17,
option_value_id = 1161,
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 = 27422
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100160899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3249 AS option_value_id,
language_id,
17 AS option_id,
'100160899 - Guache Giotto Lavável 1000 ml Amarelo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3249
DELETE FROM oc_product
WHERE
model = '100160899'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3249,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.