cancel
Showing results for 
Search instead for 
Did you mean: 
sychan
Level 4

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

I am setting up new company product master.  I am trying to import the Item List (using excel template) but QBO not allowing the import due to no "Quantity on Hand".  However, I wish to set up the item details only, starting the inventory at Zero qty, and will create Purchase Order for the kick off inventory.  Any suggestions how to proceed.  Thank you.

Solved
Best answer September 20, 2020

Best Answers
vpcontroller
Level 11

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


@sychan wrote:

I am setting up new company product master.  I am trying to import the Item List (using excel template) but QBO not allowing the import due to no "Quantity on Hand".  However, I wish to set up the item details only, starting the inventory at Zero qty, and will create Purchase Order for the kick off inventory.  Any suggestions how to proceed.  Thank you.


@sychan 

 

Great idea. That's how to proceed with creating a new inventory list in QBO.

Quantity on Hand is a required field so if you enter "0" (not blank) as a new starting point on your spreadsheet, it should import.

 

I hope this helps!

 

View solution in original post

8 Comments 8
MichelleBh
Moderator

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. 

 

 

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

vpcontroller
Level 11

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


@sychan wrote:

I am setting up new company product master.  I am trying to import the Item List (using excel template) but QBO not allowing the import due to no "Quantity on Hand".  However, I wish to set up the item details only, starting the inventory at Zero qty, and will create Purchase Order for the kick off inventory.  Any suggestions how to proceed.  Thank you.


@sychan 

 

Great idea. That's how to proceed with creating a new inventory list in QBO.

Quantity on Hand is a required field so if you enter "0" (not blank) as a new starting point on your spreadsheet, it should import.

 

I hope this helps!

 

sychan
Level 4

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

Hello @vpcontroller 

 

Thanks for your advice. Tested and worked!

I will complete the rest of the product master.

 

SY

 

 

sychan
Level 4

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

Thanks @MichelleBh 

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

 

SY

cmoss1919
Level 1

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

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?

FritzF
Moderator

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

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.

hahnsburg
Level 1

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

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 !

Rubielyn_J
QuickBooks Team

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

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:

 

 

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

Need to get in touch?

Contact us