Product Sync.
Opencart products: 272
Input products: 100
UPDATING: Médio Gel para Acrílico Extra Forte Talens
Product ID: 27503
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 - %'
)
NEW: Gel de Textura e Estruturante 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 'Gel de Textura e Estruturante Winsor & Newton - %'
)
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: 27439
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: 305
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 = 27503
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491105599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/491105599.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3920 AS option_value_id,
language_id,
17 AS option_id,
'491105599 - Médio Gel para Acrílico Forte Talens 015 Brilhante 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 466
AND product_id = 27503
AND option_id = 17
AND option_value_id = 3920
DELETE FROM oc_product
WHERE
model = '491105599'
INSERT INTO oc_product_option_value
SET
product_option_id = 466,
product_id = 27503,
option_id = 17,
option_value_id = 3920,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/491105699.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3921 AS option_value_id,
language_id,
17 AS option_id,
'491105699 - Médio Gel para Acrílico Forte Talens 020 Mate 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 466
AND product_id = 27503
AND option_id = 17
AND option_value_id = 3921
DELETE FROM oc_product
WHERE
model = '491105699'
INSERT INTO oc_product_option_value
SET
product_option_id = 466,
product_id = 27503,
option_id = 17,
option_value_id = 3921,
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 = 27677
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27677,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491106699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3922 AS option_value_id,
language_id,
17 AS option_id,
'491106699 - Gel Modeling Paste Winsor & Newton Galeria 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 534
AND product_id = 27677
AND option_id = 17
AND option_value_id = 3922
DELETE FROM oc_product
WHERE
model = '491106699'
INSERT INTO oc_product_option_value
SET
product_option_id = 534,
product_id = 27677,
option_id = 17,
option_value_id = 3922,
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 = 27439
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491108399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/491108399.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3923 AS option_value_id,
language_id,
17 AS option_id,
'491108399 - White Spirit Talens 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 420
AND product_id = 27439
AND option_id = 17
AND option_value_id = 3923
DELETE FROM oc_product
WHERE
model = '491108399'
INSERT INTO oc_product_option_value
SET
product_option_id = 420,
product_id = 27439,
option_id = 17,
option_value_id = 3923,
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 = 27679
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27679,
option_id = 17,
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 = 535
AND product_id = 27679
AND option_id = 17
AND option_value_id = 1346
DELETE FROM oc_product
WHERE
model = '491901399'
INSERT INTO oc_product_option_value
SET
product_option_id = 535,
product_id = 27679,
option_id = 17,
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 = 27680
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27680,
option_id = 17,
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 = 536
AND product_id = 27680
AND option_id = 17
AND option_value_id = 1341
DELETE FROM oc_product
WHERE
model = '491901599'
INSERT INTO oc_product_option_value
SET
product_option_id = 536,
product_id = 27680,
option_id = 17,
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 = 27681
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27681,
option_id = 17,
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 = 537
AND product_id = 27681
AND option_id = 17
AND option_value_id = 1342
DELETE FROM oc_product
WHERE
model = '491902299'
INSERT INTO oc_product_option_value
SET
product_option_id = 537,
product_id = 27681,
option_id = 17,
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 = 27682
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27682,
option_id = 17,
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 = 538
AND product_id = 27682
AND option_id = 17
AND option_value_id = 1343
DELETE FROM oc_product
WHERE
model = '491902399'
INSERT INTO oc_product_option_value
SET
product_option_id = 538,
product_id = 27682,
option_id = 17,
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 = 17
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491902899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3924 AS option_value_id,
language_id,
17 AS option_id,
'491902899 - Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Acrílico Van Gogh' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 17
AND option_value_id = 3924
DELETE FROM oc_product
WHERE
model = '491902899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3924,
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 = 27684
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27684,
option_id = 17,
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 = 539
AND product_id = 27684
AND option_id = 17
AND option_value_id = 1344
DELETE FROM oc_product
WHERE
model = '491903899'
INSERT INTO oc_product_option_value
SET
product_option_id = 539,
product_id = 27684,
option_id = 17,
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 = 17
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491904099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3925 AS option_value_id,
language_id,
17 AS option_id,
'491904099 - Cavalete Tripé Combi Talens Pinho 180 cm, Tela e Caixa Óleo Van Gogh' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 17
AND option_value_id = 3925
DELETE FROM oc_product
WHERE
model = '491904099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3925,
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 = 27686
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27686,
option_id = 17,
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 = 540
AND product_id = 27686
AND option_id = 17
AND option_value_id = 1345
DELETE FROM oc_product
WHERE
model = '491904199'
INSERT INTO oc_product_option_value
SET
product_option_id = 540,
product_id = 27686,
option_id = 17,
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 = 27687
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27687,
option_id = 17,
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 = 541
AND product_id = 27687
AND option_id = 17
AND option_value_id = 1517
DELETE FROM oc_product
WHERE
model = '491904499'
INSERT INTO oc_product_option_value
SET
product_option_id = 541,
product_id = 27687,
option_id = 17,
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 = 27688
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27688,
option_id = 17,
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 = 542
AND product_id = 27688
AND option_id = 17
AND option_value_id = 1175
DELETE FROM oc_product
WHERE
model = '491904699'
INSERT INTO oc_product_option_value
SET
product_option_id = 542,
product_id = 27688,
option_id = 17,
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 = 27689
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27689,
option_id = 17,
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 = 543
AND product_id = 27689
AND option_id = 17
AND option_value_id = 1176
DELETE FROM oc_product
WHERE
model = '491904799'
INSERT INTO oc_product_option_value
SET
product_option_id = 543,
product_id = 27689,
option_id = 17,
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 = 27690
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27690,
option_id = 17,
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 = 544
AND product_id = 27690
AND option_id = 17
AND option_value_id = 1177
DELETE FROM oc_product
WHERE
model = '491904899'
INSERT INTO oc_product_option_value
SET
product_option_id = 544,
product_id = 27690,
option_id = 17,
option_value_id = 1177,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.