Product Sync.
Opencart products: 230
Input products: 100
NEW: 101969499
NEW: 101969599
NEW: 101969699
NEW: 101969799
NEW: 101969899
NEW: 101969999
NEW: 101970099
NEW: 101970199
NEW: 101970299
NEW: 101970399
NEW: 101970499
NEW: 101970599
NEW: 101970699
NEW: 101970799
NEW: 101970899
NEW: 101970999
NEW: 101971099
UPDATING: Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato
Product ID: 27218
Image file:
NEW: Pincel Daler Rowney de Cerda Cabo Comprido Espatulado Longo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney de Cerda Cabo Comprido Espatulado Longo - %'
)
NEW: Pincel Daler Rowney de Cerda Cabo Comprido Redondo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney de Cerda Cabo Comprido Redondo - %'
)
NEW: 101971699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101971699 - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Pêlo Cabra Redondo Oval
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Pêlo Cabra Redondo Oval - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo Oval
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo Oval - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Pêlo Sintético Redondo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Pêlo Sintético Redondo - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo - %'
)
NEW: 101972899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101972899 - %'
)
NEW: 101972999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101972999 - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Pêlo Sintético Espatulado
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Pêlo Sintético Espatulado - %'
)
NEW: Pincel Daler Rowney Cabo Curto Pêlo Sintético Biselado
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney Cabo Curto Pêlo Sintético Biselado - %'
)
NEW: Pincel Daler Rowney Cabo Curto Espatulado
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney Cabo Curto Espatulado - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Língua de Gato
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Língua de Gato - %'
)
NEW: 101973599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101973599 - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Pêlo Longo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Pêlo Longo - %'
)
NEW: 101973999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101973999 - %'
)
NEW: Pincel Daler Rowney Cabo Curto Pêlo Redondo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney Cabo Curto Pêlo Redondo - %'
)
NEW: Pincel Daler Rowney Cabo Comprido Redondo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney Cabo Comprido Redondo - %'
)
NEW: Pincel Daler Rowney Cabo Comprido Espatulado
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney Cabo Comprido Espatulado - %'
)
NEW: \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Espatulado
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Pincel Daler Rowney Cabo Curto Pêlo Ponei Espatulado - %'
)
NEW: 101975699
NEW: 101975799
NEW: 101975899
NEW: 101975999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101975999 - %'
)
NEW: 101976099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101976099 - %'
)
NEW: 101976199
NEW: 101976299
NEW: 101976399
NEW: 101976499
NEW: 101976599
NEW: 101976699
NEW: 101976799
NEW: 101976899
NEW: 101976999
NEW: 101977099
NEW: 101977199
NEW: 101977299
NEW: 101977399
NEW: 101977499
NEW: 101977599
NEW: 101977699
NEW: 101977799
NEW: 101977899
NEW: 101977999
NEW: 101978099
NEW: 101978199
NEW: 101978299
NEW: 101978399
NEW: 101978499
NEW: 101978599
NEW: 101978699
NEW: 101978799
NEW: 101978899
NEW: 101978999
NEW: 101979099
NEW: 101979199
NEW: 101979299
NEW: 101979399
Ok.
Product Option Sync.
Opencart products: 244
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 = 27218
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101971199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2520
UPDATE oc_option_value_description
SET
name = '101971199 - Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato N8'
WHERE
option_value_id = 2520
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 325
AND product_id = 27218
AND option_id = 15
AND option_value_id = 2520
DELETE FROM oc_product
WHERE
model = '101971199'
INSERT INTO oc_product_option_value
SET
product_option_id = 325,
product_id = 27218,
option_id = 15,
option_value_id = 2520,
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 = 27219
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27219,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101971299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2521
UPDATE oc_option_value_description
SET
name = '101971299 - Pincel Daler Rowney de Cerda Cabo Comprido Espatulado Longo N4'
WHERE
option_value_id = 2521
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 326
AND product_id = 27219
AND option_id = 15
AND option_value_id = 2521
DELETE FROM oc_product
WHERE
model = '101971299'
INSERT INTO oc_product_option_value
SET
product_option_id = 326,
product_id = 27219,
option_id = 15,
option_value_id = 2521,
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 '101971399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2522
UPDATE oc_option_value_description
SET
name = '101971399 - Pincel Daler Rowney de Cerda Cabo Comprido Espatulado Longo N8'
WHERE
option_value_id = 2522
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 326
AND product_id = 27219
AND option_id = 15
AND option_value_id = 2522
DELETE FROM oc_product
WHERE
model = '101971399'
INSERT INTO oc_product_option_value
SET
product_option_id = 326,
product_id = 27219,
option_id = 15,
option_value_id = 2522,
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 = 27220
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27220,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101971499 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3187 AS option_value_id,
language_id,
15 AS option_id,
'101971499 - \''Pincel Daler Rowney de Cerda Cabo Comprido Redondo N2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 327
AND product_id = 27220
AND option_id = 15
AND option_value_id = 3187
DELETE FROM oc_product
WHERE
model = '101971499'
INSERT INTO oc_product_option_value
SET
product_option_id = 327,
product_id = 27220,
option_id = 15,
option_value_id = 3187,
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 '101971599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2524
UPDATE oc_option_value_description
SET
name = '101971599 - Pincel Daler Rowney de Cerda Cabo Comprido Redondo N10'
WHERE
option_value_id = 2524
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 327
AND product_id = 27220
AND option_id = 15
AND option_value_id = 2524
DELETE FROM oc_product
WHERE
model = '101971599'
INSERT INTO oc_product_option_value
SET
product_option_id = 327,
product_id = 27220,
option_id = 15,
option_value_id = 2524,
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 '101971799 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3188 AS option_value_id,
language_id,
15 AS option_id,
'101971799 - \''Pincel Daler Rowney Cabo Curto Pêlo Cabra Redondo Oval 3/4' 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 = 15
AND option_value_id = 3188
DELETE FROM oc_product
WHERE
model = '101971799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3188,
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 '101971899 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3189 AS option_value_id,
language_id,
15 AS option_id,
'101971899 - \''Pincel Daler Rowney Cabo Curto Pêlo Cabra Redondo Oval 1\''\''' 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 = 15
AND option_value_id = 3189
DELETE FROM oc_product
WHERE
model = '101971899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3189,
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 '101971999 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3190 AS option_value_id,
language_id,
15 AS option_id,
'101971999 - \''Pincel Daler Rowney Cabo Curto Pêlo Cabra Redondo Oval 1/2\''\''' 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 = 15
AND option_value_id = 3190
DELETE FROM oc_product
WHERE
model = '101971999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3190,
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 '101972099 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3191 AS option_value_id,
language_id,
15 AS option_id,
'101972099 - \''Pincel Daler Rowney Cabo Curto Pêlo Cabra Redondo Oval 3/4\''\''' 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 = 15
AND option_value_id = 3191
DELETE FROM oc_product
WHERE
model = '101972099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3191,
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 '101975499 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3192 AS option_value_id,
language_id,
15 AS option_id,
'101975499 - \''Pincel Daler Rowney Cabo Curto Pêlo Cabra Redondo Oval' 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 = 15
AND option_value_id = 3192
DELETE FROM oc_product
WHERE
model = '101975499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3192,
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 '101972199 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3193 AS option_value_id,
language_id,
15 AS option_id,
'101972199 - \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo Oval 1\''\''' 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 = 15
AND option_value_id = 3193
DELETE FROM oc_product
WHERE
model = '101972199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3193,
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 '101974099 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3194 AS option_value_id,
language_id,
15 AS option_id,
'101974099 - \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo Oval 1/2' 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 = 15
AND option_value_id = 3194
DELETE FROM oc_product
WHERE
model = '101974099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3194,
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 '101975399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2564
UPDATE oc_option_value_description
SET
name = '101975399 - Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo Oval 3/4'
WHERE
option_value_id = 2564
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 = 2564
DELETE FROM oc_product
WHERE
model = '101975399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2564,
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 '101972299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2537
UPDATE oc_option_value_description
SET
name = '101972299 - Pincel Daler Rowney Cabo Curto Pêlo Sintético Redondo N6'
WHERE
option_value_id = 2537
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 = 2537
DELETE FROM oc_product
WHERE
model = '101972299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2537,
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 '101972399 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3195 AS option_value_id,
language_id,
15 AS option_id,
'101972399 - \''Pincel Daler Rowney Cabo Curto Pêlo Sintético Redondo N10' 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 = 15
AND option_value_id = 3195
DELETE FROM oc_product
WHERE
model = '101972399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3195,
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 '101972499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2539
UPDATE oc_option_value_description
SET
name = '101972499 - Pincel Daler Rowney Cabo Curto Pêlo Sintético Redondo N12'
WHERE
option_value_id = 2539
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 = 2539
DELETE FROM oc_product
WHERE
model = '101972499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2539,
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 '101972599 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3196 AS option_value_id,
language_id,
15 AS option_id,
'101972599 - \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo N18' 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 = 15
AND option_value_id = 3196
DELETE FROM oc_product
WHERE
model = '101972599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3196,
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 '101972699 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3197 AS option_value_id,
language_id,
15 AS option_id,
'101972699 - \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo N26' 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 = 15
AND option_value_id = 3197
DELETE FROM oc_product
WHERE
model = '101972699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3197,
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 '101972799 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3198 AS option_value_id,
language_id,
15 AS option_id,
'101972799 - \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Redondo N30' 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 = 15
AND option_value_id = 3198
DELETE FROM oc_product
WHERE
model = '101972799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3198,
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 '101973099 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3199 AS option_value_id,
language_id,
15 AS option_id,
'101973099 - \''Pincel Daler Rowney Cabo Curto Pêlo Sintético Espatulado 1/2' 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 = 15
AND option_value_id = 3199
DELETE FROM oc_product
WHERE
model = '101973099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3199,
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 '101973199 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3200 AS option_value_id,
language_id,
15 AS option_id,
'101973199 - \''Pincel Daler Rowney Cabo Curto PPêlo Sintético Espatulado 3/4' 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 = 15
AND option_value_id = 3200
DELETE FROM oc_product
WHERE
model = '101973199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3200,
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 '101975199 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3201 AS option_value_id,
language_id,
15 AS option_id,
'101975199 - \''Pincel Daler Rowney Cabo Curto Pêlo Sintético Espatulado 1\''\''' 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 = 15
AND option_value_id = 3201
DELETE FROM oc_product
WHERE
model = '101975199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3201,
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 = 27224
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27224,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101973299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2547
UPDATE oc_option_value_description
SET
name = '101973299 - Pincel Daler Rowney Cabo Curto Pêlo Sintético Biselado 1/2'
WHERE
option_value_id = 2547
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 328
AND product_id = 27224
AND option_id = 15
AND option_value_id = 2547
DELETE FROM oc_product
WHERE
model = '101973299'
INSERT INTO oc_product_option_value
SET
product_option_id = 328,
product_id = 27224,
option_id = 15,
option_value_id = 2547,
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 '101975299 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3202 AS option_value_id,
language_id,
15 AS option_id,
'101975299 - \''Pincel Daler Rowney Cabo Curto Pêlo Sintético Biselado 1/4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 328
AND product_id = 27224
AND option_id = 15
AND option_value_id = 3202
DELETE FROM oc_product
WHERE
model = '101975299'
INSERT INTO oc_product_option_value
SET
product_option_id = 328,
product_id = 27224,
option_id = 15,
option_value_id = 3202,
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 = 27225
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27225,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101973399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2548
UPDATE oc_option_value_description
SET
name = '101973399 - Pincel Daler Rowney Cabo Curto Espatulado N8'
WHERE
option_value_id = 2548
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 329
AND product_id = 27225
AND option_id = 15
AND option_value_id = 2548
DELETE FROM oc_product
WHERE
model = '101973399'
INSERT INTO oc_product_option_value
SET
product_option_id = 329,
product_id = 27225,
option_id = 15,
option_value_id = 2548,
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 '101974899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2559
UPDATE oc_option_value_description
SET
name = '101974899 - Pincel Daler Rowney Cabo Curto Espatulado 3/4'
WHERE
option_value_id = 2559
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 329
AND product_id = 27225
AND option_id = 15
AND option_value_id = 2559
DELETE FROM oc_product
WHERE
model = '101974899'
INSERT INTO oc_product_option_value
SET
product_option_id = 329,
product_id = 27225,
option_id = 15,
option_value_id = 2559,
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 '101973499 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3203 AS option_value_id,
language_id,
15 AS option_id,
'101973499 - \''Pincel Daler Rowney Cabo Curto Língua de Gato N2' 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 = 15
AND option_value_id = 3203
DELETE FROM oc_product
WHERE
model = '101973499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3203,
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 '101974199 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3204 AS option_value_id,
language_id,
15 AS option_id,
'101974199 - \''Pincel Daler Rowney Cabo Curto Língua de Gato N6' 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 = 15
AND option_value_id = 3204
DELETE FROM oc_product
WHERE
model = '101974199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3204,
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 '101973699 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3205 AS option_value_id,
language_id,
15 AS option_id,
'101973699 - \''Pincel Daler Rowney Cabo Curto Pêlo Longo N1' 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 = 15
AND option_value_id = 3205
DELETE FROM oc_product
WHERE
model = '101973699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3205,
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 '101973799 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3206 AS option_value_id,
language_id,
15 AS option_id,
'101973799 - \''Pincel Daler Rowney Cabo Curto Pêlo Longo N2' 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 = 15
AND option_value_id = 3206
DELETE FROM oc_product
WHERE
model = '101973799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3206,
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 '101973899 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3207 AS option_value_id,
language_id,
15 AS option_id,
'101973899 - \''Pincel Daler Rowney Cabo Curto Pêlo Longo N3' 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 = 15
AND option_value_id = 3207
DELETE FROM oc_product
WHERE
model = '101973899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3207,
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 = 27228
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27228,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101974299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2557
UPDATE oc_option_value_description
SET
name = '101974299 - Pincel Daler Rowney Cabo Curto Pêlo Redondo N1'
WHERE
option_value_id = 2557
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 330
AND product_id = 27228
AND option_id = 15
AND option_value_id = 2557
DELETE FROM oc_product
WHERE
model = '101974299'
INSERT INTO oc_product_option_value
SET
product_option_id = 330,
product_id = 27228,
option_id = 15,
option_value_id = 2557,
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 '101974399 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3208 AS option_value_id,
language_id,
15 AS option_id,
'101974399 - \''Pincel Daler Rowney Cabo Curto Pêlo Redondo N4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 330
AND product_id = 27228
AND option_id = 15
AND option_value_id = 3208
DELETE FROM oc_product
WHERE
model = '101974399'
INSERT INTO oc_product_option_value
SET
product_option_id = 330,
product_id = 27228,
option_id = 15,
option_value_id = 3208,
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 = 27229
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27229,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101974499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2526
UPDATE oc_option_value_description
SET
name = '101974499 - Pincel Daler Rowney Cabo Comprido Redondo N16'
WHERE
option_value_id = 2526
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 331
AND product_id = 27229
AND option_id = 15
AND option_value_id = 2526
DELETE FROM oc_product
WHERE
model = '101974499'
INSERT INTO oc_product_option_value
SET
product_option_id = 331,
product_id = 27229,
option_id = 15,
option_value_id = 2526,
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 '101974699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2528
UPDATE oc_option_value_description
SET
name = '101974699 - Pincel Daler Rowney Cabo Comprido Redondo N4'
WHERE
option_value_id = 2528
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 331
AND product_id = 27229
AND option_id = 15
AND option_value_id = 2528
DELETE FROM oc_product
WHERE
model = '101974699'
INSERT INTO oc_product_option_value
SET
product_option_id = 331,
product_id = 27229,
option_id = 15,
option_value_id = 2528,
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 '101974799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2529
UPDATE oc_option_value_description
SET
name = '101974799 - Pincel Daler Rowney Cabo Comprido Redondo N20'
WHERE
option_value_id = 2529
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 331
AND product_id = 27229
AND option_id = 15
AND option_value_id = 2529
DELETE FROM oc_product
WHERE
model = '101974799'
INSERT INTO oc_product_option_value
SET
product_option_id = 331,
product_id = 27229,
option_id = 15,
option_value_id = 2529,
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 = 27230
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27230,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101974599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2527
UPDATE oc_option_value_description
SET
name = '101974599 - Pincel Daler Rowney Cabo Comprido Espatulado N6'
WHERE
option_value_id = 2527
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 332
AND product_id = 27230
AND option_id = 15
AND option_value_id = 2527
DELETE FROM oc_product
WHERE
model = '101974599'
INSERT INTO oc_product_option_value
SET
product_option_id = 332,
product_id = 27230,
option_id = 15,
option_value_id = 2527,
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 '101975599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2530
UPDATE oc_option_value_description
SET
name = '101975599 - Pincel Daler Rowney Cabo Comprido Espatulado N16'
WHERE
option_value_id = 2530
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 332
AND product_id = 27230
AND option_id = 15
AND option_value_id = 2530
DELETE FROM oc_product
WHERE
model = '101975599'
INSERT INTO oc_product_option_value
SET
product_option_id = 332,
product_id = 27230,
option_id = 15,
option_value_id = 2530,
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 '101974999 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3209 AS option_value_id,
language_id,
15 AS option_id,
'101974999 - \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Espatulado 3/4' 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 = 15
AND option_value_id = 3209
DELETE FROM oc_product
WHERE
model = '101974999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3209,
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 '101975099 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3210 AS option_value_id,
language_id,
15 AS option_id,
'101975099 - \''Pincel Daler Rowney Cabo Curto Pêlo Ponei Espatulado 1/2' 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 = 15
AND option_value_id = 3210
DELETE FROM oc_product
WHERE
model = '101975099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 3210,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.