Inventory - Bulk update/import stock quantities
Ability to have bulk updates and import stock quantities into Xero.
Purpose: To save users time from having to adjust/update inventory one by one.

Thank you to everyone that contributed to the teams research in this space. We wanted to share that discovery for bulk updating stock quantities has been greatly insightful and we're pleased to share that we are moving forward to develop a solution.
We'll shift the idea to working on it as development begins, and as this moves along we'll return when there is more opportunity for you to get involved.
-
Scott Farrow commented
After having multiple Xero support hook ups about this issue it seems I was not alone. Not sure why Xero went through days of support just to send me to this thread. Whilst support were determined to help it seems they were none the wiser to this issue either?
If it is a known lack of ability in the system then I would suggest Xero specifically mentions this in the product pages so we don't go around in circles trying to work out what as users we might be doing wrong. Once Xero developers complete this vital function to bulk upload and adjust all inventory features, then tell us it is possible.
I also note it has been almost a year since the announcement it is being worked on. Come on Xero. You're a global company. Chop chop.
-
Alex McDonald commented
I forgot to mention that you are able to get a free 31 day trial to check out the app for free and we have intentionally kept our subscription as low as possible to make adoption a no brainer!
-
Alex McDonald commented
Whilst there may be a solution in the works, we have launched a way to make multiple adjustments to tracked inventory. Envy Stock Take provides a solution for managing multiple tracked inventory items in bulk. Check it out on the app store: https://apps.xero.com/!j744y/uk/app/envy-analytics#overview
Envy Stock Take is one module of our Evny Analytics suite (the other being Envy DI, dealinin with deferred income) where we are adding new modules to help tackle some of the more time consuming areas of Xero, trying to improve users quality of life of Xero users. Access to Envy Analytics gives you access to Envy Stock Take and Envy DI.
-
Merrilynn Howard commented
Hello Kelly,
As stocktake time nears, I am wondering how progress on this vital issue is going. I do not wish to waste the time required to go into every item and my bosses do not wish to pay overtime for this to happen either. Please help!
-
Jacobus Freysen commented
I am right in saying that you can do bulk Ventory importation of cost price and sales price, but not bulk stock quantity?
What is difference??
In the meantime we are forced to upload 2600 items manually, which is TIME consuming.
-
John Farmer commented
I keep getting emails from Xero about how to improve their inventory. The Inventory "system" in Xero is almost infantile. This is a prime example. It is unbelievable in 2025 that bulk inventory adjustments remain unavailable, particularly when users have been complaining (by this thread) for 3 years. It is not rocket science. Xero might as well say they do not have an inventory system as it is missing so many basic features as to be virtually unusable.
-
MIchael Carere commented
Hello,
Coming up 8 months since the last update on where this is headed. I understand a large amount of businesses wouldn't need this feature but for the ones that do, its entirely necessary to run. Even just being able to delete all current items recorded in stock then reuploading a new list of items would be a tremendous amount faster.
Is there any update on this?
Thank you,
Mike -
Mykonos Office commented
Hi Xero,
Any update on this? would be highly appreciated if this can get sorted out asap. we produce loads of items and every month there are cost prices which need to be adjusted. now we have to adj the stock on hand cost price per item. which is very time consuming.
-
Sarah Stewart commented
It would be great if the Inventory Item List Report that can be downloaded out of Products and Services, be updated with the new Unit Cost Price, Unit Sale Price and Quantity on Hand, and simply reimported once updated.
Crazy that it is not possible. I have tried doing it on the Inventory Items template, but it refused to reimport it, even though headings are correct and it is a CSV file. However, it still does not include the quantity of goods. -
Amit Ramani commented
I see that a bunch of XERO users have been requesting this feature (i.e. bulk update Inventory Quantity/Stock On Hand) via Export/Import.
Can you please treat this with urgency? This is the top issue that needs to be addressed -
Angela See commented
I have an accounts 2 years late. We want to mass upload sales n inventory sold. Pls contact me
-
George Tutt commented
This is really important
I am about to do my first stock take on Zero (NOT my first Stock Take!!) and am actually surprised that there is no way that you can post the adjustments from the stock take into Xero.
Please can this idea get pushed to the top of the list, it will make many users very happy and save tons of time.
Thanks
George -
David Salib commented
Can Xero Developers create a column in the CSV. inventory Item list to allow for "Quantity adjustments," then once its adjusted thru the CSV file we can then import it back into xero with the updated SOH (Stock on Hand)?
This would make really good sense to carry out a stocktake on products.
Not sure why this isn’t an option Xero?
Perhaps the developers need to look into this and make it possible, either within Xero ideally or if it can be done in the CSV. File where it has a column for quantity of stock on hand. SOH.
-
Ibrahim Hashmi commented
It is so ridiculous for product management to not consider this feature given the amount of product it can hold - 4000! For the love of god - introduce bulk import feature for people to adjust inventory quantities.
-
Sue Elliott commented
with 4000 lines we need this.
-
Paul King commented
We take a physical inventory each month and since we don't import certain classes of orders virtually ALL items have a monthly adjustment. Please make this update
-
Mel Hevey commented
my client needs to do each week as the warehouse staff are not accessing XERO yet - only adjusting usage in an excel SS
-
Axis IT Consulting commented
Yes please this is super critical.
-
James Cargill commented
Definitely! Becomes a nightmare everytime a client has a stocktake
-
Mark Yoshida commented
we need to be able to export and import SOH.