1. The Dynamics of Fast-Moving Consumer Goods (FMCG)

Unlike high-ticket industrial hardware or B2B software, Fast-Moving Consumer Goods (FMCG) operate on high volume, razor-thin margins, and rapid inventory turnover. The success of an FMCG brand relies entirely on seamless distribution depth—moving stock efficiently from factory warehouses to central stockists, regional distributors, and ultimately neighborhood Kirana stores or supermarket shelves.

2. Multi-Tier Distribution Hierarchy

Tier Level Stakeholder Key Operational Responsibility
Tier 1: Primary Sales Manufacturer to C&F (Carrying & Forwarding) / Stockist Bulk truckload dispatch, regional warehousing, and primary credit ledger settlement.
Tier 2: Secondary Sales Stockist to Distributor / Wholesaler Van sales distribution, breaking bulk quantities, and managing regional dealer networks.
Tier 3: Tertiary Sales Distributor to Retailer / Kirana / Modern Trade Daily store-level replenishment, visual merchandising, and point-of-sale collections.

3. Database Schema for Distributor Ledger & Secondary Sales Tracking

To prevent stockouts across retail outlets and track distributor credit limits accurately, FMCG supply chain databases track multi-tier orders and outstanding credit ledgers:

CREATE TABLE fmcg_distributor_ledger (
    distributor_id UUID PRIMARY KEY,
    distributor_name VARCHAR(255) NOT NULL,
    territory_code VARCHAR(50) NOT NULL,
    credit_limit_amount NUMERIC(12, 2) NOT NULL,
    current_outstanding_amount NUMERIC(12, 2) NOT NULL,
    available_credit_balance NUMERIC(12, 2) GENERATED ALWAYS AS (credit_limit_amount - current_outstanding_amount) STORED,
    last_order_epoch BIGINT NOT NULL,
    is_active BOOLEAN DEFAULT TRUE
);

CREATE TABLE secondary_sales_orders (
    order_id UUID PRIMARY KEY,
    distributor_id UUID REFERENCES fmcg_distributor_ledger(distributor_id),
    retailer_outlet_id UUID NOT NULL,
    total_invoice_value NUMERIC(10, 2) NOT NULL,
    payment_status VARCHAR(32) DEFAULT 'PENDING', -- PENDING, COD_COLLECTED, CREDITED
    dispatched_at_epoch BIGINT NOT NULL
);

-- Index for rapid territory sales analysis
CREATE INDEX idx_territory_sales ON fmcg_distributor_ledger (territory_code, is_active);

4. Operational Best Practices for FMCG Distribution

  1. Minimizing Out-of-Stock (OOS) at Retail: In FMCG, if a consumer’s preferred brand is missing on the shelf, brand switching happens instantly. Route sales automation (DSA) apps must track real-time retail shelf stock during every sales visit.
  2. FIFO Batch Tracking for Perishables: Many FMCG categories (food, beverages, personal care) have strict expiry dates. Enforce First-In, First-Out (FIFO) warehouse picking rules to prevent inventory write-offs from expired goods.
  3. Optimized Credit Cycles: Maintain tight control over distributor credit windows (e.g., 15 to 30 days) backed by automated ledger reminders to maintain healthy working capital flow.