Case Study: Locksmith Supply Company (LSC) achieves Epicor data access and improved company-wide decision-making with Phocas

Data consolidation and accessibility improve company-wide decision making

Locksmith Supply Company (LSC) is a 93‑year‑old security hardware distributor managing 20,000 stock lines. Facing the need to be more agile and customer‑centric, LSC needed to turn disparate ERP, SQL and payroll data into reliable, accessible insights so teams across sales, purchasing, HR and finance could make faster, fact‑based decisions.

LSC implemented Phocas, consolidating Epicor extracts, a SQL database and ADP payroll into nightly syncs and tailored dashboards administered by data engineer Gordon Howell. The result is company‑wide transparency and real‑time access—hourly sales updates, financial statements, inventory snapshots and drill‑downs for field account managers—boosting decision making, sales performance and overall competitiveness.

Locksmith Supply Company

Gordon Howell

Data Engineer