Product Sync.
Opencart products: 389
Input products: 100
NEW: 497141899
NEW: 497141999
NEW: 497142099
NEW: 497161199
NEW: 497161299
NEW: 497162499
NEW: 497162599
NEW: 497162699
NEW: 497162799
NEW: 497162899
NEW: 497162999
NEW: 497163099
NEW: 497163199
NEW: 497163299
NEW: 497163399
NEW: 497163499
NEW: 497401140
NEW: 497401340
NEW: 497900299
UPDATING: Tela Talens
Product ID: 27034
Image file:
NEW: 498406699
NEW: Cartão Tela Winsor & Newton
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cartão Tela Winsor & Newton - %'
)
NEW: 498409399
UPDATING: Tela Winsor & Newton
Product ID: 27164
Image file:
NEW: 498418199
NEW: 498418499
NEW: 498418599
NEW: 498418799
NEW: 498428899
NEW: 498429599
UPDATING: Tela Art Creation
Product ID: 27035
Image file:
NEW: 498500299
NEW: 498500599
NEW: 498500667
NEW: 498500798
NEW: 498501199
NEW: 498502399
NEW: 498505399
NEW: 498505599
NEW: 498505699
NEW: 498505799
NEW: 498505999
NEW: 498506499
NEW: 498506599
NEW: 498506699
NEW: 498506799
NEW: 498507099
NEW: 498507199
NEW: 498507299
NEW: 498507399
NEW: 498507499
NEW: 498507599
Ok.
Product Option Sync.
Opencart products: 390
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 = 27034
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2943
UPDATE oc_option_value_description
SET
name = '498404199 - Tela Talens 18 x 24'
WHERE
option_value_id = 2943
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2943
DELETE FROM oc_product
WHERE
model = '498404199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0.244,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2943
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2944
UPDATE oc_option_value_description
SET
name = '498404299 - Tela Talens 24 x 30'
WHERE
option_value_id = 2944
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2944
DELETE FROM oc_product
WHERE
model = '498404299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2944
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2945
UPDATE oc_option_value_description
SET
name = '498404499 - Tela Talens 30 x 40'
WHERE
option_value_id = 2945
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2945
DELETE FROM oc_product
WHERE
model = '498404499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 3.862,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2945
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2946
UPDATE oc_option_value_description
SET
name = '498404599 - Tela Talens 40 x 50'
WHERE
option_value_id = 2946
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2946
DELETE FROM oc_product
WHERE
model = '498404599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 5.163,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2946
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2947
UPDATE oc_option_value_description
SET
name = '498404699 - Tela Talens 40 x 60'
WHERE
option_value_id = 2947
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2947
DELETE FROM oc_product
WHERE
model = '498404699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 7.277,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2947
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2948
UPDATE oc_option_value_description
SET
name = '498404899 - Tela Talens 50 x 70'
WHERE
option_value_id = 2948
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2948
DELETE FROM oc_product
WHERE
model = '498404899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 10.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2948
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498405099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2949
UPDATE oc_option_value_description
SET
name = '498405099 - Tela Talens 60 x 80'
WHERE
option_value_id = 2949
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2949
DELETE FROM oc_product
WHERE
model = '498405099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 14.35,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2949
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498405299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2950
UPDATE oc_option_value_description
SET
name = '498405299 - Tela Talens 80 x 100'
WHERE
option_value_id = 2950
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2950
DELETE FROM oc_product
WHERE
model = '498405299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 21.504,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2950
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498408499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2951
UPDATE oc_option_value_description
SET
name = '498408499 - Tela Talens 13 x 18'
WHERE
option_value_id = 2951
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2951
DELETE FROM oc_product
WHERE
model = '498408499'
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 = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2951
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498409299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2952
UPDATE oc_option_value_description
SET
name = '498409299 - Tela Talens 40 x 100'
WHERE
option_value_id = 2952
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2952
DELETE FROM oc_product
WHERE
model = '498409299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 17.441,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2952
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498409699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2953
UPDATE oc_option_value_description
SET
name = '498409699 - Tela Talens 70 x 90'
WHERE
option_value_id = 2953
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2953
DELETE FROM oc_product
WHERE
model = '498409699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 18.171,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2953
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498410199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2954
UPDATE oc_option_value_description
SET
name = '498410199 - Tela Talens 80 x 120'
WHERE
option_value_id = 2954
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2954
DELETE FROM oc_product
WHERE
model = '498410199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 26.464,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2954
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498410399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2955
UPDATE oc_option_value_description
SET
name = '498410399 - Tela Talens 100 x 120'
WHERE
option_value_id = 2955
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2955
DELETE FROM oc_product
WHERE
model = '498410399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 39.878,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2955
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498410499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2956
UPDATE oc_option_value_description
SET
name = '498410499 - Tela Talens 100 x 140'
WHERE
option_value_id = 2956
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2956
DELETE FROM oc_product
WHERE
model = '498410499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 46.301,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2956
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498411699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2957
UPDATE oc_option_value_description
SET
name = '498411699 - Tela Talens Banda Larga 50 x 70'
WHERE
option_value_id = 2957
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2957
DELETE FROM oc_product
WHERE
model = '498411699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 18.821,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2957
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498411799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2958
UPDATE oc_option_value_description
SET
name = '498411799 - Tela Talens Banda Larga 60 x 80'
WHERE
option_value_id = 2958
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2958
DELETE FROM oc_product
WHERE
model = '498411799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 23.13,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2958
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498424299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2959
UPDATE oc_option_value_description
SET
name = '498424299 - Tela Talens Banda Larga Conjunto 2 x 20 x 50 e 1 x 40 x 50'
WHERE
option_value_id = 2959
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2959
DELETE FROM oc_product
WHERE
model = '498424299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 23.943,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2959
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498425699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2960
UPDATE oc_option_value_description
SET
name = '498425699 - Tela Talens Banda Larga 40 x 60'
WHERE
option_value_id = 2960
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2960
DELETE FROM oc_product
WHERE
model = '498425699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 13.537,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2960
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498429399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2961
UPDATE oc_option_value_description
SET
name = '498429399 - Tela Talens Banda Larga 24 x 30'
WHERE
option_value_id = 2961
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2961
DELETE FROM oc_product
WHERE
model = '498429399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 5.163,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2961
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 '498406799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2962
UPDATE oc_option_value_description
SET
name = '498406799 - Cartão Tela Winsor & Newton 13 x 18'
WHERE
option_value_id = 2962
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 = 2962
DELETE FROM oc_product
WHERE
model = '498406799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2962,
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 '498406899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2963
UPDATE oc_option_value_description
SET
name = '498406899 - Cartão Tela Winsor & Newton 15 x 20'
WHERE
option_value_id = 2963
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 = 2963
DELETE FROM oc_product
WHERE
model = '498406899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2963,
quantity = 1,
subtract = 1,
price = 0.326,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498407199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2964
UPDATE oc_option_value_description
SET
name = '498407199 - Cartão Tela Winsor & Newton 20 x 30'
WHERE
option_value_id = 2964
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 = 2964
DELETE FROM oc_product
WHERE
model = '498407199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2964,
quantity = 1,
subtract = 1,
price = 0.407,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498407299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2965
UPDATE oc_option_value_description
SET
name = '498407299 - Cartão Tela Winsor & Newton 24 x 30'
WHERE
option_value_id = 2965
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 = 2965
DELETE FROM oc_product
WHERE
model = '498407299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2965,
quantity = 1,
subtract = 1,
price = 0.651,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498407499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2966
UPDATE oc_option_value_description
SET
name = '498407499 - Cartão Tela Winsor & Newton 30 x 40'
WHERE
option_value_id = 2966
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 = 2966
DELETE FROM oc_product
WHERE
model = '498407499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2966,
quantity = 1,
subtract = 1,
price = 1.545,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498407899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2967
UPDATE oc_option_value_description
SET
name = '498407899 - Cartão Tela Winsor & Newton 40 x 50'
WHERE
option_value_id = 2967
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 = 2967
DELETE FROM oc_product
WHERE
model = '498407899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2967,
quantity = 1,
subtract = 1,
price = 3.008,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498408099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2968
UPDATE oc_option_value_description
SET
name = '498408099 - Cartão Tela Winsor & Newton 50 x 60'
WHERE
option_value_id = 2968
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 = 2968
DELETE FROM oc_product
WHERE
model = '498408099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2968,
quantity = 1,
subtract = 1,
price = 4.96,
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 '498411099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2969
UPDATE oc_option_value_description
SET
name = '498411099 - Tela Winsor & Newton 100 x 120'
WHERE
option_value_id = 2969
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 = 2969
DELETE FROM oc_product
WHERE
model = '498411099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2969,
quantity = 1,
subtract = 1,
price = 26.26,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498415099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2970
UPDATE oc_option_value_description
SET
name = '498415099 - Tela Winsor & Newton 30 x 40'
WHERE
option_value_id = 2970
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 = 2970
DELETE FROM oc_product
WHERE
model = '498415099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2970,
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 '498415199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2971
UPDATE oc_option_value_description
SET
name = '498415199 - Tela Winsor & Newton 30 x 80'
WHERE
option_value_id = 2971
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 = 2971
DELETE FROM oc_product
WHERE
model = '498415199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2971,
quantity = 1,
subtract = 1,
price = 5.203,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498415299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2972
UPDATE oc_option_value_description
SET
name = '498415299 - Tela Winsor & Newton 40 x 40'
WHERE
option_value_id = 2972
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 = 2972
DELETE FROM oc_product
WHERE
model = '498415299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2972,
quantity = 1,
subtract = 1,
price = 1.87,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498415499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2973
UPDATE oc_option_value_description
SET
name = '498415499 - Tela Winsor & Newton 40 x 60'
WHERE
option_value_id = 2973
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 = 2973
DELETE FROM oc_product
WHERE
model = '498415499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2973,
quantity = 1,
subtract = 1,
price = 4.065,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498415599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2974
UPDATE oc_option_value_description
SET
name = '498415599 - Tela Winsor & Newton 40 x 100'
WHERE
option_value_id = 2974
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 = 2974
DELETE FROM oc_product
WHERE
model = '498415599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2974,
quantity = 1,
subtract = 1,
price = 11.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498415699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2975
UPDATE oc_option_value_description
SET
name = '498415699 - Tela Winsor & Newton 50 x 50'
WHERE
option_value_id = 2975
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 = 2975
DELETE FROM oc_product
WHERE
model = '498415699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2975,
quantity = 1,
subtract = 1,
price = 3.74,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498415899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2976
UPDATE oc_option_value_description
SET
name = '498415899 - Tela Winsor & Newton 50 x 70'
WHERE
option_value_id = 2976
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 = 2976
DELETE FROM oc_product
WHERE
model = '498415899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2976,
quantity = 1,
subtract = 1,
price = 6.911,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498416099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2977
UPDATE oc_option_value_description
SET
name = '498416099 - Tela Winsor & Newton 60 x 80'
WHERE
option_value_id = 2977
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 = 2977
DELETE FROM oc_product
WHERE
model = '498416099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2977,
quantity = 1,
subtract = 1,
price = 8.862,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498416399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2978
UPDATE oc_option_value_description
SET
name = '498416399 - Tela Winsor & Newton 70 x 90'
WHERE
option_value_id = 2978
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 = 2978
DELETE FROM oc_product
WHERE
model = '498416399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2978,
quantity = 1,
subtract = 1,
price = 12.195,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498416899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2979
UPDATE oc_option_value_description
SET
name = '498416899 - Tela Winsor & Newton Banda Larga 30 x 30'
WHERE
option_value_id = 2979
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 = 2979
DELETE FROM oc_product
WHERE
model = '498416899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2979,
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 '498416999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2980
UPDATE oc_option_value_description
SET
name = '498416999 - Tela Winsor & Newton Banda Larga 40 x 50'
WHERE
option_value_id = 2980
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 = 2980
DELETE FROM oc_product
WHERE
model = '498416999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2980,
quantity = 1,
subtract = 1,
price = 5.772,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498417099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2981
UPDATE oc_option_value_description
SET
name = '498417099 - Tela Winsor & Newton Banda Larga 50 x 50'
WHERE
option_value_id = 2981
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 = 2981
DELETE FROM oc_product
WHERE
model = '498417099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2981,
quantity = 1,
subtract = 1,
price = 6.341,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498417199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2982
UPDATE oc_option_value_description
SET
name = '498417199 - Tela Winsor & Newton Banda Larga 50 x 70'
WHERE
option_value_id = 2982
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 = 2982
DELETE FROM oc_product
WHERE
model = '498417199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2982,
quantity = 1,
subtract = 1,
price = 8.862,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498417299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2983
UPDATE oc_option_value_description
SET
name = '498417299 - Tela Winsor & Newton Banda Larga 60 x 80'
WHERE
option_value_id = 2983
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 = 2983
DELETE FROM oc_product
WHERE
model = '498417299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2983,
quantity = 1,
subtract = 1,
price = 11.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498422499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2984
UPDATE oc_option_value_description
SET
name = '498422499 - Tela Banda Larga Winsor & Newton 40 x 40'
WHERE
option_value_id = 2984
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 = 2984
DELETE FROM oc_product
WHERE
model = '498422499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2984,
quantity = 1,
subtract = 1,
price = 4.065,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498426599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2985
UPDATE oc_option_value_description
SET
name = '498426599 - Tela Winsor & Newton Banda Larga 20 x 20'
WHERE
option_value_id = 2985
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 = 2985
DELETE FROM oc_product
WHERE
model = '498426599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2985,
quantity = 1,
subtract = 1,
price = 0.244,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498429899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2986
UPDATE oc_option_value_description
SET
name = '498429899 - TELA Winsor & Newton Banda Larga 80 x 120'
WHERE
option_value_id = 2986
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 = 2986
DELETE FROM oc_product
WHERE
model = '498429899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2986,
quantity = 1,
subtract = 1,
price = 22.114,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498441199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2987
UPDATE oc_option_value_description
SET
name = '498441199 - Tela Winsor & Newton Banda Larga 70 x 90'
WHERE
option_value_id = 2987
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 = 2987
DELETE FROM oc_product
WHERE
model = '498441199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2987,
quantity = 1,
subtract = 1,
price = 14.634,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498461399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2988
UPDATE oc_option_value_description
SET
name = '498461399 - Tela Winsor & Newton 20 x 20'
WHERE
option_value_id = 2988
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 = 2988
DELETE FROM oc_product
WHERE
model = '498461399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2988,
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 '498461499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2989
UPDATE oc_option_value_description
SET
name = '498461499 - Tela Winsor & Newton Banda Larga 24 x 30'
WHERE
option_value_id = 2989
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 = 2989
DELETE FROM oc_product
WHERE
model = '498461499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2989,
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 '498461599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2990
UPDATE oc_option_value_description
SET
name = '498461599 - Tela Winsor & Newton Banda Larga 30 x 40'
WHERE
option_value_id = 2990
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 = 2990
DELETE FROM oc_product
WHERE
model = '498461599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2990,
quantity = 1,
subtract = 1,
price = 2.52,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498461699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2991
UPDATE oc_option_value_description
SET
name = '498461699 - Tela Winsor & Newton 80 x 100'
WHERE
option_value_id = 2991
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 = 2991
DELETE FROM oc_product
WHERE
model = '498461699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2991,
quantity = 1,
subtract = 1,
price = 15.203,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498461799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2992
UPDATE oc_option_value_description
SET
name = '498461799 - Tela Winsor & Newton 100 x 150'
WHERE
option_value_id = 2992
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 = 2992
DELETE FROM oc_product
WHERE
model = '498461799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2992,
quantity = 1,
subtract = 1,
price = 30.569,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27035
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498461899 - %'
UPDATE oc_option_value
SET
image = 'catalog/498461899.jpg'
WHERE
option_value_id = 2993
UPDATE oc_option_value_description
SET
name = '498461899 - Tela Art Creation 18 x 24'
WHERE
option_value_id = 2993
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 102
AND product_id = 27035
AND option_id = 15
AND option_value_id = 2993
DELETE FROM oc_product
WHERE
model = '498461899'
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 = 102
AND product_id = 27035
AND option_id = 15
AND option_value_id = 2993
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498461999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2994
UPDATE oc_option_value_description
SET
name = '498461999 - Tela Art Creation 40 x 50'
WHERE
option_value_id = 2994
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 102
AND product_id = 27035
AND option_id = 15
AND option_value_id = 2994
DELETE FROM oc_product
WHERE
model = '498461999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 3.09,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 102
AND product_id = 27035
AND option_id = 15
AND option_value_id = 2994
Ok.