Product Sync.
Opencart products: 30
Input products: 100
NEW: 240042248
NEW: 240215502
NEW: 240607067
NEW: 240640399
NEW: 240671398
NEW: 240671498
NEW: 240672198
NEW: 241217900
NEW: 241218100
NEW: 241218200
NEW: 241218300
NEW: 241218400
NEW: 241221000
NEW: 241221300
NEW: 241221400
NEW: 241221500
NEW: 241226000
NEW: 241227000
NEW: 241227100
NEW: 242309199
NEW: 243113699
NEW: 243510098
NEW: 243905099
NEW: 243905599
NEW: 243906099
NEW: 243906199
UPDATING: Giotto 7,5 e 10ml
Product ID: 27388
Image file: Giotto 7,5 e 10ml.jpg
NEW: 245110499
UPDATING: Pelikan 10ml
Product ID: 27390
Image file: Pelikan 10ml.jpg
NEW: 245120228
NEW: 245132921
NEW: 245133021
NEW: 245133221
NEW: 245133321
NEW: 245196899
NEW: 245197199
NEW: 245197299
NEW: 245197399
NEW: 245197499
NEW: 245197599
NEW: 245197699
NEW: 245197799
NEW: 245197899
NEW: 245197999
NEW: 245198099
NEW: 245198199
NEW: 245198299
NEW: 245198399
NEW: 245198499
NEW: 245198599
NEW: 247904276
NEW: 247904676
NEW: 247906059
NEW: 247910500
NEW: 251702975
NEW: 252303021
NEW: 252306521
NEW: 252306621
NEW: 252306821
NEW: 252307021
NEW: 252307221
NEW: 252307421
NEW: 252313099
NEW: 252319165
NEW: 252319365
NEW: 252326322
NEW: 252333321
NEW: 252333421
NEW: 252333521
NEW: 252333721
NEW: 252334021
NEW: 252335021
NEW: 252335121
NEW: 252335221
NEW: 252335321
NEW: 252344467
NEW: 252348128
NEW: 252355687
NEW: 252356567
NEW: 252356767
NEW: 252356867
NEW: 252510121
NEW: 252514121
NEW: 252514221
NEW: 252514321
NEW: 252542598
NEW: 252544099
NEW: 252546167
NEW: 252546267
NEW: 252546467
NEW: 252546567
NEW: 252546667
NEW: 252546767
NEW: 252546967
Ok.
Product Option Sync.
Opencart products: 30
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 = 27388
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245110299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1925
UPDATE oc_option_value_description
SET
name = '245110299 - GUACHE GIOTTO CX/12 REF302500'
WHERE
option_value_id = 1925
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1925
DELETE FROM oc_product
WHERE
model = '245110299'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1925,
quantity = 1,
subtract = 1,
price = 6.341,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245196599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1926
UPDATE oc_option_value_description
SET
name = '245196599 - GUACHE GIOTTO CX/5 REF303500'
WHERE
option_value_id = 1926
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1926
DELETE FROM oc_product
WHERE
model = '245196599'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1926,
quantity = 1,
subtract = 1,
price = 2.927,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245196699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1927
UPDATE oc_option_value_description
SET
name = '245196699 - GUACHE GIOTTO BRC 7,5ML REF351001'
WHERE
option_value_id = 1927
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1927
DELETE FROM oc_product
WHERE
model = '245196699'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1927,
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 '245196799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1928
UPDATE oc_option_value_description
SET
name = '245196799 - GUACHE GIOTTO AMA PRIM 7,5ML REF351002'
WHERE
option_value_id = 1928
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1928
DELETE FROM oc_product
WHERE
model = '245196799'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1928,
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 '245196999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1929
UPDATE oc_option_value_description
SET
name = '245196999 - GUACHE GIOTTO CYAN 7,5ML REF351015'
WHERE
option_value_id = 1929
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1929
DELETE FROM oc_product
WHERE
model = '245196999'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1929,
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 '245197099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1930
UPDATE oc_option_value_description
SET
name = '245197099 - GUACHE GIOTT0 PRTO 7,5ML REF351024'
WHERE
option_value_id = 1930
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1930
DELETE FROM oc_product
WHERE
model = '245197099'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1930,
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 = 27390
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245119028 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1931
UPDATE oc_option_value_description
SET
name = '245119028 - GUACHE PELIKAN 740/4 10ML AMA PRIM'
WHERE
option_value_id = 1931
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1931
DELETE FROM oc_product
WHERE
model = '245119028'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1931,
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 '245119128 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1932
UPDATE oc_option_value_description
SET
name = '245119128 - GUACHE PELIKAN 10ML 740/ MAGENTA'
WHERE
option_value_id = 1932
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1932
DELETE FROM oc_product
WHERE
model = '245119128'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1932,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.