Daily Uploads
How to send your daily inventory snapshot and what happens after it arrives.
Snapshot Rules
- Submit exactly one inventory file per day
- Each file must be a full snapshot of your current inventory
- Include all SKUs, all conditions, all locations
- Missing SKUs are treated as zero inventory
- Changes-only or delta files are not accepted
Submission Methods
However your data reaches us, it becomes one daily snapshot read through the column mapping you built during setup. Pick the one that matches where your inventory already lives.
Connected database
We query your SQL database read-only on a daily schedule — nothing to export and nothing to send. Best when your inventory lives in an ERP or warehouse system with a database we can reach.
Connected cloud source
Sign in once with Microsoft, Google, or Airtable and pick the workbook, sheet, or base that holds your inventory. We read it daily from the cloud. Best when your team maintains inventory in a spreadsheet or app rather than a database.
SFTP file drop
Drop your file into your dedicated SFTP folder and ConEquip polls for new files automatically. Best when your ERP or a script already generates an export on a schedule. Schedule your export for after business hours or around 11:00 PM ET to capture a full day's changes.
See the SFTP Setup guide for connection details.
Upload it yourself
Sign in and send us the file straight from your account — nothing to install and nothing to schedule. Best when someone on your team refreshes the numbers by hand anyway. Upload whenever you update them; most vendors send one file a day.
Your file is read on that night's sync. To see it sooner, use Process now on your Automation page.
Email Coming soon
Sending your inventory file as an email attachment is on the way. It isn't available yet — until it is, upload the file yourself or use a folder drop.
File Naming
If you send files over SFTP, keep your filenames the same every day — that's how we know which file is which when we read your columns. A steady name is all we need:
inventory_east.csv
If your export system puts the date in the filename and you can't change that, tell us during setup — we can configure your folder to read whatever turns up, whatever it's called.
Accepted formats: .xlsx and .csv. You label your columns once during setup, and SPS reads them that way from then on.
Sync Status Flow
Each upload moves through these stages:
If validation fails, the upload is marked as Failed and you'll receive an email notification with details.
Submission Window
Submit your daily inventory file between 12:00 PM (noon) and 11:59 PM Eastern Time (ET) each business day. Files received by midnight are processed overnight and live in our sales tools the next morning.
How the daily cycle works:
Your daily snapshot reaches us (connected source, SFTP folder, or email)
If your upload has errors, you'll be notified and can fix and re-upload before midnight
Once your upload is approved, our scheduled sync picks it up and pushes the changes into Odoo (our ERP)
Your inventory is live for ConEquip sales reps and customers on the website
Missed deadlines: If no file is received by midnight, you'll get an email reminder. Consistently missing uploads may reduce your visibility in our sales tools.
All times are Eastern Time (ET), which adjusts automatically for daylight saving time.