Product Sync.
Opencart products: 333
Input products: 100
NEW: 440317399
NEW: 440317499
NEW: 440317599
NEW: 440317699
NEW: 440317799
NEW: 440317899
UPDATING: Guache Pelikan
Product ID: 27022
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: 337
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 = 27022
AND option_id = 15
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 = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1941
DELETE FROM oc_product
WHERE
model = '440324699'
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 = 1941
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 = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1943
DELETE FROM oc_product
WHERE
model = '440325799'
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 = 1943
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 = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1944
DELETE FROM oc_product
WHERE
model = '440325999'
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 = 1944
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27322
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27322,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '440500299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2862
UPDATE oc_option_value_description
SET
name = '440500299 - Godé Duplo 31 mm MOD'
WHERE
option_value_id = 2862
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 357
AND product_id = 27322
AND option_id = 15
AND option_value_id = 2862
DELETE FROM oc_product
WHERE
model = '440500299'
INSERT INTO oc_product_option_value
SET
product_option_id = 357,
product_id = 27322,
option_id = 15,
option_value_id = 2862,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2864
UPDATE oc_option_value_description
SET
name = '440500699 - Godé Duplo 40mm MOD'
WHERE
option_value_id = 2864
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 357
AND product_id = 27322
AND option_id = 15
AND option_value_id = 2864
DELETE FROM oc_product
WHERE
model = '440500699'
INSERT INTO oc_product_option_value
SET
product_option_id = 357,
product_id = 27322,
option_id = 15,
option_value_id = 2864,
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 = 27323
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27323,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '440500499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2863
UPDATE oc_option_value_description
SET
name = '440500499 - Godé Duplo para Paleta com Tampa'
WHERE
option_value_id = 2863
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 358
AND product_id = 27323
AND option_id = 15
AND option_value_id = 2863
DELETE FROM oc_product
WHERE
model = '440500499'
INSERT INTO oc_product_option_value
SET
product_option_id = 358,
product_id = 27323,
option_id = 15,
option_value_id = 2863,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.