Product Sync.
Opencart products: 249
Input products: 100
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27030
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: 250
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 = 27030
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102141299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2619
UPDATE oc_option_value_description
SET
name = '102141299 - Setacolor Opaco Vermelho Paixão Brilhante'
WHERE
option_value_id = 2619
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2619
DELETE FROM oc_product
WHERE
model = '102141299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2619
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102141399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2620
UPDATE oc_option_value_description
SET
name = '102141399 - Setacolor Opaco Ouro Rico Brilhante'
WHERE
option_value_id = 2620
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2620
DELETE FROM oc_product
WHERE
model = '102141399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2620
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27238
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27238,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102142199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2621
UPDATE oc_option_value_description
SET
name = '102142199 - Secante Pébéo para Óleo Courtrai 75 ml'
WHERE
option_value_id = 2621
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 335
AND product_id = 27238
AND option_id = 15
AND option_value_id = 2621
DELETE FROM oc_product
WHERE
model = '102142199'
INSERT INTO oc_product_option_value
SET
product_option_id = 335,
product_id = 27238,
option_id = 15,
option_value_id = 2621,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.