Validation & Errors

What gets checked when you upload a file, and how to fix common issues.

What Gets Checked

Every row in your file is validated against these rules:

  • Required fields present — SKU (OEM Part Number), Product Condition, Location fields, Quantity, Price must not be empty
  • Valid condition values — Product Condition must match an approved ConEquip condition (see list below)
  • Numeric values — Quantity must be a whole number ≥ 0; Price must be a number ≥ 0
  • Relational integrity (relational template only) — all identifier references must resolve to existing rows

Note: Validation runs on every row. Even one invalid row blocks the entire upload from being approved. Fix all errors and re-upload.

Approved Product Conditions

The Product Condition field must match one of these values exactly (case-sensitive):

New Genuine OEM contracted another manufacturer
New OEM New part from OEM dealer
New OEM Surplus New OEM part for surplus distribution
New Replacement New aftermarket, meets OEM specs
New Takeoff New OEM part from unused component
Reconditioned Used, cleaned, worn parts replaced
Reman Exchanged Remanufactured, requires core return
Reman Outright Remanufactured, no core required
Resealed Only seals replaced

Common Errors & Fixes

Missing required field: SKU

Fix: Ensure every row has a value in the SKU column (your OEM Part Number). Check for blank rows at the bottom of your spreadsheet.

Invalid product condition: "New"

Fix: Use the exact approved condition name. "New" should be "New OEM", "New Replacement", etc.

Invalid numeric value for Quantity On Hand

Fix: Quantity must be a whole number (no decimals, no text). Check for currency symbols or commas in the number.

Invalid numeric value for ConEquip Price

Fix: Price must be a plain number (e.g., 1895.25). Remove "$", commas, or any text.

Unresolved reference: Location Identifier "L999"

Fix: (Relational template) The Location ID referenced in Variant Stocks doesn't exist in the Locations sheet. Add the missing location or fix the ID.

Tips for Clean Uploads

  • Download our template files and test with a few rows before building your full export
  • Check for trailing blank rows in your spreadsheet — these create "missing required field" errors
  • Copy condition values directly from the approved list to avoid typos
  • Use the upload detail page in the portal to see exactly which rows have errors and why
Daily Uploads SFTP Setup