Product Sync.
Opencart products: 73
Input products: 100
UPDATING: Tinta Relevo Cerne Pébéo
Product ID: 27470
Image file:
NEW: 100535499
NEW: 100535599
UPDATING: Médio para Vitral Pébeo
Product ID: 27464
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: 73
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 = 27470
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100535399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3440 AS option_value_id,
language_id,
17 AS option_id,
'100535399 - Cerne Pébéo Ouro Pálido' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3440
DELETE FROM oc_product
WHERE
model = '100535399'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3440,
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 = 27464
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100535699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3441 AS option_value_id,
language_id,
17 AS option_id,
'100535699 - Médio para Vitral Pébéo Clareador 45 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 442
AND product_id = 27464
AND option_id = 17
AND option_value_id = 3441
DELETE FROM oc_product
WHERE
model = '100535699'
INSERT INTO oc_product_option_value
SET
product_option_id = 442,
product_id = 27464,
option_id = 17,
option_value_id = 3441,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3442 AS option_value_id,
language_id,
17 AS option_id,
'100535799 - Médio para Vitral Pébéo Glitter 45 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 442
AND product_id = 27464
AND option_id = 17
AND option_value_id = 3442
DELETE FROM oc_product
WHERE
model = '100535799'
INSERT INTO oc_product_option_value
SET
product_option_id = 442,
product_id = 27464,
option_id = 17,
option_value_id = 3442,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3443 AS option_value_id,
language_id,
17 AS option_id,
'100535899 - Médio para Vitral Pébéo Mate 45 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 442
AND product_id = 27464
AND option_id = 17
AND option_value_id = 3443
DELETE FROM oc_product
WHERE
model = '100535899'
INSERT INTO oc_product_option_value
SET
product_option_id = 442,
product_id = 27464,
option_id = 17,
option_value_id = 3443,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3444 AS option_value_id,
language_id,
17 AS option_id,
'100535999 - Médio para Vitral Pébéo Anti - Gota 30 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 442
AND product_id = 27464
AND option_id = 17
AND option_value_id = 3444
DELETE FROM oc_product
WHERE
model = '100535999'
INSERT INTO oc_product_option_value
SET
product_option_id = 442,
product_id = 27464,
option_id = 17,
option_value_id = 3444,
quantity = 1,
subtract = 1,
price = 0.569,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.