Skip to main content
June 16, 2022
Question

Importing Products with Zero Balance

  • June 16, 2022
  • 1 reply
  • 0 views

I'm trying to import my inventoru products list from Excel but it won't import products I list as zero on hand. If I do it manually it will allow it. Any tricks to getting it to work? 

1 reply

June 18, 2022

Welcome to QuickBooks Online, the @Electric lady.

 

I recognize this is important to you. Let me explain how to import Products and Services into QuickBooks Online further (QBO).

 

You're unable to import the list if you don't have the quantity on hand because this is one of the most required information to have when importing in QBO. I'd recommend importing the inventory list again with the quantity on hand, then adjusting the number immediately afterward.

 

Before we begin, note that once a list has been imported, it cannot be changed. In addition, we can only import 1,000 rows at a time. If your list is longer, I recommend separating it into smaller files.

 

Here's how: 

 

  1. Go to the Gear icon at the top. 
  2. Select Product& Services. 
  3. Put a check on those inventories that need to be edited, then click the Batch drop-down and choose Adjust Quantity
  4. Hit Save and close

 

For the detailed guide, please refer to this article: Adjust inventory quantity on hand.

 

You can always open another inventory report to check the stock, status, and best-selling item. Visit this article for more information: Use reports to see your sales and inventory status. 

 

Additionally, I've attached helpful articles about how to add inventory items and resolve the negative amount. 

 

 

I'm just a post away if you need help with your inventory items. Have a lovely day.