Winning a National Government Contract by Solving Home Hardware's Data Fragmentation Problem

The Opportunity

Home Hardware is a dealer co-operative with over 1,000 independently owned stores across Canada. The brand was pursuing a national standing offer to supply building materials to CORCAN (Corrections Canada’s construction and rehabilitation enterprise), the Department of National Defence, Border Services and Fisheries and Parks Canada. The federal government’s Buy Canadian mandate put Home Hardware in a strong position to compete.

Atkinson Home Hardware, our Kingston client with locations in Kingston and Hartington, was a key part of driving the bid forward. Winning the contract would mean new government supply work flowing through Home Hardware dealers across the country, including Atkinson’s local stores.

The catch was the technical requirements of the RFP.

The Challenge

Home Hardware’s co-op structure is its strength as a retailer and its obstacle as a bidder. Every store operates independently, using its own point-of-sale and lumber management software. Profitmaster is common across the network, but implementations differ. Pricing, product codes and data structures vary from one dealer to the next.

The CORCAN RFP required a publicly accessible, standardized retail price list by commodity category, updated on a defined schedule. There was no way to meet that requirement by extracting a report from a single system. The data lived in dozens of independent systems across dealers coast to coast, in different formats, with no shared structure.

Standard Home Hardware systems offered no path forward. The contract would have to be declined, or the problem would have to be solved from scratch.

What We Built

Acadian designed and built a three-stage Retail Price Hub:

Stage 1 — Data ingestion. We wrote scripts to pull raw pricing data from multiple POS and lumber management systems used across the participating dealer network. Each data source had its own format, field names and quirks. The ingestion layer handled all of them.

Stage 2 — Normalization engine. Raw data passed through a cleaning and standardization pipeline that mapped every source field to a single, RFP-compliant schema. Pricing was validated, commodity categories were assigned consistently and edge cases were flagged for review rather than silently dropped.

Stage 3 — Auto-publishing. The normalized output published automatically to a government-compliant public pricing website on the required schedule. The site met all technical and accessibility requirements of the standing offer documentation.

The entire system ran without manual intervention after the initial configuration was complete.

The Result

Home Hardware submitted their bid with the technical requirements fully met. The national standing offer was awarded.

For Atkinson, the impact was direct and local. As part of the winning dealer network, their Kingston and Hartington stores are now fulfilling government supply orders for their region. Marc Atkinson estimates the contract will generate several million dollars in new annual revenue for their operations, supporting local jobs in the communities they’ve served for decades.

The Retail Price Hub continues to run, keeping pricing current and compliant with the standing offer terms.

---

“The CORCAN bid was a massive undertaking with zero room for error. We had to combine data from independent dealers across the country into a single format, something our standard systems just couldn’t do. Chris and the team at Acadian stepped in and built the custom pricing hub we needed in record time. We simply wouldn’t have been able to navigate the technical requirements of this contract without them.”

— Marc Atkinson, Vice President, Atkinson Home Hardware