Product Sync.
Opencart products: 26
Input products: 100
NEW: 101266299
NEW: 101266399
NEW: 101266499
NEW: 101266599
NEW: 101266699
NEW: 101266799
NEW: 101266899
NEW: 101266999
NEW: 101267099
NEW: 101267199
NEW: 101267299
NEW: 101267399
UPDATING: Galeria W&N 250ml
Product ID: 27392
Image file:
NEW: Galeria W&N 500ml
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 500ml - %'
)
NEW: 101268599
NEW: 101268699
NEW: 101268799
NEW: 101268899
NEW: 101268999
NEW: 101269099
NEW: 101269199
NEW: 101269299
NEW: 101269399
NEW: 101269499
NEW: 101269599
NEW: 101269699
NEW: 101269799
NEW: 101269899
NEW: 101269999
NEW: 101270099
NEW: 101270199
NEW: 101270299
NEW: 101270399
NEW: 101270499
NEW: 101270599
NEW: 101270699
NEW: 101270799
NEW: 101270899
NEW: 101270999
NEW: 101271099
NEW: 101271199
NEW: 101271299
NEW: 101271399
NEW: 101271499
UPDATING: Rembrandt 15ml
Product ID: 27397
Image file: Rembrandt 15ml.png
NEW: 101271699
NEW: 101271799
NEW: 101271899
NEW: 101271999
NEW: 101272099
NEW: 101272199
NEW: 101272299
NEW: 101272399
NEW: 101272499
NEW: 101272599
NEW: 101272699
NEW: 101272799
NEW: 101272899
NEW: 101272999
NEW: 101273099
NEW: 101273199
NEW: 101273299
NEW: 101273399
NEW: 101273499
NEW: 101273599
NEW: 101273699
NEW: 101273799
NEW: 101273899
NEW: 101273999
NEW: 101274099
NEW: 101274199
NEW: 101274299
NEW: 101274399
NEW: 101274499
NEW: 101274599
NEW: 101274699
NEW: 101274799
NEW: 101274899
NEW: 101274999
NEW: 101275099
NEW: 101275199
NEW: 101275299
NEW: 101275399
NEW: 101275499
NEW: 101275599
NEW: 101275699
NEW: 101275799
NEW: 101275899
NEW: 101275999
NEW: 101276099
NEW: 101276199
Ok.
Product Option Sync.
Opencart products: 27
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 = 27392
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101267499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1562
UPDATE oc_option_value_description
SET
name = '101267499 - ACRIL GALERIA W&N 250ML OLIVE GREEN 447'
WHERE
option_value_id = 1562
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1562
DELETE FROM oc_product
WHERE
model = '101267499'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1562,
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 '101267599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1559
UPDATE oc_option_value_description
SET
name = '101267599 - ACRIL GALERIA W&N 250ML CADMIUM RED HUE 095'
WHERE
option_value_id = 1559
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1559
DELETE FROM oc_product
WHERE
model = '101267599'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1559,
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 '101267699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1560
UPDATE oc_option_value_description
SET
name = '101267699 - ACRIL GALERIA W&N 250ML WINSOR BLUE 706'
WHERE
option_value_id = 1560
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1560
DELETE FROM oc_product
WHERE
model = '101267699'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1560,
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 '101267799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1561
UPDATE oc_option_value_description
SET
name = '101267799 - ACRIL GALERIA W&N 250ML CADIMUM YELLOW DEEP HUE 115'
WHERE
option_value_id = 1561
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1561
DELETE FROM oc_product
WHERE
model = '101267799'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1561,
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 '101267899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1563
UPDATE oc_option_value_description
SET
name = '101267899 - ACRIL GALERIA W&N 250ML RAW UMBER 554'
WHERE
option_value_id = 1563
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1563
DELETE FROM oc_product
WHERE
model = '101267899'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1563,
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 = 27398
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27398,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101267999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1494
UPDATE oc_option_value_description
SET
name = '101267999 - ACRIL GALERIA W&N 500ML TITANIUM WHITE 644'
WHERE
option_value_id = 1494
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1494
DELETE FROM oc_product
WHERE
model = '101267999'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1494,
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 '101268099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1495
UPDATE oc_option_value_description
SET
name = '101268099 - ACRIL GALERIA W&N 500ML CADMIUM YELLOW PALE HUE 114'
WHERE
option_value_id = 1495
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1495
DELETE FROM oc_product
WHERE
model = '101268099'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1495,
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 '101268199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1496
UPDATE oc_option_value_description
SET
name = '101268199 - ACRIL GALERIA W&N 500ML IVORY BLACK 331'
WHERE
option_value_id = 1496
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1496
DELETE FROM oc_product
WHERE
model = '101268199'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1496,
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 '101268299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1497
UPDATE oc_option_value_description
SET
name = '101268299 - ACRIL GALERIA W&N 500ML SAP GREEN 599'
WHERE
option_value_id = 1497
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1497
DELETE FROM oc_product
WHERE
model = '101268299'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1497,
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 '101268399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1498
UPDATE oc_option_value_description
SET
name = '101268399 - ACRIL GALERIA W&N 500ML RAW UMBER 554'
WHERE
option_value_id = 1498
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1498
DELETE FROM oc_product
WHERE
model = '101268399'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1498,
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 '101268499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1499
UPDATE oc_option_value_description
SET
name = '101268499 - ACRIL GALERIA W&N 500ML CADMIUM RED HUE 095'
WHERE
option_value_id = 1499
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1499
DELETE FROM oc_product
WHERE
model = '101268499'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1499,
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 = 27397
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101271599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1765
UPDATE oc_option_value_description
SET
name = '101271599 - OLEO REMB T6-15ML S5 CORES DIV'
WHERE
option_value_id = 1765
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 390
AND product_id = 27397
AND option_id = 17
AND option_value_id = 1765
DELETE FROM oc_product
WHERE
model = '101271599'
INSERT INTO oc_product_option_value
SET
product_option_id = 390,
product_id = 27397,
option_id = 17,
option_value_id = 1765,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.