Product Sync.
Opencart products: 8
Input products: 100
NEW: 100000099
NEW: 100000199
NEW: 100000299
NEW: 100000399
NEW: 100000499
NEW: 100000599
NEW: 100000699
NEW: 100000799
NEW: 100000899
NEW: 100000999
NEW: PASTA ARQ A4 PP PERS ELBA
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'PASTA ARQ A4 PP PERS ELBA - %'
)
NEW: 100001199
NEW: 100001299
NEW: 100001399
NEW: 100001499
NEW: 100001599
NEW: 100001699
NEW: 100001799
NEW: 100001899
NEW: 100001999
NEW: 100002099
NEW: 100002199
NEW: 100002299
NEW: 100002399
NEW: 100002499
NEW: 100002599
NEW: 100002699
NEW: 100002799
NEW: 100002899
NEW: 100002999
NEW: 100003099
NEW: 100003199
NEW: 100003299
NEW: 100003399
NEW: 100003499
NEW: 100003599
NEW: 100003699
NEW: 100003799
NEW: 100003899
NEW: 100003999
NEW: 100004099
NEW: 100004199
NEW: 100004299
NEW: 100004399
NEW: 100004499
NEW: 100004599
NEW: 100004699
NEW: 100004799
NEW: 100004899
NEW: 100004999
NEW: 100005099
NEW: 100005199
NEW: 100005299
NEW: 100005399
NEW: 100005499
NEW: 100005599
NEW: 100005699
NEW: 100005799
NEW: 100005899
NEW: 100005999
NEW: 100006099
NEW: 100006199
NEW: 100006299
NEW: 100006399
NEW: 100006499
NEW: 100006599
NEW: 100006699
NEW: 100006799
NEW: 100006899
NEW: 100006999
NEW: 100007099
NEW: 100007199
NEW: 100007299
NEW: 100007399
NEW: 100007499
NEW: 100007599
NEW: Galeria W&N 120ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Galeria W&N 120ml - %'
)
Ok.
Product Option Sync.
Opencart products: 10
Input products: 100
SELECT option_id FROM oc_option_description
WHERE
NAME = 'Opção'
INSERT INTO oc_option
SET
type = 'multiple',
sort_order = 0
INSERT INTO oc_option_description
SELECT
17 AS option_id,
language_id,
'Opção'AS name
FROM
oc_language
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27380
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27380,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100001099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3232 AS option_value_id,
language_id,
17 AS option_id,
'100001099 - PASTA ARQ A4 PP PERS ELBA 15MM VDE' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 373
AND product_id = 27380
AND option_id = 17
AND option_value_id = 3232
DELETE FROM oc_product
WHERE
model = '100001099'
INSERT INTO oc_product_option_value
SET
product_option_id = 373,
product_id = 27380,
option_id = 17,
option_value_id = 3232,
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 = 27381
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27381,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100007699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1018
UPDATE oc_option_value_description
SET
name = '100007699 - ACRIL GALER 120ML BUFF TITANIUM'
WHERE
option_value_id = 1018
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1018
DELETE FROM oc_product
WHERE
model = '100007699'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1018,
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 '100007799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1019
UPDATE oc_option_value_description
SET
name = '100007799 - ACRIL GALER 120ML BURNT SIENNA'
WHERE
option_value_id = 1019
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1019
DELETE FROM oc_product
WHERE
model = '100007799'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1019,
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 '100007899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1020
UPDATE oc_option_value_description
SET
name = '100007899 - ACRIL GALER 120ML BURNT UMBER'
WHERE
option_value_id = 1020
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1020
DELETE FROM oc_product
WHERE
model = '100007899'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1020,
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 '100007999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1021
UPDATE oc_option_value_description
SET
name = '100007999 - ACRIL GALER 120ML CADMIUM ORANGE HUE'
WHERE
option_value_id = 1021
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1021
DELETE FROM oc_product
WHERE
model = '100007999'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1021,
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 '100008099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1022
UPDATE oc_option_value_description
SET
name = '100008099 - ACRIL GALER 120ML CADMIUM RED HUE'
WHERE
option_value_id = 1022
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1022
DELETE FROM oc_product
WHERE
model = '100008099'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1022,
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 '100008199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1023
UPDATE oc_option_value_description
SET
name = '100008199 - ACRIL GALER 120ML CADMIUM YELLOW PALE HUE'
WHERE
option_value_id = 1023
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1023
DELETE FROM oc_product
WHERE
model = '100008199'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1023,
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 '100008299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1024
UPDATE oc_option_value_description
SET
name = '100008299 - ACRIL GALER 120ML CADMIUM YELLOW DEEP HUE'
WHERE
option_value_id = 1024
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1024
DELETE FROM oc_product
WHERE
model = '100008299'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1024,
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 '100008399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1025
UPDATE oc_option_value_description
SET
name = '100008399 - ACRIL GALER 120ML CADMIUM YELLOW MEDIUM HUE'
WHERE
option_value_id = 1025
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1025
DELETE FROM oc_product
WHERE
model = '100008399'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1025,
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 '100008499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1026
UPDATE oc_option_value_description
SET
name = '100008499 - ACRIL GALER 120ML CERULEAN BLUE HUE'
WHERE
option_value_id = 1026
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1026
DELETE FROM oc_product
WHERE
model = '100008499'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1026,
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 '100008599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1027
UPDATE oc_option_value_description
SET
name = '100008599 - ACRIL GALER 120ML COBALT BLUE HUE'
WHERE
option_value_id = 1027
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1027
DELETE FROM oc_product
WHERE
model = '100008599'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1027,
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 '100008699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1028
UPDATE oc_option_value_description
SET
name = '100008699 - ACRIL GALER 120ML CRIMSON'
WHERE
option_value_id = 1028
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1028
DELETE FROM oc_product
WHERE
model = '100008699'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1028,
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 '100008799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1029
UPDATE oc_option_value_description
SET
name = '100008799 - ACRIL GALER 120ML DEEP TURQUOISE'
WHERE
option_value_id = 1029
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1029
DELETE FROM oc_product
WHERE
model = '100008799'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1029,
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 '100008899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1030
UPDATE oc_option_value_description
SET
name = '100008899 - ACRIL GALER 120ML IVORY BLACK'
WHERE
option_value_id = 1030
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1030
DELETE FROM oc_product
WHERE
model = '100008899'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1030,
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 '100008999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1031
UPDATE oc_option_value_description
SET
name = '100008999 - ACRIL GALER 120ML LEMON YELLOW 346'
WHERE
option_value_id = 1031
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1031
DELETE FROM oc_product
WHERE
model = '100008999'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1031,
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 '100009099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1032
UPDATE oc_option_value_description
SET
name = '100009099 - ACRIL GALER 120ML MARS BLACK Test'
WHERE
option_value_id = 1032
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1032
DELETE FROM oc_product
WHERE
model = '100009099'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1032,
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 '100009199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1033
UPDATE oc_option_value_description
SET
name = '100009199 - ACRIL GALER 120ML MIXING WHITE 415'
WHERE
option_value_id = 1033
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1033
DELETE FROM oc_product
WHERE
model = '100009199'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1033,
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 '100009299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1034
UPDATE oc_option_value_description
SET
name = '100009299 - ACRIL GALER 120ML NAPLES YELLOW'
WHERE
option_value_id = 1034
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1034
DELETE FROM oc_product
WHERE
model = '100009299'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1034,
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 '100009399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1035
UPDATE oc_option_value_description
SET
name = '100009399 - ACRIL GALER 120ML PALE TERRACOTTA'
WHERE
option_value_id = 1035
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1035
DELETE FROM oc_product
WHERE
model = '100009399'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1035,
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 '100009499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1073
UPDATE oc_option_value_description
SET
name = '100009499 - ACRIL GALER 120ML POWDER BLUE'
WHERE
option_value_id = 1073
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1073
DELETE FROM oc_product
WHERE
model = '100009499'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1073,
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 '100009599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1074
UPDATE oc_option_value_description
SET
name = '100009599 - ACRIL GALER 120ML OLIVE GREEN'
WHERE
option_value_id = 1074
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1074
DELETE FROM oc_product
WHERE
model = '100009599'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1074,
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 '100009699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1075
UPDATE oc_option_value_description
SET
name = '100009699 - ACRIL GALER 120ML OPERA ROSE'
WHERE
option_value_id = 1075
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1075
DELETE FROM oc_product
WHERE
model = '100009699'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1075,
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 '100009799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1076
UPDATE oc_option_value_description
SET
name = '100009799 - ACRIL GALER 120ML PAYNES GRAY'
WHERE
option_value_id = 1076
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1076
DELETE FROM oc_product
WHERE
model = '100009799'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1076,
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 '100009899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1077
UPDATE oc_option_value_description
SET
name = '100009899 - ACRIL GALER 120ML PERM ALIZ CRIMSON'
WHERE
option_value_id = 1077
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1077
DELETE FROM oc_product
WHERE
model = '100009899'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1077,
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 '100009999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1135
UPDATE oc_option_value_description
SET
name = '100009999 - ACRIL GALER 120ML PERMANENT GREEN LIGHT'
WHERE
option_value_id = 1135
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 374
AND product_id = 27381
AND option_id = 17
AND option_value_id = 1135
DELETE FROM oc_product
WHERE
model = '100009999'
INSERT INTO oc_product_option_value
SET
product_option_id = 374,
product_id = 27381,
option_id = 17,
option_value_id = 1135,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.