Product Sync.
Opencart products: 245
Input products: 100
NEW: 102050399
NEW: 102050499
NEW: 102050599
NEW: 102050699
NEW: 102050799
NEW: 102050899
NEW: 102050999
NEW: 102051099
NEW: 102051199
NEW: 102051299
NEW: 102051399
NEW: 102051499
NEW: 102051599
NEW: 102051699
NEW: 102051799
NEW: 102051899
NEW: 102051999
NEW: 102052099
NEW: 102052199
NEW: 102052299
NEW: 102052399
NEW: 102052499
NEW: 102052599
NEW: 102052699
NEW: 102052799
NEW: 102052899
NEW: 102052999
NEW: 102053099
NEW: 102053199
NEW: 102053299
NEW: 102053399
NEW: 102053499
NEW: 102053599
NEW: 102053699
NEW: 102053799
NEW: 102053899
NEW: 102053999
NEW: 102054099
NEW: 102054199
NEW: 102054299
NEW: 102054399
NEW: 102054499
NEW: 102054599
UPDATING: Tinta Relevo Pébéo para Tecido
Product ID: 27081
Image file:
NEW: 102056299
NEW: 102056399
NEW: 102056499
NEW: 102056599
NEW: 102056699
NEW: 102056799
NEW: 102056899
NEW: 102056999
NEW: 102057099
NEW: 102057199
NEW: 102057299
NEW: 102057399
NEW: 102057499
NEW: 102057599
NEW: 102057699
NEW: 102057799
NEW: 102057899
NEW: 102057999
NEW: 102058099
NEW: 102058199
NEW: 102058299
NEW: 102058399
NEW: 102058499
NEW: 102058599
NEW: 102058699
NEW: 102058799
NEW: 102058899
NEW: 102058999
NEW: 102059099
NEW: 102059199
NEW: 102059299
NEW: 102059399
NEW: 102059499
NEW: 102059599
NEW: 102059699
NEW: 102059799
NEW: 102059899
NEW: 102059999
NEW: 102060099
NEW: 102060199
NEW: 102060299
Ok.
Product Option Sync.
Opencart products: 245
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 = 27081
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102054699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2592
UPDATE oc_option_value_description
SET
name = '102054699 - Setacolor 3D Metal 20 ml Ouro Branco'
WHERE
option_value_id = 2592
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2592
DELETE FROM oc_product
WHERE
model = '102054699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2592
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102054799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2593
UPDATE oc_option_value_description
SET
name = '102054799 - Setacolor 3D Metal 20 ml Papoila'
WHERE
option_value_id = 2593
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2593
DELETE FROM oc_product
WHERE
model = '102054799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2593
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102054899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2594
UPDATE oc_option_value_description
SET
name = '102054899 - Setacolor 3D Metal 20 ml Verde esmeralda'
WHERE
option_value_id = 2594
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2594
DELETE FROM oc_product
WHERE
model = '102054899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2594
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102054999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2595
UPDATE oc_option_value_description
SET
name = '102054999 - Setacolor 3D Metal 20 ml Cinza'
WHERE
option_value_id = 2595
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2595
DELETE FROM oc_product
WHERE
model = '102054999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2595
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2596
UPDATE oc_option_value_description
SET
name = '102055099 - Setacolor 3D Metal 20 ml Prateado'
WHERE
option_value_id = 2596
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2596
DELETE FROM oc_product
WHERE
model = '102055099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2596
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2597
UPDATE oc_option_value_description
SET
name = '102055199 - Setacolor 3D Metal 20 ml Azul Faiança'
WHERE
option_value_id = 2597
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2597
DELETE FROM oc_product
WHERE
model = '102055199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2597
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2598
UPDATE oc_option_value_description
SET
name = '102055299 - Setacolor 3D Metal 20 ml Lilás'
WHERE
option_value_id = 2598
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2598
DELETE FROM oc_product
WHERE
model = '102055299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2598
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2599
UPDATE oc_option_value_description
SET
name = '102055399 - Setacolor 3D Gloss 20 ml Preto'
WHERE
option_value_id = 2599
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2599
DELETE FROM oc_product
WHERE
model = '102055399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2599
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2600
UPDATE oc_option_value_description
SET
name = '102055499 - Setacolor 3D Gloss 20 ml Azul Escuro'
WHERE
option_value_id = 2600
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2600
DELETE FROM oc_product
WHERE
model = '102055499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2600
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2601
UPDATE oc_option_value_description
SET
name = '102055599 - Setacolor 3D Gloss 20 ml Amarelo Limão'
WHERE
option_value_id = 2601
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2601
DELETE FROM oc_product
WHERE
model = '102055599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2601
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2602
UPDATE oc_option_value_description
SET
name = '102055699 - Setacolor 3D Gloss 20 ml Vermelho Pimentão'
WHERE
option_value_id = 2602
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2602
DELETE FROM oc_product
WHERE
model = '102055699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2602
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2603
UPDATE oc_option_value_description
SET
name = '102055799 - Setacolor 3D Gloss 20 ml Azul Brilhante'
WHERE
option_value_id = 2603
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2603
DELETE FROM oc_product
WHERE
model = '102055799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2603
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2604
UPDATE oc_option_value_description
SET
name = '102055899 - Setacolor 3D Gloss 20 ml Rosa'
WHERE
option_value_id = 2604
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2604
DELETE FROM oc_product
WHERE
model = '102055899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2604
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102055999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2605
UPDATE oc_option_value_description
SET
name = '102055999 - Setacolor 3D Gloss 20 ml Laranja'
WHERE
option_value_id = 2605
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2605
DELETE FROM oc_product
WHERE
model = '102055999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2605
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102056099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2606
UPDATE oc_option_value_description
SET
name = '102056099 - Setacolor 3D Gloss 20 ml Azul Claro'
WHERE
option_value_id = 2606
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2606
DELETE FROM oc_product
WHERE
model = '102056099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2606
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102056199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2607
UPDATE oc_option_value_description
SET
name = '102056199 - Setacolor 3D Gloss 20 ml Azul Bermuda'
WHERE
option_value_id = 2607
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2607
DELETE FROM oc_product
WHERE
model = '102056199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2607
Ok.