Product Sync.
Opencart products: 163
Input products: 100
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27455
Image file:
NEW: 102141499
NEW: 102141599
NEW: 102141699
NEW: 102141799
NEW: 102141899
NEW: 102141999
NEW: 102142099
NEW: Secante Pébéo para Óleo Courtrai
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Secante Pébéo para Óleo Courtrai - %'
)
NEW: 102142299
NEW: 102142399
NEW: 102142499
NEW: 102142599
NEW: 102142699
NEW: 102142799
NEW: 102142899
NEW: 102142999
NEW: 102143099
NEW: 102143199
NEW: 102143299
NEW: 102143399
NEW: 102143499
NEW: 102143599
NEW: 102143699
NEW: 102143799
NEW: 102143899
NEW: 102143999
NEW: 102144099
NEW: 102144199
NEW: 102144299
NEW: 102144399
NEW: 102144499
NEW: 102144599
NEW: 102144699
NEW: 102144799
NEW: 102144899
NEW: 102144999
NEW: 102145099
NEW: 102145199
NEW: 102145299
NEW: 102145399
NEW: 102145499
NEW: 102145599
NEW: 102145699
NEW: 102145799
NEW: 102145899
NEW: 102145999
NEW: 102146099
NEW: 102146199
NEW: 102146299
NEW: 102146399
NEW: 102146499
NEW: 102146599
NEW: 102146699
NEW: 102146799
NEW: 102146899
NEW: 102146999
NEW: 102147099
NEW: 102147199
NEW: 102147299
NEW: 102147399
NEW: 102147499
NEW: 102147599
NEW: 102147699
NEW: 102147799
NEW: 102147899
NEW: 102147999
NEW: 102148099
NEW: 102148199
NEW: 102148299
NEW: 102148399
NEW: 102148499
NEW: 102148599
NEW: 102148699
NEW: 102148799
NEW: 102148899
NEW: 102148999
NEW: 102149099
NEW: 102149199
NEW: 102149299
NEW: 102149399
NEW: 102149499
NEW: 102149599
NEW: 102149699
NEW: 102149799
NEW: 102149899
NEW: 102149999
NEW: 102150099
NEW: 102150199
NEW: 102150299
NEW: 102150399
NEW: 102150499
NEW: 102150599
NEW: 102150699
NEW: 102150799
NEW: 102150899
NEW: 102150999
NEW: 102151099
NEW: 102151199
Ok.
Product Option Sync.
Opencart products: 164
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 '102141299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3672 AS option_value_id,
language_id,
17 AS option_id,
'102141299 - Setacolor Opaco Vermelho Paixão Brilhante' 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 = 3672
DELETE FROM oc_product
WHERE
model = '102141299'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3672,
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 '102141399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3673 AS option_value_id,
language_id,
17 AS option_id,
'102141399 - Setacolor Opaco Ouro Rico Brilhante' 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 = 3673
DELETE FROM oc_product
WHERE
model = '102141399'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3673,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27561
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27561,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102142199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3674 AS option_value_id,
language_id,
17 AS option_id,
'102142199 - Secante Pébéo para Óleo Courtrai 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 496
AND product_id = 27561
AND option_id = 17
AND option_value_id = 3674
DELETE FROM oc_product
WHERE
model = '102142199'
INSERT INTO oc_product_option_value
SET
product_option_id = 496,
product_id = 27561,
option_id = 17,
option_value_id = 3674,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.