Product Sync.
Opencart products: 28
Input products: 100
NEW: 101631399
NEW: 101631499
NEW: 101631599
NEW: 101631699
NEW: 101631799
NEW: 101631899
NEW: 101631999
NEW: 101632099
NEW: 101632199
NEW: 101632299
NEW: 101632399
NEW: 101632499
NEW: 101632599
NEW: 101632699
NEW: 101632799
NEW: 101632899
NEW: 101632999
NEW: 101633099
NEW: 101633199
NEW: 101633299
NEW: 101633399
NEW: 101633499
NEW: 101633599
NEW: 101633699
NEW: 101633799
NEW: 101633899
NEW: 101633999
NEW: 101634099
NEW: 101634199
NEW: 101634299
NEW: 101634399
NEW: 101634499
NEW: 101634599
NEW: 101634699
NEW: 101634799
NEW: 101634899
NEW: 101634999
NEW: 101635099
NEW: 101635199
NEW: 101635299
NEW: 101635399
NEW: 101635499
NEW: 101635599
NEW: 101635699
NEW: 101635799
NEW: 101635899
NEW: 101635999
NEW: 101636099
NEW: 101636199
NEW: 101636299
NEW: 101636399
NEW: 101636499
NEW: 101636599
NEW: 101636699
NEW: 101636799
NEW: 101636899
NEW: 101636999
NEW: 101637099
NEW: 101637199
NEW: 101637299
NEW: 101637399
NEW: 101637499
NEW: 101637599
NEW: 101637699
NEW: 101637799
NEW: 101637899
NEW: 101637999
NEW: 101638099
NEW: 101638199
NEW: 101638299
NEW: 101638399
NEW: 101638499
NEW: 101638599
NEW: 101638699
NEW: 101638799
NEW: 101638899
NEW: 101638999
NEW: 101639099
NEW: 101639199
NEW: 101639299
NEW: 101639399
NEW: 101639499
NEW: 101639599
NEW: 101639699
NEW: 101639799
NEW: 101639899
NEW: 101639999
NEW: 101640099
NEW: 101640199
NEW: 101640299
NEW: Amsterdam Spray
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Amsterdam Spray - %'
)
NEW: 101640499
Ok.
Product Option Sync.
Opencart products: 29
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 = 27400
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27400,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101640399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1770
UPDATE oc_option_value_description
SET
name = '101640399 - ACRIL SPRAY AMST 400ML BRCO TITANIO 105'
WHERE
option_value_id = 1770
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1770
DELETE FROM oc_product
WHERE
model = '101640399'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1770,
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 '101640599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1771
UPDATE oc_option_value_description
SET
name = '101640599 - ACRIL SPRAY AMST 400ML AMAR NAPOLES ESC 223'
WHERE
option_value_id = 1771
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1771
DELETE FROM oc_product
WHERE
model = '101640599'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1771,
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 '101640699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1772
UPDATE oc_option_value_description
SET
name = '101640699 - ACRIL SPRAY AMST 400ML OCRE AMA 227'
WHERE
option_value_id = 1772
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1772
DELETE FROM oc_product
WHERE
model = '101640699'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1772,
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 '101640799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1773
UPDATE oc_option_value_description
SET
name = '101640799 - ACRIL SPRAY AMST 400ML TERRA SIENA NAT 234'
WHERE
option_value_id = 1773
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1773
DELETE FROM oc_product
WHERE
model = '101640799'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1773,
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 '101640899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1774
UPDATE oc_option_value_description
SET
name = '101640899 - ACRIL SPRAY AMST 400ML AMAR FLUO 256'
WHERE
option_value_id = 1774
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1774
DELETE FROM oc_product
WHERE
model = '101640899'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1774,
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 '101640999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1775
UPDATE oc_option_value_description
SET
name = '101640999 - ACRIL SPRAY AMST 400ML LARANJ FLUO 257'
WHERE
option_value_id = 1775
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1775
DELETE FROM oc_product
WHERE
model = '101640999'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1775,
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 '101641099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1776
UPDATE oc_option_value_description
SET
name = '101641099 - ACRIL SPRAY AMST 400ML AMAR ACO LIMAO 267'
WHERE
option_value_id = 1776
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1776
DELETE FROM oc_product
WHERE
model = '101641099'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1776,
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 '101641199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1777
UPDATE oc_option_value_description
SET
name = '101641199 - ACRIL SPRAY AMST 400ML AMAR ACO ESC 270'
WHERE
option_value_id = 1777
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1777
DELETE FROM oc_product
WHERE
model = '101641199'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1777,
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 '101641299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1778
UPDATE oc_option_value_description
SET
name = '101641299 - ACRIL SPRAY AMST 400ML AMAR PRIMARIO 275'
WHERE
option_value_id = 1778
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1778
DELETE FROM oc_product
WHERE
model = '101641299'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1778,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.