Product Sync.
Opencart products: 309
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: 27459
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: 27478
Image file:
NEW: 498418199
NEW: 498418499
NEW: 498418599
NEW: 498418799
NEW: 498428899
NEW: 498429599
UPDATING: Tela Art Creation
Product ID: 27460
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: 310
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 = 27459
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3926 AS option_value_id,
language_id,
17 AS option_id,
'498404199 - Tela Talens 18 x 24' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3926
DELETE FROM oc_product
WHERE
model = '498404199'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3926,
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 '498404299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3927 AS option_value_id,
language_id,
17 AS option_id,
'498404299 - Tela Talens 24 x 30' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3927
DELETE FROM oc_product
WHERE
model = '498404299'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3927,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3928 AS option_value_id,
language_id,
17 AS option_id,
'498404499 - Tela Talens 30 x 40' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3928
DELETE FROM oc_product
WHERE
model = '498404499'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3928,
quantity = 1,
subtract = 1,
price = 3.862,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3929 AS option_value_id,
language_id,
17 AS option_id,
'498404599 - Tela Talens 40 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3929
DELETE FROM oc_product
WHERE
model = '498404599'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3929,
quantity = 1,
subtract = 1,
price = 5.163,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3930 AS option_value_id,
language_id,
17 AS option_id,
'498404699 - Tela Talens 40 x 60' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3930
DELETE FROM oc_product
WHERE
model = '498404699'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3930,
quantity = 1,
subtract = 1,
price = 7.277,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498404899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3931 AS option_value_id,
language_id,
17 AS option_id,
'498404899 - Tela Talens 50 x 70' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3931
DELETE FROM oc_product
WHERE
model = '498404899'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3931,
quantity = 1,
subtract = 1,
price = 10.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498405099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3932 AS option_value_id,
language_id,
17 AS option_id,
'498405099 - Tela Talens 60 x 80' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3932
DELETE FROM oc_product
WHERE
model = '498405099'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3932,
quantity = 1,
subtract = 1,
price = 14.35,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498405299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3933 AS option_value_id,
language_id,
17 AS option_id,
'498405299 - Tela Talens 80 x 100' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3933
DELETE FROM oc_product
WHERE
model = '498405299'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3933,
quantity = 1,
subtract = 1,
price = 21.504,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498408499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3934 AS option_value_id,
language_id,
17 AS option_id,
'498408499 - Tela Talens 13 x 18' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3934
DELETE FROM oc_product
WHERE
model = '498408499'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3934,
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 '498409299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3935 AS option_value_id,
language_id,
17 AS option_id,
'498409299 - Tela Talens 40 x 100' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3935
DELETE FROM oc_product
WHERE
model = '498409299'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3935,
quantity = 1,
subtract = 1,
price = 17.441,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498409699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3936 AS option_value_id,
language_id,
17 AS option_id,
'498409699 - Tela Talens 70 x 90' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3936
DELETE FROM oc_product
WHERE
model = '498409699'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3936,
quantity = 1,
subtract = 1,
price = 18.171,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498410199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3937 AS option_value_id,
language_id,
17 AS option_id,
'498410199 - Tela Talens 80 x 120' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3937
DELETE FROM oc_product
WHERE
model = '498410199'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3937,
quantity = 1,
subtract = 1,
price = 26.464,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498410399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3938 AS option_value_id,
language_id,
17 AS option_id,
'498410399 - Tela Talens 100 x 120' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3938
DELETE FROM oc_product
WHERE
model = '498410399'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3938,
quantity = 1,
subtract = 1,
price = 39.878,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498410499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3939 AS option_value_id,
language_id,
17 AS option_id,
'498410499 - Tela Talens 100 x 140' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3939
DELETE FROM oc_product
WHERE
model = '498410499'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3939,
quantity = 1,
subtract = 1,
price = 46.301,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498411699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3940 AS option_value_id,
language_id,
17 AS option_id,
'498411699 - Tela Talens Banda Larga 50 x 70' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3940
DELETE FROM oc_product
WHERE
model = '498411699'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3940,
quantity = 1,
subtract = 1,
price = 18.821,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498411799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3941 AS option_value_id,
language_id,
17 AS option_id,
'498411799 - Tela Talens Banda Larga 60 x 80' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3941
DELETE FROM oc_product
WHERE
model = '498411799'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3941,
quantity = 1,
subtract = 1,
price = 23.13,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498424299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3942 AS option_value_id,
language_id,
17 AS option_id,
'498424299 - Tela Talens Banda Larga Conjunto 2 x 20 x 50 e 1 x 40 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3942
DELETE FROM oc_product
WHERE
model = '498424299'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3942,
quantity = 1,
subtract = 1,
price = 23.943,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498425699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3943 AS option_value_id,
language_id,
17 AS option_id,
'498425699 - Tela Talens Banda Larga 40 x 60' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3943
DELETE FROM oc_product
WHERE
model = '498425699'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3943,
quantity = 1,
subtract = 1,
price = 13.537,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498429399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3944 AS option_value_id,
language_id,
17 AS option_id,
'498429399 - Tela Talens Banda Larga 24 x 30' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3944
DELETE FROM oc_product
WHERE
model = '498429399'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3944,
quantity = 1,
subtract = 1,
price = 5.163,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27707
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27707,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498406799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3945 AS option_value_id,
language_id,
17 AS option_id,
'498406799 - Cartão 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 = 545
AND product_id = 27707
AND option_id = 17
AND option_value_id = 3945
DELETE FROM oc_product
WHERE
model = '498406799'
INSERT INTO oc_product_option_value
SET
product_option_id = 545,
product_id = 27707,
option_id = 17,
option_value_id = 3945,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3946 AS option_value_id,
language_id,
17 AS option_id,
'498406899 - Cartão Tela Winsor & Newton 15 x 20' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 545
AND product_id = 27707
AND option_id = 17
AND option_value_id = 3946
DELETE FROM oc_product
WHERE
model = '498406899'
INSERT INTO oc_product_option_value
SET
product_option_id = 545,
product_id = 27707,
option_id = 17,
option_value_id = 3946,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3947 AS option_value_id,
language_id,
17 AS option_id,
'498407199 - Cartão 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 = 545
AND product_id = 27707
AND option_id = 17
AND option_value_id = 3947
DELETE FROM oc_product
WHERE
model = '498407199'
INSERT INTO oc_product_option_value
SET
product_option_id = 545,
product_id = 27707,
option_id = 17,
option_value_id = 3947,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3948 AS option_value_id,
language_id,
17 AS option_id,
'498407299 - Cartão Tela Winsor & Newton 24 x 30' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 545
AND product_id = 27707
AND option_id = 17
AND option_value_id = 3948
DELETE FROM oc_product
WHERE
model = '498407299'
INSERT INTO oc_product_option_value
SET
product_option_id = 545,
product_id = 27707,
option_id = 17,
option_value_id = 3948,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3949 AS option_value_id,
language_id,
17 AS option_id,
'498407499 - Cartão Tela Winsor & Newton 30 x 40' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 545
AND product_id = 27707
AND option_id = 17
AND option_value_id = 3949
DELETE FROM oc_product
WHERE
model = '498407499'
INSERT INTO oc_product_option_value
SET
product_option_id = 545,
product_id = 27707,
option_id = 17,
option_value_id = 3949,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3950 AS option_value_id,
language_id,
17 AS option_id,
'498407899 - Cartão Tela Winsor & Newton 40 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 545
AND product_id = 27707
AND option_id = 17
AND option_value_id = 3950
DELETE FROM oc_product
WHERE
model = '498407899'
INSERT INTO oc_product_option_value
SET
product_option_id = 545,
product_id = 27707,
option_id = 17,
option_value_id = 3950,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3951 AS option_value_id,
language_id,
17 AS option_id,
'498408099 - Cartão 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 = 545
AND product_id = 27707
AND option_id = 17
AND option_value_id = 3951
DELETE FROM oc_product
WHERE
model = '498408099'
INSERT INTO oc_product_option_value
SET
product_option_id = 545,
product_id = 27707,
option_id = 17,
option_value_id = 3951,
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 = 27478
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498411099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3952 AS option_value_id,
language_id,
17 AS option_id,
'498411099 - Tela Winsor & Newton 100 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 = 3952
DELETE FROM oc_product
WHERE
model = '498411099'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3952,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3953 AS option_value_id,
language_id,
17 AS option_id,
'498415099 - Tela Winsor & Newton 30 x 40' 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 = 3953
DELETE FROM oc_product
WHERE
model = '498415099'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3953,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3954 AS option_value_id,
language_id,
17 AS option_id,
'498415199 - Tela Winsor & Newton 30 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 = 3954
DELETE FROM oc_product
WHERE
model = '498415199'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3954,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3955 AS option_value_id,
language_id,
17 AS option_id,
'498415299 - Tela Winsor & Newton 40 x 40' 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 = 3955
DELETE FROM oc_product
WHERE
model = '498415299'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3955,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3956 AS option_value_id,
language_id,
17 AS option_id,
'498415499 - Tela Winsor & Newton 40 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 = 3956
DELETE FROM oc_product
WHERE
model = '498415499'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3956,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3957 AS option_value_id,
language_id,
17 AS option_id,
'498415599 - Tela Winsor & Newton 40 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 = 3957
DELETE FROM oc_product
WHERE
model = '498415599'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3957,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3958 AS option_value_id,
language_id,
17 AS option_id,
'498415699 - Tela Winsor & Newton 50 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 = 3958
DELETE FROM oc_product
WHERE
model = '498415699'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3958,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3959 AS option_value_id,
language_id,
17 AS option_id,
'498415899 - Tela Winsor & Newton 50 x 70' 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 = 3959
DELETE FROM oc_product
WHERE
model = '498415899'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3959,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3960 AS option_value_id,
language_id,
17 AS option_id,
'498416099 - Tela Winsor & Newton 60 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 = 3960
DELETE FROM oc_product
WHERE
model = '498416099'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3960,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3961 AS option_value_id,
language_id,
17 AS option_id,
'498416399 - Tela Winsor & Newton 70 x 90' 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 = 3961
DELETE FROM oc_product
WHERE
model = '498416399'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3961,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3962 AS option_value_id,
language_id,
17 AS option_id,
'498416899 - Tela Winsor & Newton Banda Larga 30 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 = 3962
DELETE FROM oc_product
WHERE
model = '498416899'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3962,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3963 AS option_value_id,
language_id,
17 AS option_id,
'498416999 - Tela Winsor & Newton Banda Larga 40 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 = 3963
DELETE FROM oc_product
WHERE
model = '498416999'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3963,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3964 AS option_value_id,
language_id,
17 AS option_id,
'498417099 - Tela Winsor & Newton Banda Larga 50 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 = 3964
DELETE FROM oc_product
WHERE
model = '498417099'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3964,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3965 AS option_value_id,
language_id,
17 AS option_id,
'498417199 - Tela Winsor & Newton Banda Larga 50 x 70' 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 = 3965
DELETE FROM oc_product
WHERE
model = '498417199'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3965,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3966 AS option_value_id,
language_id,
17 AS option_id,
'498417299 - Tela Winsor & Newton Banda Larga 60 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 = 3966
DELETE FROM oc_product
WHERE
model = '498417299'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3966,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3967 AS option_value_id,
language_id,
17 AS option_id,
'498422499 - Tela Banda Larga Winsor & Newton 40 x 40' 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 = 3967
DELETE FROM oc_product
WHERE
model = '498422499'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3967,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3968 AS option_value_id,
language_id,
17 AS option_id,
'498426599 - Tela Winsor & Newton Banda Larga 20 x 20' 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 = 3968
DELETE FROM oc_product
WHERE
model = '498426599'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3968,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3969 AS option_value_id,
language_id,
17 AS option_id,
'498429899 - TELA Winsor & Newton Banda Larga 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 = 3969
DELETE FROM oc_product
WHERE
model = '498429899'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3969,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3970 AS option_value_id,
language_id,
17 AS option_id,
'498441199 - Tela Winsor & Newton Banda Larga 70 x 90' 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 = 3970
DELETE FROM oc_product
WHERE
model = '498441199'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3970,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3971 AS option_value_id,
language_id,
17 AS option_id,
'498461399 - Tela Winsor & Newton 20 x 20' 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 = 3971
DELETE FROM oc_product
WHERE
model = '498461399'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3971,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3972 AS option_value_id,
language_id,
17 AS option_id,
'498461499 - Tela Winsor & Newton Banda Larga 24 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 = 3972
DELETE FROM oc_product
WHERE
model = '498461499'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3972,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3973 AS option_value_id,
language_id,
17 AS option_id,
'498461599 - Tela Winsor & Newton Banda Larga 30 x 40' 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 = 3973
DELETE FROM oc_product
WHERE
model = '498461599'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3973,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3974 AS option_value_id,
language_id,
17 AS option_id,
'498461699 - Tela Winsor & Newton 80 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 = 3974
DELETE FROM oc_product
WHERE
model = '498461699'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3974,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3975 AS option_value_id,
language_id,
17 AS option_id,
'498461799 - Tela Winsor & Newton 100 x 150' 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 = 3975
DELETE FROM oc_product
WHERE
model = '498461799'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3975,
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 = 27460
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498461899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/498461899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3976 AS option_value_id,
language_id,
17 AS option_id,
'498461899 - Tela Art Creation 18 x 24' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 439
AND product_id = 27460
AND option_id = 17
AND option_value_id = 3976
DELETE FROM oc_product
WHERE
model = '498461899'
INSERT INTO oc_product_option_value
SET
product_option_id = 439,
product_id = 27460,
option_id = 17,
option_value_id = 3976,
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 '498461999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3977 AS option_value_id,
language_id,
17 AS option_id,
'498461999 - Tela Art Creation 40 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 439
AND product_id = 27460
AND option_id = 17
AND option_value_id = 3977
DELETE FROM oc_product
WHERE
model = '498461999'
INSERT INTO oc_product_option_value
SET
product_option_id = 439,
product_id = 27460,
option_id = 17,
option_value_id = 3977,
quantity = 1,
subtract = 1,
price = 3.09,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.