Product Sync.
Opencart products: 24
Input products: 100
NEW: 101073999
NEW: 101074099
NEW: 101074199
NEW: 101074299
NEW: 101074399
NEW: 101074499
NEW: 101074599
NEW: 101074699
NEW: Amsterdam 500ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Amsterdam 500ml - %'
)
NEW: 101075699
NEW: 101075799
NEW: 101075899
NEW: 101075999
NEW: 101076099
NEW: 101076199
NEW: 101076299
NEW: 101076399
NEW: 101076499
NEW: 101076599
NEW: 101076699
NEW: 101076799
NEW: 101076899
NEW: 101076999
NEW: 101077099
NEW: 101077199
NEW: 101077299
NEW: 101077399
NEW: 101077499
NEW: 101077599
NEW: 101077699
NEW: 101077799
NEW: 101077899
NEW: 101077999
NEW: 101078099
NEW: 101078199
NEW: 101078299
NEW: 101078399
NEW: 101078499
NEW: 101078599
NEW: 101078699
NEW: 101078799
NEW: 101078899
NEW: 101078999
NEW: 101079099
NEW: 101079199
NEW: 101079299
NEW: 101079399
NEW: 101079499
NEW: 101079599
NEW: 101079699
NEW: 101079799
NEW: 101079899
NEW: 101079999
NEW: 101080099
NEW: 101080199
NEW: 101080299
NEW: 101080399
NEW: 101080499
NEW: 101080599
NEW: 101080699
NEW: 101080799
NEW: 101080899
NEW: 101080999
NEW: 101081099
NEW: 101081199
NEW: 101081299
NEW: 101081399
NEW: 101081499
NEW: 101081599
NEW: 101081699
NEW: 101081799
NEW: 101081899
NEW: 101081999
NEW: 101082099
NEW: 101082199
NEW: 101082299
NEW: 101082399
NEW: 101082499
NEW: 101082599
NEW: 101082699
NEW: 101082799
NEW: 101082899
NEW: 101082999
NEW: 101083099
NEW: 101083199
NEW: 101083299
NEW: 101083399
NEW: 101083499
NEW: 101083599
NEW: 101083699
NEW: 101083799
NEW: 101083899
Ok.
Product Option Sync.
Opencart products: 25
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 = 27396
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27396,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101074799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1546
UPDATE oc_option_value_description
SET
name = '101074799 - ACRIL AMST 500ML BCO TITANIUM'
WHERE
option_value_id = 1546
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1546
DELETE FROM oc_product
WHERE
model = '101074799'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1546,
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 '101074899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1547
UPDATE oc_option_value_description
SET
name = '101074899 - ACRIL AMST 500ML PTO LAMP'
WHERE
option_value_id = 1547
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1547
DELETE FROM oc_product
WHERE
model = '101074899'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1547,
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 '101074999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1548
UPDATE oc_option_value_description
SET
name = '101074999 - ACRIL AMST 500ML AMA PRIMARIO'
WHERE
option_value_id = 1548
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1548
DELETE FROM oc_product
WHERE
model = '101074999'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1548,
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 '101075099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1549
UPDATE oc_option_value_description
SET
name = '101075099 - ACRIL AMST 500ML VERMELHAO'
WHERE
option_value_id = 1549
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1549
DELETE FROM oc_product
WHERE
model = '101075099'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1549,
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 '101075199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1550
UPDATE oc_option_value_description
SET
name = '101075199 - ACRIL AMST 500ML VERM NAFTOL MED'
WHERE
option_value_id = 1550
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1550
DELETE FROM oc_product
WHERE
model = '101075199'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1550,
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 '101075299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1551
UPDATE oc_option_value_description
SET
name = '101075299 - ACRIL AMST 500ML TERRA SIENA TOSTADA'
WHERE
option_value_id = 1551
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1551
DELETE FROM oc_product
WHERE
model = '101075299'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1551,
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 '101075399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1552
UPDATE oc_option_value_description
SET
name = '101075399 - ACRIL AMST 500ML AZL ULTRAM VIOL'
WHERE
option_value_id = 1552
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1552
DELETE FROM oc_product
WHERE
model = '101075399'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1552,
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 '101075499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1553
UPDATE oc_option_value_description
SET
name = '101075499 - ACRIL AMST 500ML VDE PERM CLR'
WHERE
option_value_id = 1553
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1553
DELETE FROM oc_product
WHERE
model = '101075499'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1553,
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 '101075599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1554
UPDATE oc_option_value_description
SET
name = '101075599 - ACRIL AMST 500ML CYAN PRIMARIO'
WHERE
option_value_id = 1554
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 389
AND product_id = 27396
AND option_id = 17
AND option_value_id = 1554
DELETE FROM oc_product
WHERE
model = '101075599'
INSERT INTO oc_product_option_value
SET
product_option_id = 389,
product_id = 27396,
option_id = 17,
option_value_id = 1554,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.