Product Sync.
Opencart products: 86
Input products: 100
NEW: 100767799
NEW: 100767899
NEW: 100767999
UPDATING: Guache Giotto Lavável 500 ml
Product ID: 27482
Image file:
NEW: 100768199
NEW: 100768299
NEW: 100768399
NEW: 100768499
NEW: 100768599
NEW: 100768699
NEW: 100768799
NEW: 100768899
NEW: 100768999
NEW: 100769099
NEW: 100769199
NEW: 100769299
NEW: 100769399
NEW: 100769499
NEW: 100769599
NEW: 100769699
NEW: 100769799
NEW: 100769899
NEW: 100769999
NEW: 100770099
NEW: 100770199
NEW: 100770299
NEW: 100770399
NEW: 100770499
NEW: 100770599
NEW: 100770699
NEW: 100770799
NEW: 100770899
NEW: 100770999
NEW: 100771099
NEW: 100771199
NEW: 100771209
NEW: 100771299
NEW: 100771399
NEW: 100771499
NEW: 100771599
NEW: 100771699
NEW: 100771799
NEW: 100771899
NEW: 100771999
NEW: 100772099
NEW: 100772199
NEW: 100772299
NEW: 100772399
NEW: 100772499
NEW: 100772599
NEW: 100772699
NEW: 100772799
NEW: 100772899
NEW: 100772999
NEW: 100773099
NEW: 100773199
NEW: 100773299
NEW: 100773699
NEW: 100773799
NEW: 100773899
NEW: 100773999
NEW: 100774099
NEW: 100774199
NEW: 100774299
NEW: 100774399
NEW: 100774499
NEW: 100774599
NEW: 100774699
NEW: 100774799
NEW: 100774899
NEW: 100774999
NEW: 100775099
NEW: 100775199
NEW: 100775299
NEW: 100775399
NEW: 100775499
NEW: 100775599
NEW: 100775699
NEW: 100775799
NEW: 100775899
NEW: 100775999
NEW: 100776099
NEW: 100776199
NEW: 100776299
NEW: 100776399
NEW: 100776499
NEW: 100776599
NEW: 100776699
NEW: 100776799
NEW: 100776899
NEW: 100776999
NEW: 100777099
NEW: 100777199
NEW: 100777299
NEW: 100777399
NEW: 100777499
NEW: 100777599
Ok.
Product Option Sync.
Opencart products: 86
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 = 27482
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100768099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3453 AS option_value_id,
language_id,
17 AS option_id,
'100768099 - Guache Giotto 500 ml Lavável Laranja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3453
DELETE FROM oc_product
WHERE
model = '100768099'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3453,
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 '100773399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3454 AS option_value_id,
language_id,
17 AS option_id,
'100773399 - Guache Giotto 500 ml Lavável Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3454
DELETE FROM oc_product
WHERE
model = '100773399'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3454,
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 '100773499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3455 AS option_value_id,
language_id,
17 AS option_id,
'100773499 - Guache Giotto 500 ml Lavável Vermelhão' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3455
DELETE FROM oc_product
WHERE
model = '100773499'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3455,
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 '100773599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3456 AS option_value_id,
language_id,
17 AS option_id,
'100773599 - Guache Giotto 500 ml Lavável Vermelho Escarlate' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3456
DELETE FROM oc_product
WHERE
model = '100773599'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3456,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.