Product Sync.
Opencart products: 353
Input products: 100
UPDATING: Médio Gel para Acrílico Extra Forte Talens
Product ID: 27183
Image file:
NEW: 491105799
NEW: 491105899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491105899 - %'
)
NEW: 491105999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491105999 - %'
)
NEW: 491106099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491106099 - %'
)
NEW: 491106199
NEW: 491106299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491106299 - %'
)
NEW: 491106399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491106399 - %'
)
NEW: 491106499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491106499 - %'
)
NEW: 491106599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491106599 - %'
)
UPDATING: Gel de Textura e Estruturante Winsor & Newton
Product ID: 27112
Image file:
NEW: 491106799
NEW: 491106899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491106899 - %'
)
NEW: 491106999
NEW: 491107099
NEW: 491107199
NEW: 491107299
NEW: 491107399
UPDATING: White Spirit Talens
Product ID: 27015
Image file:
NEW: 491111499
NEW: 491111699
NEW: 491300199
NEW: 491300399
NEW: 491300899
NEW: 491300999
NEW: 491301099
NEW: 491301199
NEW: 491301299
NEW: 491301399
NEW: 491301499
NEW: 491301699
NEW: 491301799
NEW: 491301899
NEW: 491302099
NEW: 491302399
NEW: 491302599
NEW: 491302699
NEW: 491302899
NEW: 491303199
NEW: 491303299
NEW: 491303399
NEW: 491303499
NEW: 491702699
NEW: 491800599
NEW: 491800899
NEW: 491801061
NEW: Cavalete Estudio New Orleans 130 cm
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Estudio New Orleans 130 cm - %'
)
NEW: Cavalete Campo Talens Umbra
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Campo Talens Umbra - %'
)
NEW: Cavalete Mesa Talens Leda em Faia
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Mesa Talens Leda em Faia - %'
)
NEW: Cavalete de Mesa Talens Elara em Faia
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete de Mesa Talens Elara em Faia - %'
)
NEW: Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Acrílico Van Gogh
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Acrílico Van Gogh - %'
)
NEW: Cavalete Estudio Talens Madrid em Faia
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Estudio Talens Madrid em Faia - %'
)
NEW: Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Óleo Van Gogh
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Óleo Van Gogh - %'
)
NEW: Cavalete Campo Talens Metalico PRT
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Campo Talens Metalico PRT - %'
)
NEW: Cavalete Estudio Tripé Madeira
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Estudio Tripé Madeira - %'
)
NEW: Cavalete Trident Estúdio Base Triangulo Ref. 12005
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Trident Estúdio Base Triangulo Ref. 12005 - %'
)
NEW: Cavalete Trident Estúdio Prateleira para Baixo 12338
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Trident Estúdio Prateleira para Baixo 12338 - %'
)
NEW: Cavalete Trdident Mini de Mesa 12014
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Trdident Mini de Mesa 12014 - %'
)
NEW: 491905399
NEW: 491960199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491960199 - %'
)
NEW: 491970199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491970199 - %'
)
NEW: 491970299
NEW: 491970399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491970399 - %'
)
NEW: 491970499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '491970499 - %'
)
NEW: 492003999
NEW: 492004099
NEW: 492009199
NEW: 492009299
NEW: 492009399
NEW: 492009499
NEW: 492009599
NEW: 492009699
NEW: 492009799
NEW: 492009899
NEW: 492009999
NEW: 492010099
NEW: 492101099
NEW: 492101199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492101199 - %'
)
NEW: 492101399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492101399 - %'
)
NEW: 492101499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492101499 - %'
)
NEW: 492101699
NEW: 492104099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492104099 - %'
)
NEW: 492104499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492104499 - %'
)
NEW: 492104820
NEW: 492105799
NEW: 492105899
NEW: 492105999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492105999 - %'
)
NEW: 492106099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492106099 - %'
)
NEW: 492106299
NEW: 492106399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '492106399 - %'
)
NEW: 492106499
NEW: 492106699
NEW: 492203099
NEW: 492203199
NEW: 492203299
NEW: 492203399
NEW: 492203499
NEW: 492300499
NEW: 492302899
Ok.
Product Option Sync.
Opencart products: 385
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 = 27183
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491105599 - %'
UPDATE oc_option_value
SET
image = 'catalog/491105599.jpg'
WHERE
option_value_id = 2914
UPDATE oc_option_value_description
SET
name = '491105599 - Médio Gel para Acrílico Forte Talens 015 Brilhante 250 ml'
WHERE
option_value_id = 2914
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 312
AND product_id = 27183
AND option_id = 15
AND option_value_id = 2914
DELETE FROM oc_product
WHERE
model = '491105599'
INSERT INTO oc_product_option_value
SET
product_option_id = 312,
product_id = 27183,
option_id = 15,
option_value_id = 2914,
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 '491105699 - %'
UPDATE oc_option_value
SET
image = 'catalog/491105699.jpg'
WHERE
option_value_id = 2915
UPDATE oc_option_value_description
SET
name = '491105699 - Médio Gel para Acrílico Forte Talens 020 Mate 250 ml'
WHERE
option_value_id = 2915
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 312
AND product_id = 27183
AND option_id = 15
AND option_value_id = 2915
DELETE FROM oc_product
WHERE
model = '491105699'
INSERT INTO oc_product_option_value
SET
product_option_id = 312,
product_id = 27183,
option_id = 15,
option_value_id = 2915,
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491106699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2923
UPDATE oc_option_value_description
SET
name = '491106699 - Gel Modeling Paste Winsor & Newton Galeria 250 ml'
WHERE
option_value_id = 2923
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2923
DELETE FROM oc_product
WHERE
model = '491106699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2923,
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 = 27015
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491108399 - %'
UPDATE oc_option_value
SET
image = 'catalog/491108399.jpg'
WHERE
option_value_id = 2925
UPDATE oc_option_value_description
SET
name = '491108399 - White Spirit Talens 250 ml'
WHERE
option_value_id = 2925
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 84
AND product_id = 27015
AND option_id = 15
AND option_value_id = 2925
DELETE FROM oc_product
WHERE
model = '491108399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 84
AND product_id = 27015
AND option_id = 15
AND option_value_id = 2925
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27350
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27350,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491901399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1346
UPDATE oc_option_value_description
SET
name = '491901399 - Cavalete Estudio New Orleans 130 cm'
WHERE
option_value_id = 1346
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 362
AND product_id = 27350
AND option_id = 15
AND option_value_id = 1346
DELETE FROM oc_product
WHERE
model = '491901399'
INSERT INTO oc_product_option_value
SET
product_option_id = 362,
product_id = 27350,
option_id = 15,
option_value_id = 1346,
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 = 27351
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27351,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491901599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1341
UPDATE oc_option_value_description
SET
name = '491901599 - Cavalete Campo Talens Umbra'
WHERE
option_value_id = 1341
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 363
AND product_id = 27351
AND option_id = 15
AND option_value_id = 1341
DELETE FROM oc_product
WHERE
model = '491901599'
INSERT INTO oc_product_option_value
SET
product_option_id = 363,
product_id = 27351,
option_id = 15,
option_value_id = 1341,
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 = 27352
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27352,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491902299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1342
UPDATE oc_option_value_description
SET
name = '491902299 - Cavalete Mesa Talens Leda em Faia'
WHERE
option_value_id = 1342
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 364
AND product_id = 27352
AND option_id = 15
AND option_value_id = 1342
DELETE FROM oc_product
WHERE
model = '491902299'
INSERT INTO oc_product_option_value
SET
product_option_id = 364,
product_id = 27352,
option_id = 15,
option_value_id = 1342,
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 = 27353
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27353,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491902399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1343
UPDATE oc_option_value_description
SET
name = '491902399 - Cavalete de Mesa Talens Elara em Faia'
WHERE
option_value_id = 1343
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 365
AND product_id = 27353
AND option_id = 15
AND option_value_id = 1343
DELETE FROM oc_product
WHERE
model = '491902399'
INSERT INTO oc_product_option_value
SET
product_option_id = 365,
product_id = 27353,
option_id = 15,
option_value_id = 1343,
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491902899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2926
UPDATE oc_option_value_description
SET
name = '491902899 - Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Acrílico Van Gogh'
WHERE
option_value_id = 2926
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2926
DELETE FROM oc_product
WHERE
model = '491902899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2926,
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 = 27355
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27355,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491903899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1344
UPDATE oc_option_value_description
SET
name = '491903899 - Cavalete Estudio Talens Madrid em Faia'
WHERE
option_value_id = 1344
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 366
AND product_id = 27355
AND option_id = 15
AND option_value_id = 1344
DELETE FROM oc_product
WHERE
model = '491903899'
INSERT INTO oc_product_option_value
SET
product_option_id = 366,
product_id = 27355,
option_id = 15,
option_value_id = 1344,
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491904099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2927
UPDATE oc_option_value_description
SET
name = '491904099 - Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Óleo Van Gogh'
WHERE
option_value_id = 2927
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2927
DELETE FROM oc_product
WHERE
model = '491904099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2927,
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 = 27357
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27357,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491904199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1345
UPDATE oc_option_value_description
SET
name = '491904199 - Cavalete Campo Talens Metalico PRT'
WHERE
option_value_id = 1345
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 367
AND product_id = 27357
AND option_id = 15
AND option_value_id = 1345
DELETE FROM oc_product
WHERE
model = '491904199'
INSERT INTO oc_product_option_value
SET
product_option_id = 367,
product_id = 27357,
option_id = 15,
option_value_id = 1345,
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 = 27358
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27358,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491904499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1517
UPDATE oc_option_value_description
SET
name = '491904499 - Cavalete Estudio Tripé Madeira'
WHERE
option_value_id = 1517
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 368
AND product_id = 27358
AND option_id = 15
AND option_value_id = 1517
DELETE FROM oc_product
WHERE
model = '491904499'
INSERT INTO oc_product_option_value
SET
product_option_id = 368,
product_id = 27358,
option_id = 15,
option_value_id = 1517,
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 = 27359
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27359,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491904699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1175
UPDATE oc_option_value_description
SET
name = '491904699 - Cavalete Trident Estúdio Base Triangulo Ref. 12005'
WHERE
option_value_id = 1175
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 369
AND product_id = 27359
AND option_id = 15
AND option_value_id = 1175
DELETE FROM oc_product
WHERE
model = '491904699'
INSERT INTO oc_product_option_value
SET
product_option_id = 369,
product_id = 27359,
option_id = 15,
option_value_id = 1175,
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 = 27360
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27360,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491904799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1176
UPDATE oc_option_value_description
SET
name = '491904799 - Cavalete Trident Estúdio Prateleira para Baixo 12338'
WHERE
option_value_id = 1176
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 370
AND product_id = 27360
AND option_id = 15
AND option_value_id = 1176
DELETE FROM oc_product
WHERE
model = '491904799'
INSERT INTO oc_product_option_value
SET
product_option_id = 370,
product_id = 27360,
option_id = 15,
option_value_id = 1176,
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 = 27361
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27361,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491904899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1177
UPDATE oc_option_value_description
SET
name = '491904899 - Cavalete Trdident Mini de Mesa 12014'
WHERE
option_value_id = 1177
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 371
AND product_id = 27361
AND option_id = 15
AND option_value_id = 1177
DELETE FROM oc_product
WHERE
model = '491904899'
INSERT INTO oc_product_option_value
SET
product_option_id = 371,
product_id = 27361,
option_id = 15,
option_value_id = 1177,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.