Product Sync.
Opencart products: 24
Input products: 100
UPDATING: Cotman W&N Pastilha
Product ID: 27395
Image file:
NEW: 100993199
UPDATING: Galeria W&N 250ml
Product ID: 27392
Image file:
NEW: 100993499
NEW: 100993599
NEW: 100993699
NEW: 100993799
NEW: 100993899
NEW: 100993999
NEW: 100994099
NEW: 100994199
NEW: 100994299
NEW: 100994399
NEW: 100994499
NEW: 100994599
NEW: 100994699
NEW: 100994799
NEW: 100994899
NEW: 100994999
NEW: 100995099
NEW: 100995199
NEW: 100995299
NEW: 100995399
NEW: 100995499
NEW: 100995599
NEW: 100995699
NEW: 100995799
NEW: 100995899
NEW: 100995999
NEW: 100996099
NEW: 100996199
NEW: 100996299
NEW: 100996399
NEW: 100996499
NEW: 100996599
NEW: 100996699
NEW: 100996799
NEW: 100996899
NEW: 100996999
NEW: 100997099
NEW: 100997199
NEW: 100997299
NEW: 100997399
NEW: 100997499
NEW: 100997599
NEW: 100997699
NEW: 100997799
NEW: 100997899
NEW: 100997999
NEW: 100998099
NEW: 100998199
NEW: 100998299
NEW: 100998399
NEW: 100998499
NEW: 100998599
NEW: 100998699
NEW: 100998799
NEW: 100998899
NEW: 100998999
NEW: 100999099
NEW: 100999199
NEW: 100999299
NEW: 100999399
NEW: 100999499
NEW: 100999599
NEW: 100999699
NEW: 100999799
NEW: 100999899
NEW: 100999999
NEW: 101000099
NEW: 101000199
NEW: 101000299
NEW: 101000399
NEW: 101000499
NEW: 101000599
NEW: 101000699
NEW: 101000799
NEW: 101000899
NEW: 101000999
NEW: 101001099
NEW: 101001199
NEW: 101001299
NEW: 101001399
NEW: 101001499
NEW: 101001599
NEW: 101001699
NEW: 101001799
NEW: 101001899
NEW: 101001999
NEW: 101002099
NEW: 101002199
NEW: 101002299
NEW: 101002399
NEW: 101002499
NEW: 101002599
NEW: 101002699
NEW: 101002799
NEW: 101002899
NEW: 101002999
Ok.
Product Option Sync.
Opencart products: 24
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 = 27395
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100993099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1525
UPDATE oc_option_value_description
SET
name = '100993099 - AGUAR W&N COTMAN PASTILHA YELLOW OCHRE 744'
WHERE
option_value_id = 1525
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 388
AND product_id = 27395
AND option_id = 17
AND option_value_id = 1525
DELETE FROM oc_product
WHERE
model = '100993099'
INSERT INTO oc_product_option_value
SET
product_option_id = 388,
product_id = 27395,
option_id = 17,
option_value_id = 1525,
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 = 27392
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100993299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1514
UPDATE oc_option_value_description
SET
name = '100993299 - ACRIL GALERIA W&N 250ML BCO TITANIUM 644'
WHERE
option_value_id = 1514
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 = 1514
DELETE FROM oc_product
WHERE
model = '100993299'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1514,
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 '100993399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1515
UPDATE oc_option_value_description
SET
name = '100993399 - ACRIL GALERIA W&N 250ML MARS BLACK 386'
WHERE
option_value_id = 1515
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 = 1515
DELETE FROM oc_product
WHERE
model = '100993399'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1515,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.