Part Imports

Part Imports

Part imports allow you to mass import new parts and mass update existing parts. Please read carefully and take your time. Not following the directions will undeniably lead to grief and heartache.

Step One: Create your spreadsheet.

Follow the steps below if you are adding new parts that do not currently exist in your HindSite database.

  1. Use the table below to format your spreadsheet.
  2. Make sure your spreadsheet does not contain more than one sheet.
    Because the spreadsheet will be saved as a text document later, all of the other sheets will be deleted.
  3. Once you have formatted your spreadsheet and added your new parts, select File, select Save As, select Browse, set the Save as type to Text (Tab delimited) (*.txt), save.

Optionally, export your spreadsheet from HindSite.

Follow the steps below if you are updating existing parts.

  1. Go to Maintenance > Products/Parts.
  2. Use the search fields to retrieve the list of parts you want to update.
  3. Select Export/Report
  4. Select the Browse button on the right to select the location you want to save the file to.
  5. Once you select the file location, select Save in the bottom right.

Step Two: Import your spreadsheet.

  1. Go to Maintenance, select Utilities, select Imports
  2. Open the drop-down menu and select Parts
  3. Select the Browse button (across from File Path) and find your tab delimited file. Select it and click Open.
  4. Once the file has been selected, select the Import button in the bottom right. HindSite will prompt you to take a backup, take a backup. Once the backup is completed, the import will begin.

Additional notes/guidelines

  • Each column title must be entered EXACTLY as shown below.
  • The only column title absolutely required is ITEM ID.
  • A part’s ITEM ID and ITEM NAME may be the same.
  • Use decimals instead of fractions (example: .25” instead of 1/4”) (for sorting)
  • All new parts must have a category.
  • If you enter a DIVISION name that doesn’t match exactly with what’s already in HindSite, then the import will create a new one. So watch for typos

Part Import Columns

Column Title Description


Product/Part ID
ITEM NAME Part Description
TAX Is this part taxable?
CAT The Category this part will be in
SUBCAT1 The 1st Sub Category this part will be in
SUBCAT2 The 2nd Sub Category this part will be in
PRICE What you charge the customer
COST The cost of this part to you
EST PRICE Price of this part on an estimate
DIVISION The division this part is assigned to
ACTIVE Active flag (use "I" to inactivate the part)
TO PDA If this part will be viewable in the field
QB FULLNAME Item's name in QuickBooks (use a colon for QB categories)

If you have any other questions, feel free to give us a call at our mainline (888) 752-5978, email us at or submit a ticket through our portal.

See attachment below for an example spreadsheet.