Product Sync.
Opencart products: 225
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: 27435
Image file:
NEW: 245110499
NEW: 245119028
UPDATING: Guache Pelikan
Product ID: 27446
Image file:
NEW: 245120228
UPDATING: Guache Caran D´Ache com 5
Product ID: 27483
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: 227
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 = 27435
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 com 12'
WHERE
option_value_id = 1925
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 416
AND product_id = 27435
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 = 416,
product_id = 27435,
option_id = 17,
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 = 416
AND product_id = 27435
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 = 416,
product_id = 27435,
option_id = 17,
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 = 27446
AND option_id = 17
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 = 425
AND product_id = 27446
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 = 425,
product_id = 27446,
option_id = 17,
option_value_id = 1932,
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 = 27483
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '245132921 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3754 AS option_value_id,
language_id,
17 AS option_id,
'245132921 - Guache Caran D´Ache Caixa com 5 Cores (3 Primárias, Preto e Branco)' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 456
AND product_id = 27483
AND option_id = 17
AND option_value_id = 3754
DELETE FROM oc_product
WHERE
model = '245132921'
INSERT INTO oc_product_option_value
SET
product_option_id = 456,
product_id = 27483,
option_id = 17,
option_value_id = 3754,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3755 AS option_value_id,
language_id,
17 AS option_id,
'245133021 - Guache Caran D´Ache Studio Caixa com 8 Cores' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 456
AND product_id = 27483
AND option_id = 17
AND option_value_id = 3755
DELETE FROM oc_product
WHERE
model = '245133021'
INSERT INTO oc_product_option_value
SET
product_option_id = 456,
product_id = 27483,
option_id = 17,
option_value_id = 3755,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3756 AS option_value_id,
language_id,
17 AS option_id,
'245133221 - Guache Caran D´Ache Caixa 13 Cores e Pincel' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 456
AND product_id = 27483
AND option_id = 17
AND option_value_id = 3756
DELETE FROM oc_product
WHERE
model = '245133221'
INSERT INTO oc_product_option_value
SET
product_option_id = 456,
product_id = 27483,
option_id = 17,
option_value_id = 3756,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3757 AS option_value_id,
language_id,
17 AS option_id,
'245133321 - Guache Caran D´Ache Studio Caixa com 8 Cores Sortidas e Pincel' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 456
AND product_id = 27483
AND option_id = 17
AND option_value_id = 3757
DELETE FROM oc_product
WHERE
model = '245133321'
INSERT INTO oc_product_option_value
SET
product_option_id = 456,
product_id = 27483,
option_id = 17,
option_value_id = 3757,
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 = 27624
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27624,
option_id = 17,
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 = 512
AND product_id = 27624
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 = 512,
product_id = 27624,
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 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 = 512
AND product_id = 27624
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 = 512,
product_id = 27624,
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 '245196899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3758 AS option_value_id,
language_id,
17 AS option_id,
'245196899 - Guache Giotto 7,5 ml Magenta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 512
AND product_id = 27624
AND option_id = 17
AND option_value_id = 3758
DELETE FROM oc_product
WHERE
model = '245196899'
INSERT INTO oc_product_option_value
SET
product_option_id = 512,
product_id = 27624,
option_id = 17,
option_value_id = 3758,
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 = 512
AND product_id = 27624
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 = 512,
product_id = 27624,
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 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 = 512
AND product_id = 27624
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 = 512,
product_id = 27624,
option_id = 17,
option_value_id = 1930,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.