Product Sync.
Opencart products: 37
Input products: 100
NEW: 100212199
NEW: 100212299
NEW: 100212399
NEW: 100212499
NEW: 100212599
NEW: 100212699
NEW: 100212799
NEW: 100212899
NEW: 100212999
NEW: 100213099
NEW: 100213199
NEW: 100213299
NEW: 100213399
NEW: 100213499
NEW: 100213599
NEW: 100213699
NEW: 100213799
NEW: 100213899
NEW: 100213999
NEW: 100214099
NEW: 100214199
NEW: 100214299
NEW: 100214399
NEW: 100214499
NEW: 100214599
NEW: 100214699
NEW: 100214799
NEW: 100214899
NEW: 100214999
NEW: 100215099
NEW: 100215199
NEW: 100215299
NEW: 100215399
NEW: 100215499
NEW: 100215599
NEW: 100215699
NEW: 100215799
NEW: 100215899
NEW: 100215999
NEW: Guache Giotto Caixa
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 Caixa - %'
)
NEW: 100216199
NEW: 100216299
NEW: 100216399
NEW: 100216499
NEW: 100216599
NEW: 100216699
NEW: 100216799
NEW: 100216899
NEW: 100216999
NEW: 100217099
NEW: 100217199
NEW: 100217299
NEW: 100217399
NEW: 100217499
NEW: 100217599
NEW: 100217699
NEW: Guache Giotto 500 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 500 ml - %'
)
NEW: 100218099
NEW: Guache Giotto 1000 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 1000 ml - %'
)
NEW: 100218999
NEW: 100219099
NEW: Guache Giotto Bebé 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 Bebé 250 ml - %'
)
UPDATING: Guache Giotto Frasco 250 ml
Product ID: 27413
Image file:
NEW: 100219699
NEW: 100219899
NEW: 100219999
NEW: 100220099
NEW: 100220199
NEW: 100220299
NEW: 100220399
NEW: 100220499
NEW: 100220599
NEW: 100220699
NEW: 100220799
NEW: 100220899
NEW: 100220999
NEW: 100221099
NEW: 100221199
NEW: 100221299
NEW: 100221399
NEW: 100221499
NEW: 100221599
NEW: 100221699
NEW: 100221799
NEW: 100221899
NEW: 100221999
NEW: 100222099
Ok.
Product Option Sync.
Opencart products: 41
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 = 27435
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27435,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100216099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1734
UPDATE oc_option_value_description
SET
name = '100216099 - Guache Giotto com 6'
WHERE
option_value_id = 1734
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 416
AND product_id = 27435
AND option_id = 17
AND option_value_id = 1734
DELETE FROM oc_product
WHERE
model = '100216099'
INSERT INTO oc_product_option_value
SET
product_option_id = 416,
product_id = 27435,
option_id = 17,
option_value_id = 1734,
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 = 27436
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27436,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100217799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1564
UPDATE oc_option_value_description
SET
name = '100217799 - Guache Acrílico Giotto 500 ml Azul Cyan'
WHERE
option_value_id = 1564
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 = 1564
DELETE FROM oc_product
WHERE
model = '100217799'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1564,
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 '100217899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1565
UPDATE oc_option_value_description
SET
name = '100217899 - Guache Acrílico Giotto 500 ml Magenta'
WHERE
option_value_id = 1565
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 = 1565
DELETE FROM oc_product
WHERE
model = '100217899'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1565,
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 '100217999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1566
UPDATE oc_option_value_description
SET
name = '100217999 - Guache Acrílico Giotto 500 ml Castanho'
WHERE
option_value_id = 1566
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 = 1566
DELETE FROM oc_product
WHERE
model = '100217999'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1566,
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 '100218199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1568
UPDATE oc_option_value_description
SET
name = '100218199 - Guache Acrílico Giotto 500 ml Preto'
WHERE
option_value_id = 1568
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 = 1568
DELETE FROM oc_product
WHERE
model = '100218199'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1568,
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 '100218299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1571
UPDATE oc_option_value_description
SET
name = '100218299 - Guache Acrílico Giotto 500 ml Branco'
WHERE
option_value_id = 1571
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 = 1571
DELETE FROM oc_product
WHERE
model = '100218299'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1571,
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 '100218399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1572
UPDATE oc_option_value_description
SET
name = '100218399 - Guache Acrílico Giotto 500 ml Amarelo'
WHERE
option_value_id = 1572
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 = 1572
DELETE FROM oc_product
WHERE
model = '100218399'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1572,
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 '100218499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1573
UPDATE oc_option_value_description
SET
name = '100218499 - Guache Acrílico Giotto 500 ml Verde'
WHERE
option_value_id = 1573
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 = 1573
DELETE FROM oc_product
WHERE
model = '100218499'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1573,
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 = 27437
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27437,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100218599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3254 AS option_value_id,
language_id,
17 AS option_id,
'100218599 - Guache Giotto 1000 ml Magenta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3254
DELETE FROM oc_product
WHERE
model = '100218599'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3254,
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 '100218699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3255 AS option_value_id,
language_id,
17 AS option_id,
'100218699 - Guache Giotto 1000 ml Azul Ultramarino' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3255
DELETE FROM oc_product
WHERE
model = '100218699'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3255,
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 '100218799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3256 AS option_value_id,
language_id,
17 AS option_id,
'100218799 - Guache Giotto 1000 ml Laranja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3256
DELETE FROM oc_product
WHERE
model = '100218799'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3256,
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 '100218899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3257 AS option_value_id,
language_id,
17 AS option_id,
'100218899 - Guache Giotto 1000 ml Violeta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3257
DELETE FROM oc_product
WHERE
model = '100218899'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3257,
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 = 27438
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27438,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100219199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3258 AS option_value_id,
language_id,
17 AS option_id,
'100219199 - Guache Giotto Bebé 250 ml Castanho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3258
DELETE FROM oc_product
WHERE
model = '100219199'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3258,
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 '100219299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3259 AS option_value_id,
language_id,
17 AS option_id,
'100219299 - Guache Giotto Bebé 250 ml Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3259
DELETE FROM oc_product
WHERE
model = '100219299'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3259,
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 '100219399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3260 AS option_value_id,
language_id,
17 AS option_id,
'100219399 - Guache Giotto Bebé 250 ml Azul Cyan' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 419
AND product_id = 27438
AND option_id = 17
AND option_value_id = 3260
DELETE FROM oc_product
WHERE
model = '100219399'
INSERT INTO oc_product_option_value
SET
product_option_id = 419,
product_id = 27438,
option_id = 17,
option_value_id = 3260,
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 = 27413
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100219499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1735
UPDATE oc_option_value_description
SET
name = '100219499 - Guache Acrilico Giotto 250 ml Prata'
WHERE
option_value_id = 1735
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 = 1735
DELETE FROM oc_product
WHERE
model = '100219499'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1735,
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 '100219599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1736
UPDATE oc_option_value_description
SET
name = '100219599 - Guache Acrilico Giotto 250 ml Magenta'
WHERE
option_value_id = 1736
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 = 1736
DELETE FROM oc_product
WHERE
model = '100219599'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1736,
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 '100219799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1737
UPDATE oc_option_value_description
SET
name = '100219799 - Guache Giotto 250 ml Ouro Pérola'
WHERE
option_value_id = 1737
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 = 1737
DELETE FROM oc_product
WHERE
model = '100219799'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1737,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.