Skip to content
← For small businesses

Enter your idea

For small businesses: Business features

Categories

(thinking…)

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.

47 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminXero Team (Admin, Xero) shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
working on it  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

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. 

Show previous admin responses (2)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Sarah Stewart commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    I have an accounts 2 years late. We want to mass upload sales n inventory sold. Pls contact me

  • George Tutt commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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.

  • Paul King commented  ·   ·  Report

    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  ·   ·  Report

    my client needs to do each week as the warehouse staff are not accessing XERO yet - only adjusting usage in an excel SS

  • James Cargill commented  ·   ·  Report

    Definitely! Becomes a nightmare everytime a client has a stocktake