Product Sync.
Opencart products: 8
Input products: 100
UPDATING: Tinta Acrílica Winsor & Newton 120 ml
Product ID: 27405
Image file:
NEW: 100011699
NEW: Bloco Aguarela Cotman 300 grs
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Aguarela Cotman 300 grs - %'
)
NEW: 100012099
NEW: 100012199
NEW: 100012299
NEW: 100012399
NEW: 100012499
NEW: 100012599
NEW: 100012699
NEW: 100012799
NEW: 100012899
NEW: 100012999
NEW: 100013099
NEW: 100013199
NEW: 100013299
NEW: 100013399
NEW: 100013499
NEW: 100013599
NEW: 100013699
NEW: 100013799
NEW: 100013899
NEW: 100013999
NEW: 100014099
NEW: 100014199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100014199 - %'
)
NEW: 100014299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100014299 - %'
)
NEW: 100014399
NEW: 100014499
NEW: 100014599
NEW: 100014699
NEW: 100014799
NEW: 100014899
NEW: 100014999
NEW: 100015099
NEW: 100015199
NEW: 100015299
NEW: 100015399
NEW: 100015499
NEW: 100015599
NEW: 100015699
NEW: 100015799
NEW: 100015899
NEW: 100015999
NEW: 100016099
NEW: 100016199
NEW: 100016299
NEW: 100016399
NEW: 100016499
NEW: 100016599
NEW: 100016699
NEW: 100016799
NEW: 100016899
NEW: 100016999
NEW: 100017099
NEW: 100017199
NEW: 100017299
NEW: 100017399
NEW: 100017499
NEW: 100017599
NEW: 100017699
NEW: 100017799
NEW: 100017899
NEW: 100017999
NEW: 100018099
NEW: 100018199
NEW: 100018299
NEW: 100018399
NEW: 100018499
NEW: 100018599
NEW: 100018699
NEW: 100018799
NEW: 100018899
NEW: 100018999
NEW: 100019099
NEW: 100019199
NEW: 100019299
NEW: 100019399
NEW: 100019499
NEW: 100019599
NEW: 100019699
NEW: 100019799
NEW: 100019899
NEW: 100019999
NEW: 100020099
Ok.
Product Option Sync.
Opencart products: 11
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 = 27405
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100010199 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010199.jpg'
WHERE
option_value_id = 1137
UPDATE oc_option_value_description
SET
name = '100010199 - Acrílico Winsor & Newton Galeria 120 ml Rosa Permanente'
WHERE
option_value_id = 1137
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1137
DELETE FROM oc_product
WHERE
model = '100010199'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1137,
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 '100010299 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010299.jpg'
WHERE
option_value_id = 1138
UPDATE oc_option_value_description
SET
name = '100010299 - Acrílico Winsor & Newton Galeria 120 ml Magenta Processo'
WHERE
option_value_id = 1138
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1138
DELETE FROM oc_product
WHERE
model = '100010299'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1138,
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 '100010399 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010399.jpg'
WHERE
option_value_id = 1139
UPDATE oc_option_value_description
SET
name = '100010399 - Acrílico Winsor & Newton Galeria 120 ml Azul Primário (535)'
WHERE
option_value_id = 1139
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1139
DELETE FROM oc_product
WHERE
model = '100010399'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1139,
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 '100010499 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010499.jpg'
WHERE
option_value_id = 1140
UPDATE oc_option_value_description
SET
name = '100010499 - Acrílico Winsor & Newton Galeria 120 ml Amarelo Processo (537)'
WHERE
option_value_id = 1140
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1140
DELETE FROM oc_product
WHERE
model = '100010499'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1140,
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 '100010599 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010599.jpg'
WHERE
option_value_id = 1141
UPDATE oc_option_value_description
SET
name = '100010599 - Acrílico Winsor & Newton Galeria 120 ml Azul Prússia HUE'
WHERE
option_value_id = 1141
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1141
DELETE FROM oc_product
WHERE
model = '100010599'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1141,
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 '100010699 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010699.jpg'
WHERE
option_value_id = 1142
UPDATE oc_option_value_description
SET
name = '100010699 - Acrílico Winsor & Newton Galeria 120 ml Terra Sienna Natural'
WHERE
option_value_id = 1142
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1142
DELETE FROM oc_product
WHERE
model = '100010699'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1142,
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 '100010799 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010799.jpg'
WHERE
option_value_id = 1143
UPDATE oc_option_value_description
SET
name = '100010799 - Acrílico Winsor & Newton Galeria 120 ml Terra Sombra Natural'
WHERE
option_value_id = 1143
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1143
DELETE FROM oc_product
WHERE
model = '100010799'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1143,
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 '100010899 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010899.jpg'
WHERE
option_value_id = 1144
UPDATE oc_option_value_description
SET
name = '100010899 - Acrílico Winsor & Newton Galeria 120 ml Verde Sap'
WHERE
option_value_id = 1144
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1144
DELETE FROM oc_product
WHERE
model = '100010899'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1144,
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 '100010999 - %'
UPDATE oc_option_value
SET
image = 'catalog/100010999.jpg'
WHERE
option_value_id = 1145
UPDATE oc_option_value_description
SET
name = '100010999 - Acrílico Winsor & Newton Galeria 120 ml Branco Titânio (644)'
WHERE
option_value_id = 1145
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1145
DELETE FROM oc_product
WHERE
model = '100010999'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1145,
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 '100011099 - %'
UPDATE oc_option_value
SET
image = 'catalog/100011099.jpg'
WHERE
option_value_id = 1146
UPDATE oc_option_value_description
SET
name = '100011099 - Acrílico Winsor & Newton Galeria 120 ml Ultramarino'
WHERE
option_value_id = 1146
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1146
DELETE FROM oc_product
WHERE
model = '100011099'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1146,
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 '100011199 - %'
UPDATE oc_option_value
SET
image = 'catalog/100011199.jpg'
WHERE
option_value_id = 1147
UPDATE oc_option_value_description
SET
name = '100011199 - Acrílico Winsor & Newton Galeria 120 ml Castanho Van Dyck'
WHERE
option_value_id = 1147
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1147
DELETE FROM oc_product
WHERE
model = '100011199'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1147,
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 '100011299 - %'
UPDATE oc_option_value
SET
image = 'catalog/100011299.jpg'
WHERE
option_value_id = 1148
UPDATE oc_option_value_description
SET
name = '100011299 - Acrílico Winsor & Newton Galeria 120 ml Vernelhão HUE'
WHERE
option_value_id = 1148
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1148
DELETE FROM oc_product
WHERE
model = '100011299'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1148,
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 '100011399 - %'
UPDATE oc_option_value
SET
image = 'catalog/100011399.jpg'
WHERE
option_value_id = 1149
UPDATE oc_option_value_description
SET
name = '100011399 - Acrílico Winsor & Newton Galeria 120 ml Amarelo Ocre'
WHERE
option_value_id = 1149
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1149
DELETE FROM oc_product
WHERE
model = '100011399'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1149,
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 '100011499 - %'
UPDATE oc_option_value
SET
image = 'catalog/100011499.jpg'
WHERE
option_value_id = 1150
UPDATE oc_option_value_description
SET
name = '100011499 - Acrílico Winsor & Newton Galeria 120 ml S2 Ouro'
WHERE
option_value_id = 1150
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1150
DELETE FROM oc_product
WHERE
model = '100011499'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1150,
quantity = 1,
subtract = 1,
price = 1.057,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100011599 - %'
UPDATE oc_option_value
SET
image = 'catalog/100011599.jpg'
WHERE
option_value_id = 1151
UPDATE oc_option_value_description
SET
name = '100011599 - Acrílico Winsor & Newton Galeria 120 ml S2 Prata'
WHERE
option_value_id = 1151
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 398
AND product_id = 27405
AND option_id = 17
AND option_value_id = 1151
DELETE FROM oc_product
WHERE
model = '100011599'
INSERT INTO oc_product_option_value
SET
product_option_id = 398,
product_id = 27405,
option_id = 17,
option_value_id = 1151,
quantity = 1,
subtract = 1,
price = 1.057,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27406
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27406,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100011799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3233 AS option_value_id,
language_id,
17 AS option_id,
'100011799 - Bloco Aguarela Cotman 300 grs Formato Postal' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 399
AND product_id = 27406
AND option_id = 17
AND option_value_id = 3233
DELETE FROM oc_product
WHERE
model = '100011799'
INSERT INTO oc_product_option_value
SET
product_option_id = 399,
product_id = 27406,
option_id = 17,
option_value_id = 3233,
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 '100011899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3234 AS option_value_id,
language_id,
17 AS option_id,
'100011899 - Bloco Aguarela Cotman 300 grs 30 x 23' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 399
AND product_id = 27406
AND option_id = 17
AND option_value_id = 3234
DELETE FROM oc_product
WHERE
model = '100011899'
INSERT INTO oc_product_option_value
SET
product_option_id = 399,
product_id = 27406,
option_id = 17,
option_value_id = 3234,
quantity = 1,
subtract = 1,
price = 0.488,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100011999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3235 AS option_value_id,
language_id,
17 AS option_id,
'100011999 - Bloco Aguarela Cotman 300 grs 40,6 x 30,5' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 399
AND product_id = 27406
AND option_id = 17
AND option_value_id = 3235
DELETE FROM oc_product
WHERE
model = '100011999'
INSERT INTO oc_product_option_value
SET
product_option_id = 399,
product_id = 27406,
option_id = 17,
option_value_id = 3235,
quantity = 1,
subtract = 1,
price = 6.423,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.