Product Sync.
Opencart products: 244
Input products: 100
NEW: 426021699
NEW: 426022099
NEW: 426023799
NEW: 426024199
NEW: 426024799
NEW: 426027299
NEW: 426309099
NEW: 427000199
NEW: 427040099
NEW: 427201899
NEW: 427202399
NEW: 427202699
NEW: 427440099
NEW: 427450099
NEW: 427450199
NEW: 427470099
NEW: 427498799
NEW: 427660099
NEW: 427735099
NEW: 428600199
NEW: 429100299
NEW: 429100699
NEW: 429101199
NEW: 429700499
NEW: 429700599
NEW: 429701299
NEW: 429701399
NEW: 429701699
NEW: 429701799
NEW: 429701899
NEW: 429701999
NEW: 429702299
NEW: 429702399
NEW: 429703299
NEW: 430102499
NEW: 430102599
NEW: 430103399
NEW: 430103499
NEW: 430103599
NEW: 430103799
NEW: 430103899
NEW: 430103999
NEW: 430104099
NEW: 430104199
NEW: 430104299
NEW: 430104399
NEW: 430104499
NEW: 430104599
NEW: 430104799
NEW: 430104899
NEW: 430104999
NEW: 430105099
NEW: 430105199
NEW: 430105299
NEW: 430105399
NEW: 430105699
NEW: 430105899
NEW: 430106199
NEW: 430106399
NEW: 430106499
NEW: 430106599
NEW: 430106699
NEW: 430106999
NEW: 430107499
NEW: 430107899
NEW: 430108299
NEW: 430108399
NEW: 430108899
NEW: 430109199
NEW: 430109399
NEW: 430109499
NEW: 430109899
NEW: 430109999
NEW: 430110099
UPDATING: Espátula Pintura
Product ID: 27602
Image file:
NEW: 430600399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '430600399 - %'
)
NEW: 430600499
NEW: 430602999
NEW: 430603299
NEW: 431117899
NEW: 431117999
NEW: 431418999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '431418999 - %'
)
NEW: 431440599
Ok.
Product Option Sync.
Opencart products: 246
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 = 27602
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '430600299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3860 AS option_value_id,
language_id,
17 AS option_id,
'430600299 - Espátula Pintura N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3860
DELETE FROM oc_product
WHERE
model = '430600299'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3860,
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 '430600799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3861 AS option_value_id,
language_id,
17 AS option_id,
'430600799 - Espátula Pintura N3' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3861
DELETE FROM oc_product
WHERE
model = '430600799'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3861,
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 '430600899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3862 AS option_value_id,
language_id,
17 AS option_id,
'430600899 - Espátula Pintura N4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3862
DELETE FROM oc_product
WHERE
model = '430600899'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3862,
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 '430600999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3863 AS option_value_id,
language_id,
17 AS option_id,
'430600999 - Espátula Pintura N5' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3863
DELETE FROM oc_product
WHERE
model = '430600999'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3863,
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 '430601099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3864 AS option_value_id,
language_id,
17 AS option_id,
'430601099 - Espátula Pintura N6' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3864
DELETE FROM oc_product
WHERE
model = '430601099'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3864,
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 '430601399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3865 AS option_value_id,
language_id,
17 AS option_id,
'430601399 - Espátula Pintura N9' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3865
DELETE FROM oc_product
WHERE
model = '430601399'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3865,
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 '430601499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3866 AS option_value_id,
language_id,
17 AS option_id,
'430601499 - Espátula Pintura N10' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3866
DELETE FROM oc_product
WHERE
model = '430601499'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3866,
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 '430601599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3867 AS option_value_id,
language_id,
17 AS option_id,
'430601599 - Espátula Pintura N11' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3867
DELETE FROM oc_product
WHERE
model = '430601599'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3867,
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 '430601699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3868 AS option_value_id,
language_id,
17 AS option_id,
'430601699 - Espátula Pintura N12' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3868
DELETE FROM oc_product
WHERE
model = '430601699'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3868,
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 '430601799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3869 AS option_value_id,
language_id,
17 AS option_id,
'430601799 - Espátula Pintura N13' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3869
DELETE FROM oc_product
WHERE
model = '430601799'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3869,
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 '430601899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3870 AS option_value_id,
language_id,
17 AS option_id,
'430601899 - Espátula Pintura N14' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3870
DELETE FROM oc_product
WHERE
model = '430601899'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3870,
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 '430601999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3871 AS option_value_id,
language_id,
17 AS option_id,
'430601999 - Espátula Pintura N15' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3871
DELETE FROM oc_product
WHERE
model = '430601999'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3871,
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 '430602099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3872 AS option_value_id,
language_id,
17 AS option_id,
'430602099 - Espátula Pintura N16' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3872
DELETE FROM oc_product
WHERE
model = '430602099'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3872,
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 '430602199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3873 AS option_value_id,
language_id,
17 AS option_id,
'430602199 - Espátula Pintura N17' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3873
DELETE FROM oc_product
WHERE
model = '430602199'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3873,
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 '430602299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3874 AS option_value_id,
language_id,
17 AS option_id,
'430602299 - Espátula Pintura N18' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3874
DELETE FROM oc_product
WHERE
model = '430602299'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3874,
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 '430602399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3875 AS option_value_id,
language_id,
17 AS option_id,
'430602399 - Espátula Pintura N19' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3875
DELETE FROM oc_product
WHERE
model = '430602399'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3875,
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 '430602799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3876 AS option_value_id,
language_id,
17 AS option_id,
'430602799 - Espátula Pintura N23' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3876
DELETE FROM oc_product
WHERE
model = '430602799'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3876,
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 '430602899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3877 AS option_value_id,
language_id,
17 AS option_id,
'430602899 - Espátula Pintura N24' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3877
DELETE FROM oc_product
WHERE
model = '430602899'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3877,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.