Product Sync.
Opencart products: 312
Input products: 100
NEW: 241221500
NEW: 241226000
NEW: 241227000
NEW: 241227100
NEW: 242309199
NEW: 243113699
NEW: 243510098
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '243510098 - %'
)
NEW: 243905099
NEW: 243905599
NEW: 243906099
NEW: 243906199
UPDATING: Guache Giotto Caixa
Product ID: 27140
Image file:
NEW: 245110499
NEW: 245119028
UPDATING: Guache Pelikan
Product ID: 27022
Image file:
NEW: 245120228
UPDATING: Guache Caran D´Ache com 5
Product ID: 27167
Image file:
NEW: Guache Giotto Tubo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Guache Giotto Tubo - %'
)
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
NEW: 252547267
NEW: 252586021
NEW: 252596198
NEW: 252598599
NEW: 252598799
NEW: 252598999
NEW: 252599099
NEW: 252599199
NEW: 252599299
NEW: 252599399
NEW: 252600199
NEW: 252600299
NEW: 252600399
NEW: 252600499
NEW: 252600599
Ok.
Product Option Sync.
Opencart products: 314
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 = 27140
AND option_id = 15
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 com 12'
WHERE
option_value_id = 1925
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 289
AND product_id = 27140
AND option_id = 15
AND option_value_id = 1925
DELETE FROM oc_product
WHERE
model = '245110299'
INSERT INTO oc_product_option_value
SET
product_option_id = 289,
product_id = 27140,
option_id = 15,
option_value_id = 1925,
quantity = 1,
subtract = 1,
price = 3.333,
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 com 5'
WHERE
option_value_id = 1926
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 289
AND product_id = 27140
AND option_id = 15
AND option_value_id = 1926
DELETE FROM oc_product
WHERE
model = '245196599'
INSERT INTO oc_product_option_value
SET
product_option_id = 289,
product_id = 27140,
option_id = 15,
option_value_id = 1926,
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 = 27022
AND option_id = 15
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 10 ml Magenta'
WHERE
option_value_id = 1932
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1932
DELETE FROM oc_product
WHERE
model = '245119128'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1932
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27167
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245132921 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2731
UPDATE oc_option_value_description
SET
name = '245132921 - Guache Caran D´Ache Caixa com 5 Cores (3 Primárias, Preto e Branco)'
WHERE
option_value_id = 2731
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 307
AND product_id = 27167
AND option_id = 15
AND option_value_id = 2731
DELETE FROM oc_product
WHERE
model = '245132921'
INSERT INTO oc_product_option_value
SET
product_option_id = 307,
product_id = 27167,
option_id = 15,
option_value_id = 2731,
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 '245133021 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2732
UPDATE oc_option_value_description
SET
name = '245133021 - Guache Caran D´Ache Studio Caixa com 8 Cores'
WHERE
option_value_id = 2732
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 307
AND product_id = 27167
AND option_id = 15
AND option_value_id = 2732
DELETE FROM oc_product
WHERE
model = '245133021'
INSERT INTO oc_product_option_value
SET
product_option_id = 307,
product_id = 27167,
option_id = 15,
option_value_id = 2732,
quantity = 1,
subtract = 1,
price = 10,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245133221 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2733
UPDATE oc_option_value_description
SET
name = '245133221 - Guache Caran D´Ache Caixa 13 Cores e Pincel'
WHERE
option_value_id = 2733
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 307
AND product_id = 27167
AND option_id = 15
AND option_value_id = 2733
DELETE FROM oc_product
WHERE
model = '245133221'
INSERT INTO oc_product_option_value
SET
product_option_id = 307,
product_id = 27167,
option_id = 15,
option_value_id = 2733,
quantity = 1,
subtract = 1,
price = 15.772,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245133321 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2734
UPDATE oc_option_value_description
SET
name = '245133321 - Guache Caran D´Ache Studio Caixa com 8 Cores Sortidas e Pincel'
WHERE
option_value_id = 2734
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 307
AND product_id = 27167
AND option_id = 15
AND option_value_id = 2734
DELETE FROM oc_product
WHERE
model = '245133321'
INSERT INTO oc_product_option_value
SET
product_option_id = 307,
product_id = 27167,
option_id = 15,
option_value_id = 2734,
quantity = 1,
subtract = 1,
price = 12.845,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27302
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27302,
option_id = 15,
value = '',
required = 1
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 7,5 ml Branco'
WHERE
option_value_id = 1927
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 349
AND product_id = 27302
AND option_id = 15
AND option_value_id = 1927
DELETE FROM oc_product
WHERE
model = '245196699'
INSERT INTO oc_product_option_value
SET
product_option_id = 349,
product_id = 27302,
option_id = 15,
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 7,5 ml Amarelo Primário'
WHERE
option_value_id = 1928
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 349
AND product_id = 27302
AND option_id = 15
AND option_value_id = 1928
DELETE FROM oc_product
WHERE
model = '245196799'
INSERT INTO oc_product_option_value
SET
product_option_id = 349,
product_id = 27302,
option_id = 15,
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 '245196899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2730
UPDATE oc_option_value_description
SET
name = '245196899 - Guache Giotto 7,5 ml Magenta'
WHERE
option_value_id = 2730
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 349
AND product_id = 27302
AND option_id = 15
AND option_value_id = 2730
DELETE FROM oc_product
WHERE
model = '245196899'
INSERT INTO oc_product_option_value
SET
product_option_id = 349,
product_id = 27302,
option_id = 15,
option_value_id = 2730,
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 7,5 ml Azul Cyan'
WHERE
option_value_id = 1929
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 349
AND product_id = 27302
AND option_id = 15
AND option_value_id = 1929
DELETE FROM oc_product
WHERE
model = '245196999'
INSERT INTO oc_product_option_value
SET
product_option_id = 349,
product_id = 27302,
option_id = 15,
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 Giotto 7,5 ml Preto'
WHERE
option_value_id = 1930
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 349
AND product_id = 27302
AND option_id = 15
AND option_value_id = 1930
DELETE FROM oc_product
WHERE
model = '245197099'
INSERT INTO oc_product_option_value
SET
product_option_id = 349,
product_id = 27302,
option_id = 15,
option_value_id = 1930,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.