Product Sync.
Opencart products: 12
Input products: 100
NEW: 100030399
NEW: 100030499
NEW: 100030599
NEW: 100030699
NEW: 100030799
NEW: 100030899
NEW: 100030999
NEW: 100031099
NEW: 100031199
NEW: 100031299
NEW: 100031399
NEW: 100031499
NEW: 100031599
NEW: 100031699
NEW: 100031799
NEW: Aguarela Escolar Giotto
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Aguarela Escolar Giotto - %'
)
NEW: 100032099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100032099 - %'
)
NEW: 100032199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100032199 - %'
)
UPDATING: 100032299
Product ID: 27123
Image file:
NEW: 100032399
NEW: 100032499
NEW: 100032599
NEW: 100032699
NEW: 100032799
NEW: Guache Giotto Frasco 250 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Guache Giotto Frasco 250 ml - %'
)
NEW: 100034699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100034699 - %'
)
NEW: 100034799
NEW: 100034899
NEW: 100034999
NEW: 100035099
NEW: 100035199
NEW: 100035299
NEW: 100035399
NEW: 100035499
NEW: 100035599
NEW: 100035699
NEW: 100035799
NEW: 100035899
NEW: 100035999
NEW: 100036099
NEW: 100036199
NEW: 100036299
NEW: 100036399
NEW: 100036499
NEW: 100036599
NEW: 100036699
NEW: 100036799
NEW: 100036899
NEW: 100036999
NEW: 100037099
NEW: 100037199
NEW: 100037299
NEW: 100037399
NEW: 100037499
NEW: 100037599
NEW: 100037699
NEW: 100037799
NEW: 100037899
NEW: 100037999
NEW: 100038099
NEW: 100038199
NEW: 100038299
NEW: 100038399
NEW: 100038499
NEW: 100038599
NEW: 100038699
NEW: 100038799
NEW: 100038899
NEW: 100038999
NEW: 100039099
NEW: 100039199
NEW: 100039299
NEW: 100039399
NEW: 100039499
NEW: 100039599
NEW: 100039699
NEW: 100039799
NEW: 100039899
NEW: 100039999
NEW: 100040099
NEW: 100040199
NEW: 100040299
Ok.
Product Option Sync.
Opencart products: 17
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 = 27410
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27410,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100031899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1713
UPDATE oc_option_value_description
SET
name = '100031899 - Aguarela Giotto com 12'
WHERE
option_value_id = 1713
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 401
AND product_id = 27410
AND option_id = 17
AND option_value_id = 1713
DELETE FROM oc_product
WHERE
model = '100031899'
INSERT INTO oc_product_option_value
SET
product_option_id = 401,
product_id = 27410,
option_id = 17,
option_value_id = 1713,
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 '100031999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1714
UPDATE oc_option_value_description
SET
name = '100031999 - Aguarela Giotto com 24'
WHERE
option_value_id = 1714
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 401
AND product_id = 27410
AND option_id = 17
AND option_value_id = 1714
DELETE FROM oc_product
WHERE
model = '100031999'
INSERT INTO oc_product_option_value
SET
product_option_id = 401,
product_id = 27410,
option_id = 17,
option_value_id = 1714,
quantity = 1,
subtract = 1,
price = 2.601,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27413
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27413,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100032899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1715
UPDATE oc_option_value_description
SET
name = '100032899 - Guache Giotto Fluorescente 250 ml Amarelo'
WHERE
option_value_id = 1715
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1715
DELETE FROM oc_product
WHERE
model = '100032899'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1715,
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 '100032999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1716
UPDATE oc_option_value_description
SET
name = '100032999 - Guache Giotto Fluorescente 250 ml Verde'
WHERE
option_value_id = 1716
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1716
DELETE FROM oc_product
WHERE
model = '100032999'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1716,
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 '100033099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1717
UPDATE oc_option_value_description
SET
name = '100033099 - Guache Giotto Fluorescente 250 ml Laranja'
WHERE
option_value_id = 1717
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1717
DELETE FROM oc_product
WHERE
model = '100033099'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1717,
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 '100033199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1718
UPDATE oc_option_value_description
SET
name = '100033199 - Guache Giotto Fluorescente 250 ml Rosa'
WHERE
option_value_id = 1718
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1718
DELETE FROM oc_product
WHERE
model = '100033199'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1718,
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 '100033299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1719
UPDATE oc_option_value_description
SET
name = '100033299 - Guache Giotto Fluorescente 250 ml Ouro'
WHERE
option_value_id = 1719
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1719
DELETE FROM oc_product
WHERE
model = '100033299'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1719,
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 '100033399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1720
UPDATE oc_option_value_description
SET
name = '100033399 - Guache Giotto Glitter 250 ml Prata'
WHERE
option_value_id = 1720
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1720
DELETE FROM oc_product
WHERE
model = '100033399'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1720,
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 '100033499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1721
UPDATE oc_option_value_description
SET
name = '100033499 - Guache Giotto Fluorescente 250 ml Magenta'
WHERE
option_value_id = 1721
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1721
DELETE FROM oc_product
WHERE
model = '100033499'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1721,
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 '100033599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1722
UPDATE oc_option_value_description
SET
name = '100033599 - Guache Giotto Fluorescente 250 ml Azul'
WHERE
option_value_id = 1722
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1722
DELETE FROM oc_product
WHERE
model = '100033599'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1722,
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 '100033699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1723
UPDATE oc_option_value_description
SET
name = '100033699 - Guache Giotto Fluorescente 250 ml Verde'
WHERE
option_value_id = 1723
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1723
DELETE FROM oc_product
WHERE
model = '100033699'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1723,
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 '100033799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1724
UPDATE oc_option_value_description
SET
name = '100033799 - Guache Giotto Fluorescente 250 ml Vermelho'
WHERE
option_value_id = 1724
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1724
DELETE FROM oc_product
WHERE
model = '100033799'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1724,
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 '100033899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1725
UPDATE oc_option_value_description
SET
name = '100033899 - Guache Giotto Fluorescente 250 ml Bronze'
WHERE
option_value_id = 1725
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1725
DELETE FROM oc_product
WHERE
model = '100033899'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1725,
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 '100033999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1726
UPDATE oc_option_value_description
SET
name = '100033999 - Guache Giotto Fluorescente 250 ml Azul Escuro'
WHERE
option_value_id = 1726
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1726
DELETE FROM oc_product
WHERE
model = '100033999'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1726,
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 '100034099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1727
UPDATE oc_option_value_description
SET
name = '100034099 - Guache Giotto Metal 250 ml Ouro'
WHERE
option_value_id = 1727
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1727
DELETE FROM oc_product
WHERE
model = '100034099'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1727,
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 '100034199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1728
UPDATE oc_option_value_description
SET
name = '100034199 - Guache Giotto Metal 250 ml Prata'
WHERE
option_value_id = 1728
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1728
DELETE FROM oc_product
WHERE
model = '100034199'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1728,
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 '100034299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3236 AS option_value_id,
language_id,
17 AS option_id,
'100034299 - Guache Giotto Metal 250 ml Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 3236
DELETE FROM oc_product
WHERE
model = '100034299'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 3236,
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 '100034399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3237 AS option_value_id,
language_id,
17 AS option_id,
'100034399 - Guache Giotto Metal 250 ml Magenta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 3237
DELETE FROM oc_product
WHERE
model = '100034399'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 3237,
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 '100034499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1729
UPDATE oc_option_value_description
SET
name = '100034499 - Guache Giotto 250 ml Verde Pérola'
WHERE
option_value_id = 1729
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1729
DELETE FROM oc_product
WHERE
model = '100034499'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1729,
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 '100034599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3238 AS option_value_id,
language_id,
17 AS option_id,
'100034599 - Guache Giotto 250 ml Azul Pérola' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 3238
DELETE FROM oc_product
WHERE
model = '100034599'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 3238,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.