Inventory type not present when importing on Quickbooks Online

Tadeo · ‎April 14, 2020

Hello, this is on a new Quickbooks Plus account when trying to import my inventory:

After enabling inventory tracking:

I can add an "Inventory" type item on Products and Services/New page:

But when using "Import products and services" function I don't get "Inventory" as a Type option:

Because of this, "Inventory" type is marked as an invalid entry and the import fails:

I've already searched for an answer to my problem everywhere without success.

Thanks for your help!

Charies_M · ‎April 14, 2020

It's a delight to see your post today, Tadeo.

Nice screenshots! This helped me understand your concern better.

Let's review the imported inventory file and make sure you're able to use Inventory as your item Type.

Once done, you can re-import the file to see the changes. I'd be happy to guide you through the whole steps below:

Go to the Gear icon and choose Import Data.
Click Products and Services.
Hit Browse to select the file. Then, click Open.
Click Next.
From the Map Data window, review the fields, then click Next.
Form the Import window, you'll see the list of products ready to be imported. Review the Type and click Import.

I've added a screenshot for your visual guide. This is how your import process should look like:

To become more familiar with importing files in QBO, check out this guide: Import products and services from Excel.

Let me know if you have additional questions. Stay safe and have a great day ahead!

View solution in original post

Charies_M · ‎April 14, 2020

It's a delight to see your post today, Tadeo.

Nice screenshots! This helped me understand your concern better.

Let's review the imported inventory file and make sure you're able to use Inventory as your item Type.

Once done, you can re-import the file to see the changes. I'd be happy to guide you through the whole steps below:

Go to the Gear icon and choose Import Data.
Click Products and Services.
Hit Browse to select the file. Then, click Open.
Click Next.
From the Map Data window, review the fields, then click Next.
Form the Import window, you'll see the list of products ready to be imported. Review the Type and click Import.

I've added a screenshot for your visual guide. This is how your import process should look like:

To become more familiar with importing files in QBO, check out this guide: Import products and services from Excel.

Let me know if you have additional questions. Stay safe and have a great day ahead!

Tadeo · ‎April 14, 2020

Thank you so much Charies_M, problem solved.

Likewise, stay safe and have a great day!

LackMacM · ‎January 16, 2021

Hello,

Just found this post, I am having a similar issue however, Inventory is not a selectable option on the drop down menu. Only Service and Noninventory.

I tried to do fancy screenshots, but was unsuccessful

Any help would be great.

Thanks

JessT · ‎January 16, 2021

Hi LackMacM!

The inventory tracking feature is available in the QuickBooks Online Plus plan, and you'll want to enable it in the settings, so you can import your items. If you're not using the Plus plan, you can go to your Billing & Subscription page and upgrade your plan.

Enable to Inventory tracking feature in the settings:

Click on the Gear icon in the upper-right hand corner.
Choose Accounts and settings.
Go to Sales, then Products and Services.
Enable Track inventory quantity on hand.
Click Save and Done.

After this, you can import your inventory items using the steps that Charies shared. You can also check out the article she shared.

If you have other questions in mind, you can always go back to this thread.

Simon Stock · ‎January 19, 2021

I'm having the exact same issue when trying to Import Items with QuickBooks Online Plus, and I do have Track Stock on hand enabled. What else could I be missing?

JenoP · ‎January 19, 2021

Thanks for joining us in this thread, scstock.

Have you tried the steps provided in the earlier responses? If so, I would recommend reaching to our Chat Support Team for QuickBooks Online International. They can take a closer look at this to determine what's causing the issue.

Here's how:

Click Help in the upper right-hand corner of QBO.
Type in "support" or "contact support" and press Enter.
Select Contact Support Team.
Type in "support" or "contact support" again and press Enter.
Click No, I still need help.
Select Contact Support Team one more time.
Click Start a chat.

Don't hesitate to reach out to us again if you need anything else.

Simon Stock · ‎January 20, 2021

Yes, I had tried the previous steps.

Contact Support Team is not an option when I type support into the Help dialogue

LackMacM · ‎January 20, 2021

I worked out what i was doing wrong.

On the sample data, i hadn't scrolled enough to the right and found the stock on hand column. It needs to have a value for it to read the import. for me it was stock on hand qty = 0 all the way down. Worked like a charm

Simon Stock · ‎January 20, 2021

Support were very helpful - I had to use the Sample File as a starting point as for some reason QBO would not accept the word "Stock" from my file but did accept it from the sample file.