TMS Go-Live, Month One: Clean Your Carrier Master Data First

Let me tell you a story. Winter of 2019, I was sitting in my cab outside a food distribution center in Dallas, waiting to get loaded. The warehouse had just gone live on a brand-new TMS, and the young dispatcher inside was about to cry. The system had over three hundred carrier profiles, and half the phone numbers were dead. The rate tables were three years old. A carrier that had been blacklisted was still getting loads assigned by the system. I waited from noon until dark — five hours — before my trailer finally got loaded. That dispatcher took close to a hundred phone calls that night, all carriers asking one question: "So how much does this load actually pay?"

After fifteen years on the road, I've seen this movie too many times. When a TMS go-live blows up in the first month, it's usually not the software's fault. It's the carrier master data. Garbage in, garbage out — and no software license is expensive enough to survive that.

Why Carrier Data Is Always Dirty

This isn't the frontline team's fault. Carrier master data is one of those things nobody maintains until the day it bites you.

First, people move on, but the phone numbers don't. The traffic manager listed as the contact left two years ago. His number is disconnected. Emails bounce into a black hole. The dispatcher ends up cold-calling around to find out who actually runs the account now.

Second, the rate tables are fossils. The TMS auto-tenders at the rate stored in the system, which was negotiated three years back. The carrier shows up, looks at the number, and says: "I haven't run at that rate in three years." The load stalls. The dispatcher renegotiates by phone. The fancy TMS becomes a very expensive paperweight.

Third, nobody maintains the blacklist. A carrier with a damage claim history or a string of complaints changes its name, swaps in a new contact person, and waltzes right back into the system. Nobody remembers the blacklisting until something goes wrong — then everyone asks, "Wait, weren't they banned?"

Fourth, one carrier, three identities. Sales entered "ABC Logistics," customer service entered "ABC Logistics Inc.," and accounting entered "ABC-Logistics Co." — same company, three profiles. Come settlement time, nothing matches, and people are arguing at midnight over spreadsheets.

Cleaning It Takes Three Passes — No More

I've watched warehouses spend three or four months "cleaning data" and never finish, because they tried to boil the ocean. It takes three passes. That's it.

Pass one: verify contacts. Export every carrier profile and call each one. Does the phone ring? Is the contact still there? Is there an emergency number? Focus on carriers you've done business with in the past year and flag the rest. It's tedious — and you'll be shocked how many dead numbers and departed contacts you find.

Pass two: reconcile the rates. Ask every active carrier for a current rate sheet. Freeze everything expired in the system — mark it red, lock it out of auto-tendering. One rule: the system only holds rates you can actually use today. Archive the history somewhere else.

Pass three: sort the black and white lists. Which carriers are truly off-limits, and which are your core partners? That decision belongs to the business owner, not IT. IT can't tell you who's reliable on the road. Your dispatchers can.

What Dirty Data Actually Costs You

People grumble that data cleanup is a hassle. Let me show you what skipping it costs.

A mid-sized warehouse burns one to two dispatcher hours every single day just "finding people" — calling dead numbers, asking around in group chats for someone's phone number, renegotiating rates the system got wrong. Over a month, that's dozens of hours of skilled labor poured down the drain. Dispatchers are paid by the hour. That money is gone.

Worse is the cost of a bad tender. One load goes to a blacklisted carrier, something happens on the road, and the shipper's claim eats months of margin. Or the rate doesn't match, the carrier adds a surcharge on the spot, and the boss has no choice but to swallow it. A few of those "silent losses" a year, and your TMS investment is money down the drain.

Here's the before-and-after from a California warehouse, straight from their dispatch supervisor — a guy named Lao Li I've known for years:

Your numbers will differ, but the direction won't: clean data is what makes the system actually work.

The Counterintuitive Bit: Don't Clean Everything — Clean the Top 20% First

Here's what most people get wrong. They try to scrub all five or six hundred carrier profiles at once, take three months, and the go-live still crashes on day one. My advice is counterintuitive: don't clean everything. Clean the high-frequency 20% first.

Eighty percent of your loads run through about twenty percent of your carriers. Get those core carriers' contacts, rates, and payment terms spotless, and the system runs fine from day one. The long tail — carriers you use once or twice a year — can wait. Clean them gradually, as you use them.

One more thing: don't let IT do this behind closed doors. Dispatchers talk to carriers every day. They know who's reliable, who pads the bill, whose phone number changed. Bring dispatchers into the cleanup, and give them a dead-simple "report bad data" channel — one click when they spot something wrong. Data is alive. One cleanup pass won't keep it clean forever; somebody has to watch it every day.

Three Pieces of Advice for Shippers and Warehouses

First, for shippers about to go live on a TMS: a month before launch, export your carrier profiles and take a hard look. How many dead numbers? How many expired rates? If the data isn't clean, it doesn't matter how good the vendor demo looked — day one will be a mess.

Second, for warehouse managers: don't outsource the cleanup to people who don't know the business. The business decides the black and white lists. Dispatchers do the verification. It's unglamorous work, but it's the foundation everything else sits on.

Third, for my fellow dispatchers: when you spot a wrong record in the system, report it — don't just work around it. The dead number you tolerate today is the one you'll be cursing at tomorrow when you can't reach anyone.

A TMS is a good tool, but it trusts data, not people. Feed it clean data and it's your best helper. Feed it garbage and it's just a pricier spreadsheet — and a worse one.

There's an old saying: sharpening the axe doesn't delay the woodcutting. Spend that first month getting the data clean, and the next twelve months take care of themselves.

By Shifu Zhao, Trucking Veteran (15 yrs)