Forum Discussion

Altec's avatar
Altec
Experienced Cover User
4 years ago
Solved

Adjust Inventory - Current Price

I have to increase the price of approx. 90% of my inventory "current price" soon and am investigating the best method to do this.   I have found the shortcut calculation method "percentage markup" ...
  • Steven_M's avatar
    Steven_M
    4 years ago

    Hi Altec 

     

    I would recommend taking a look at Help Article: Bulk update item prices. This outlines a process in which you can export the information out of AccountRight, update it in Excel or another application, and then importing it back in to update that information.

Altec's avatar
Altec
Experienced Cover User
4 years ago

To add to this post:

I need to update the "Base Selling Price" only.

After further investigation I expect the best way to do this is to export data (via copy to clipboard and copy to excel) from the Items list, which correctly displays the "sell price".  Then use excel to calculate 7% and round to the nearest 5c; then manually enter the new price into the "Set Item Prices > Current Price" field.  Run the report again and use excel again to compare them to make sure I haven't made any mistakes.

If you have any better suggestions, I am truly open to them.....there are 774 active items (although there is a small percentage that do not need to be updated); and I have to get this done so that all invoices that go out the next day are at the new price (and still work a 12 hour day to get my regular work done!)  wish me luck!