Product Sync.
Opencart products: 249
Input products: 100
NEW: 102131199
NEW: 102131299
NEW: 102131399
NEW: 102131499
NEW: 102131599
NEW: 102131699
NEW: 102131799
NEW: 102131899
NEW: 102131999
NEW: 102132099
NEW: 102132199
NEW: 102132299
NEW: 102132399
NEW: 102132499
NEW: 102132599
NEW: 102132699
NEW: 102132799
NEW: 102132899
NEW: 102132999
NEW: 102133099
NEW: 102133199
NEW: 102133299
NEW: 102133399
NEW: 102133499
NEW: 102133599
NEW: 102133699
NEW: 102133799
NEW: 102133899
NEW: 102133999
NEW: 102134099
NEW: 102134199
NEW: 102134299
NEW: 102134399
NEW: 102134499
NEW: 102134599
NEW: 102134699
NEW: 102134799
NEW: 102134899
NEW: 102134999
NEW: 102135099
NEW: 102135199
NEW: 102135299
NEW: 102135399
NEW: 102135499
NEW: 102135599
NEW: 102135699
NEW: 102135799
NEW: 102135899
NEW: 102135999
NEW: 102136099
NEW: 102136199
NEW: 102136299
NEW: 102136399
NEW: 102136499
NEW: 102136599
NEW: 102136699
NEW: 102136799
NEW: 102136899
NEW: 102136999
NEW: 102137099
NEW: 102137199
NEW: 102137299
NEW: 102137399
NEW: 102137499
NEW: 102137599
NEW: 102137699
NEW: 102137799
NEW: 102137899
NEW: 102137999
NEW: 102138099
NEW: 102138199
NEW: 102138299
NEW: 102138399
NEW: 102138499
NEW: 102138599
NEW: 102138699
NEW: 102138799
NEW: 102138899
NEW: 102138999
NEW: 102139099
NEW: 102139199
NEW: 102139299
NEW: 102139399
NEW: 102139499
NEW: 102139599
NEW: 102139699
NEW: 102139799
NEW: 102139899
NEW: 102139999
NEW: 102140099
NEW: 102140199
NEW: 102140299
NEW: 102140399
NEW: 102140499
NEW: 102140599
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27030
Image file:
NEW: 102141099
Ok.
Product Option Sync.
Opencart products: 249
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 '102140699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2615
UPDATE oc_option_value_description
SET
name = '102140699 - Setacolor Opaco Lilás'
WHERE
option_value_id = 2615
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 = 2615
DELETE FROM oc_product
WHERE
model = '102140699'
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 = 2615
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102140799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2616
UPDATE oc_option_value_description
SET
name = '102140799 - Setacolor Opaco Azul Céu'
WHERE
option_value_id = 2616
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 = 2616
DELETE FROM oc_product
WHERE
model = '102140799'
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 = 2616
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102140899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2617
UPDATE oc_option_value_description
SET
name = '102140899 - Setacolor Opaco Bege'
WHERE
option_value_id = 2617
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 = 2617
DELETE FROM oc_product
WHERE
model = '102140899'
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 = 2617
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102140999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2618
UPDATE oc_option_value_description
SET
name = '102140999 - Setacolor Opaco Brilho Marfim'
WHERE
option_value_id = 2618
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 = 2618
DELETE FROM oc_product
WHERE
model = '102140999'
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 = 2618
Ok.