Product Sync.
Opencart products: 163
Input products: 100
NEW: 102131199
NEW: 102131299
NEW: 102131399
NEW: 102131499
NEW: 102131599
NEW: 102131699
NEW: 102131799
NEW: 102131899
NEW: 102131999
NEW: 102132099
NEW: 102132199
NEW: 102132299
NEW: 102132399
NEW: 102132499
NEW: 102132599
NEW: 102132699
NEW: 102132799
NEW: 102132899
NEW: 102132999
NEW: 102133099
NEW: 102133199
NEW: 102133299
NEW: 102133399
NEW: 102133499
NEW: 102133599
NEW: 102133699
NEW: 102133799
NEW: 102133899
NEW: 102133999
NEW: 102134099
NEW: 102134199
NEW: 102134299
NEW: 102134399
NEW: 102134499
NEW: 102134599
NEW: 102134699
NEW: 102134799
NEW: 102134899
NEW: 102134999
NEW: 102135099
NEW: 102135199
NEW: 102135299
NEW: 102135399
NEW: 102135499
NEW: 102135599
NEW: 102135699
NEW: 102135799
NEW: 102135899
NEW: 102135999
NEW: 102136099
NEW: 102136199
NEW: 102136299
NEW: 102136399
NEW: 102136499
NEW: 102136599
NEW: 102136699
NEW: 102136799
NEW: 102136899
NEW: 102136999
NEW: 102137099
NEW: 102137199
NEW: 102137299
NEW: 102137399
NEW: 102137499
NEW: 102137599
NEW: 102137699
NEW: 102137799
NEW: 102137899
NEW: 102137999
NEW: 102138099
NEW: 102138199
NEW: 102138299
NEW: 102138399
NEW: 102138499
NEW: 102138599
NEW: 102138699
NEW: 102138799
NEW: 102138899
NEW: 102138999
NEW: 102139099
NEW: 102139199
NEW: 102139299
NEW: 102139399
NEW: 102139499
NEW: 102139599
NEW: 102139699
NEW: 102139799
NEW: 102139899
NEW: 102139999
NEW: 102140099
NEW: 102140199
NEW: 102140299
NEW: 102140399
NEW: 102140499
NEW: 102140599
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27455
Image file:
NEW: 102141099
Ok.
Product Option Sync.
Opencart products: 163
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 = 27455
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102140699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3668 AS option_value_id,
language_id,
17 AS option_id,
'102140699 - Setacolor Opaco Lilás' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3668
DELETE FROM oc_product
WHERE
model = '102140699'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3668,
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 '102140799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3669 AS option_value_id,
language_id,
17 AS option_id,
'102140799 - Setacolor Opaco Azul Céu' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3669
DELETE FROM oc_product
WHERE
model = '102140799'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3669,
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 '102140899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3670 AS option_value_id,
language_id,
17 AS option_id,
'102140899 - Setacolor Opaco Bege' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3670
DELETE FROM oc_product
WHERE
model = '102140899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3670,
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 '102140999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3671 AS option_value_id,
language_id,
17 AS option_id,
'102140999 - Setacolor Opaco Brilho Marfim' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3671
DELETE FROM oc_product
WHERE
model = '102140999'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3671,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.