Product Sync.
Opencart products: 330
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: 27280
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: 332
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 = 27280
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '430600299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2841
UPDATE oc_option_value_description
SET
name = '430600299 - Espátula Pintura N1'
WHERE
option_value_id = 2841
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2841
DELETE FROM oc_product
WHERE
model = '430600299'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2841,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2843
UPDATE oc_option_value_description
SET
name = '430600799 - Espátula Pintura N3'
WHERE
option_value_id = 2843
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2843
DELETE FROM oc_product
WHERE
model = '430600799'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2843,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2844
UPDATE oc_option_value_description
SET
name = '430600899 - Espátula Pintura N4'
WHERE
option_value_id = 2844
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2844
DELETE FROM oc_product
WHERE
model = '430600899'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2844,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2845
UPDATE oc_option_value_description
SET
name = '430600999 - Espátula Pintura N5'
WHERE
option_value_id = 2845
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2845
DELETE FROM oc_product
WHERE
model = '430600999'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2845,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2846
UPDATE oc_option_value_description
SET
name = '430601099 - Espátula Pintura N6'
WHERE
option_value_id = 2846
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2846
DELETE FROM oc_product
WHERE
model = '430601099'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2846,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2847
UPDATE oc_option_value_description
SET
name = '430601399 - Espátula Pintura N9'
WHERE
option_value_id = 2847
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2847
DELETE FROM oc_product
WHERE
model = '430601399'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2847,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2848
UPDATE oc_option_value_description
SET
name = '430601499 - Espátula Pintura N10'
WHERE
option_value_id = 2848
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2848
DELETE FROM oc_product
WHERE
model = '430601499'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2848,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2849
UPDATE oc_option_value_description
SET
name = '430601599 - Espátula Pintura N11'
WHERE
option_value_id = 2849
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2849
DELETE FROM oc_product
WHERE
model = '430601599'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2849,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2850
UPDATE oc_option_value_description
SET
name = '430601699 - Espátula Pintura N12'
WHERE
option_value_id = 2850
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2850
DELETE FROM oc_product
WHERE
model = '430601699'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2850,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2851
UPDATE oc_option_value_description
SET
name = '430601799 - Espátula Pintura N13'
WHERE
option_value_id = 2851
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2851
DELETE FROM oc_product
WHERE
model = '430601799'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2851,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2852
UPDATE oc_option_value_description
SET
name = '430601899 - Espátula Pintura N14'
WHERE
option_value_id = 2852
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2852
DELETE FROM oc_product
WHERE
model = '430601899'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2852,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2853
UPDATE oc_option_value_description
SET
name = '430601999 - Espátula Pintura N15'
WHERE
option_value_id = 2853
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2853
DELETE FROM oc_product
WHERE
model = '430601999'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2853,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2854
UPDATE oc_option_value_description
SET
name = '430602099 - Espátula Pintura N16'
WHERE
option_value_id = 2854
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2854
DELETE FROM oc_product
WHERE
model = '430602099'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2854,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2855
UPDATE oc_option_value_description
SET
name = '430602199 - Espátula Pintura N17'
WHERE
option_value_id = 2855
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2855
DELETE FROM oc_product
WHERE
model = '430602199'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2855,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2856
UPDATE oc_option_value_description
SET
name = '430602299 - Espátula Pintura N18'
WHERE
option_value_id = 2856
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2856
DELETE FROM oc_product
WHERE
model = '430602299'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2856,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2857
UPDATE oc_option_value_description
SET
name = '430602399 - Espátula Pintura N19'
WHERE
option_value_id = 2857
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2857
DELETE FROM oc_product
WHERE
model = '430602399'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2857,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2858
UPDATE oc_option_value_description
SET
name = '430602799 - Espátula Pintura N23'
WHERE
option_value_id = 2858
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2858
DELETE FROM oc_product
WHERE
model = '430602799'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2858,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2859
UPDATE oc_option_value_description
SET
name = '430602899 - Espátula Pintura N24'
WHERE
option_value_id = 2859
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 342
AND product_id = 27280
AND option_id = 15
AND option_value_id = 2859
DELETE FROM oc_product
WHERE
model = '430602899'
INSERT INTO oc_product_option_value
SET
product_option_id = 342,
product_id = 27280,
option_id = 15,
option_value_id = 2859,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.