Skip to main content
Jul 17, 2019 12:58 AM UTC
Question

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

Original commenter did not share additional details

1 reply

Jul 17, 2019 2:18 AM UTC

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.