Product Sync.
Opencart products: 30
Input products: 100
NEW: 451468799
NEW: 451469399
NEW: 451474299
NEW: 451474699
NEW: 451474799
NEW: 451474899
NEW: 451474999
NEW: 451475099
NEW: 451475199
NEW: 451475299
NEW: 451500499
NEW: 452257571
NEW: 452257671
NEW: 452257871
NEW: 452400167
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: 455001599
NEW: Winton W&N 37ML
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Winton W&N 37ML - %'
)
NEW: 455002299
NEW: 455002499
NEW: 455007999
NEW: 455008099
UPDATING: Rembrandt 15ml
Product ID: 27397
Image file: Rembrandt 15ml.png
Ok.
Product Option Sync.
Opencart products: 31
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 = 27403
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27403,
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 - OLEO W&N 37ML FLAKE WHITE'
WHERE
option_value_id = 1945
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML ALIZARIN CRIMSON'
WHERE
option_value_id = 1946
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 = NULL
WHERE
option_value_id = 1947
UPDATE oc_option_value_description
SET
name = '455002699 - OLEO W&N 37ML BURNT SIENNA'
WHERE
option_value_id = 1947
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML BURNT UMBER'
WHERE
option_value_id = 1948
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CADMIUM ORANGE HUE'
WHERE
option_value_id = 1949
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CADMIUM RED HUE'
WHERE
option_value_id = 1950
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CADMIUM RED DEEP HUE'
WHERE
option_value_id = 1951
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CADMIUM LEMON HUE'
WHERE
option_value_id = 1952
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CADM YELLOW PALE HUE'
WHERE
option_value_id = 1953
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CADMIUM YELLOW HUE'
WHERE
option_value_id = 1954
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CERULEAN BLUE HUE'
WHERE
option_value_id = 1955
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CHROME GREEN HUE'
WHERE
option_value_id = 1956
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CHROME YELLOW HUE 149'
WHERE
option_value_id = 1957
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML COBALT BLUE HUE'
WHERE
option_value_id = 1958
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML COBALT VIOLET HUE'
WHERE
option_value_id = 1959
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML PERMAN CRIMSON LAKE'
WHERE
option_value_id = 1960
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML EMERALD GREEN'
WHERE
option_value_id = 1961
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML FLESH TINT'
WHERE
option_value_id = 1962
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML FRENCH ULTRAMARINE'
WHERE
option_value_id = 1963
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML PERMAN GERANIUM LAKE'
WHERE
option_value_id = 1964
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML INDIAN RED 317'
WHERE
option_value_id = 1965
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML IVORY BLACK'
WHERE
option_value_id = 1966
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML LAMP BLACK'
WHERE
option_value_id = 1967
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML LEMON YELLOW HUE'
WHERE
option_value_id = 1968
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML LIGHT RED'
WHERE
option_value_id = 1969
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML MAGENTA'
WHERE
option_value_id = 1970
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML NAPLES YELLOW HUE'
WHERE
option_value_id = 1971
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML PHTHALO BLUE'
WHERE
option_value_id = 1972
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML OXIDE OF CHROMIUM'
WHERE
option_value_id = 1973
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML PAYNES GRAY'
WHERE
option_value_id = 1974
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML PRUSSIAN BLUE'
WHERE
option_value_id = 1975
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML RAW SIENNA'
WHERE
option_value_id = 1976
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML RAW UMBER'
WHERE
option_value_id = 1977
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML SAP GREEN'
WHERE
option_value_id = 1978
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML SCARLET LAKE'
WHERE
option_value_id = 1979
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML TERRE VERTE'
WHERE
option_value_id = 1980
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML TITANIUM WHITE'
WHERE
option_value_id = 1981
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML VANDYKE BROWN'
WHERE
option_value_id = 1982
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML VERMILION HUE'
WHERE
option_value_id = 1983
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML VIRIDIAN HUE'
WHERE
option_value_id = 1984
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML YELLOW OCHRE'
WHERE
option_value_id = 1985
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML ZINC WHITE'
WHERE
option_value_id = 1986
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML CADM YELLOW DEEP HUE'
WHERE
option_value_id = 1987
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML DIOXAZINE PURPLE'
WHERE
option_value_id = 1988
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML PERMAN GREEN LIGHT'
WHERE
option_value_id = 1989
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 - OLEO W&N 37ML PERMANENT ROSE'
WHERE
option_value_id = 1990
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 396
AND product_id = 27403
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 = 396,
product_id = 27403,
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 = 27397
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455015099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1991
UPDATE oc_option_value_description
SET
name = '455015099 - OLEO REMB T6-15 ML S1 BRANCO ZINCO (ALAZOR OIL)'
WHERE
option_value_id = 1991
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 1992
UPDATE oc_option_value_description
SET
name = '455015199 - OLEO REMB T6-15 ML S1 BRANCO TITANIUM (ALAZOR OIL)'
WHERE
option_value_id = 1992
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 1993
UPDATE oc_option_value_description
SET
name = '455015299 - OLEO REMB T6-15ML S1 BRANCO ZINCO (LINAZA OIL)'
WHERE
option_value_id = 1993
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 1994
UPDATE oc_option_value_description
SET
name = '455015399 - OLEO REMB T6-15ML S1 BRANCO TITANIUM (LINAZA OIL)'
WHERE
option_value_id = 1994
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 1995
UPDATE oc_option_value_description
SET
name = '455015499 - OLEO REMB T6-15ML S1 TRANSP WHITE'
WHERE
option_value_id = 1995
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 1996
UPDATE oc_option_value_description
SET
name = '455015599 - OLEO REMB T6-15ML S1 YELLOW OCHRE'
WHERE
option_value_id = 1996
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 - OLEO REMB T6-15ML S1 YELLOW OCHRE LIGHT'
WHERE
option_value_id = 1997
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 1998
UPDATE oc_option_value_description
SET
name = '455015799 - OLEO REMB T6-15ML S1 GOLD OCHRE'
WHERE
option_value_id = 1998
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 1999
UPDATE oc_option_value_description
SET
name = '455015999 - OLEO REMB T6-15ML S1 TERRA SIENNA NATURAL'
WHERE
option_value_id = 1999
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 - OLEO REMB T6-15ML S1 LIGHT VERMELHO INGLES'
WHERE
option_value_id = 2000
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 - OLEO REMB T6-15ML S1 INDIAN RED'
WHERE
option_value_id = 2001
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 2002
UPDATE oc_option_value_description
SET
name = '455016499 - OLEO REMB T6-15ML S1 VANDYKE BROWN'
WHERE
option_value_id = 2002
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 2003
UPDATE oc_option_value_description
SET
name = '455016599 - OLEO REMB T6-15ML S1 TERRA SOMBRA NATURAL'
WHERE
option_value_id = 2003
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
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 = NULL
WHERE
option_value_id = 2004
UPDATE oc_option_value_description
SET
name = '455016699 - OLEO REMB T6-15ML S1 TERRA SOMBRA TOSTADA'
WHERE
option_value_id = 2004
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
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 = 390,
product_id = 27397,
option_id = 17,
option_value_id = 2004,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.