Inventory - Option to automatically update purchase price when buy new product
Ability to have an option to automatically update purchase price on the item when users buy the same new items.
Purpose: To save time from having to manually update each item price when there’s a different price on the same new items.

Thanks for your comments and emphasis on the bills side of things for the idea here. I've made sure this is shared with our team in this space.
Bills is an area we're continuing to develop with building on beautiful and I'll be sure to let you know here if there's any consideration made to change behaviour of this through the bills add and edit flow.
-
Luisa Magao commented
We have prices that constantly fluctuate and it is very time consuming to have to constantly update the price item by item. Very frustrating. I agree with Riaan would have expected it to be a standard - or at least have the option to turn this on or off as needed.
-
Riaan Badenhorst commented
This is something I expected to be standard. If the system update the "on hand", why not the cost price?
-
John Bryan commented
Hi Kelly
That still requires us to remember that an item has changed at the point where we sell it. What we need to be able to do is easily record that the cost has changed at the point when we BUY it.
-
Katie Manns commented
Hi Kelly, it is more critical to be able to edit the inventory items from the Bills so that when we enter a Bill from our supplier if the cost of the inventory item has increased (as has been happening due to inflation) then we can quickly and easily update the sales price in the inventory so that we can maintain the correct margin on our products. Can you please extend the edit function from invoicing into bills as well.
-
Edward Henry FIPA FFA commented
It's not the ability to edit from new invoicing, but rather when the items are purchased ie from a bill, that it is important to update the cost.
-
Libby Owen commented
We really need the ability to edit inventory straight from bills. I'm double handling things and it leads to mistakes and inaccuracies when I'm invoicing. Please consider making this change!
-
Amanda Hubley commented
It would be better if the products were able to be edited from Quote documents. Since we almost always start with a Quote. This is in response to being able to edit items from invoice lines.
-
Emma Rosenblatt (Accounts) commented
Hi @Kelly, I still don't think this solves our issue. Firstly, you have only addressed items we invoice but not items we are billed for. If we are uploading bills into the system and they include items that we track, then there is no way for us to update the pricing of each item like you are suggesting we do in the "new invoicing"...This option of automatically updating prices when creating invoices and bills are both important, but I do feel like most of us are referring to bills.
Another issue with inventory is when I assign items to a project from a bill why does it not take it out of stock or show anywhere in the inventory section that items are allocated to a project? I feel like assigning items to projects is only half doing the job. Yes, an expense "a dollar value" is charged to the project by doing this action, but nothing about it affects the stock count. From what I understand the only time we can affect the stock count is once the item has been invoiced, but, if materials are being used to make an item then technically they are no longer in stock or for better words they have been allocated to a job. Or the items were delivered before the bill was entered into Xero and the purchased items are already being used...If I wait until invoicing an item before stock is affected then this is not an accurate or true representation of stock count...Also my company will never invoice each individual item because that would create a 100+ line item invoice. A product bundle system would work much better where many items make 1 product.
-
Emma Rosenblatt (Accounts) commented
Not having this feature takes away the autonomy of Xero. Our stock controller is very frustrated that prices do not update automatically when billed for a different amount, prices for us are almost always changing, nothing stays the same price for very long.
-
Katie Manns commented
This would be amazing, especially paired with the ability to set a standard markup or margin so that when you entered a bill that saw the cost price on an item had increased then it automatically updates the sales price in inventory according to the standard margin or makeup set.
-
Udo Systems Accounts commented
I need different price points for bulk buys! manually entering and remembering these is painful and time consuming.
the only thing MYOB has over Xero.
Min Max system would also be great to help with stock control.
Thank you!
-
Kellie Galati commented
Yes this is critical. I can buy things one week and a few weeks later and continually changing price. If I have 10's of items on the bill and have to update after that is extremely tedious. If we could have the ability to update on the purchase order and our the bill/ invoice and this is updated in products and services. That would save so much time
-
Leonie Williamson commented
Yes, please add this feature as the current climate is seeing the prices changing constantly. I have also found that in the change over from MYOB the prices did not come across and I thought that when I entered cost price when entering a bill that it would update. But unfortunately not so I am having to do it manually. Very frustrating.
-
Kellie Galati commented
I totally agree, I have to highlight my invoices to keep aside for when I have finished, then go into products and services and update each line individually. Would be so much easier if when changing price on purchase order or bill/invoice for a line item, it updates for those products in inventory.
-
Emma Rosenblatt (Accounts) commented
Please add this feature! And sales price too please.
Having to do this manually is way too time consuming and almost becomes pointless. XERO advertises itself as an automated admin solution, yet it fails to automate this simple feature???
Another thing MYOB has over XERO...
-
Libby Owen commented
Bill - Edit inventory item from bill.
It's great that we can now edit an inventory item from invoices. But I often need to edit an inventory item when I receive a new bill and its cost has increased.
COULD YOU PLEASE ADD AN EDIT INVENTORY FEATURE WHEN EDITING A NEW BILL.
That way I can update cost price and sale price as they change straight from the new bill page instead of having the new bill page open and the products and services page open in another tab. -
Lisa Beech commented
Our buying prices are constantly increasing and our purchasers consistently purchase the same products so automatic increase in sale price would be fantastic.
-
Nataliia Konopinska commented
And sales price update too
-
Igor Bozalo commented
its amazing how XERO has a bunch of simple functions that are missing and would make life a lot easier. coming from MYOB (which has its own issues) there is a number of features that make MYOB a lot easier to operate
-
Ben Kampschoer commented
Essential for an imports based business. Purchase price is dependent on AUD which is constantly changing.