Product Sync.
Opencart products: 283
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: 27170
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: 26999
Image file:
UPDATING: Tela Winsor & Newton
Product ID: 27164
Image file:
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27027
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: 288
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 = 27272
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27272,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102338799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2660
UPDATE oc_option_value_description
SET
name = '102338799 - Bloco Espiral Aguarela Cotman 190 grs 255 x 175'
WHERE
option_value_id = 2660
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 340
AND product_id = 27272
AND option_id = 15
AND option_value_id = 2660
DELETE FROM oc_product
WHERE
model = '102338799'
INSERT INTO oc_product_option_value
SET
product_option_id = 340,
product_id = 27272,
option_id = 15,
option_value_id = 2660,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2664
UPDATE oc_option_value_description
SET
name = '102341899 - Bloco Espiral Aguarela Cotman 300 grs 25,4 x 17,8'
WHERE
option_value_id = 2664
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 340
AND product_id = 27272
AND option_id = 15
AND option_value_id = 2664
DELETE FROM oc_product
WHERE
model = '102341899'
INSERT INTO oc_product_option_value
SET
product_option_id = 340,
product_id = 27272,
option_id = 15,
option_value_id = 2664,
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
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 =
AND product_id =
AND option_id = 15
AND option_value_id = 1917
DELETE FROM oc_product
WHERE
model = '102339099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 26999
AND option_id = 15
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1918
DELETE FROM oc_product
WHERE
model = '102340099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 1.504,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1918
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1919
DELETE FROM oc_product
WHERE
model = '102340199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 1.504,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1919
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1920
DELETE FROM oc_product
WHERE
model = '102340299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1920
SELECT product_option_id FROM oc_product_option
WHERE
product_id =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102340499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2667
UPDATE oc_option_value_description
SET
name = '102340499 - Tela Winsor & Newton 13 x 18'
WHERE
option_value_id = 2667
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2667
DELETE FROM oc_product
WHERE
model = '102340499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2667,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2668
UPDATE oc_option_value_description
SET
name = '102340599 - Tela Winsor & Newton 20 x 25'
WHERE
option_value_id = 2668
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2668
DELETE FROM oc_product
WHERE
model = '102340599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2668,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2669
UPDATE oc_option_value_description
SET
name = '102340699 - Tela Winsor & Newton 20 x 30'
WHERE
option_value_id = 2669
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2669
DELETE FROM oc_product
WHERE
model = '102340699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2669,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2670
UPDATE oc_option_value_description
SET
name = '102340799 - Tela Winsor & Newton 50 x 100'
WHERE
option_value_id = 2670
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2670
DELETE FROM oc_product
WHERE
model = '102340799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2670,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2671
UPDATE oc_option_value_description
SET
name = '102340899 - Tela Winsor & Newton 50 x 60'
WHERE
option_value_id = 2671
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2671
DELETE FROM oc_product
WHERE
model = '102340899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2671,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2672
UPDATE oc_option_value_description
SET
name = '102340999 - Tela Winsor & Newton 70 x 100'
WHERE
option_value_id = 2672
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2672
DELETE FROM oc_product
WHERE
model = '102340999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2672,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2673
UPDATE oc_option_value_description
SET
name = '102341099 - Tela Winsor & Newton 70 x 80'
WHERE
option_value_id = 2673
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2673
DELETE FROM oc_product
WHERE
model = '102341099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2673,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2674
UPDATE oc_option_value_description
SET
name = '102341199 - Tela Winsor & Newton 80 x 120'
WHERE
option_value_id = 2674
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2674
DELETE FROM oc_product
WHERE
model = '102341199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2674,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2675
UPDATE oc_option_value_description
SET
name = '102341299 - Tela Winsor & Newton Banda Larga 20 x 50'
WHERE
option_value_id = 2675
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2675
DELETE FROM oc_product
WHERE
model = '102341299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2675,
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
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 =
AND product_id =
AND option_id = 15
AND option_value_id = 1921
DELETE FROM oc_product
WHERE
model = '102341399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 27273
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27273,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102341599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2661
UPDATE oc_option_value_description
SET
name = '102341599 - Bloco Aguarela Cotman 425 grs 40,6 x 30,5'
WHERE
option_value_id = 2661
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 341
AND product_id = 27273
AND option_id = 15
AND option_value_id = 2661
DELETE FROM oc_product
WHERE
model = '102341599'
INSERT INTO oc_product_option_value
SET
product_option_id = 341,
product_id = 27273,
option_id = 15,
option_value_id = 2661,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2662
UPDATE oc_option_value_description
SET
name = '102341699 - Bloco Aguarela Cotman 425 grs 30,5 x 22,9'
WHERE
option_value_id = 2662
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 341
AND product_id = 27273
AND option_id = 15
AND option_value_id = 2662
DELETE FROM oc_product
WHERE
model = '102341699'
INSERT INTO oc_product_option_value
SET
product_option_id = 341,
product_id = 27273,
option_id = 15,
option_value_id = 2662,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2663
UPDATE oc_option_value_description
SET
name = '102341799 - Bloco Aguarela Cotman 425 grs 20,3 x 12,7'
WHERE
option_value_id = 2663
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 341
AND product_id = 27273
AND option_id = 15
AND option_value_id = 2663
DELETE FROM oc_product
WHERE
model = '102341799'
INSERT INTO oc_product_option_value
SET
product_option_id = 341,
product_id = 27273,
option_id = 15,
option_value_id = 2663,
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102342199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2676
UPDATE oc_option_value_description
SET
name = '102342199 - Bloco Óleo Winsor & Newton Winton 230 gr 29,7 x 21'
WHERE
option_value_id = 2676
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2676
DELETE FROM oc_product
WHERE
model = '102342199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2676,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2677
UPDATE oc_option_value_description
SET
name = '102342299 - Bloco Óleo Winsor & Newton Winton 230 gr 40,5 x 30,5'
WHERE
option_value_id = 2677
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2677
DELETE FROM oc_product
WHERE
model = '102342299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2677,
quantity = 1,
subtract = 1,
price = 4.553,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.