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.
-
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.