Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to update a pricelist using 'import from excel'

Hi All

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?

Thanks J.R.

Former Member
Not what you were looking for? View more on this topic or Ask a question