Matrix pricing, three branches, an ERP that actually fits.

Summary

An Australian-owned industrial-trade supplier of nearly four decades — industrial and hospitality gases, PPE, workwear, power tools, abrasives, height-safety gear — running three regional branches, ISO 9001 certified, supplying fabrication, construction, and manufacturing clients statewide. Their Jiwa ERP needed to carry customer-specific pricing matrices, default-supplier automation, a gas-supplier data feed, and daily multi-branch sales reporting. Still active.

Context

A mid-market distribution business at this shape runs on pricing rules that look simple from a distance and aren't. Every customer sits in a pricing band. Every branch has its own stock reality. Every product category has a default supplier the sales team can override but usually doesn't need to. The reporting has to reflect daily sales across three branches, reconciled against supplier-side data for the major gas partnership. Standard Jiwa covered part of it; the custom surface covered the rest.

What was built

• Twenty-seven Jiwa plugins

  Spanning pricing matrices, default-supplier logic, and the operational UI injections the sales floor and back office use every day.

• Twenty-eight SQL scripts

  Covering reporting, reconciliation, and data-quality audits across the three-branch footprint.

• Gas-supplier integration

  Keeping product, pricing, and availability data in step with the external partner's feed.

• Daily sales reporting

  Branch, customer, and product-category breakdowns delivered overnight rather than rebuilt at month-end.

• SQL Agent job suite

  Handling the overnight reconciliation, report generation, and data-integrity checks.

Outcome

Pricing consistency across three branches. Default-supplier selection made automatic, with manual override where it's needed. Month-end reporting becomes a daily delta, not a rebuild. The engagement is still active — plugin and reporting work has continued through 2025.