Customers and points of sale
A reference of wholesale customers and stores: code, type, channel, region, payment terms.
What the template is for
The order book, receivables, allocation to stores.
- What one row is
- one row = a customer or a point
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Customer or point code | code | Text | yes | unique in the file |
| Name | name | Text | yes | not empty |
| Type | type | List value | yes | wholesale, own store, platform, franchise |
| Channel | channel | List value | yes | a value from the reference book |
| Region | region | List value | no | a value from the reference book |
| Payment term, days | terms | Integer | no | an integer not below 0 |
| Credit limit excl. VAT | limit | Number | no | a number not below 0 |
| E-document operator | edo | Text | no | operator name; check roaming |
Example rows
| Customer or point code | Name | Type | Channel | Region | Payment term, days | Credit limit excl. VAT | E-document operator |
|---|---|---|---|---|---|---|---|
| C001 | Store A | wholesale | multi-brand | MSK | 30 | 3,000,000 | op1 |
| ST07 | Own store 7 | own store | retail | SPB | 0 | 0 |
The example data is illustrative: an exercise, replace it with your own.
Note
Do not include personal data of individuals: for consumers keep only a pseudonymous identifier.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Customer concentration: share of the largest
- RFM segments from your customer table
- CRM coverage: how many sales and customers you can see and reach
- Customer credit limit and wholesale receivables aging
- Bonus points liability and breakage
- Early-payment discount: annual rate
- Acquisition payback with returns
- Cohort retention: curve, churn and cohort LTV
Documents that need this data
- CRM analytics: RFM, cohorts, retention, LTV/CAC, loyalty
- Market pyramid: segments, markups and business model
- Wholesale documents: pre-order, ship window, chargebacks, EDI/ASN
- Management balance sheet
- Customer service: SLA, FCR, claims and consumer rights
- Consolidation of several legal entities, intercompany and transfer pricing
- CRM chains and the loyalty program: triggers, frequency, consents, tiers, points lifetime and payback by cohort
- Franchise: lump-sum fee, royalty, standards and franchisee economics
- Marketing channels in Russia: Telegram, VK, MAX, Dzen, Rutube, Yandex Direct, bloggers and placements, content plan and metrics
- Market research: TAM/SAM/SOM, CustDev, UX tests and benchmarking
- Omnichannel: OMS, ship-from-store, BOPIS and unified stock
- Payment calendar: priorities and cash gap