From 6 Disconnected Tools to One Custom ERP
PNW Components was managing their growing B2B distribution business across Shopify admin, spreadsheets, email threads, and manual processes. We built them a custom ERP platform that unified dealer management, inventory, and operations — starting with the module that hurt most.
PNW Components • Ongoing partnership (started Q3 2025)
The Problem
What PNW Components was dealing with before we started.
Dealer relationships tracked across spreadsheets, email, and Shopify admin — no single source of truth
Manual tier calculations for 200+ dealers, taking hours each month
Inventory visibility scattered across multiple systems with no real-time view
Sales team couldn't see dealer purchase history, tier status, or engagement in one place
Reporting required pulling data from 6 different sources and stitching together manually
No way for dealers to self-service their account status or tier progress
What We Built
A modular ERP platform purpose-built for PNW's B2B distribution workflow. We started with the CRM module (the biggest pain point), then expanded to inventory management, and connected everything to a data warehouse for reporting.
Custom CRM
Dealer management built around PNW's specific sales process — tier tracking, purchase history from Shopify, engagement scoring, and bulk operations.
Inventory Module
Real-time inventory management integrated with Shopify, with data grid editing, category management, and supplier tracking.
Tier Progress Dashboard
Automated nightly sync of dealer tier data to Shopify customer metafields, powering a self-service tier progress page on the B2B storefront.
Data Warehouse
BigQuery integration via Fivetran for cross-system reporting and business intelligence.
Our Approach
We started with a discovery phase mapping PNW's actual dealer workflow — not what a generic CRM assumed it should be. The CRM module launched first and delivered immediate value. Inventory came next. Each module was designed to stand alone while connecting seamlessly to the others. The platform continues to evolve as PNW's needs grow.
# Modular build order
Phase 1 ── CRM Module ✓ shipped
Phase 2 ── Inventory Module ✓ shipped
Phase 3 ── Tier Dashboard ✓ shipped
Phase 4 ── Data Warehouse ✓ shipped
Phase 5 ── Finance Module ◌ planned
── Purchasing Module ◌ plannedResults
6+
Disconnected tools consolidated
100%
Dealer visibility in one platform
Automated
Tier calculations and storefront sync
Real-time
Inventory across all channels
Tech Stack
Modern, proven technologies chosen for reliability and developer velocity.
Want Results Like These?
Every business is different, but the approach is the same — start with the biggest pain point and build from there.