Product Sync.
Opencart products: 112
Input products: 100
NEW: 101333299
NEW: 101333399
NEW: 101333499
NEW: 101333599
NEW: 101333699
NEW: 101333799
NEW: 101333899
NEW: 101333999
NEW: 101334099
NEW: 101334199
NEW: 101334299
NEW: 101334399
NEW: 101334499
NEW: 101334599
NEW: 101334699
NEW: 101334799
NEW: 101334899
NEW: 101334999
NEW: 101335099
NEW: 101335199
NEW: 101335299
NEW: 101335399
NEW: 101335499
NEW: 101335599
NEW: 101335699
NEW: 101335799
NEW: 101335899
NEW: 101335999
NEW: Guache Giotto Pintura a Dedos 750 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 Pintura a Dedos 750 ml - %'
)
NEW: 101336399
NEW: 101336499
NEW: 101336599
NEW: 101336699
NEW: 101336799
NEW: 101336899
NEW: 101336999
NEW: 101337099
NEW: 101337199
NEW: 101337299
NEW: 101337399
NEW: 101337499
NEW: 101337599
NEW: 101337699
NEW: 101337799
NEW: 101337899
NEW: 101337999
NEW: 101338099
NEW: 101338199
NEW: 101338299
NEW: 101338399
NEW: 101338499
NEW: 101338599
NEW: 101338699
NEW: 101338799
NEW: 101338899
NEW: 101338999
NEW: 101339099
NEW: 101339199
NEW: 101339299
NEW: 101339399
NEW: 101339499
NEW: 101339599
NEW: 101339699
NEW: 101339799
NEW: 101339899
NEW: 101339999
NEW: 101340099
NEW: 101340199
NEW: 101340299
NEW: 101340399
NEW: 101340499
NEW: 101340599
NEW: 101340699
UPDATING: Tinta da China Winsor & Newton
Product ID: 27479
Image file:
NEW: 101340899
NEW: 101340999
NEW: 101341099
NEW: 101341199
NEW: 101341299
NEW: 101341399
NEW: 101341499
NEW: 101341599
NEW: 101341699
NEW: 101341799
NEW: 101341899
NEW: 101341999
NEW: 101342099
NEW: 101342199
NEW: 101342299
NEW: 101342399
NEW: 101342499
NEW: 101342599
NEW: 101342699
NEW: 101342799
NEW: 101342899
NEW: 101342999
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27452
Image file:
UPDATING: Tinta Acrílica Winsor & Newton 500 ml
Product ID: 27507
Image file:
Ok.
Product Option Sync.
Opencart products: 113
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 = 27510
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27510,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101336099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3532 AS option_value_id,
language_id,
17 AS option_id,
'101336099 - Guache Pintura a Dedos Giotto 750 ml Azul Cyan' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3532
DELETE FROM oc_product
WHERE
model = '101336099'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3532,
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 '101336199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3533 AS option_value_id,
language_id,
17 AS option_id,
'101336199 - Guache Pintura a Dedos Giotto 750 ml Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3533
DELETE FROM oc_product
WHERE
model = '101336199'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3533,
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 '101336299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3534 AS option_value_id,
language_id,
17 AS option_id,
'101336299 - Guache Pintura a Dedos Giotto 750 ml Amarelo Primário' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3534
DELETE FROM oc_product
WHERE
model = '101336299'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3534,
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 = 27479
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101340799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3535 AS option_value_id,
language_id,
17 AS option_id,
'101340799 - Tinta da China Winsor & Newton Terra Sienna Queimada 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3535
DELETE FROM oc_product
WHERE
model = '101340799'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3535,
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 = 27452
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101343099 - %'
UPDATE oc_option_value
SET
image = 'catalog/101343099.jpg'
WHERE
option_value_id = 1574
UPDATE oc_option_value_description
SET
name = '101343099 - Acrílico Winsor & Newton Galeria 250 ml Preto Marfim (331)'
WHERE
option_value_id = 1574
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1574
DELETE FROM oc_product
WHERE
model = '101343099'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1574,
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 = 27507
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101343199 - %'
UPDATE oc_option_value
SET
image = 'catalog/101343199.jpg'
WHERE
option_value_id = 1575
UPDATE oc_option_value_description
SET
name = '101343199 - Acrílico Winsor & Newton Galeria 500 ml Vermelhão HUE (682)'
WHERE
option_value_id = 1575
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 468
AND product_id = 27507
AND option_id = 17
AND option_value_id = 1575
DELETE FROM oc_product
WHERE
model = '101343199'
INSERT INTO oc_product_option_value
SET
product_option_id = 468,
product_id = 27507,
option_id = 17,
option_value_id = 1575,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.