Product Sync.
Opencart products: 196
Input products: 100
NEW: 102333199
NEW: 102333299
NEW: 102333399
NEW: 102333499
NEW: 102333599
NEW: 102333699
NEW: 102333799
NEW: 102333899
NEW: 102333999
NEW: 102334099
NEW: 102334199
NEW: 102334299
NEW: 102334399
NEW: 102334499
NEW: 102334599
NEW: 102334699
NEW: 102334799
NEW: 102334899
NEW: 102334999
NEW: 102335099
NEW: 102335199
NEW: 102335299
NEW: 102335399
NEW: 102335499
NEW: 102335599
NEW: 102335699
NEW: 102335799
NEW: 102335899
NEW: 102335999
NEW: 102336099
NEW: 102336199
NEW: 102336299
NEW: 102336399
NEW: 102336499
NEW: 102336599
NEW: 102336699
NEW: 102336799
NEW: 102336899
NEW: 102336999
NEW: 102337099
NEW: 102337199
NEW: 102337299
NEW: 102337399
NEW: 102337499
NEW: 102337599
NEW: 102337699
NEW: 102337799
NEW: 102337899
NEW: 102337999
NEW: 102338099
NEW: 102338199
NEW: 102338299
NEW: 102338399
NEW: 102338499
NEW: 102338599
NEW: 102338699
NEW: Bloco Espiral Aguarela Cotman
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Espiral Aguarela Cotman - %'
)
NEW: 102338899
NEW: 102338999
UPDATING: Aguarela Winsor & Newton Cotman Pastilha
Product ID: 27486
Image file:
NEW: 102339199
NEW: 102339299
NEW: 102339399
NEW: 102339499
NEW: 102339599
NEW: 102339699
NEW: 102339799
NEW: 102339899
NEW: 102339999
UPDATING: Tinta Acrílica Talens Amsterdam 120ml
Product ID: 27419
Image file:
UPDATING: Tela Winsor & Newton
Product ID: 27478
Image file:
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27452
Image file:
NEW: 102341499
NEW: Bloco Aguarela Cotman 425 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 425 grs - %'
)
NEW: 102341999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102341999 - %'
)
NEW: 102342099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102342099 - %'
)
NEW: Bloco Óleo Winsor & Newton Winton 230 gr
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Óleo Winsor & Newton Winton 230 gr - %'
)
NEW: 102342399
NEW: 102342499
NEW: 102342599
NEW: 102342699
NEW: 102342799
NEW: 102342899
NEW: 102342999
NEW: 102343099
NEW: 102343199
Ok.
Product Option Sync.
Opencart products: 201
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 = 27594
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27594,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102338799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3697 AS option_value_id,
language_id,
17 AS option_id,
'102338799 - Bloco Espiral Aguarela Cotman 190 grs 255 x 175' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 502
AND product_id = 27594
AND option_id = 17
AND option_value_id = 3697
DELETE FROM oc_product
WHERE
model = '102338799'
INSERT INTO oc_product_option_value
SET
product_option_id = 502,
product_id = 27594,
option_id = 17,
option_value_id = 3697,
quantity = 1,
subtract = 1,
price = 0.813,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3698 AS option_value_id,
language_id,
17 AS option_id,
'102341899 - Bloco Espiral Aguarela Cotman 300 grs 25,4 x 17,8' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 502
AND product_id = 27594
AND option_id = 17
AND option_value_id = 3698
DELETE FROM oc_product
WHERE
model = '102341899'
INSERT INTO oc_product_option_value
SET
product_option_id = 502,
product_id = 27594,
option_id = 17,
option_value_id = 3698,
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 = 27486
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102339099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1917
UPDATE oc_option_value_description
SET
name = '102339099 - Aguarela Winsor & Newton Cotman Pastilha Vermelho Cádmio Pálido HUE 103'
WHERE
option_value_id = 1917
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1917
DELETE FROM oc_product
WHERE
model = '102339099'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1917,
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 = 27419
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1918
UPDATE oc_option_value_description
SET
name = '102340099 - Acrílico Amsterdam 120 ml Burgundy 075'
WHERE
option_value_id = 1918
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1918
DELETE FROM oc_product
WHERE
model = '102340099'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1918,
quantity = 1,
subtract = 1,
price = 1.504,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1919
UPDATE oc_option_value_description
SET
name = '102340199 - Acrílico Amsterdam 120 ml Copper 214'
WHERE
option_value_id = 1919
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1919
DELETE FROM oc_product
WHERE
model = '102340199'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1919,
quantity = 1,
subtract = 1,
price = 1.504,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1920
UPDATE oc_option_value_description
SET
name = '102340299 - Acrílico Amsterdam 120 ml Laranja Fluorescente 257'
WHERE
option_value_id = 1920
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1920
DELETE FROM oc_product
WHERE
model = '102340299'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1920,
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 = 27478
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3699 AS option_value_id,
language_id,
17 AS option_id,
'102340499 - Tela Winsor & Newton 13 x 18' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3699
DELETE FROM oc_product
WHERE
model = '102340499'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3699,
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 '102340599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3700 AS option_value_id,
language_id,
17 AS option_id,
'102340599 - Tela Winsor & Newton 20 x 25' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3700
DELETE FROM oc_product
WHERE
model = '102340599'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3700,
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 '102340699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3701 AS option_value_id,
language_id,
17 AS option_id,
'102340699 - Tela Winsor & Newton 20 x 30' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3701
DELETE FROM oc_product
WHERE
model = '102340699'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3701,
quantity = 1,
subtract = 1,
price = 1.301,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3702 AS option_value_id,
language_id,
17 AS option_id,
'102340799 - Tela Winsor & Newton 50 x 100' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3702
DELETE FROM oc_product
WHERE
model = '102340799'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3702,
quantity = 1,
subtract = 1,
price = 11.626,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3703 AS option_value_id,
language_id,
17 AS option_id,
'102340899 - Tela Winsor & Newton 50 x 60' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3703
DELETE FROM oc_product
WHERE
model = '102340899'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3703,
quantity = 1,
subtract = 1,
price = 7.479,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3704 AS option_value_id,
language_id,
17 AS option_id,
'102340999 - Tela Winsor & Newton 70 x 100' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3704
DELETE FROM oc_product
WHERE
model = '102340999'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3704,
quantity = 1,
subtract = 1,
price = 16.666,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3705 AS option_value_id,
language_id,
17 AS option_id,
'102341099 - Tela Winsor & Newton 70 x 80' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3705
DELETE FROM oc_product
WHERE
model = '102341099'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3705,
quantity = 1,
subtract = 1,
price = 13.211,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3706 AS option_value_id,
language_id,
17 AS option_id,
'102341199 - Tela Winsor & Newton 80 x 120' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3706
DELETE FROM oc_product
WHERE
model = '102341199'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3706,
quantity = 1,
subtract = 1,
price = 21.992,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3707 AS option_value_id,
language_id,
17 AS option_id,
'102341299 - Tela Winsor & Newton Banda Larga 20 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3707
DELETE FROM oc_product
WHERE
model = '102341299'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3707,
quantity = 1,
subtract = 1,
price = 4.715,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27452
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1921
UPDATE oc_option_value_description
SET
name = '102341399 - Acrílico Winsor & Newton Galeria 250 ml Preto Fumo (337)'
WHERE
option_value_id = 1921
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1921
DELETE FROM oc_product
WHERE
model = '102341399'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1921,
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 = 27595
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27595,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3708 AS option_value_id,
language_id,
17 AS option_id,
'102341599 - Bloco Aguarela Cotman 425 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 = 503
AND product_id = 27595
AND option_id = 17
AND option_value_id = 3708
DELETE FROM oc_product
WHERE
model = '102341599'
INSERT INTO oc_product_option_value
SET
product_option_id = 503,
product_id = 27595,
option_id = 17,
option_value_id = 3708,
quantity = 1,
subtract = 1,
price = 13.293,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3709 AS option_value_id,
language_id,
17 AS option_id,
'102341699 - Bloco Aguarela Cotman 425 grs 30,5 x 22,9' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 503
AND product_id = 27595
AND option_id = 17
AND option_value_id = 3709
DELETE FROM oc_product
WHERE
model = '102341699'
INSERT INTO oc_product_option_value
SET
product_option_id = 503,
product_id = 27595,
option_id = 17,
option_value_id = 3709,
quantity = 1,
subtract = 1,
price = 4.025,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3710 AS option_value_id,
language_id,
17 AS option_id,
'102341799 - Bloco Aguarela Cotman 425 grs 20,3 x 12,7' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 503
AND product_id = 27595
AND option_id = 17
AND option_value_id = 3710
DELETE FROM oc_product
WHERE
model = '102341799'
INSERT INTO oc_product_option_value
SET
product_option_id = 503,
product_id = 27595,
option_id = 17,
option_value_id = 3710,
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 = 27598
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27598,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102342199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3711 AS option_value_id,
language_id,
17 AS option_id,
'102342199 - Bloco Óleo Winsor & Newton Winton 230 gr 29,7 x 21' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 504
AND product_id = 27598
AND option_id = 17
AND option_value_id = 3711
DELETE FROM oc_product
WHERE
model = '102342199'
INSERT INTO oc_product_option_value
SET
product_option_id = 504,
product_id = 27598,
option_id = 17,
option_value_id = 3711,
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 '102342299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3712 AS option_value_id,
language_id,
17 AS option_id,
'102342299 - Bloco Óleo Winsor & Newton Winton 230 gr 40,5 x 30,5' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 504
AND product_id = 27598
AND option_id = 17
AND option_value_id = 3712
DELETE FROM oc_product
WHERE
model = '102342299'
INSERT INTO oc_product_option_value
SET
product_option_id = 504,
product_id = 27598,
option_id = 17,
option_value_id = 3712,
quantity = 1,
subtract = 1,
price = 4.553,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.