Product Sync.
Opencart products: 254
Input products: 100
NEW: 452409867
NEW: 452409967
NEW: 452562499
NEW: 452562699
NEW: 452585999
NEW: 453001899
NEW: 453002299
NEW: 453002399
NEW: 453002499
NEW: 453002599
NEW: 453002699
NEW: 453002799
NEW: 453002899
NEW: 453003099
NEW: 453003199
NEW: 453901699
NEW: 454032564
NEW: 455000399
NEW: 455000799
NEW: 455001299
NEW: Óleo de Linho 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 'Óleo de Linho Winsor & Newton - %'
)
NEW: Tinta Óleo Winsor & Newton 37 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Óleo Winsor & Newton 37 ml - %'
)
NEW: Óleo de Linho Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Óleo de Linho Talens - %'
)
NEW: 455007999
NEW: 455008099
UPDATING: Tinta Óleo Talens Rembrandt 15 ml
Product ID: 27493
Image file:
Ok.
Product Option Sync.
Opencart products: 257
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 = 27652
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27652,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455001599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3895 AS option_value_id,
language_id,
17 AS option_id,
'455001599 - Óleo Linho Winsor and Newton 75ML' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 526
AND product_id = 27652
AND option_id = 17
AND option_value_id = 3895
DELETE FROM oc_product
WHERE
model = '455001599'
INSERT INTO oc_product_option_value
SET
product_option_id = 526,
product_id = 27652,
option_id = 17,
option_value_id = 3895,
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 = 27653
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27653,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455001799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1945
UPDATE oc_option_value_description
SET
name = '455001799 - Tinta Óleo Winsor & Newton 37 ml Branco Flocos'
WHERE
option_value_id = 1945
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1945
DELETE FROM oc_product
WHERE
model = '455001799'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1945,
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 '455002599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1946
UPDATE oc_option_value_description
SET
name = '455002599 - Tinta Óleo Winsor & Newton 37 ml Carmim d\'' Alizarina'
WHERE
option_value_id = 1946
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1946
DELETE FROM oc_product
WHERE
model = '455002599'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1946,
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 '455002699 - %'
UPDATE oc_option_value
SET
image = 'catalog/455002699.jpg'
WHERE
option_value_id = 1947
UPDATE oc_option_value_description
SET
name = '455002699 - Tinta Óleo Winsor & Newton 37 ml Terra Siena Queimada'
WHERE
option_value_id = 1947
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1947
DELETE FROM oc_product
WHERE
model = '455002699'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1947,
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 '455002799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1948
UPDATE oc_option_value_description
SET
name = '455002799 - Tinta Óleo Winsor & Newton 37 ml Terra Sombra Queimada'
WHERE
option_value_id = 1948
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1948
DELETE FROM oc_product
WHERE
model = '455002799'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1948,
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 '455002899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1949
UPDATE oc_option_value_description
SET
name = '455002899 - Tinta Óleo Winsor & Newton 37 ml Laranja Cádmio HUE'
WHERE
option_value_id = 1949
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1949
DELETE FROM oc_product
WHERE
model = '455002899'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1949,
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 '455002999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1950
UPDATE oc_option_value_description
SET
name = '455002999 - Tinta Óleo Winsor & Newton 37 ml Vermelho Cádmio HUE'
WHERE
option_value_id = 1950
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1950
DELETE FROM oc_product
WHERE
model = '455002999'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1950,
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 '455003099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1951
UPDATE oc_option_value_description
SET
name = '455003099 - Tinta Óleo Winsor & Newton 37 ml Vermelho Cádmio Escuro HUE'
WHERE
option_value_id = 1951
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1951
DELETE FROM oc_product
WHERE
model = '455003099'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1951,
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 '455003199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1952
UPDATE oc_option_value_description
SET
name = '455003199 - Tinta Óleo Winsor & Newton 37 ml Amarelo Cádmio Limão HUE'
WHERE
option_value_id = 1952
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1952
DELETE FROM oc_product
WHERE
model = '455003199'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1952,
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 '455003299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1953
UPDATE oc_option_value_description
SET
name = '455003299 - Tinta Óleo Winsor & Newton 37 ml Amarelo Cádmio Pálido HUE'
WHERE
option_value_id = 1953
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1953
DELETE FROM oc_product
WHERE
model = '455003299'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1953,
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 '455003399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1954
UPDATE oc_option_value_description
SET
name = '455003399 - Tinta Óleo Winsor & Newton 37 ml Amarelo Cádmio HUE'
WHERE
option_value_id = 1954
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1954
DELETE FROM oc_product
WHERE
model = '455003399'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1954,
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 '455003499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1955
UPDATE oc_option_value_description
SET
name = '455003499 - Tinta Óleo Winsor & Newton 37 ml Azul Ceruleo HUE'
WHERE
option_value_id = 1955
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1955
DELETE FROM oc_product
WHERE
model = '455003499'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1955,
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 '455003599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1956
UPDATE oc_option_value_description
SET
name = '455003599 - Tinta Óleo Winsor & Newton 37 ml Verde Crómio HUE'
WHERE
option_value_id = 1956
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1956
DELETE FROM oc_product
WHERE
model = '455003599'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1956,
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 '455003699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1957
UPDATE oc_option_value_description
SET
name = '455003699 - Tinta Óleo Winsor & Newton 37 ml Amarelo Crómio HUE 149'
WHERE
option_value_id = 1957
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1957
DELETE FROM oc_product
WHERE
model = '455003699'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1957,
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 '455003799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1958
UPDATE oc_option_value_description
SET
name = '455003799 - Tinta Óleo Winsor & Newton 37 ml Azul Cobalto HUE'
WHERE
option_value_id = 1958
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1958
DELETE FROM oc_product
WHERE
model = '455003799'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1958,
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 '455003899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1959
UPDATE oc_option_value_description
SET
name = '455003899 - Tinta Óleo Winsor & Newton 37 ml Violeta Cobalto HUE'
WHERE
option_value_id = 1959
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1959
DELETE FROM oc_product
WHERE
model = '455003899'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1959,
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 '455003999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1960
UPDATE oc_option_value_description
SET
name = '455003999 - Tinta Óleo Winsor & Newton 37 ml Lago Carmesim Permanente'
WHERE
option_value_id = 1960
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1960
DELETE FROM oc_product
WHERE
model = '455003999'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1960,
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 '455004099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1961
UPDATE oc_option_value_description
SET
name = '455004099 - Tinta Óleo Winsor & Newton 37 ml Verde Esmeralda'
WHERE
option_value_id = 1961
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1961
DELETE FROM oc_product
WHERE
model = '455004099'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1961,
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 '455004199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1962
UPDATE oc_option_value_description
SET
name = '455004199 - Tinta Óleo Winsor & Newton 37 ml Cor de Carne'
WHERE
option_value_id = 1962
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1962
DELETE FROM oc_product
WHERE
model = '455004199'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1962,
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 '455004299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1963
UPDATE oc_option_value_description
SET
name = '455004299 - Tinta Óleo Winsor & Newton 37 ml Ultramarino Francês'
WHERE
option_value_id = 1963
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1963
DELETE FROM oc_product
WHERE
model = '455004299'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1963,
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 '455004399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1964
UPDATE oc_option_value_description
SET
name = '455004399 - Tinta Óleo Winsor & Newton 37 ml Lago Gerânio Permanente'
WHERE
option_value_id = 1964
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1964
DELETE FROM oc_product
WHERE
model = '455004399'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1964,
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 '455004499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1965
UPDATE oc_option_value_description
SET
name = '455004499 - Tinta Óleo Winsor & Newton 37 ml Vermelho Indio'
WHERE
option_value_id = 1965
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1965
DELETE FROM oc_product
WHERE
model = '455004499'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1965,
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 '455004599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1966
UPDATE oc_option_value_description
SET
name = '455004599 - Tinta Óleo Winsor & Newton 37 ml Preto Marfim'
WHERE
option_value_id = 1966
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1966
DELETE FROM oc_product
WHERE
model = '455004599'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1966,
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 '455004699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1967
UPDATE oc_option_value_description
SET
name = '455004699 - Tinta Óleo Winsor & Newton 37 ml Preto Fumo'
WHERE
option_value_id = 1967
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1967
DELETE FROM oc_product
WHERE
model = '455004699'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1967,
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 '455004799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1968
UPDATE oc_option_value_description
SET
name = '455004799 - Tinta Óleo Winsor & Newton 37 ml Amarelo Limão HUE'
WHERE
option_value_id = 1968
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1968
DELETE FROM oc_product
WHERE
model = '455004799'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1968,
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 '455004899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1969
UPDATE oc_option_value_description
SET
name = '455004899 - Tinta Óleo Winsor & Newton 37 ml Vermelho Claro'
WHERE
option_value_id = 1969
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1969
DELETE FROM oc_product
WHERE
model = '455004899'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1969,
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 '455004999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1970
UPDATE oc_option_value_description
SET
name = '455004999 - Tinta Óleo Winsor & Newton 37 ml Magenta'
WHERE
option_value_id = 1970
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1970
DELETE FROM oc_product
WHERE
model = '455004999'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1970,
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 '455005099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1971
UPDATE oc_option_value_description
SET
name = '455005099 - Tinta Óleo Winsor & Newton 37 ml Amarelo de Nápoles HUE'
WHERE
option_value_id = 1971
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1971
DELETE FROM oc_product
WHERE
model = '455005099'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1971,
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 '455005199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1972
UPDATE oc_option_value_description
SET
name = '455005199 - Tinta Óleo Winsor & Newton 37 ml Azul Ftalo'
WHERE
option_value_id = 1972
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1972
DELETE FROM oc_product
WHERE
model = '455005199'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1972,
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 '455005299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1973
UPDATE oc_option_value_description
SET
name = '455005299 - Tinta Óleo Winsor & Newton 37 ml Óxido de Crómio'
WHERE
option_value_id = 1973
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1973
DELETE FROM oc_product
WHERE
model = '455005299'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1973,
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 '455005399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1974
UPDATE oc_option_value_description
SET
name = '455005399 - Tinta Óleo Winsor & Newton 37 ml Cinzento de Payne'
WHERE
option_value_id = 1974
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1974
DELETE FROM oc_product
WHERE
model = '455005399'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1974,
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 '455005499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1975
UPDATE oc_option_value_description
SET
name = '455005499 - Tinta Óleo Winsor & Newton 37 ml Azul Prussia'
WHERE
option_value_id = 1975
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1975
DELETE FROM oc_product
WHERE
model = '455005499'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1975,
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 '455005599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1976
UPDATE oc_option_value_description
SET
name = '455005599 - Tinta Óleo Winsor & Newton 37 ml Terra Siena Natural'
WHERE
option_value_id = 1976
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1976
DELETE FROM oc_product
WHERE
model = '455005599'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1976,
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 '455005699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1977
UPDATE oc_option_value_description
SET
name = '455005699 - Tinta Óleo Winsor & Newton 37 ml Terra Sombra Natural'
WHERE
option_value_id = 1977
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1977
DELETE FROM oc_product
WHERE
model = '455005699'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1977,
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 '455005799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1978
UPDATE oc_option_value_description
SET
name = '455005799 - Tinta Óleo Winsor & Newton 37 ml Verde Sap'
WHERE
option_value_id = 1978
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1978
DELETE FROM oc_product
WHERE
model = '455005799'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1978,
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 '455005899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1979
UPDATE oc_option_value_description
SET
name = '455005899 - Tinta Óleo Winsor & Newton 37 ml Lago Escarlate'
WHERE
option_value_id = 1979
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1979
DELETE FROM oc_product
WHERE
model = '455005899'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1979,
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 '455005999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1980
UPDATE oc_option_value_description
SET
name = '455005999 - Tinta Óleo Winsor & Newton 37 ml Terra Verde'
WHERE
option_value_id = 1980
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1980
DELETE FROM oc_product
WHERE
model = '455005999'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1980,
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 '455006099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1981
UPDATE oc_option_value_description
SET
name = '455006099 - Tinta Óleo Winsor & Newton 37 ml Branco Titânio'
WHERE
option_value_id = 1981
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1981
DELETE FROM oc_product
WHERE
model = '455006099'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1981,
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 '455006199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1982
UPDATE oc_option_value_description
SET
name = '455006199 - Tinta Óleo Winsor & Newton 37 ml Castanho Van Dyke'
WHERE
option_value_id = 1982
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1982
DELETE FROM oc_product
WHERE
model = '455006199'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1982,
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 '455006299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1983
UPDATE oc_option_value_description
SET
name = '455006299 - Tinta Óleo Winsor & Newton 37 ml Vermelhão HUE'
WHERE
option_value_id = 1983
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1983
DELETE FROM oc_product
WHERE
model = '455006299'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1983,
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 '455006399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1984
UPDATE oc_option_value_description
SET
name = '455006399 - Tinta Óleo Winsor & Newton 37 ml Tom de Verde HUE'
WHERE
option_value_id = 1984
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1984
DELETE FROM oc_product
WHERE
model = '455006399'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1984,
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 '455006499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1985
UPDATE oc_option_value_description
SET
name = '455006499 - Tinta Óleo Winsor & Newton 37 ml Amarelo Ocre'
WHERE
option_value_id = 1985
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1985
DELETE FROM oc_product
WHERE
model = '455006499'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1985,
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 '455006599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1986
UPDATE oc_option_value_description
SET
name = '455006599 - Tinta Óleo Winsor & Newton 37 ml Branco Zinco'
WHERE
option_value_id = 1986
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1986
DELETE FROM oc_product
WHERE
model = '455006599'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1986,
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 '455006699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1987
UPDATE oc_option_value_description
SET
name = '455006699 - Tinta Óleo Winsor & Newton 37 ml Amarelo Cádmio Escuro HUE'
WHERE
option_value_id = 1987
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1987
DELETE FROM oc_product
WHERE
model = '455006699'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1987,
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 '455006799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1988
UPDATE oc_option_value_description
SET
name = '455006799 - Tinta Óleo Winsor & Newton 37 ml Roxo Dioxazine'
WHERE
option_value_id = 1988
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1988
DELETE FROM oc_product
WHERE
model = '455006799'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1988,
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 '455006899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1989
UPDATE oc_option_value_description
SET
name = '455006899 - Tinta Óleo Winsor & Newton 37 ml Verde Claro Permanente'
WHERE
option_value_id = 1989
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1989
DELETE FROM oc_product
WHERE
model = '455006899'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1989,
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 '455006999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1990
UPDATE oc_option_value_description
SET
name = '455006999 - Tinta Óleo Winsor & Newton 37 ml Rosa Permanente'
WHERE
option_value_id = 1990
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 527
AND product_id = 27653
AND option_id = 17
AND option_value_id = 1990
DELETE FROM oc_product
WHERE
model = '455006999'
INSERT INTO oc_product_option_value
SET
product_option_id = 527,
product_id = 27653,
option_id = 17,
option_value_id = 1990,
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 = 27654
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27654,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455002299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/455002299.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3896 AS option_value_id,
language_id,
17 AS option_id,
'455002299 - Óleo Linho Talens Purificado 0027 S2 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 528
AND product_id = 27654
AND option_id = 17
AND option_value_id = 3896
DELETE FROM oc_product
WHERE
model = '455002299'
INSERT INTO oc_product_option_value
SET
product_option_id = 528,
product_id = 27654,
option_id = 17,
option_value_id = 3896,
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 '455002499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3897 AS option_value_id,
language_id,
17 AS option_id,
'455002499 - Óleo Linho Talens Cozido S2 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 528
AND product_id = 27654
AND option_id = 17
AND option_value_id = 3897
DELETE FROM oc_product
WHERE
model = '455002499'
INSERT INTO oc_product_option_value
SET
product_option_id = 528,
product_id = 27654,
option_id = 17,
option_value_id = 3897,
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 = 27493
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455015099 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015099.jpg'
WHERE
option_value_id = 1991
UPDATE oc_option_value_description
SET
name = '455015099 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Branco Zinco (Óleo Linhaça)'
WHERE
option_value_id = 1991
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1991
DELETE FROM oc_product
WHERE
model = '455015099'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1991,
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 '455015199 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015199.jpg'
WHERE
option_value_id = 1992
UPDATE oc_option_value_description
SET
name = '455015199 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Branco Titânio (Óleo Linhaça)'
WHERE
option_value_id = 1992
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1992
DELETE FROM oc_product
WHERE
model = '455015199'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1992,
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 '455015299 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015299.jpg'
WHERE
option_value_id = 1993
UPDATE oc_option_value_description
SET
name = '455015299 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Branco Zinco (Óleo de Linhaça)'
WHERE
option_value_id = 1993
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1993
DELETE FROM oc_product
WHERE
model = '455015299'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1993,
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 '455015399 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015399.jpg'
WHERE
option_value_id = 1994
UPDATE oc_option_value_description
SET
name = '455015399 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Branco Titânio (Óleo de Linhaça)'
WHERE
option_value_id = 1994
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1994
DELETE FROM oc_product
WHERE
model = '455015399'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1994,
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 '455015499 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015499.jpg'
WHERE
option_value_id = 1995
UPDATE oc_option_value_description
SET
name = '455015499 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Branco Transparente'
WHERE
option_value_id = 1995
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1995
DELETE FROM oc_product
WHERE
model = '455015499'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1995,
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 '455015599 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015599.jpg'
WHERE
option_value_id = 1996
UPDATE oc_option_value_description
SET
name = '455015599 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Amarelo Ocre'
WHERE
option_value_id = 1996
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1996
DELETE FROM oc_product
WHERE
model = '455015599'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1996,
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 '455015699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1997
UPDATE oc_option_value_description
SET
name = '455015699 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Amarelo Ocre Claro'
WHERE
option_value_id = 1997
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1997
DELETE FROM oc_product
WHERE
model = '455015699'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1997,
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 '455015799 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015799.jpg'
WHERE
option_value_id = 1998
UPDATE oc_option_value_description
SET
name = '455015799 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Ouro Ocre'
WHERE
option_value_id = 1998
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1998
DELETE FROM oc_product
WHERE
model = '455015799'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1998,
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 '455015999 - %'
UPDATE oc_option_value
SET
image = 'catalog/455015999.jpg'
WHERE
option_value_id = 1999
UPDATE oc_option_value_description
SET
name = '455015999 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Terra Siena Natural'
WHERE
option_value_id = 1999
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1999
DELETE FROM oc_product
WHERE
model = '455015999'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1999,
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 '455016099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2000
UPDATE oc_option_value_description
SET
name = '455016099 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Vermelho Ingles Claro'
WHERE
option_value_id = 2000
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2000
DELETE FROM oc_product
WHERE
model = '455016099'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2000,
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 '455016299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2001
UPDATE oc_option_value_description
SET
name = '455016299 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Vermelho Indio'
WHERE
option_value_id = 2001
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2001
DELETE FROM oc_product
WHERE
model = '455016299'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2001,
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 '455016499 - %'
UPDATE oc_option_value
SET
image = 'catalog/455016499.jpg'
WHERE
option_value_id = 2002
UPDATE oc_option_value_description
SET
name = '455016499 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Castanho Van Dyck'
WHERE
option_value_id = 2002
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2002
DELETE FROM oc_product
WHERE
model = '455016499'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2002,
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 '455016599 - %'
UPDATE oc_option_value
SET
image = 'catalog/455016599.jpg'
WHERE
option_value_id = 2003
UPDATE oc_option_value_description
SET
name = '455016599 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Terra Sombra Natural'
WHERE
option_value_id = 2003
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2003
DELETE FROM oc_product
WHERE
model = '455016599'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2003,
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 '455016699 - %'
UPDATE oc_option_value
SET
image = 'catalog/455016699.jpg'
WHERE
option_value_id = 2004
UPDATE oc_option_value_description
SET
name = '455016699 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Terra Sombra Queimada'
WHERE
option_value_id = 2004
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2004
DELETE FROM oc_product
WHERE
model = '455016699'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2004,
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 '455016899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/455016899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3898 AS option_value_id,
language_id,
17 AS option_id,
'455016899 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Terra Siena Queimada' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 3898
DELETE FROM oc_product
WHERE
model = '455016899'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 3898,
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 '455017099 - %'
UPDATE oc_option_value
SET
image = 'catalog/455017099.jpg'
WHERE
option_value_id = 2005
UPDATE oc_option_value_description
SET
name = '455017099 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Sepia'
WHERE
option_value_id = 2005
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2005
DELETE FROM oc_product
WHERE
model = '455017099'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2005,
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 '455017299 - %'
UPDATE oc_option_value
SET
image = 'catalog/455017299.jpg'
WHERE
option_value_id = 2006
UPDATE oc_option_value_description
SET
name = '455017299 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Terra Verde'
WHERE
option_value_id = 2006
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2006
DELETE FROM oc_product
WHERE
model = '455017299'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2006,
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 '455017399 - %'
UPDATE oc_option_value
SET
image = 'catalog/455017399.jpg'
WHERE
option_value_id = 2007
UPDATE oc_option_value_description
SET
name = '455017399 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Preto Marfim'
WHERE
option_value_id = 2007
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2007
DELETE FROM oc_product
WHERE
model = '455017399'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2007,
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 '455017499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2008
UPDATE oc_option_value_description
SET
name = '455017499 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Preto Fumo'
WHERE
option_value_id = 2008
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2008
DELETE FROM oc_product
WHERE
model = '455017499'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2008,
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 '455017599 - %'
UPDATE oc_option_value
SET
image = 'catalog/455017599.jpg'
WHERE
option_value_id = 2009
UPDATE oc_option_value_description
SET
name = '455017599 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Cinzento de Payne'
WHERE
option_value_id = 2009
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2009
DELETE FROM oc_product
WHERE
model = '455017599'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2009,
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 '455017699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2010
UPDATE oc_option_value_description
SET
name = '455017699 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Cinzento Frio'
WHERE
option_value_id = 2010
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2010
DELETE FROM oc_product
WHERE
model = '455017699'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2010,
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 '455017999 - %'
UPDATE oc_option_value
SET
image = 'catalog/455017999.jpg'
WHERE
option_value_id = 2011
UPDATE oc_option_value_description
SET
name = '455017999 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 Amarelo de Nápoles Escuro'
WHERE
option_value_id = 2011
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2011
DELETE FROM oc_product
WHERE
model = '455017999'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2011,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455018099 - %'
UPDATE oc_option_value
SET
image = 'catalog/455018099.jpg'
WHERE
option_value_id = 2012
UPDATE oc_option_value_description
SET
name = '455018099 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 Amarelo de Napoles Avermelhado'
WHERE
option_value_id = 2012
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2012
DELETE FROM oc_product
WHERE
model = '455018099'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2012,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455018299 - %'
UPDATE oc_option_value
SET
image = 'catalog/455018299.jpg'
WHERE
option_value_id = 2013
UPDATE oc_option_value_description
SET
name = '455018299 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 AMARELO NIQUEL TIT ESC'
WHERE
option_value_id = 2013
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2013
DELETE FROM oc_product
WHERE
model = '455018299'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2013,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455018399 - %'
UPDATE oc_option_value
SET
image = 'catalog/455018399.jpg'
WHERE
option_value_id = 2014
UPDATE oc_option_value_description
SET
name = '455018399 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 Amarelo de Nápoles Esverdiado'
WHERE
option_value_id = 2014
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2014
DELETE FROM oc_product
WHERE
model = '455018399'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2014,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455018499 - %'
UPDATE oc_option_value
SET
image = 'catalog/455018499.jpg'
WHERE
option_value_id = 2015
UPDATE oc_option_value_description
SET
name = '455018499 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 Azul Ultramarino Claro'
WHERE
option_value_id = 2015
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2015
DELETE FROM oc_product
WHERE
model = '455018499'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2015,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455018599 - %'
UPDATE oc_option_value
SET
image = 'catalog/455018599.jpg'
WHERE
option_value_id = 2016
UPDATE oc_option_value_description
SET
name = '455018599 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 Azul Ultramarino Escuro'
WHERE
option_value_id = 2016
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2016
DELETE FROM oc_product
WHERE
model = '455018599'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2016,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455018799 - %'
UPDATE oc_option_value
SET
image = 'catalog/455018799.jpg'
WHERE
option_value_id = 2017
UPDATE oc_option_value_description
SET
name = '455018799 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 Azul Prússia'
WHERE
option_value_id = 2017
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2017
DELETE FROM oc_product
WHERE
model = '455018799'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2017,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455018899 - %'
UPDATE oc_option_value
SET
image = 'catalog/455018899.jpg'
WHERE
option_value_id = 2018
UPDATE oc_option_value_description
SET
name = '455018899 - Tinta Óleo Talens Rembrandt T6 - 15 ml S2 Azul Cobalto Ultramarino'
WHERE
option_value_id = 2018
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 2018
DELETE FROM oc_product
WHERE
model = '455018899'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 2018,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.