Template Guide
One single-sheet template holds everything — one row per SKU, condition, and location. Export it as CSV or XLSX, whichever your system produces.
Download Templates
Flat Template — Required Columns
| Column | Description |
|---|---|
| SKU | Your part number — this is the OEM Part Number (stable, unique per product) |
| Product Condition | Must use an approved ConEquip condition value |
| 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" |
| 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. Each file must be uploaded to the assets/images/ folder in your SFTP root before (or alongside) your data upload. Files missing at fetch time are recorded as failed and do not block the upload. 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 upload. |
| 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. |
| 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) |