Product Sync.
Opencart products: 234
Input products: 100
NEW: 280208099
NEW: 280208109
NEW: 280221900
NEW: 280224599
NEW: 282703176
NEW: 282705600
NEW: 282707599
NEW: 282707899
NEW: 282707999
NEW: 282708099
NEW: 283302600
NEW: 283321600
NEW: 283321700
NEW: 283322800
NEW: 283323800
NEW: 283345300
NEW: 283345600
NEW: 283349200
NEW: 283349300
NEW: 283351500
NEW: 283365700
NEW: 283366500
NEW: 283366600
NEW: 283378400
NEW: 283378500
NEW: 283381500
NEW: 283381700
NEW: 283382300
NEW: 283386200
NEW: 283386782
NEW: 283399499
NEW: 283447000
NEW: 283451600
NEW: 285301000
NEW: 285302000
NEW: 285631985
NEW: Terebentina Rectificada Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Terebentina Rectificada Talens - %'
)
NEW: 288608128
NEW: 288608228
NEW: 288608328
UPDATING: Tinta da China Pelikan
Product ID: 27458
Image file:
NEW: 288620728
NEW: 288634064
NEW: 288634464
NEW: 288636099
NEW: 288685621
NEW: 288686121
NEW: 288790499
NEW: 288790599
NEW: 288790699
NEW: 288790799
NEW: 288790899
NEW: 288790999
NEW: 288791099
NEW: 288791199
NEW: 295400199
NEW: 295400299
NEW: 295443598
NEW: 295451198
UPDATING: Verniz Talens Spray
Product ID: 27559
Image file:
UPDATING: Verniz Talens para Óleo de Retoque 75 ml
Product ID: 27427
Image file:
NEW: Verniz Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Verniz Talens - %'
)
NEW: 295463399
UPDATING: Verniz Amsterdam para Óleo e para Acrílico
Product ID: 27448
Image file:
NEW: 3
NEW: 4
NEW: 400027999
NEW: 400168499
NEW: 400168699
NEW: 400169499
NEW: 400169599
NEW: 400311802
NEW: 400320799
NEW: 400333299
NEW: 400333599
NEW: 400333799
NEW: 400334499
NEW: 400340102
NEW: 400355502
NEW: 400365002
NEW: 400373799
NEW: 400376399
NEW: 400386402
NEW: 400390199
NEW: 400401799
NEW: 400401899
NEW: 400401999
NEW: 400406699
NEW: 400406799
NEW: 400407899
NEW: 400511899
NEW: 400521699
NEW: 400523899
NEW: 400525799
NEW: 400532699
NEW: 400532899
NEW: 400533399
NEW: 400537399
Ok.
Product Option Sync.
Opencart products: 236
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 = 27632
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27632,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '288116298 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/288116298.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3848 AS option_value_id,
language_id,
17 AS option_id,
'288116298 - Terebentina Rectificada Talens 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 518
AND product_id = 27632
AND option_id = 17
AND option_value_id = 3848
DELETE FROM oc_product
WHERE
model = '288116298'
INSERT INTO oc_product_option_value
SET
product_option_id = 518,
product_id = 27632,
option_id = 17,
option_value_id = 3848,
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 = 27458
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '288617528 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3849 AS option_value_id,
language_id,
17 AS option_id,
'288617528 - Tinta da China Pelikan 10 ml Amarela' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 437
AND product_id = 27458
AND option_id = 17
AND option_value_id = 3849
DELETE FROM oc_product
WHERE
model = '288617528'
INSERT INTO oc_product_option_value
SET
product_option_id = 437,
product_id = 27458,
option_id = 17,
option_value_id = 3849,
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 '288617928 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3850 AS option_value_id,
language_id,
17 AS option_id,
'288617928 - Tinta da China Pelikan 10 ml Azul Ultramarino' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 437
AND product_id = 27458
AND option_id = 17
AND option_value_id = 3850
DELETE FROM oc_product
WHERE
model = '288617928'
INSERT INTO oc_product_option_value
SET
product_option_id = 437,
product_id = 27458,
option_id = 17,
option_value_id = 3850,
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 '288619328 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3851 AS option_value_id,
language_id,
17 AS option_id,
'288619328 - Tinta da China Pelikan 10 ml Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 437
AND product_id = 27458
AND option_id = 17
AND option_value_id = 3851
DELETE FROM oc_product
WHERE
model = '288619328'
INSERT INTO oc_product_option_value
SET
product_option_id = 437,
product_id = 27458,
option_id = 17,
option_value_id = 3851,
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 = 27559
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '295456298 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3852 AS option_value_id,
language_id,
17 AS option_id,
'295456298 - Verniz Talens de Retoque para Óleo Spray 400 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 495
AND product_id = 27559
AND option_id = 17
AND option_value_id = 3852
DELETE FROM oc_product
WHERE
model = '295456298'
INSERT INTO oc_product_option_value
SET
product_option_id = 495,
product_id = 27559,
option_id = 17,
option_value_id = 3852,
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 = 27427
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '295457298 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3853 AS option_value_id,
language_id,
17 AS option_id,
'295457298 - Verniz Talens para Óleo de Retoque 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 410
AND product_id = 27427
AND option_id = 17
AND option_value_id = 3853
DELETE FROM oc_product
WHERE
model = '295457298'
INSERT INTO oc_product_option_value
SET
product_option_id = 410,
product_id = 27427,
option_id = 17,
option_value_id = 3853,
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 = 27633
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27633,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '295460098 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3854 AS option_value_id,
language_id,
17 AS option_id,
'295460098 - Verniz Decorfin Multi 50 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 519
AND product_id = 27633
AND option_id = 17
AND option_value_id = 3854
DELETE FROM oc_product
WHERE
model = '295460098'
INSERT INTO oc_product_option_value
SET
product_option_id = 519,
product_id = 27633,
option_id = 17,
option_value_id = 3854,
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 = 27448
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '295463499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3855 AS option_value_id,
language_id,
17 AS option_id,
'295463499 - Verniz Amsterdam para Óleo e para Acrílico Brilhante 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 427
AND product_id = 27448
AND option_id = 17
AND option_value_id = 3855
DELETE FROM oc_product
WHERE
model = '295463499'
INSERT INTO oc_product_option_value
SET
product_option_id = 427,
product_id = 27448,
option_id = 17,
option_value_id = 3855,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.