Import Non-Inventory Part

Pre-Conditions:

Make sure the following conditions are met before importing:

• ✅ Use the Non-Inventory Part template.
• ✅ The Name* and Quantity* fields are required.
• ⚠️ Do not include column headers in your Excel file.
• ⚠️ Remove any duplicate records—they will still be imported but as separate entries.
• ⚠️ Check for bad or incorrect data (like typos or missing values), as this can cause the import to fail.

Template Tip: Only fields marked with an asterisk (*) are required.

NON-INVENTORY PART IMPORT TEMPLATE

The following columns are required:

• Name*
• SKU
• Sales Description
• Sale Price
• Cost
• QTY*
• Vendor

How to Import Non-Inventory Part

1. Go to:
   Settings > Integrations > Import List > ACTIONS > Import Non-Inventory Part

2. Upload Your File:

• A window will pop up.
• Select your timezone.
• Click Upload, then choose your prepared Excel file.

3. Map Your Fields:

• Match the columns in your file to the corresponding fields in IndusTrack.
• Click Save.

4. Wait for the Upload to Complete:

• The status will change to COMPLETE once done.
• For large files, this may take some time.

5. Check the Import Status:

• Click the three dots next to the import status.
• Select Details.
• Confirm the number of All Rows matches the Successful Rows.

6. Spot Check:

• Go to Settings > Inventory > Inventory List.
• Verify that the data was imported correctly.

If the Import Fails

• If there’s bad data, some rows won’t be uploaded.
• In the Details tab, you’ll see:
  • The line number of the error.
  • The data from that line.
  • A description of the error under the Error tab.

Fixing Import Errors

1. Click Export Errors to download the list.
2. Open the file and find the issues.
3. Correct the errors in your original Excel file.
4. Re-upload the corrected file using the same steps.