Cannot import Excel Item List into Product/Service without quantity on hand

Hello, @sychan.

Let me explain further about importing Products and Services in QuickBooks Online (QBO). 

You're unable to import the list without quantity on hand because this is one of the important information while importing in QBO. I'd suggest importing the inventory list again with the quantity on hand then adjust the number right after. 

Before diving in, we'll have to keep in mind that once a list is imported, it can't be undone anymore. Also, we can only import a maximum of 1,000 rows at a time. I recommend splitting up your list into smaller files if it's longer than that. 

To know more about the process, check out this article: Import products and services from Excel.

Once you've done importing, let's open Products & Services to override the number. Please note that QuickBooks Online automatically records appropriate adjustments to your stock Asset and Cost of Goods Sold (under stock Shrinkage) accounts.

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 o to be edit, 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 a different inventory report to check the stock, status, and the best seller item. For more information, visit this article: 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. 

• Set up and track your inventory
• Fix negative inventory issues

I'm just a post away if you should have any questions. Have a lovely day.

Hello @vpcontroller 

Thanks for your advice. Tested and worked!

I will complete the rest of the product master.

SY

Thanks @MichelleBh 

In fact user @vpcontroller offered a smart solution to work around.

SY

Don't you think it's pretty stupid that we can't import with 0 quantity? Don't you think that Quickbooks should fix this issue instead of just offering a time-consuming work-around?

Thanks for joining this conversation, @cmoss1919.

Allow me to chime in and help ensure this is taken care of for you.

Though the option the import item list from Excel with no quantity is currently unavailable, you can follow the workaround shared by vpcontroller above to enter "0" in the quantity field instead of blank.

I can see how having this option would be helpful for you and your business. I highly suggest sending feedback directly to our product developers. They're always looking for ideas to consider on how to improve QuickBooks.

Here's how to submit feedback:

1. In QuickBooks Online (QBO), go to the Gear icon at the top, then click Feedback.
2. Enter your comments or product suggestions. Then select Next to submit feedback.

For further guidance with managing and importing item lists from Excel or Google Sheets to QBO, consider checking out this article: Import products and services into QuickBooks Online.

Once done, you can always run a report to keep track of your inventory. Refer to this article for more information: Use reports to see your sales and inventory status.

I also recommend visiting our website for more tips and other resources you can use in the future: Self-help articles.

Please post again or leave a comment in this thread if you have follow-up questions about this or anything else QuickBooks. I'm always here to lend a hand. Take care.

I am creating a NEW company.  We just ordered inventory and I am setting up QBO to prepare.  I had to create product list with quantity =1 for every SKU.   Then batch adjust every SKU back to zero.  Now I'm stuck with an "Inventory Shrinkage" charge automatically generated by QBO.   Arggg ..................... this is really broken Intuit !

We want to ensure that your experience is better than this.

I have some information about the inventory shrinkage that's showing up on your end.

When you save the inventory adjustment, QuickBooks Online automatically records the appropriate adjustments to your stock Asset and Cost of Goods Sold (under stock Shrinkage) accounts.

We can enter inventory adjustment entries to fix this. This can have a significant impact on your accounting, so if you're unsure, I strongly recommend contacting your accountant.

For more information, please utilize this link: Adjust inventory quantity on hand in QuickBooks Online.

Additionally, I will be providing you with the following articles to assist you in managing your inventory in QBO:

• Set up and track your inventory in QuickBooks Online
• Get alerts for low or out-of-stock products.

Feel free to inform me if you have any further concerns about inventory shrinkage. I'm available to help you. Take care!