If you would like to upload your inventory list, you will need to download the sample template attached below.
The following fields are available in the template:
- Brand Name (Required)
- Part Name (Required)
- Part Number (Required)
- Alternate Part Number
- Description
- Part Type (1 = Part, 2 = Tire, and 5 = Battery) (Required)
- BIN #
- Quantity in Stock (you can enter 0) (Required)
- Minimum Quantity
- Maximum Quantity
- Unit Cost (can not be $0 or blank) (Required)
- Retail Price (can not be $0 or blank) (Required)
- Tire Model
- Tire Width
- Tire Ratio
- Tire Diameter
- Tire Construction
- Tire Load Index
- Tire Speed Rating
- Tire Type
- Tire Mileage Warranty
- Tire Load Range
- Tire Category
- Tire Run-Flat
- Tire Side Wall Style
- Tire Treadwear
- Tire Traction
- Tire Temperature
Please do not add or rearrange the columns in the template, as this may cause delays in the upload process.
Below are some examples of how the data will appear inside of Tekmetric after the template has been imported.
Inventory View:
Repair Order/Estimate View:
Key:
1 – Brand 4 – Description 7 – BIN
2 – Name 5 – Unit Cost 8 – Quantity
3 – Part Number 6 – Retail Price 9 – Unit Type
Once you fill out the template, you will email it to your Customer Onboarding Manager to get it uploaded. Please note, if this is part of your data migration, please let your onboarding specialist know you do not want to migrate any inventory from your legacy shop management system.
Note: If you do not format your inventory list correctly, some data (some parts) will not be migrated correctly, and you will have to manually clean up your data.