Product Sync.
Opencart products: 247
Input products: 100
NEW: 440317399
NEW: 440317499
NEW: 440317599
NEW: 440317699
NEW: 440317799
NEW: 440317899
UPDATING: Guache Pelikan
Product ID: 27446
Image file:
NEW: 440325699
NEW: 440326999
NEW: 440328099
NEW: 440328199
NEW: 440328299
NEW: 440328699
NEW: 440328899
NEW: 440328999
NEW: 440329499
NEW: 440329699
NEW: 440330099
NEW: 440330399
NEW: 440330699
NEW: 440330799
NEW: 440330899
NEW: 440331099
NEW: 440331399
NEW: 440331499
NEW: 440331699
NEW: 440331799
NEW: 440332299
NEW: 440332399
NEW: 440332499
NEW: Godé Duplo MOD
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Godé Duplo MOD - %'
)
NEW: Godé Duplo para Paleta com Tampa
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Godé Duplo para Paleta com Tampa - %'
)
NEW: 440501099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '440501099 - %'
)
NEW: 440501399
NEW: 440501499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '440501499 - %'
)
NEW: 441300299
NEW: 441300399
NEW: 441302576
NEW: 441302676
NEW: 441639399
NEW: 443721799
NEW: 444100399
NEW: 444100499
NEW: 444100999
NEW: 444101099
NEW: 444101199
NEW: 444102899
NEW: 444107999
NEW: 444108199
NEW: 444311099
NEW: 444311499
NEW: 444315099
NEW: 444901899
NEW: 444902199
NEW: 445008199
NEW: 445100299
NEW: 445100699
NEW: 445100899
NEW: 445100999
NEW: 445101099
NEW: 445101299
NEW: 445101399
NEW: 445101499
NEW: 445113299
NEW: 445113899
NEW: 445115199
NEW: 445154599
NEW: 445200799
NEW: 445201067
NEW: 445201167
NEW: 445201367
NEW: 445201667
NEW: 445201699
NEW: 445201799
NEW: 445202261
NEW: 445203021
NEW: 445203199
NEW: 445203299
NEW: 445203399
NEW: 445203499
NEW: 445203521
NEW: 445203599
NEW: 445203799
NEW: 445204199
NEW: 445204299
NEW: 445204361
NEW: 445204399
NEW: 445204521
NEW: 445206967
NEW: 445210199
NEW: 445225721
NEW: 445231721
NEW: 445231821
NEW: 445231921
NEW: 445232021
NEW: 445232121
NEW: 445232221
Ok.
Product Option Sync.
Opencart products: 251
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 = 27446
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '440324699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1941
UPDATE oc_option_value_description
SET
name = '440324699 - Guache Pelikan 10 ml Branco'
WHERE
option_value_id = 1941
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 = 1941
DELETE FROM oc_product
WHERE
model = '440324699'
INSERT INTO oc_product_option_value
SET
product_option_id = 425,
product_id = 27446,
option_id = 17,
option_value_id = 1941,
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 '440325799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1943
UPDATE oc_option_value_description
SET
name = '440325799 - Guache Pelikan 10 ml Amarelo'
WHERE
option_value_id = 1943
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 = 1943
DELETE FROM oc_product
WHERE
model = '440325799'
INSERT INTO oc_product_option_value
SET
product_option_id = 425,
product_id = 27446,
option_id = 17,
option_value_id = 1943,
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 '440325999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1944
UPDATE oc_option_value_description
SET
name = '440325999 - Guache Pelikan 10 ml Vermelho'
WHERE
option_value_id = 1944
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 = 1944
DELETE FROM oc_product
WHERE
model = '440325999'
INSERT INTO oc_product_option_value
SET
product_option_id = 425,
product_id = 27446,
option_id = 17,
option_value_id = 1944,
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 = 27645
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27645,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '440500299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3878 AS option_value_id,
language_id,
17 AS option_id,
'440500299 - Godé Duplo 31 mm MOD' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 521
AND product_id = 27645
AND option_id = 17
AND option_value_id = 3878
DELETE FROM oc_product
WHERE
model = '440500299'
INSERT INTO oc_product_option_value
SET
product_option_id = 521,
product_id = 27645,
option_id = 17,
option_value_id = 3878,
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 '440500699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3879 AS option_value_id,
language_id,
17 AS option_id,
'440500699 - Godé Duplo 40mm MOD' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 521
AND product_id = 27645
AND option_id = 17
AND option_value_id = 3879
DELETE FROM oc_product
WHERE
model = '440500699'
INSERT INTO oc_product_option_value
SET
product_option_id = 521,
product_id = 27645,
option_id = 17,
option_value_id = 3879,
quantity = 1,
subtract = 1,
price = 0.162,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27646
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27646,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '440500499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3880 AS option_value_id,
language_id,
17 AS option_id,
'440500499 - Godé Duplo para Paleta com Tampa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 522
AND product_id = 27646
AND option_id = 17
AND option_value_id = 3880
DELETE FROM oc_product
WHERE
model = '440500499'
INSERT INTO oc_product_option_value
SET
product_option_id = 522,
product_id = 27646,
option_id = 17,
option_value_id = 3880,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.