Forum Discussion

Altec's avatar
Altec
Experienced Cover User
4 years ago

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" but it only give me the option to increase the "last cost" price or the "average cost" price; not the 'Current Price"

 

I expect I could export, modify and import all prices.  Is there a better way to increase the Current Price by 7%?

  • 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.

  • Steven_M's avatar
    Steven_M
    Former Staff
    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

      Thank you, yes I did test that option yesterday and it works; albiet would have been quicker to be able to use the percentage markup option. 

      It's a pity the shortcut calculation method "percentage markup" doesn't have an option to update the base selling price.  I don't understand how it can be useful the way it is designed, but it must have some purpose I guess.

      Thank you for you assistance.

  • 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!

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.