Product Sync.
Opencart products: 168
Input products: 100
UPDATING: Tinta Relevo Cerne Pébéo
Product ID: 27043
Image file:
NEW: 100535499
NEW: 100535599
UPDATING: Médio para Vitral Pébeo
Product ID: 27152
Image file:
NEW: 100536099
NEW: 100536199
NEW: 100536299
NEW: 100536399
NEW: 100536499
NEW: 100536599
NEW: 100536699
NEW: 100536799
NEW: 100536899
NEW: 100536999
NEW: 100537099
NEW: 100537199
NEW: 100537299
NEW: 100537399
NEW: 100537499
NEW: 100537599
NEW: 100537699
NEW: 100537799
NEW: 100537899
NEW: 100537999
NEW: 100538099
NEW: 100538199
NEW: 100538299
NEW: 100538399
NEW: 100538499
NEW: 100538599
NEW: 100538699
NEW: 100538799
NEW: 100538899
NEW: 100538999
NEW: 100539099
NEW: 100539199
NEW: 100539299
NEW: 100539399
NEW: 100539499
NEW: 100539599
NEW: 100539699
NEW: 100539799
NEW: 100539899
NEW: 100539999
NEW: 100540099
NEW: 100540199
NEW: 100540299
NEW: 100540399
NEW: 100540499
NEW: 100540599
NEW: 100540699
NEW: 100540799
NEW: 100540899
NEW: 100540999
NEW: 100541099
NEW: 100541199
NEW: 100541299
NEW: 100541399
NEW: 100541499
NEW: 100541599
NEW: 100541699
NEW: 100541799
NEW: 100541899
NEW: 100541999
NEW: 100542099
NEW: 100542199
NEW: 100542299
NEW: 100542399
NEW: 100542499
NEW: 100542599
NEW: 100542699
NEW: 100542799
NEW: 100542899
NEW: 100542999
NEW: 100543099
NEW: 100543199
NEW: 100543299
NEW: 100543399
NEW: 100543499
NEW: 100543599
NEW: 100543699
NEW: 100543799
NEW: 100543899
NEW: 100543999
NEW: 100544099
NEW: 100544199
NEW: 100544299
NEW: 100544399
NEW: 100544499
NEW: 100544599
NEW: 100544699
NEW: 100544799
NEW: 100544899
NEW: 100544999
NEW: 100545099
NEW: 100545199
NEW: 100545299
Ok.
Product Option Sync.
Opencart products: 168
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 = 27043
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100535399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2352
UPDATE oc_option_value_description
SET
name = '100535399 - Cerne Pébéo Ouro Pálido'
WHERE
option_value_id = 2352
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2352
DELETE FROM oc_product
WHERE
model = '100535399'
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 = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2352
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27152
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100535699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2353
UPDATE oc_option_value_description
SET
name = '100535699 - Médio para Vitral Pébéo Clareador 45 ml'
WHERE
option_value_id = 2353
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 298
AND product_id = 27152
AND option_id = 15
AND option_value_id = 2353
DELETE FROM oc_product
WHERE
model = '100535699'
INSERT INTO oc_product_option_value
SET
product_option_id = 298,
product_id = 27152,
option_id = 15,
option_value_id = 2353,
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 '100535799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2354
UPDATE oc_option_value_description
SET
name = '100535799 - Médio para Vitral Pébéo Glitter 45 ml'
WHERE
option_value_id = 2354
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 298
AND product_id = 27152
AND option_id = 15
AND option_value_id = 2354
DELETE FROM oc_product
WHERE
model = '100535799'
INSERT INTO oc_product_option_value
SET
product_option_id = 298,
product_id = 27152,
option_id = 15,
option_value_id = 2354,
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 '100535899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2355
UPDATE oc_option_value_description
SET
name = '100535899 - Médio para Vitral Pébéo Mate 45 ml'
WHERE
option_value_id = 2355
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 298
AND product_id = 27152
AND option_id = 15
AND option_value_id = 2355
DELETE FROM oc_product
WHERE
model = '100535899'
INSERT INTO oc_product_option_value
SET
product_option_id = 298,
product_id = 27152,
option_id = 15,
option_value_id = 2355,
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 '100535999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2356
UPDATE oc_option_value_description
SET
name = '100535999 - Médio para Vitral Pébéo Anti - Gota 30 ml'
WHERE
option_value_id = 2356
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 298
AND product_id = 27152
AND option_id = 15
AND option_value_id = 2356
DELETE FROM oc_product
WHERE
model = '100535999'
INSERT INTO oc_product_option_value
SET
product_option_id = 298,
product_id = 27152,
option_id = 15,
option_value_id = 2356,
quantity = 1,
subtract = 1,
price = 0.569,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.