Template Guide
The fields SPS needs, and what each one means — one row per SKU, condition, and location.
How to use this page. Each field below is something SPS stores about a part. During setup you point at the column in your own data that holds it. Use this page to see what a field means and whether it's required; the downloads give you a sheet with the columns already laid out.
Download Templates
A sheet with every column laid out, for building an export from scratch.
Use the template exactly and setup maps itself. When you pick your inventory file, worksheet or table during setup, SPS checks whether it follows this template. If it does, every field is mapped for you and you go straight to the review step. It counts as a match when:
- All your inventory is in one file, worksheet or table.
- The 10 required column headers below are spelled exactly as in the template, capitals included.
- Every Product Condition value is one of the approved conditions.
Optional template columns are picked up when they're there. For the surest match, include every template column and nothing else. If your data doesn't match, setup works exactly as before: you point at each column yourself.
Required Fields
| Column | Description |
|---|---|
| SKU | Your part number — this is the OEM Part Number (stable, unique per product) |
| Product Condition | The condition of the part. During setup you match each condition value in your data to an approved ConEquip condition. |
| Location Name | Location nickname (e.g., "Birmingham Warehouse") |
| Location Street | Street address |
| Location City | City name |
| Location State/Province | State or province |
| Location Zip/Postal Code | ZIP or postal code |
| Location Country | Country name |
| Quantity On Hand | Available quantity at this location for this variant |
| ConEquip Price (USD) | Your cost to ConEquip for this SKU/condition/location |
If a product appears in multiple conditions or locations, include one row per combination.
Optional Columns
| Column | Description |
|---|---|
| List Price/MSRP (USD) | Retail/MSRP price |
| Product Category | Highly encouraged. Product type or description (e.g., "Seal Kit", "Hydraulic Pump", "Thermostat"). Helps distinguish parts when the same OEM part number appears across different manufacturers. |
| Alternate Part Numbers | Strongly encouraged. Pipe-delimited list of cross-reference numbers (e.g. OEM part numbers, equivalent SKUs from other manufacturers). Buyers searching by OEM number won't find your part otherwise — and your Data Score includes a Cross-references tile that reflects how many of your products carry this signal. |
| Superseded by | Replacement SKU if this part is superseded by a newer one. Counts toward the same Cross-references signal as Alternate Part Numbers — either column is sufficient. |
| Makes/Models | Pipe-delimited pairs: "Make, Model|Make, Model". Connecting a data source instead of uploading? Make and model can also be two separate columns, mapped on two steps. |
| Image Name | Product image filename(s), filename only (no folders or URLs — use the Image URL column for hosted links). Pipe-delimit multiple images: SKU-001.jpg|SKU-001-alt.jpg. Filenames need a staged file, so this column is for SFTP vendors uploading the template directly: stage each file to the assets/images/ folder in your SFTP root before (or alongside) your data sync. If you connected a source through the setup wizard (SQL, Excel, or a mapped SFTP folder), neither image column can be mapped yet — talk to us and we will load your photos separately. Files missing at fetch time are recorded as failed and do not block the sync. Once SPS has picked up an image, the source file is removed from your SFTP folder automatically — you don't need to keep them around after they're picked up. |
| Image URL | An alternative to staging files on SFTP: a direct, public image link (Azure Blob, Dropbox, Google Drive, or any https:// URL). Pipe-delimit multiple links. SPS fetches each link and runs it through the same normalize-and-store pipeline as SFTP images. Links must be direct/public — Dropbox and Google Drive share links are handled automatically, but OneDrive/SharePoint links are not yet supported. A link that can't be reached is recorded as failed (visible under Images in your portal) and does not block the upload. You may use Image Name, Image URL, or both. Both columns are read from the uploaded template only; a source connected through the setup wizard cannot supply either one yet. |
| Shipping Included | True/False |
| Core Charge | Core charge amount in USD — include this if your parts have a core return charge (common for reman parts) |