Product Sync.
Opencart products: 27
Input products: 100
NEW: 101337099
NEW: 101337199
NEW: 101337299
NEW: 101337399
NEW: 101337499
NEW: 101337599
NEW: 101337699
NEW: 101337799
NEW: 101337899
NEW: 101337999
NEW: 101338099
NEW: 101338199
NEW: 101338299
NEW: 101338399
NEW: 101338499
NEW: 101338599
NEW: 101338699
NEW: 101338799
NEW: 101338899
NEW: 101338999
NEW: 101339099
NEW: 101339199
NEW: 101339299
NEW: 101339399
NEW: 101339499
NEW: 101339599
NEW: 101339799
NEW: 101339899
NEW: 101339999
NEW: 101340099
NEW: 101340199
NEW: 101340299
NEW: 101340399
NEW: 101340499
NEW: 101340599
NEW: 101340799
NEW: 101340899
NEW: 101340999
NEW: 101341099
NEW: 101341199
NEW: 101341299
NEW: 101341399
NEW: 101341499
NEW: 101341599
NEW: 101341699
NEW: 101341799
NEW: 101341899
NEW: 101341999
NEW: 101342099
NEW: 101342199
NEW: 101342299
NEW: 101342399
NEW: 101342499
NEW: 101342599
NEW: 101342699
NEW: 101342799
NEW: 101342899
NEW: 101342999
UPDATING: Galeria W&N 250ml
Product ID: 27392
Image file:
UPDATING: Galeria W&N 500ml
Product ID: 27398
Image file:
NEW: 101343299
NEW: 101343399
NEW: 101343499
NEW: 101343599
NEW: 101343699
NEW: 101343799
NEW: 101343899
NEW: 101343999
NEW: 101344099
NEW: 101344199
NEW: 101344299
NEW: 101344399
NEW: 101344499
NEW: 101344599
NEW: 101344699
NEW: 101344799
NEW: 101344899
NEW: 101344999
NEW: 101345099
NEW: 101345199
NEW: 101345299
NEW: 101345399
NEW: 101345499
NEW: 101345599
NEW: 101345699
NEW: 101345799
NEW: 101345899
NEW: 101345999
NEW: 101346099
NEW: 101346199
NEW: 101346299
NEW: 101346399
NEW: 101346499
NEW: 101346599
NEW: 101346699
NEW: Pebeo Artist 37ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pebeo Artist 37ml - %'
)
NEW: 101346899
NEW: 101347199
Ok.
Product Option Sync.
Opencart products: 28
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 '101343099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1574
UPDATE oc_option_value_description
SET
name = '101343099 - ACRIL GALERIA W&N 250ML IVORY BLACK 331'
WHERE
option_value_id = 1574
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 = 1574
DELETE FROM oc_product
WHERE
model = '101343099'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1574,
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
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101343199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1575
UPDATE oc_option_value_description
SET
name = '101343199 - ACRIL GALERIA W&N 500ML VERMILION HUE 682'
WHERE
option_value_id = 1575
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 = 1575
DELETE FROM oc_product
WHERE
model = '101343199'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1575,
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 = 27399
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27399,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101346799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1576
UPDATE oc_option_value_description
SET
name = '101346799 - ACRIL PEBEO ARTIST37 ML S3 MAGENTA DE QUINA 326'
WHERE
option_value_id = 1576
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1576
DELETE FROM oc_product
WHERE
model = '101346799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1576,
quantity = 1,
subtract = 1,
price = 2.358,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101346999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1577
UPDATE oc_option_value_description
SET
name = '101346999 - ACRIL PEBEO ARTIST 37 ML S1 MARS BLACK 105'
WHERE
option_value_id = 1577
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1577
DELETE FROM oc_product
WHERE
model = '101346999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1577,
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 '101347099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1578
UPDATE oc_option_value_description
SET
name = '101347099 - ACRIL PEBEO ARTIST37 ML S5 AZL CERULEO 550'
WHERE
option_value_id = 1578
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1578
DELETE FROM oc_product
WHERE
model = '101347099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1578,
quantity = 1,
subtract = 1,
price = 3.984,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.