Inventory - Option to automatically update Purchase Price from bills
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.
-
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.
-
Aaron Garozzo commented
REMEMBER PRODUCT PRICE CHANGES
Let's say you have a product you sell, and when last purchased, its cost was $5.00. Now you have purchased it 2 months later and it's cost is now $10.00, when you enter that bill, Xero should recognise that product is now costing $10.00 and change it in your inventory so it remembers it next time you enter that same part number... Instead of having to edit the price every time you enter an invoice with that same product - even just a pop up box when you close the invoice that says something along the lines of "the price for (part # & description) has changed, would you like to update this" and the user can select yes if it's a price increase from supplier or no if it's a once-off price difference.
It's such a simple thing that could be changed. It adds so much time to invoicing, especially when entering parts that aren't whole numbers (e.g. 1.7, 2.5, 3.9, etc. as you have to calculate the cost per whole unit, divide it by the quantity and then adjust the price... every time)
Also, another suggestion in-line with this one. Can you make it when entering a bill, that you can edit the "Amount" column on the far right (so just enter the total value). That way, you can have your quantity set and then enter the total value amount, and Xero can calculate the cost per unit (and once again, prompt you if this price has changed from previous entries.
Thanks,
Aaron -
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.
-
Kaori Nishioka-Lopez commented
Option to update purchase(sales) item prices to be updated.
It would be nice to have the above function than manually going to items after entering purchase invoices and update one by one or import, when suppliers have increased their prices. -
Ian Forsyth commented
I have a client with well over 2000 items and the prices change regularly - particularly now since supply chains have been disrupted and fuel / transport costs etc. Having to go back and manually update the price is too time consuming so it remains undone which is not good as stock valuations are then incorrect.
-
Lisa Woodcock commented
This would also be great if it could show on selection a date for last price change as things are moving so rapidly at the moment, you would know if you needed to check for a price increase before quoting customer.
-
Ebony Lacey commented
Our inventory items have increased in price numerous times over the last couple of years so it would be great if this was a priority. The double entering just isn't efficient.
-
Natasha Hamlet commented
For all items i purchase I leave the purchase price on the product record as 0.00 because the costs fluctuate, then i input with each invoice.
I wouldnt want the sales prices to be updated across repeating invoices if I raise the price on the product record. Our customers have contracts stating their prices and just because i raise the price for new customers, doesnt mean i want it to be raised on the existing ones.