Product Sync.
Opencart products: 14
Input products: 100
NEW: 100151599
NEW: 100151699
NEW: 100151799
NEW: 100151899
NEW: 100151999
NEW: 100152099
NEW: 100152199
NEW: 100152299
NEW: 100152399
NEW: 100152499
NEW: 100152599
NEW: 100152699
NEW: 100152799
NEW: 100152899
NEW: 100152999
NEW: 100153099
NEW: 100153199
NEW: 100153299
NEW: 100153399
NEW: 100153499
NEW: 100153599
NEW: 100153699
NEW: 100153799
NEW: 100153899
NEW: 100153999
NEW: 100154099
NEW: 100154199
NEW: 100154299
NEW: 100154399
NEW: 100154499
NEW: 100154599
NEW: 100154699
NEW: 100154799
NEW: 100154899
NEW: 100154999
NEW: 100155099
NEW: 100155199
NEW: 100155299
NEW: 100155399
NEW: 100155499
NEW: 100155599
NEW: 100155699
NEW: 100155799
NEW: 100155899
NEW: 100155999
NEW: 100156099
NEW: 100156199
NEW: 100156299
NEW: 100156399
NEW: 100156499
NEW: 100156599
NEW: 100156699
NEW: 100156799
NEW: 100156899
NEW: 100156999
NEW: 100157099
NEW: 100157199
NEW: 100157299
NEW: 100157399
NEW: 100157499
NEW: 100157599
NEW: 100157699
NEW: 100157799
NEW: 100157899
NEW: 100157999
NEW: 100158099
NEW: 100158199
NEW: 100158299
NEW: Galeria W&N 60ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Galeria W&N 60ml - %'
)
NEW: 100159399
NEW: 100159499
NEW: 100159599
NEW: 100159699
NEW: 100159799
NEW: 100159899
NEW: 100159999
NEW: 100160099
NEW: 100160199
NEW: 100160299
NEW: 100160399
NEW: 100160499
NEW: 100160599
NEW: 100160699
NEW: 100160799
NEW: 100160899
NEW: 100160999
NEW: 100161099
NEW: 100161199
NEW: 100161299
NEW: 100161399
NEW: 100161499
Ok.
Product Option Sync.
Opencart products: 15
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 = 27386
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27386,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100158399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1152
UPDATE oc_option_value_description
SET
name = '100158399 - ACRIL W&N GALER 60ML BUFF TITANIUM'
WHERE
option_value_id = 1152
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1152
DELETE FROM oc_product
WHERE
model = '100158399'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1152,
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 '100158499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1153
UPDATE oc_option_value_description
SET
name = '100158499 - ACRIL W&N GALER 60ML BURNT SIENNA OPAC'
WHERE
option_value_id = 1153
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1153
DELETE FROM oc_product
WHERE
model = '100158499'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1153,
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 '100158599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1154
UPDATE oc_option_value_description
SET
name = '100158599 - ACRIL W&N GALER 60ML CADMIUM RED MEDIUM 099'
WHERE
option_value_id = 1154
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1154
DELETE FROM oc_product
WHERE
model = '100158599'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1154,
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 '100158699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1155
UPDATE oc_option_value_description
SET
name = '100158699 - ACRIL W&N GALER 60ML CADMIUM YELLOW MED 116'
WHERE
option_value_id = 1155
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1155
DELETE FROM oc_product
WHERE
model = '100158699'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1155,
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 '100158799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1156
UPDATE oc_option_value_description
SET
name = '100158799 - ACRIL W&N GALER 60ML COBALT BLUE'
WHERE
option_value_id = 1156
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1156
DELETE FROM oc_product
WHERE
model = '100158799'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1156,
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 '100158899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1157
UPDATE oc_option_value_description
SET
name = '100158899 - ACRIL W&N GALER 60ML HOOKERS GREEN'
WHERE
option_value_id = 1157
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1157
DELETE FROM oc_product
WHERE
model = '100158899'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1157,
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 '100158999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1158
UPDATE oc_option_value_description
SET
name = '100158999 - ACRIL W&N GALER 60ML LAMP BLACK'
WHERE
option_value_id = 1158
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1158
DELETE FROM oc_product
WHERE
model = '100158999'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1158,
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 '100159099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1159
UPDATE oc_option_value_description
SET
name = '100159099 - ACRIL W&N GALER 60ML PERMAN ALIZARIN CRIMSON'
WHERE
option_value_id = 1159
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1159
DELETE FROM oc_product
WHERE
model = '100159099'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1159,
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 '100159199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1160
UPDATE oc_option_value_description
SET
name = '100159199 - ACRIL W&N GALER 60ML RAW SIENNA OPAC'
WHERE
option_value_id = 1160
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1160
DELETE FROM oc_product
WHERE
model = '100159199'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1160,
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 '100159299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1161
UPDATE oc_option_value_description
SET
name = '100159299 - ACRIL W&N GALER 60ML VANDYKE BROWN'
WHERE
option_value_id = 1161
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1161
DELETE FROM oc_product
WHERE
model = '100159299'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1161,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.