What Is a Customer Hierarchy in SFA
A customer hierarchy is a structured representation of the relationships between different account levels within a single retail or distribution organisation. It maps how outlets connect to each other and to the entities that control their purchasing, credit, and commercial agreements.
In SFA, the customer hierarchy is not just an organisational chart. It is an operational data structure that determines how orders roll up, how credit is managed, how targets are assigned, and how key account managers relate to field reps.
What a Customer Hierarchy Looks Like
Section titled “What a Customer Hierarchy Looks Like”The simplest way to understand a customer hierarchy is to follow a retail chain through its account levels.
A national supermarket chain operates through a head office that negotiates commercial terms at the brand level. Below the head office may be regional buying hubs or area management structures. Below those are individual store locations where field reps make visits and capture orders.
In SFA, this is represented as a parent-child account tree:
- Level 1 - Head Office: The top-level account holding commercial agreements, credit limits, and key account management relationships
- Level 2 - Regional Node: An intermediate account representing a cluster of stores, used for reporting and regional ordering
- Level 3 - Individual Outlet: The leaf-level account where visit activity, orders, and execution data are captured
Not all hierarchies are three levels deep. A simple chain with no regional layer is two levels. A complex national distributor with multiple business units may be five or six levels deep.
Why Customer Hierarchy Matters in SFA
Section titled “Why Customer Hierarchy Matters in SFA”Credit Management
Section titled “Credit Management”Credit limits are often set at the head office level but must be visible at the outlet level when a rep is capturing an order. If the head office account has exceeded its credit limit, the SFA system needs to know that this restriction applies to every child outlet within that hierarchy - not just to orders placed directly with the head office.
Without hierarchy data, credit management becomes fragmented. Individual outlet accounts accumulate receivables independently, and the consolidated exposure to a single retail group is not visible until a finance team manually aggregates the data.
Consolidated Reporting
Section titled “Consolidated Reporting”A field manager reviewing territory performance needs to see how a retail chain is performing as a whole, not just how individual stores are performing in isolation. The hierarchy enables this consolidation: total orders, revenue, scheme activation rate, and compliance scores roll up automatically from outlet records to the chain level.
This consolidation is particularly important for key account managers who own the commercial relationship at the head office level. When negotiating with a chain’s buying team, they need performance data across all stores within that chain - not just aggregate totals.
Target Assignment
Section titled “Target Assignment”Some organisations assign sales targets at the key account or chain level, then distribute them to individual outlets. SFA uses the hierarchy to perform this cascade automatically, allocating outlet-level targets based on each store’s historical share of the chain’s total volume.
Key Account and Field Rep Coordination
Section titled “Key Account and Field Rep Coordination”In organisations with both key account managers and field reps, the hierarchy clarifies who owns what. The key account manager handles the head office relationship: commercial terms, promotional calendars, credit disputes. The field rep handles outlet execution: visits, orders, compliance checks, and scheme activation.
SFA uses the hierarchy to connect both roles to the same account structure. Key account managers can see field execution data from every outlet within their chain. Field reps can see the commercial terms and active promotions negotiated at the head office level.
How SFA Stores and Uses Hierarchy Data
Section titled “How SFA Stores and Uses Hierarchy Data”Each account in the SFA system carries a parent account reference. This reference is what creates the tree structure. When a field rep pulls up an outlet visit record, the system knows which chain the outlet belongs to, which regional node it sits under, and which head office account holds the commercial relationship.
This hierarchy reference is used throughout the system:
- When an order is captured at the outlet level, it rolls up to regional and head office totals automatically
- When a credit hold is placed at the head office level, it propagates to all child outlets
- When a scheme is activated through a key account negotiation, it appears in the visit task list for every outlet within that hierarchy
Managing Hierarchy Changes
Section titled “Managing Hierarchy Changes”Retail hierarchies are not static. Chains acquire competitors and absorb their outlet networks. Stores open and close. Regions are restructured, creating new intermediate account levels or eliminating existing ones.
Each of these events requires a corresponding update in the SFA hierarchy. A new outlet opening within an existing chain must be created as a child of the correct parent, inheriting the chain’s credit terms and commercial agreements. An outlet closure must be deactivated without orphaning its historical order data.
Acquisitions are more complex. When a retail chain acquires another, the acquired chain’s outlets need to be re-parented to the acquiring chain’s head office - or a new intermediate hierarchy node may be needed if the acquired chain continues to operate under its own brand with separate commercial terms.
Maintaining an accurate hierarchy is an ongoing operational discipline, not a one-time setup task. Organisations that treat hierarchy maintenance as a continuous process keep their SFA reporting, credit management, and key account coordination functioning correctly as the retail landscape changes around them.