Migrating Your Inventory and Consignor Data Safely
October 26, 2026
Quick Summary: Migrating auction data to a new platform safely comes down to four habits: clean records before they move, map every field deliberately, run at least one test migration, and reconcile record counts and dollar totals before the first live sale. Active data (dealers, consignors, unsold units, open balances) migrates; years of closed sale history usually move to a read-only archive instead.
Your dealer list, consignor accounts, and open balances are the most valuable thing your legacy system holds. Lose a consignor's payable or a dealer's registration during a switch, and you're explaining it to them on sale day. The good news: most problems with migrating auction data to a new platform are predictable, and almost all of them can be caught before go-live.
What to Migrate, Archive, or Rebuild
Not everything in your old system deserves a seat in the new one. Migrating auction data to a new platform goes faster and cleaner when you sort it first.
| Data | Recommended handling | How to verify it moved correctly |
|---|---|---|
| Dealer registrations | Migrate active dealers | Count of active dealers matches; license numbers spot-checked |
| Consignor accounts | Migrate active consignors | Count matches; remittance details confirmed with the account owner |
| Unsold, if-sale, and no-sale units | Migrate with VIN, condition report, and status | Unit count by status matches; VINs validated |
| Open receivables and consignor payables | Migrate as opening balances | Dollar totals match to the cent |
| Title-pending units and open arbitrations | Migrate with notes and documents | Every open item accounted for by VIN |
| Closed sale and bid history | Archive read-only | Archive opens and searches correctly |
| Fee schedules and lane setup | Rebuild in the new system | Test invoices match old-system invoices |
How to Migrate Auction Data Without Losing Records
Step 1: Inventory Every Data Source
Your data rarely lives only in the AMS. List every source: the legacy database, title office spreadsheets, accounting software, your CRM, and the binders at the front desk. Anything left off this list gets left behind.
Step 2: Clean Before You Move
Merge duplicate dealer records (matching on dealer license number, not name), flag expired licenses, and retire inactive consignors. Validate every VIN: North American VINs are 17 characters, and the 9th character is a check digit that catches most typos.
Step 3: Map Every Field
Match each legacy field to its new home, field by field. Pay close attention to status codes. "If-sale" in one system may be stored as a note in another, and a wrong mapping quietly turns open units into sold ones.
Step 4: Run a Test Migration and Reconcile
Load a full copy into a test environment. Then run data reconciliation, meaning you prove the new data matches the old by comparing record counts, dollar totals, and a hand-checked sample of dealers and units. Fix what doesn't match, and run it again.
Step 5: Freeze, Load, and Reconcile Again
After your last sale on the old system, freeze changes, run the final load, and repeat every reconciliation check. Don't go live on totals that are "close." A balance that's off by a few dollars usually points to a missing record.
Step 6: Keep the Old Data Read-Only
Keep your legacy data as a read-only archive rather than deleting it. Title and transaction records may be subject to state record-retention rules, so confirm the retention period with your compliance counsel before anything is destroyed.
Protecting Data While It Moves
A migration is the one time your entire dealer and consignor file sits in an export file, so treat those files with care:
- Transfer exports over encrypted channels, never as spreadsheet email attachments
- Limit who can access export files, and delete temporary copies once reconciliation is signed off
- Re-confirm consignor banking details directly with the account owner, not from an imported field alone
For the controls that should protect that data after go-live, see how auction software protects buyer and seller data.
Frequently Asked Questions
Should we migrate all of our historical sale data?
Usually not. When migrating auction data to a new platform, move active records and open balances, and keep closed sale history in a searchable, read-only archive.
How do we know nothing was lost?
Compare record counts by category and dollar totals for receivables and payables between the old and new systems, then hand-check a sample of individual records.
Do dealers need to re-register after a migration?
Not if their registrations migrate cleanly. Dealers may still need to set up new login credentials on the new platform.
Who should own the migration on the auction side?
One person with authority over the data, often the office manager or controller, who signs off on mapping decisions and reconciliation results.
Move Your Data With Confidence
Migrating auction data to a new platform is easier when fewer systems are involved. Auction Streaming's CAMS3™ Cloud Auction Management System keeps auction management, simulcast, CRM, and the Digital Marketplace on one true-cloud platform, so your dealer and consignor records live in one place after the move instead of being split across vendors.
Contact our team to talk through what your data migration would look like.