Product Sync.
Opencart products: 129
Input products: 100
NEW: 101696799
NEW: 101696899
NEW: 101696999
UPDATING: Guache Giotto Lavável 1000 ml
Product ID: 27422
Image file:
NEW: 101697899
NEW: 101697999
NEW: 101698099
NEW: 101698199
NEW: 101698299
NEW: 101698399
NEW: 101698499
NEW: 101698599
NEW: 101698699
NEW: 101698799
NEW: 101698899
NEW: 101698999
NEW: 101699099
NEW: 101699199
NEW: 101699299
NEW: 101699399
NEW: 101699499
NEW: 101699599
NEW: 101699699
NEW: 101699799
NEW: 101699899
NEW: 101699999
NEW: 101700099
NEW: 101700199
NEW: 101700299
NEW: 101700399
NEW: 101700499
NEW: 101700599
NEW: 101700699
NEW: 101700799
NEW: 101700899
NEW: 101700999
NEW: 101701099
NEW: 101701199
NEW: 101701299
NEW: 101701399
NEW: 101701499
NEW: 101701599
NEW: 101701699
NEW: 101701799
NEW: 101701899
NEW: 101701999
NEW: 101702099
NEW: 101702199
NEW: 101702299
NEW: 101702399
NEW: 101702499
NEW: 101702599
NEW: 101702699
NEW: 101702799
NEW: 101702899
NEW: 101702999
NEW: 101703099
NEW: 101703199
NEW: 101703299
NEW: 101703399
NEW: 101703499
NEW: 101703599
NEW: 101703699
NEW: 101703799
NEW: 101703899
NEW: 101703999
NEW: 101704099
NEW: 101704199
NEW: 101704299
NEW: 101704399
NEW: 101704499
NEW: 101704599
NEW: 101704699
NEW: 101704799
NEW: 101704899
NEW: 101704999
NEW: 101705099
NEW: 101705199
NEW: 101705299
NEW: 101705399
NEW: 101705499
NEW: 101705599
NEW: 101705699
NEW: 101705799
NEW: 101705899
NEW: 101705999
NEW: 101706099
NEW: 101706199
NEW: 101706299
NEW: 101706399
NEW: 101706499
NEW: 101706599
NEW: 101706699
Ok.
Product Option Sync.
Opencart products: 129
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 = 27422
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101697099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3564 AS option_value_id,
language_id,
17 AS option_id,
'101697099 - Guache Giotto Lavável 1000 ml Azul Ultramarino' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3564
DELETE FROM oc_product
WHERE
model = '101697099'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3564,
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 '101697199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3565 AS option_value_id,
language_id,
17 AS option_id,
'101697199 - Guache Giotto Lavável 1000 ml Magenta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3565
DELETE FROM oc_product
WHERE
model = '101697199'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3565,
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 '101697299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3566 AS option_value_id,
language_id,
17 AS option_id,
'101697299 - Guache Giotto Lavável 1000 ml Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3566
DELETE FROM oc_product
WHERE
model = '101697299'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3566,
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 '101697399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3567 AS option_value_id,
language_id,
17 AS option_id,
'101697399 - Guache Giotto Lavável 1000 ml Verde Claro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3567
DELETE FROM oc_product
WHERE
model = '101697399'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3567,
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 '101697499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3568 AS option_value_id,
language_id,
17 AS option_id,
'101697499 - Guache Giotto Lavável 1000 ml Laranja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3568
DELETE FROM oc_product
WHERE
model = '101697499'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3568,
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 '101697599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3569 AS option_value_id,
language_id,
17 AS option_id,
'101697599 - Guache Giotto Lavável 1000 ml Vermelho Escarlate' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3569
DELETE FROM oc_product
WHERE
model = '101697599'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3569,
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 '101697699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3570 AS option_value_id,
language_id,
17 AS option_id,
'101697699 - Guache Giotto Lavável 1000 ml Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3570
DELETE FROM oc_product
WHERE
model = '101697699'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3570,
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 '101697799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3571 AS option_value_id,
language_id,
17 AS option_id,
'101697799 - Guache Giotto Lavável 1000 ml Azul Cyan' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3571
DELETE FROM oc_product
WHERE
model = '101697799'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3571,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.