Product Sync.
Opencart products: 310
Input products: 100
NEW: 498527799
NEW: 498527899
NEW: 498533399
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27455
Image file:
NEW: 498536299
NEW: 498536399
NEW: 498536499
NEW: 498536599
NEW: 498536699
NEW: 498536799
NEW: 498536899
NEW: 498537099
NEW: 498537199
NEW: 498537299
NEW: 498537399
NEW: 498537499
NEW: 498537599
NEW: 498537699
NEW: 498537799
NEW: 498537899
NEW: 498537999
NEW: 498538099
NEW: 498538199
NEW: 498538299
NEW: 498538499
NEW: 498538599
NEW: 498538699
NEW: 498538799
NEW: 498538899
NEW: 498538999
NEW: 498539099
NEW: 498539199
NEW: 498539299
NEW: 498539399
NEW: 498539499
NEW: 498539699
NEW: 498539799
NEW: 498539899
NEW: 498539999
NEW: 498540099
NEW: 498540199
NEW: 498540299
NEW: 498540399
NEW: 498540499
NEW: 498540599
NEW: 498540899
NEW: 498540999
NEW: 498541099
NEW: 498541199
NEW: 498541299
NEW: 498541399
NEW: 498541499
NEW: 498542099
NEW: 498549799
NEW: 498550699
NEW: 498550799
NEW: 498550899
NEW: 498550999
NEW: 498551099
NEW: 498551299
NEW: 498551399
NEW: 498551599
NEW: 498551799
NEW: 498551899
NEW: 498551999
NEW: 498552099
NEW: 498552199
NEW: 498552299
NEW: 498552399
NEW: 498552499
NEW: 498552599
NEW: 498552699
NEW: 498552799
NEW: 498552899
NEW: 498552999
NEW: 498553099
NEW: 498553199
NEW: 498553299
NEW: 498553499
NEW: 498553599
NEW: 498553699
NEW: 498553799
NEW: 498553899
NEW: 498553999
NEW: 498554099
NEW: 498554199
NEW: 498554299
NEW: 498554599
NEW: 498554699
NEW: 498554799
NEW: 498554999
NEW: 498555199
NEW: 498555399
NEW: 498555499
Ok.
Product Option Sync.
Opencart products: 310
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 '498536199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3978 AS option_value_id,
language_id,
17 AS option_id,
'498536199 - Setacolor Opaco Verde Folha' 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 = 3978
DELETE FROM oc_product
WHERE
model = '498536199'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3978,
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 '498536999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3979 AS option_value_id,
language_id,
17 AS option_id,
'498536999 - Setacolor Opaco Verde Pérola' 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 = 3979
DELETE FROM oc_product
WHERE
model = '498536999'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3979,
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 '498551199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3980 AS option_value_id,
language_id,
17 AS option_id,
'498551199 - Setacolor Opaco Cinza' 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 = 3980
DELETE FROM oc_product
WHERE
model = '498551199'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3980,
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 '498551499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3981 AS option_value_id,
language_id,
17 AS option_id,
'498551499 - Setacolor Opaco Azul Turquesa Brilho' 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 = 3981
DELETE FROM oc_product
WHERE
model = '498551499'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3981,
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 '498551699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3982 AS option_value_id,
language_id,
17 AS option_id,
'498551699 - Setacolor Opaco Ouro Pérola' 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 = 3982
DELETE FROM oc_product
WHERE
model = '498551699'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3982,
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 '498553399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3983 AS option_value_id,
language_id,
17 AS option_id,
'498553399 - Setacolor Opaco Verde Clorofila' 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 = 3983
DELETE FROM oc_product
WHERE
model = '498553399'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3983,
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 '498554399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3984 AS option_value_id,
language_id,
17 AS option_id,
'498554399 - Setacolor Opaco Verde Azeitona' 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 = 3984
DELETE FROM oc_product
WHERE
model = '498554399'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3984,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.