Update Prices of the existing Item Codes

I wish to update the prices through the Item Master for the existing Item Codes. However, I am unable to do because the error shows up saying that “Duplicate Item”. how to fix this?


Prices for the existing item must be saved in the existing Item Price record. Instead of updating item, please consider over-writing selling rate in the Item Price master.

Thanks @umair

I tried this. however, it does not work when you are updating prices. Since prices correspond to specific product code in the excel sheet I have to use the column of the code as well as the column of selling rate. It will be great if you could elaborate on the steps to update prices for existing products through item master