Product Sync.
Opencart products: 147
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: 27544
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 - %'
)
UPDATING: 101972899
Product ID: 27222
Image file:
UPDATING: 101972999
Product ID: 27223
Image file:
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 - %'
)
UPDATING: 101973599
Product ID: 27226
Image file:
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 - %'
)
UPDATING: 101976099
Product ID: 27232
Image file:
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: 157
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 = 27544
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101971199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3583 AS option_value_id,
language_id,
17 AS option_id,
'101971199 - Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato N8' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 485
AND product_id = 27544
AND option_id = 17
AND option_value_id = 3583
DELETE FROM oc_product
WHERE
model = '101971199'
INSERT INTO oc_product_option_value
SET
product_option_id = 485,
product_id = 27544,
option_id = 17,
option_value_id = 3583,
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 = 27545
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27545,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101971299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3584 AS option_value_id,
language_id,
17 AS option_id,
'101971299 - Pincel Daler Rowney de Cerda Cabo Comprido Espatulado Longo N4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 486
AND product_id = 27545
AND option_id = 17
AND option_value_id = 3584
DELETE FROM oc_product
WHERE
model = '101971299'
INSERT INTO oc_product_option_value
SET
product_option_id = 486,
product_id = 27545,
option_id = 17,
option_value_id = 3584,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3585 AS option_value_id,
language_id,
17 AS option_id,
'101971399 - Pincel Daler Rowney de Cerda Cabo Comprido Espatulado Longo N8' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 486
AND product_id = 27545
AND option_id = 17
AND option_value_id = 3585
DELETE FROM oc_product
WHERE
model = '101971399'
INSERT INTO oc_product_option_value
SET
product_option_id = 486,
product_id = 27545,
option_id = 17,
option_value_id = 3585,
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 = 27546
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27546,
option_id = 17,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3586 AS option_value_id,
language_id,
17 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 = 487
AND product_id = 27546
AND option_id = 17
AND option_value_id = 3586
DELETE FROM oc_product
WHERE
model = '101971499'
INSERT INTO oc_product_option_value
SET
product_option_id = 487,
product_id = 27546,
option_id = 17,
option_value_id = 3586,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3587 AS option_value_id,
language_id,
17 AS option_id,
'101971599 - Pincel Daler Rowney de Cerda Cabo Comprido Redondo N10' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 487
AND product_id = 27546
AND option_id = 17
AND option_value_id = 3587
DELETE FROM oc_product
WHERE
model = '101971599'
INSERT INTO oc_product_option_value
SET
product_option_id = 487,
product_id = 27546,
option_id = 17,
option_value_id = 3587,
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 '101971799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3588 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3588
DELETE FROM oc_product
WHERE
model = '101971799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3588,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3589 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3589
DELETE FROM oc_product
WHERE
model = '101971899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3589,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3590 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3590
DELETE FROM oc_product
WHERE
model = '101971999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3590,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3591 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3591
DELETE FROM oc_product
WHERE
model = '101972099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3591,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3592 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3592
DELETE FROM oc_product
WHERE
model = '101975499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3592,
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 '101972199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3593 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3593
DELETE FROM oc_product
WHERE
model = '101972199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3593,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3594 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3594
DELETE FROM oc_product
WHERE
model = '101974099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3594,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3595 AS option_value_id,
language_id,
17 AS option_id,
'101975399 - Pincel Daler Rowney Cabo Curto Pêlo Ponei 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 = 17
AND option_value_id = 3595
DELETE FROM oc_product
WHERE
model = '101975399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3595,
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 '101972299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3596 AS option_value_id,
language_id,
17 AS option_id,
'101972299 - Pincel Daler Rowney Cabo Curto Pêlo Sintético Redondo 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 = 17
AND option_value_id = 3596
DELETE FROM oc_product
WHERE
model = '101972299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3596,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3597 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3597
DELETE FROM oc_product
WHERE
model = '101972399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3597,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3598 AS option_value_id,
language_id,
17 AS option_id,
'101972499 - Pincel Daler Rowney Cabo Curto Pêlo Sintético Redondo N12' 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 = 3598
DELETE FROM oc_product
WHERE
model = '101972499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3598,
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 '101972599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3599 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3599
DELETE FROM oc_product
WHERE
model = '101972599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3599,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3600 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3600
DELETE FROM oc_product
WHERE
model = '101972699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3600,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3601 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3601
DELETE FROM oc_product
WHERE
model = '101972799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3601,
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 '101973099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3602 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3602
DELETE FROM oc_product
WHERE
model = '101973099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3602,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3603 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3603
DELETE FROM oc_product
WHERE
model = '101973199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3603,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3604 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3604
DELETE FROM oc_product
WHERE
model = '101975199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3604,
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 = 27548
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27548,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101973299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3605 AS option_value_id,
language_id,
17 AS option_id,
'101973299 - Pincel Daler Rowney Cabo Curto Pêlo Sintético Biselado 1/2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 488
AND product_id = 27548
AND option_id = 17
AND option_value_id = 3605
DELETE FROM oc_product
WHERE
model = '101973299'
INSERT INTO oc_product_option_value
SET
product_option_id = 488,
product_id = 27548,
option_id = 17,
option_value_id = 3605,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3606 AS option_value_id,
language_id,
17 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 = 488
AND product_id = 27548
AND option_id = 17
AND option_value_id = 3606
DELETE FROM oc_product
WHERE
model = '101975299'
INSERT INTO oc_product_option_value
SET
product_option_id = 488,
product_id = 27548,
option_id = 17,
option_value_id = 3606,
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 = 27549
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27549,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101973399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3607 AS option_value_id,
language_id,
17 AS option_id,
'101973399 - Pincel Daler Rowney Cabo Curto Espatulado N8' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 489
AND product_id = 27549
AND option_id = 17
AND option_value_id = 3607
DELETE FROM oc_product
WHERE
model = '101973399'
INSERT INTO oc_product_option_value
SET
product_option_id = 489,
product_id = 27549,
option_id = 17,
option_value_id = 3607,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3608 AS option_value_id,
language_id,
17 AS option_id,
'101974899 - Pincel Daler Rowney Cabo Curto Espatulado 3/4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 489
AND product_id = 27549
AND option_id = 17
AND option_value_id = 3608
DELETE FROM oc_product
WHERE
model = '101974899'
INSERT INTO oc_product_option_value
SET
product_option_id = 489,
product_id = 27549,
option_id = 17,
option_value_id = 3608,
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 '101973499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3609 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3609
DELETE FROM oc_product
WHERE
model = '101973499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3609,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3610 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3610
DELETE FROM oc_product
WHERE
model = '101974199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3610,
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 '101973699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3611 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3611
DELETE FROM oc_product
WHERE
model = '101973699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3611,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3612 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3612
DELETE FROM oc_product
WHERE
model = '101973799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3612,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3613 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3613
DELETE FROM oc_product
WHERE
model = '101973899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3613,
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 = 27551
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27551,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101974299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3614 AS option_value_id,
language_id,
17 AS option_id,
'101974299 - Pincel Daler Rowney Cabo Curto Pêlo Redondo N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 490
AND product_id = 27551
AND option_id = 17
AND option_value_id = 3614
DELETE FROM oc_product
WHERE
model = '101974299'
INSERT INTO oc_product_option_value
SET
product_option_id = 490,
product_id = 27551,
option_id = 17,
option_value_id = 3614,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3615 AS option_value_id,
language_id,
17 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 = 490
AND product_id = 27551
AND option_id = 17
AND option_value_id = 3615
DELETE FROM oc_product
WHERE
model = '101974399'
INSERT INTO oc_product_option_value
SET
product_option_id = 490,
product_id = 27551,
option_id = 17,
option_value_id = 3615,
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 = 27552
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27552,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101974499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3616 AS option_value_id,
language_id,
17 AS option_id,
'101974499 - Pincel Daler Rowney Cabo Comprido Redondo N16' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 491
AND product_id = 27552
AND option_id = 17
AND option_value_id = 3616
DELETE FROM oc_product
WHERE
model = '101974499'
INSERT INTO oc_product_option_value
SET
product_option_id = 491,
product_id = 27552,
option_id = 17,
option_value_id = 3616,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3617 AS option_value_id,
language_id,
17 AS option_id,
'101974699 - Pincel Daler Rowney Cabo Comprido Redondo N4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 491
AND product_id = 27552
AND option_id = 17
AND option_value_id = 3617
DELETE FROM oc_product
WHERE
model = '101974699'
INSERT INTO oc_product_option_value
SET
product_option_id = 491,
product_id = 27552,
option_id = 17,
option_value_id = 3617,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3618 AS option_value_id,
language_id,
17 AS option_id,
'101974799 - Pincel Daler Rowney Cabo Comprido Redondo N20' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 491
AND product_id = 27552
AND option_id = 17
AND option_value_id = 3618
DELETE FROM oc_product
WHERE
model = '101974799'
INSERT INTO oc_product_option_value
SET
product_option_id = 491,
product_id = 27552,
option_id = 17,
option_value_id = 3618,
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 = 27553
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27553,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101974599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3619 AS option_value_id,
language_id,
17 AS option_id,
'101974599 - Pincel Daler Rowney Cabo Comprido Espatulado N6' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 492
AND product_id = 27553
AND option_id = 17
AND option_value_id = 3619
DELETE FROM oc_product
WHERE
model = '101974599'
INSERT INTO oc_product_option_value
SET
product_option_id = 492,
product_id = 27553,
option_id = 17,
option_value_id = 3619,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3620 AS option_value_id,
language_id,
17 AS option_id,
'101975599 - Pincel Daler Rowney Cabo Comprido Espatulado N16' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 492
AND product_id = 27553
AND option_id = 17
AND option_value_id = 3620
DELETE FROM oc_product
WHERE
model = '101975599'
INSERT INTO oc_product_option_value
SET
product_option_id = 492,
product_id = 27553,
option_id = 17,
option_value_id = 3620,
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 '101974999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3621 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3621
DELETE FROM oc_product
WHERE
model = '101974999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3621,
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 = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3622 AS option_value_id,
language_id,
17 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 = 17
AND option_value_id = 3622
DELETE FROM oc_product
WHERE
model = '101975099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 3622,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.