Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 1

trying to change inventory when it was set up wrong in beginning with out changing each item? Thanks

1 Comment
QuickBooks Team

trying to change inventory when it was set up wrong in beginning with out changing each item? Thanks

This depends on the component of the inventory, @learning2cope4939.

If you’re trying to change the inventory quantity in the program, you can import an inventory file to override and update the existing quantity of these items. Here's how:


  1. Click on the Gear icon, then choose Import Data.
  2. From the list, select Products and Services.
  3. In the Import Products and Services page, select the Browse button. (You can also download the sample file to see how the columns look like.)
  4. Find and select the Excel file, then select Open.
  5. Select Next to continue.
  6. Map your data. 
  7. Click on Next.
  8. Check the Overwrite all values for each product or service that you import with the identical name. (This can't be undone).
  9. Click on Import.
    Capture 1.PNG

On the other hand, if you’re trying to edit your product details just like cost price and selling price, you’ll need to do it manually. This adjustment will only affect the transactions moving forward. You can also reach out to your accountant for the best advice. This way, we can ensure that your bookkeeping is done correctly to reflect the appropriate prices at the right time.

Here’s how:


  1. Go to Sales.
  2. Select Products and Services.
  3. Locate the product you wish to edit.
  4. Select Edit under the Action column.
  5. Change the cost amount.
  6. Select Save and close.

You might want to visit this link to learn how to track inventory in QuickBooks Online. It provides data so you can manage the supply chain properly, and it enables successful cost control of operations.

Let me know by leaving a comment below if you still have questions about inventory. I'm always here to assist anytime.

Need to get in touch?

Contact us