Product Sync.
Opencart products: 126
Input products: 100
NEW: 101615999
NEW: 101616099
NEW: 101616199
NEW: 101616299
NEW: 101616399
NEW: 101616499
NEW: 101616599
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27455
Image file:
NEW: 101616999
NEW: 101617099
NEW: 101617199
NEW: 101617299
NEW: 101617399
NEW: 101617499
NEW: 101617599
NEW: 101617699
NEW: 101617799
NEW: 101617899
NEW: 101617999
NEW: 101618099
NEW: 101618199
NEW: 101618299
NEW: 101618399
NEW: 101618499
NEW: 101618599
NEW: 101618699
NEW: 101618799
NEW: 101618899
NEW: 101618999
NEW: 101619099
NEW: 101619199
NEW: 101619299
NEW: 101619399
NEW: 101619499
NEW: 101619599
NEW: 101619699
NEW: 101619799
NEW: 101619899
NEW: 101619999
NEW: 101620099
NEW: 101620199
NEW: 101620299
NEW: 101620399
NEW: 101620499
NEW: 101620599
NEW: 101620699
NEW: 101620799
NEW: 101620899
NEW: 101620999
NEW: 101621099
NEW: 101621199
NEW: 101621299
NEW: 101621399
NEW: 101621499
NEW: 101621599
NEW: 101621699
NEW: 101621799
NEW: 101621899
NEW: 101621999
NEW: 101622099
NEW: 101622199
NEW: 101622299
NEW: 101622399
NEW: 101622499
NEW: 101622599
NEW: 101622699
NEW: 101622799
NEW: 101622899
NEW: 101622999
NEW: 101623099
NEW: 101623199
NEW: 101623299
NEW: 101623399
NEW: 101623499
NEW: 101623599
NEW: 101623699
NEW: 101623799
NEW: 101623899
NEW: 101623999
NEW: 101624099
NEW: 101624199
NEW: 101624299
NEW: 101624399
NEW: 101624499
NEW: 101624599
NEW: 101624699
NEW: 101624799
NEW: 101624899
NEW: 101624999
NEW: 101625099
NEW: 101625199
NEW: 101625299
NEW: 101625399
NEW: 101625499
NEW: 101625599
NEW: 101625699
NEW: 101625799
NEW: 101625899
Ok.
Product Option Sync.
Opencart products: 126
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 '101616699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3555 AS option_value_id,
language_id,
17 AS option_id,
'101616699 - Setacolor Opaco Framboesa' 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 = 3555
DELETE FROM oc_product
WHERE
model = '101616699'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3555,
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 '101616799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3556 AS option_value_id,
language_id,
17 AS option_id,
'101616799 - Setacolor Opaco Chocolate' 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 = 3556
DELETE FROM oc_product
WHERE
model = '101616799'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3556,
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 '101616899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3557 AS option_value_id,
language_id,
17 AS option_id,
'101616899 - Setacolor Opaco Rosa Claro' 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 = 3557
DELETE FROM oc_product
WHERE
model = '101616899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3557,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.