How to update a pricelist using 'import from excel'
I tried to update item prices for part of a pricelist using 'import from excel'
I managed to update the prices for specified items, however the barcodes for those items were also deleted at the same time.
Any idea why this happened?
my excel table had four columns as follows:
Column A: item code
Column B: pricelist code
Column C: price
Column D: currency
when I tried to update with headers it would not work. Even a blank row at the top would not work. For some reason when I put 1's in each cell of the first row the update worked but at the same time the barcodes for those items disappeared.
why did this happen and is there any other data that could have been deleted?