Where is zip code 99999? A Piece of Clean Data Makes a Big Difference

February 25, 2020

5 min read

RESOURCES // BLOG

Has your company ever shipped a product to the 99999 zip code?

Of course not. It doesn’t exist. In fact, the highest real zip code is 99950, for Ketchikan, Alaska. Still, if you scour your database, there’s a good chance you’ll find more than a few 99999 zip codes. 

Most organizations find that it’s been entered as a placeholder in their shipment database. If shipments go as planned, what’s the problem? If your strategy calls for automating your processes, you’ll encounter serious challenges created by a lack of data accuracy. Let’s talk about how data becomes inaccurate and what you can do about it.

Dirty Data Drives Supply Chain Inefficiency 

Depending on the solutions in use, a database may fill in 99999 if no zip code is entered, or 99999 may have been entered rather than taking the time to look up the correct number. While a placeholder zip code may not be a fatal problem, it’s likely an indicator of deeper issues. That’s one reason industry experts estimate that data is faulty in 35 to 40 percent of supply chain systems.

For example, look at a company’s fundamental systems such as the Item Master, Customer Master and Vendor Master. They must be comprehensively reviewed and corrected. Basic data such as dimension and weights could be filled with default numbers. That means there’s been a lack of validation of the data that’s been input. The lack of accurate, clean data leads to expensive inefficiency through mistakes and a lot of manual handling. 

While individual data problems are not good, they are also a symptom of the more significant challenge of potentially suspect data. Without the right numbers as a baseline, it’s impossible to make accurate strategic decisions. If you’re looking at adding or repositioning distribution centers, rationalizing your product lines, or myriad other initiatives, clean data makes all the difference. 

Clean data is also essential for implementing automation, artificial intelligence and other emerging technologies. Poor data quality can lead to problems with carrier compliance, shipment tracking and predictive and prescriptive analytics. As shipments generate more and more data in real-time, quality data is essential. It’s also vital for decision-making and sharing with strategic partners to drive benefits across your shipping eco-system.

Solving the Dirty Data Problem

How do you correct the zip code 99999 problem in your company? 

The key is to evaluate the integrity of data collection and management programs continuously, not only against your internal requirements but also in relation to external demands. Does your organization have the capability to dig deep into your data collection and management programs, identify challenges and fix them with internal resources? Or will the organizational structures and culture prevent you from making the necessary changes? Third-party analysis may be required to identify the data issues that will derail your competitiveness.

To find out more about ensuring your organization is prepared for next-generation technologies, read our resource guide, AI, Blockchain, Machine Learning: Is Your Data Ready?

Related Tags

MEET THE AUTHOR

John Richardson

SUBSCRIBE

The Expert Lens

Weekly actionable advice to keep costs down and improve your transportation management.

Share:

Share on linkedin
Share on facebook
Share on twitter

Related Articles

BLOG

Expect elevated truckload shipping costs to continue through the second quarter of 2021. Fuel prices, capacity demands and carrier operating costs all add pressure on truckload shipping costs into the busy summer season for fresh produce and highway travel.

...

BLOG

Make sure you understand how North American transportation rates affect your business performance in 2021. Our transportation management experts share their forecasts, industry analysis and actionable guidance to support your strategy for Parcel, LTL, Truckload and International transportation.

...

BLOG

In my role at Transportation Insight, clients and prospects are constantly asking me the meaning of the acronyms. BOL, BOPIS, OTIF. I get a lot of questions around shipping terms like FOB Origin, Freight Collect.

...