Product Sync.
Opencart products: 157
Input products: 100
NEW: 100303199
NEW: 100303299
NEW: 100303399
NEW: 100303499
NEW: 100303599
NEW: 100303699
NEW: 100303799
NEW: 100303899
NEW: 100303999
NEW: 100304099
NEW: 100304199
NEW: 100304299
NEW: 100304399
NEW: 100304499
NEW: 100304599
NEW: 100304699
NEW: 100304799
NEW: 100304899
NEW: 100304999
NEW: 100305099
NEW: 100305199
NEW: 100305299
NEW: 100305399
NEW: 100305499
NEW: 100305599
NEW: 100305699
NEW: 100305799
NEW: 100305899
NEW: 100305999
NEW: 100306099
NEW: 100306199
NEW: 100306299
NEW: 100306399
NEW: 100306499
NEW: 100306599
NEW: 100306699
NEW: 100306799
NEW: 100306899
NEW: 100306999
NEW: 100307099
NEW: 100307199
NEW: 100307299
NEW: 100307399
NEW: 100307499
NEW: 100307599
NEW: 100307699
NEW: 100307799
NEW: 100307899
NEW: 100307999
NEW: 100308099
NEW: 100308199
NEW: 100308299
UPDATING: Guache Giotto 500 ml
Product ID: 27012
Image file:
NEW: 100309399
NEW: 100309499
NEW: 100309599
NEW: 100309699
NEW: 100309799
NEW: 100309899
NEW: 100309999
NEW: 100310099
NEW: 100310199
UPDATING: Tinta para Porcelana Pébéo Porcelaine
Product ID: 27023
Image file:
NEW: 100310399
NEW: 100310499
NEW: 100310599
NEW: 100310699
NEW: 100310799
NEW: 100310899
NEW: 100310999
NEW: 100311099
NEW: 100311199
NEW: 100311299
NEW: 100311399
NEW: 100311499
NEW: 100311599
NEW: 100311699
NEW: 100311799
NEW: 100311899
NEW: 100311999
NEW: 100312099
NEW: 100312199
NEW: 100312299
NEW: 100312399
NEW: 100312499
NEW: 100312599
NEW: 100312699
NEW: 100312799
NEW: 100312899
NEW: 100312999
NEW: 100313099
Ok.
Product Option Sync.
Opencart products: 157
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 = 27012
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1742
UPDATE oc_option_value_description
SET
name = '100308399 - Guache Giotto 500 ml Branco'
WHERE
option_value_id = 1742
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1742
DELETE FROM oc_product
WHERE
model = '100308399'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1742
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1743
UPDATE oc_option_value_description
SET
name = '100308499 - Guache Giotto 500 ml Azul Primário'
WHERE
option_value_id = 1743
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1743
DELETE FROM oc_product
WHERE
model = '100308499'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1743
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1744
UPDATE oc_option_value_description
SET
name = '100308599 - Guache Giotto 500 ml Amarelo Primário'
WHERE
option_value_id = 1744
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1744
DELETE FROM oc_product
WHERE
model = '100308599'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1744
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1745
UPDATE oc_option_value_description
SET
name = '100308699 - Guache Giotto 500 ml Verde Prado'
WHERE
option_value_id = 1745
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1745
DELETE FROM oc_product
WHERE
model = '100308699'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1745
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1746
UPDATE oc_option_value_description
SET
name = '100308799 - Guache Giotto 500 ml Laranja'
WHERE
option_value_id = 1746
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1746
DELETE FROM oc_product
WHERE
model = '100308799'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1746
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1747
UPDATE oc_option_value_description
SET
name = '100308899 - Guache Giotto 500 ml Verde'
WHERE
option_value_id = 1747
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1747
DELETE FROM oc_product
WHERE
model = '100308899'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1747
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100308999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1748
UPDATE oc_option_value_description
SET
name = '100308999 - Guache Giotto 500 ml Azul Ultramarino'
WHERE
option_value_id = 1748
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1748
DELETE FROM oc_product
WHERE
model = '100308999'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1748
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100309099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1749
UPDATE oc_option_value_description
SET
name = '100309099 - Guache Giotto 500 ml Castanho'
WHERE
option_value_id = 1749
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1749
DELETE FROM oc_product
WHERE
model = '100309099'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1749
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100309199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1750
UPDATE oc_option_value_description
SET
name = '100309199 - Guache Giotto 500 ml Amarelo Escuro'
WHERE
option_value_id = 1750
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1750
DELETE FROM oc_product
WHERE
model = '100309199'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1750
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100309299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1751
UPDATE oc_option_value_description
SET
name = '100309299 - Guache Giotto 500 ml Preto'
WHERE
option_value_id = 1751
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1751
DELETE FROM oc_product
WHERE
model = '100309299'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1751
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27023
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100310299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2180
UPDATE oc_option_value_description
SET
name = '100310299 - Tinta Pébéo Porcelaine 150 45 ml Azul Safira'
WHERE
option_value_id = 2180
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 91
AND product_id = 27023
AND option_id = 15
AND option_value_id = 2180
DELETE FROM oc_product
WHERE
model = '100310299'
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 = 91
AND product_id = 27023
AND option_id = 15
AND option_value_id = 2180
Ok.