Product Sync.
Opencart products: 390
Input products: 100
NEW: 498527799
NEW: 498527899
NEW: 498533399
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27030
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: 390
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 '498536199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2995
UPDATE oc_option_value_description
SET
name = '498536199 - Setacolor Opaco Verde Folha'
WHERE
option_value_id = 2995
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 = 2995
DELETE FROM oc_product
WHERE
model = '498536199'
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 = 2995
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498536999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2996
UPDATE oc_option_value_description
SET
name = '498536999 - Setacolor Opaco Verde Pérola'
WHERE
option_value_id = 2996
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 = 2996
DELETE FROM oc_product
WHERE
model = '498536999'
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 = 2996
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498551199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2997
UPDATE oc_option_value_description
SET
name = '498551199 - Setacolor Opaco Cinza'
WHERE
option_value_id = 2997
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 = 2997
DELETE FROM oc_product
WHERE
model = '498551199'
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 = 2997
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498551499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2998
UPDATE oc_option_value_description
SET
name = '498551499 - Setacolor Opaco Azul Turquesa Brilho'
WHERE
option_value_id = 2998
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 = 2998
DELETE FROM oc_product
WHERE
model = '498551499'
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 = 2998
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498551699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2999
UPDATE oc_option_value_description
SET
name = '498551699 - Setacolor Opaco Ouro Pérola'
WHERE
option_value_id = 2999
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 = 2999
DELETE FROM oc_product
WHERE
model = '498551699'
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 = 2999
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498553399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 3000
UPDATE oc_option_value_description
SET
name = '498553399 - Setacolor Opaco Verde Clorofila'
WHERE
option_value_id = 3000
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 = 3000
DELETE FROM oc_product
WHERE
model = '498553399'
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 = 3000
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '498554399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 3001
UPDATE oc_option_value_description
SET
name = '498554399 - Setacolor Opaco Verde Azeitona'
WHERE
option_value_id = 3001
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 = 3001
DELETE FROM oc_product
WHERE
model = '498554399'
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 = 3001
Ok.