Who Is Atlas Supply Co.?
Atlas Supply Co. is a wholesale distributor of industrial fasteners, fittings, and safety equipment serving contractors and maintenance teams across Texas. With 120 employees and three warehouses in Dallas, Houston, and Austin, they process approximately 450 orders per day across 3,800 active SKUs.
Their customer base—general contractors, plant maintenance managers, and municipal procurement offices—expects same-day or next-day delivery. In the industrial supply world, a stockout doesn't just mean a lost sale. It means a job site goes idle, a contractor misses a deadline, and Atlas Supply loses a customer to a competitor who had the part in stock.
Wholesale Distribution (industrial fasteners, fittings, safety equipment)
120 (65 warehouse, 30 sales, 25 operations & admin)
Dallas (HQ + main warehouse), Houston, Austin
QuickBooks Enterprise + Excel spreadsheets + standalone barcode system
Inventory, Sales, Purchase, Accounting, Barcode
What Happens When Three Warehouses Can't See Each Other?
Atlas Supply's technology stack had evolved organically over 12 years. QuickBooks Enterprise handled accounting and basic inventory. Each warehouse maintained its own Excel spreadsheet for stock counts. Sales reps checked availability by calling the warehouse or—more often—guessing.
The result was predictable:
- 12% stockout rate: One in every eight orders included at least one line item that couldn't be fulfilled from the assigned warehouse. Items were often sitting 200 miles away in another location, but nobody knew.
- 45 minutes per order: Sales reps spent an average of 45 minutes per order—checking availability across spreadsheets, calling warehouses, manually entering data into QuickBooks, and emailing pick lists to the floor.
- 78% inventory accuracy: Quarterly physical counts consistently showed a 22% discrepancy between system records and actual stock. That's not a rounding error—that's a broken process.
- No cross-warehouse visibility: Dallas couldn't see Houston's stock. Houston couldn't see Austin's stock. When a customer in San Antonio needed 500 hex bolts, the Austin rep had no way to know Dallas had 2,000 sitting on a shelf.
- Manual replenishment: Reorder decisions were based on the warehouse manager's gut feeling. "I think we're low on 3/8" carriage bolts" is not a procurement strategy.
At a 12% stockout rate with 450 orders/day and an average order value of $420, Atlas Supply was losing approximately $22,680/day in orders that either went unfulfilled, were partially filled, or were lost to competitors. Even assuming 60% of those orders were eventually recovered, the annual revenue leakage exceeded $3.3 million.
How Did Odoo Connect Three Warehouses Into One System?
The core of the solution was Odoo 18's multi-warehouse inventory management, combined with automated replenishment rules and the Barcode app for real-time stock tracking. Here's how each piece worked:
Every SKU shows real-time available quantity across all three warehouses. Sales reps see a single screen: "Dallas: 340 | Houston: 180 | Austin: 95." No phone calls. No spreadsheets. No guessing.
Each warehouse has SKU-level minimum and maximum stock thresholds. When Dallas drops below 200 units on a high-velocity item, Odoo automatically generates a purchase order or an inter-warehouse transfer request—whichever is faster based on configured lead times.
Orders are automatically routed to the warehouse closest to the delivery address with sufficient stock. If the nearest warehouse is short, Odoo splits the order or routes entirely to an alternate location—all without manual intervention.
Every receiving, picking, packing, and shipping operation requires a barcode scan. No more mental math. No more "I think I put that on shelf B3." Scan in, scan out, and the system stays accurate.
Sales orders flow directly into warehouse pick lists. Purchase orders update inventory on receipt. Accounting entries post automatically. One entry point, zero re-keying.
How Was a 3-Location Rollout Completed in 10 Weeks?
The implementation followed a hub-and-spoke approach: get the Dallas headquarters fully operational first, then replicate the configuration to Houston and Austin. This reduced risk and created an internal reference site for training.
| Phase | Weeks | Focus | Key Activities |
|---|---|---|---|
| 1 — Data & Config | 1–3 | Foundation | Product master import (3,800 SKUs), warehouse structure setup, vendor/customer migration from QuickBooks, chart of accounts mapping |
| 2 — Dallas Go-Live | 3–5 | HQ Warehouse | Barcode hardware deployment, pick/pack/ship workflow configuration, sales order integration, staff training (3 days on-site) |
| 3 — Houston Rollout | 5–7 | Warehouse #2 | Replicate Dallas config, physical inventory count, barcode deployment, local staff training (2 days on-site) |
| 4 — Austin Rollout | 7–9 | Warehouse #3 | Replicate config, physical inventory count, barcode deployment, local staff training (2 days on-site) |
| 5 — Optimization | 9–10 | All Locations | Replenishment rule tuning, inter-warehouse transfer routes, reporting dashboards, accounting reconciliation |
By going live in Dallas first, we created internal experts who helped train Houston and Austin teams. The Dallas warehouse manager became the strongest advocate for the new system—and when Houston staff had questions, they called Dallas instead of the implementation team. Peer credibility beats consultant credibility every time.
What Did the Numbers Look Like After 90 Days?
Atlas Supply tracked performance metrics weekly during the first 90 days. The before/after comparison tells the story:
| Metric | Before (QuickBooks + Excel) | After (Odoo 18) | Change |
|---|---|---|---|
| Stockout rate | 12% | 2.1% | -82% |
| Order processing time | 45 minutes | 8 minutes | -82% |
| Inventory accuracy | 78% | 99.2% | +27% |
| Orders processed per day | 450 | 620 | +38% |
| Cross-warehouse transfers | Manual (2–3 day delay) | Automated (same-day) | -90% lead time |
| Picking errors | 3.2% | 0.4% | -88% |
| Monthly accounting close | 12 days | 4 days | -67% |
| Annual operational savings | — | $340,000 | Net new |
The $340,000 in annual savings breaks down as follows:
- $156,000 — Labor savings from reduced order processing time (37 min saved × 450 orders/day × $0.85/min loaded labor cost)
- $98,000 — Recovered revenue from stockout reduction (9.9% improvement × estimated lost revenue)
- $52,000 — Elimination of QuickBooks licenses, standalone barcode system, and spreadsheet maintenance labor
- $34,000 — Reduced picking errors, returns, and re-shipments
The one-time implementation cost of $72,000 achieved full payback in under 11 weeks.
How Did Each Warehouse Perform Individually?
One advantage of the hub-and-spoke rollout was the ability to compare performance across locations at different stages of maturity. Here are the warehouse-specific metrics at the 90-day mark:
| Metric | Dallas (HQ) | Houston | Austin |
|---|---|---|---|
| Days live at 90-day review | 75 days | 55 days | 35 days |
| Inventory accuracy | 99.5% | 99.1% | 98.8% |
| Stockout rate | 1.8% | 2.2% | 2.4% |
| Avg. order processing | 7 min | 8 min | 10 min |
| Picking error rate | 0.3% | 0.4% | 0.6% |
| User adoption | 98% | 96% | 91% |
The pattern is clear: Dallas, having been live the longest, shows the best numbers across every metric. Houston is close behind. Austin, the newest site, is already outperforming the old system's best-case metrics—and improving weekly as the team builds proficiency.
The gap between locations narrows every week. By the 6-month mark, we expect all three warehouses to converge within 0.5% on accuracy and stockout metrics. The system is the same—the only variable is team familiarity, and that's self-correcting with time.