Product Sync.
Opencart products: 251
Input products: 100
NEW: 445304599
NEW: 445308661
NEW: 445308767
NEW: 445308867
NEW: 445310567
NEW: 445310667
NEW: 445310767
NEW: 445310867
NEW: 445310967
NEW: 445311499
NEW: 445312499
NEW: 445313299
NEW: 445313699
NEW: 445314799
NEW: 445315199
NEW: 445319099
NEW: 445319199
NEW: 445319299
NEW: 445319399
NEW: 445319499
NEW: 445319599
NEW: 445319699
NEW: 445319799
NEW: 445319899
NEW: 445319999
NEW: 445320099
NEW: 445320199
NEW: 445320299
NEW: 445320499
NEW: 445400361
NEW: 445502599
NEW: 446300367
NEW: 446300467
NEW: 446300599
NEW: 446300699
NEW: 446300999
NEW: Verniz Winsor & Newton
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Verniz Winsor & Newton - %'
)
NEW: 446301199
NEW: 446301399
NEW: Verniz Talens para Óleo
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 para Óleo - %'
)
UPDATING: Verniz Amsterdam para Óleo e para Acrílico
Product ID: 27448
Image file:
NEW: 446302699
NEW: Verniz Talens para Óleo Damar
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 para Óleo Damar - %'
)
UPDATING: Verniz Talens Spray
Product ID: 27559
Image file:
NEW: 446303499
NEW: 446304299
NEW: 446304499
NEW: 446304599
NEW: 446305399
NEW: 446305499
NEW: 447007799
NEW: 447101899
NEW: 447120599
NEW: 447120699
NEW: 447120899
NEW: 447300200
NEW: 447300300
NEW: 447300399
NEW: 447300400
NEW: 447300899
NEW: 447301799
NEW: 447302299
NEW: 447303299
NEW: 447303399
NEW: 447303499
NEW: 447303599
NEW: 447304299
NEW: 447304399
NEW: 447304599
NEW: 447304699
NEW: 447305099
NEW: 447305399
NEW: 447305499
NEW: 447305599
NEW: 447305999
NEW: 447306099
NEW: 447306399
NEW: 447306499
NEW: 447306999
NEW: 447900899
NEW: 448005999
NEW: 448006199
NEW: 448006299
NEW: 448006399
NEW: 448006899
NEW: 448006999
NEW: 448007199
NEW: 448007299
NEW: 448620599
NEW: 448630199
NEW: 448639999
Ok.
Product Option Sync.
Opencart products: 254
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 = 27649
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27649,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446301099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3881 AS option_value_id,
language_id,
17 AS option_id,
'446301099 - Verniz Winsor & Newton Spray Mate 400 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 523
AND product_id = 27649
AND option_id = 17
AND option_value_id = 3881
DELETE FROM oc_product
WHERE
model = '446301099'
INSERT INTO oc_product_option_value
SET
product_option_id = 523,
product_id = 27649,
option_id = 17,
option_value_id = 3881,
quantity = 1,
subtract = 1,
price = 0.244,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446301499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/446301499.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3882 AS option_value_id,
language_id,
17 AS option_id,
'446301499 - Verniz Winsor & Newton Spray Brilhante 400 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 523
AND product_id = 27649
AND option_id = 17
AND option_value_id = 3882
DELETE FROM oc_product
WHERE
model = '446301499'
INSERT INTO oc_product_option_value
SET
product_option_id = 523,
product_id = 27649,
option_id = 17,
option_value_id = 3882,
quantity = 1,
subtract = 1,
price = 0.203,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446303399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/446303399.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3883 AS option_value_id,
language_id,
17 AS option_id,
'446303399 - Verniz Winsor & Newton Spray Acetinado 400 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 523
AND product_id = 27649
AND option_id = 17
AND option_value_id = 3883
DELETE FROM oc_product
WHERE
model = '446303399'
INSERT INTO oc_product_option_value
SET
product_option_id = 523,
product_id = 27649,
option_id = 17,
option_value_id = 3883,
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 = 27650
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27650,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446301799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/446301799.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3884 AS option_value_id,
language_id,
17 AS option_id,
'446301799 - Verniz Talens para Óleo Brilhante 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 524
AND product_id = 27650
AND option_id = 17
AND option_value_id = 3884
DELETE FROM oc_product
WHERE
model = '446301799'
INSERT INTO oc_product_option_value
SET
product_option_id = 524,
product_id = 27650,
option_id = 17,
option_value_id = 3884,
quantity = 1,
subtract = 1,
price = 0.366,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446301899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/446301899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3885 AS option_value_id,
language_id,
17 AS option_id,
'446301899 - Verniz Talens para Óleo Mate 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 524
AND product_id = 27650
AND option_id = 17
AND option_value_id = 3885
DELETE FROM oc_product
WHERE
model = '446301899'
INSERT INTO oc_product_option_value
SET
product_option_id = 524,
product_id = 27650,
option_id = 17,
option_value_id = 3885,
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 '446301999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3886 AS option_value_id,
language_id,
17 AS option_id,
'446301999 - Verniz Talens para Óleo Brilhante 114 S3 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 524
AND product_id = 27650
AND option_id = 17
AND option_value_id = 3886
DELETE FROM oc_product
WHERE
model = '446301999'
INSERT INTO oc_product_option_value
SET
product_option_id = 524,
product_id = 27650,
option_id = 17,
option_value_id = 3886,
quantity = 1,
subtract = 1,
price = 8.903,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446302099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3887 AS option_value_id,
language_id,
17 AS option_id,
'446302099 - \''Verniz Talens para Óleo Mate 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 524
AND product_id = 27650
AND option_id = 17
AND option_value_id = 3887
DELETE FROM oc_product
WHERE
model = '446302099'
INSERT INTO oc_product_option_value
SET
product_option_id = 524,
product_id = 27650,
option_id = 17,
option_value_id = 3887,
quantity = 1,
subtract = 1,
price = 8.903,
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 '446302199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/446302199.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3888 AS option_value_id,
language_id,
17 AS option_id,
'446302199 - Verniz Amsterdam para Óleo e para Acrílico Brilhante 75 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 = 3888
DELETE FROM oc_product
WHERE
model = '446302199'
INSERT INTO oc_product_option_value
SET
product_option_id = 427,
product_id = 27448,
option_id = 17,
option_value_id = 3888,
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 '446302299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3889 AS option_value_id,
language_id,
17 AS option_id,
'446302299 - Verniz Amsterdam para Óleo e para Acrílico Mate 75 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 = 3889
DELETE FROM oc_product
WHERE
model = '446302299'
INSERT INTO oc_product_option_value
SET
product_option_id = 427,
product_id = 27448,
option_id = 17,
option_value_id = 3889,
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 = 27651
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27651,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446302799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3890 AS option_value_id,
language_id,
17 AS option_id,
'446302799 - Verniz Talens para Óleo Damar Brilhante 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 525
AND product_id = 27651
AND option_id = 17
AND option_value_id = 3890
DELETE FROM oc_product
WHERE
model = '446302799'
INSERT INTO oc_product_option_value
SET
product_option_id = 525,
product_id = 27651,
option_id = 17,
option_value_id = 3890,
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 '446302899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3891 AS option_value_id,
language_id,
17 AS option_id,
'446302899 - Verniz Talens para Óleo Damar Mate 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 525
AND product_id = 27651
AND option_id = 17
AND option_value_id = 3891
DELETE FROM oc_product
WHERE
model = '446302899'
INSERT INTO oc_product_option_value
SET
product_option_id = 525,
product_id = 27651,
option_id = 17,
option_value_id = 3891,
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 '446302999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3892 AS option_value_id,
language_id,
17 AS option_id,
'446302999 - Verniz Acrílico Spray Talens Brilhante 114' 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 = 3892
DELETE FROM oc_product
WHERE
model = '446302999'
INSERT INTO oc_product_option_value
SET
product_option_id = 495,
product_id = 27559,
option_id = 17,
option_value_id = 3892,
quantity = 1,
subtract = 1,
price = 0.854,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446303099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3893 AS option_value_id,
language_id,
17 AS option_id,
'446303099 - Verniz Acrílico Spray Talens Mate 115' 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 = 3893
DELETE FROM oc_product
WHERE
model = '446303099'
INSERT INTO oc_product_option_value
SET
product_option_id = 495,
product_id = 27559,
option_id = 17,
option_value_id = 3893,
quantity = 1,
subtract = 1,
price = 0.854,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '446303299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3894 AS option_value_id,
language_id,
17 AS option_id,
'446303299 - Verniz Talens Mate 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 = 3894
DELETE FROM oc_product
WHERE
model = '446303299'
INSERT INTO oc_product_option_value
SET
product_option_id = 495,
product_id = 27559,
option_id = 17,
option_value_id = 3894,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.