Product Sync.
Opencart products: 49
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: 27436
Image file:
NEW: 100309399
NEW: 100309499
NEW: 100309599
NEW: 100309699
NEW: 100309799
NEW: 100309899
NEW: 100309999
NEW: 100310099
NEW: 100310199
NEW: Tinta para Porcelana Pébéo Porcelaine
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta para Porcelana Pébéo Porcelaine - %'
)
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: 50
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 = 27436
AND option_id = 17
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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1742
DELETE FROM oc_product
WHERE
model = '100308399'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1742,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1743
DELETE FROM oc_product
WHERE
model = '100308499'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1743,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1744
DELETE FROM oc_product
WHERE
model = '100308599'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1744,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1745
DELETE FROM oc_product
WHERE
model = '100308699'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1745,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1746
DELETE FROM oc_product
WHERE
model = '100308799'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1746,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1747
DELETE FROM oc_product
WHERE
model = '100308899'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1747,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1748
DELETE FROM oc_product
WHERE
model = '100308999'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1748,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1749
DELETE FROM oc_product
WHERE
model = '100309099'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1749,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1750
DELETE FROM oc_product
WHERE
model = '100309199'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1750,
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 '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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1751
DELETE FROM oc_product
WHERE
model = '100309299'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1751,
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 = 27447
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27447,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100310299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3270 AS option_value_id,
language_id,
17 AS option_id,
'100310299 - Tinta Pébéo Porcelaine 150 45 ml Azul Safira' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 426
AND product_id = 27447
AND option_id = 17
AND option_value_id = 3270
DELETE FROM oc_product
WHERE
model = '100310299'
INSERT INTO oc_product_option_value
SET
product_option_id = 426,
product_id = 27447,
option_id = 17,
option_value_id = 3270,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.