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.

Hi community, happy to share that we're in the midst of rolling out bulk adjustments! We've heard you, and appreciate that updating stock quantities 1 by 1 can be tedious especially when conducting a stock take.
With our new tool for bulk inventory adjustments you'll find finishing your stock takes faster, giving you more time back to do the things that matter.
Once available in your org, you'll be able to create, review and submit bulk inventory adjustments in-one-go, you can export and import items after a count, and you'll have an Adjustment History page where you can view historical adjustments.
If you don't quite have it just yet, look forward to seeing this soon 😊 I'll be back to confirm once it's live in all organisations. In the meantime you can read more about this feature on our blog.
-
Marvin Henshaw commented
This function isnt working. Do you have any issues with it ?
-
Shane Ham commented
Fantastic to see this has now been released onto at least one of my clients!!!
One thing I have noticed however and gives room for further improvement is that not all clients run stock adjustments through a single account code.
It would be great to have the ability to identify the account code for the adjustment in the table with the product items and not just in the header of the form.
Regardless this is a great step forward and a timesaver.
-
Bronwyn Stam commented
What would be handy is daily automatic stock updates from Square Retail to Xero. The same as how your daily sales are sent to Xero but include current stock quantities as well.
-
David Raymer commented
I'm moving to Xero from MYOB. I've exported my items from MYOB but don't understand why I can't just setup the column with the qty to be able to import them into Xero. It would make the transition so much easier but now I have to perform additional steps to do this or do I have to manually go into each item to update it?
I thought this would have been such a simple thing to do. MYOB enables quite a number of fields to be imported.
Also, why does it only allow CSV or TXT files and not spreadsheets to be imported? CSV files don't always format correctly so it requires more work to ensure they are correct. -
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