nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adjust Inventory - Current Price

Altec

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%?

Find more posts tagged with

Accepted answers

Steven_M

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.

All comments

Altec

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.

Steven_M

Hi @Altec

Altec

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!