Imports
      Back to home
      1. Help Center
      2. HindSite Solution
      3. Imports

      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

      ITEM ID

      		 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 Support@HindSiteSoftware.com or submit a ticket through our portal.

      See attachment below for an example spreadsheet.