You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
Home > How to Import Using Transaction Pro Importer > Desktop Importer > Importing Group Items into QuickBooks using Transaction Pro Importer
Importing Group Items into QuickBooks using Transaction Pro Importer
print icon

Often times, a business will set up Group Items in QuickBooks Desktop (QBDT) to simplify the data entry for multiple Items that are frequently sold together. This enables the person creating the form to enter the name of the Group Item and allow QB to fill in the details for all the Items in that Group.


This article explains how to import Group Items in QBDT using Transaction Pro Importer.


Below are some rules to help pre-plan a Group Item import:


  1. All items in the Group Item must exist in QBDT pre-import. Please note that an Item List import type can be used to create new Items, if necessary, prior to importing the Group Items.
  2. A Group Item name cannot be used that is already being used as an Item name.
  3. The import file should be ordered by the Group Name. For instance, all the Items in one Group should appear sequentially in the import file.

On the first screen of Importer, select the import file, select ITEM GROUP as the import type, and then select the NEXT button.



The File Contents screen displays the contents of the import file in a grid format. Review the data and once done, select the NEXT button.



On the mapping screen, the required fields will be highlighted in red: Group Name, Group Line Item Name, and Group Line Item Qty. Map the import file columns to the appropriate QUICKBOOKS FIELDS. Once the mapping is completed, select the SAVE AS button and save the map. Click NEXT to continue.



The next screen below depicts how the data will be matched to the various QB fields. Review and select the NEXT button.



On the last screen of Importer, this screen must be completed even if Importer will not be creating new Items. Make any selection and then select the FINISH button to begin the import.



2 out of 6 found this helpful

scroll to top icon