Skip to main content
July 17, 2019
Question

Im trying to import non-inventory items via an excel spreadsheet but theyre coming in as inventory?

  • July 17, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

July 17, 2019

Hello abefeig1,

 

Let's import your items again to verify the correct type.

 

  1. Click Gear, then click Import Data again.
  2. Click Products and Services. Then, Browse your Excel spreadsheets.
  3. Click Next.
  4. Map your fields with QuickBooks fields. Then, click Next.
  5. Make sure to select the correct Type.
  6. Put a mark next to the Overwrite all values for each products or service that you import with the identical name box.
  7. Click Import.

Once done, go back to your item lists to check your imported items. Just click Gear, and then Products and Services.

 

You can read this article for more information: Import products and services from Excel.

 

Here's a handy article in case you need further help: Manage inventory and projects for QuickBooks Online.

 

Please don't hesitate to reach out anytime if you have other questions.