Is it possible to bulk import groups of items in QuickBooks Point of Sale?

I am trying to create several thousand groups of items in QuickBooks Desktop Point of Sale Multistore Version 18.0 R6.

The items already exist in Point of Sale. The names of each group and the items within them are already documented in an Excel spreadsheet.

I would like to know if there is a way to import this huge amount of data directly into Point of Sale without directly inputting each group by hand. Thank you.


Hello there, k.x

Thank you for reaching out to me here in the Community.

In QuickBooks Desktop Point of Sale (POS), you can import a large amount of data, including your groups of items.

Since the data is ready on the Excel file, you can import up to 65,000 rows at a time. Please make sure the following reminders for a smooth import using Excel:

  • There should be no dashes in empty excel fields
  • Remove empty rows and columns
  • Delete hidden columns
  • Don't use formulas, hyperlinks, and special characters for example: @,#,$,%,&,*
  • Use “clear contents” instead of deleting info separately

Before importing your data, let’s create a backup copy of your company file. This way, it will protect your file from data loss.

Once done, you can set up and import data to POS. Here’s how:

  1. Go to the File menu in QuickBooks Desktop POS.
  2. Select Utilities, then choose Import.
  3. From the Data Import Wizard, choose Next.
  4. Select the type of data to import then select Next.
  5. Select Default template on how you want to import the data and open the Import Template.
  6. Choose Next and follow the prompt.
  7. After the import wizard checked the import file, choose Import.
  8. Close the wizard.
  9. To check for any errors, you can go to File, then select Utilities and choose View Data Import Log.  

For more information, you can check out this article: Import and Export Overview

That will do it, k.x. I’d encourage commenting below if you have other concerns while working in POS, I’ll be glad to help. Have an awesome day!

Was this answer helpful? Yes No
Default user avatars original
IntuitRaymondJay , Community Support Specialist
Employee SuperUser

No answers have been posted

More Actions

People come to QuickBooks Learn & Support for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach:

Qb community
Looking for advice from other business owners?

Visit our QuickBooks Community site.