Running an audit trail for promotional and pricing data
# Running an audit trail for promotional and pricing data
At 11:58pm, a category manager at a household goods company pushes a price change for a laundry detergent SKU across 900 stores. Two minutes later, the shelf-edge label system, the e-commerce site, and the retailer's EDI (Electronic Data Interchange) feed all need to agree on the same number. If they don't, a shopper gets overcharged, a regulator gets a complaint, and someone has to explain why. This lesson traces the checks that should have happened long before that midnight push.
Why pricing data needs its own audit trail
An audit trail is a time-stamped record of who changed what, when, and why. For pricing and promotions, that means every price change, discount, and promotional flag needs a traceable chain: request, approval, system update, and verification.
This matters for three reasons specific to FMCG (fast-moving consumer goods):
Volume and speed. A large household goods company can run thousands of SKU-store-week price points simultaneously. Manual checking doesn't scale.
Multi-system sprawl. Price lives in ERP (Enterprise Resource Planning) systems, trade promotion management (TPM) tools, retailer portals, and point-of-sale (POS) systems. Each is a place things can drift out of sync.
Regulatory exposure. Pricing errors aren't just embarrassing, they can breach consumer protection law and competition law simultaneously.
The core regulatory backdrop
Resale price maintenance (RPM)
Running an audit trail for promotional and pricing data, MBA Training, MBA Training
RPM is when a manufacturer tries to dictate or enforce the price a retailer charges consumers. In most jurisdictions this is treated as a serious antitrust violation.
In the US, RPM is assessed under the Sherman Act, enforced by the Federal Trade Commission (FTC) and Department of Justice (DOJ). Since the 2007 *Leegin* Supreme Court decision, minimum RPM is judged under a "rule of reason" rather than being automatically illegal, but it remains high-risk and many states still treat it more strictly.
In the EU, RPM is treated as a "hardcore restriction" under Article 101 of the Treaty on the Functioning of the European Union (TFEU) and the Vertical Block Exemption Regulation. It is presumed illegal, enforced by the European Commission and national competition authorities.
Why this belongs in a data lesson: compliance depends on being able to prove, from system logs, that "suggested retail price" communications to retailers were advisory and that sales reps did not pressure or monitor retailers into compliance. That proof comes from audit trails of pricing communications and CRMCRMCustomer Relationship Management: software and strategy to manage and analyse customer interactions throughout their lifecycle.View full definition → (Customer Relationship ManagementCustomer Relationship ManagementCustomer Relationship Management: software and strategy to manage and analyse customer interactions throughout their lifecycle.View full definition →) notes, not from memory.
Consumer pricing and labeling rules
US: The FTC Act prohibits unfair or deceptive pricing practices. Many states also have unit pricing and item pricing laws (for example, requiring price-per-ounce on shelf labels).
EU: The Price Indication Directive (98/6/EC) requires unit pricing, and country-level consumer protection authorities enforce it. Several EU states now also require displaying prior prices during discounts, tightened after concerns about fake "was/now" discounting, an area regulators have flagged repeatedly, including UK CMA guidance (a useful reference: UK CMA pricing practices guidance).
A shelf-edge label that shows a discount price not actually preceded by the reference price is a data governancedata governanceData governance is the set of policies, roles, and processes that ensure data is accurate, secure, well-defined, and used responsibly across an organization.View full definition → failure with legal consequences, not just a display bug.
Mapping the data flowdata flowAn automated sequence of steps that moves data from source to destination: ingestion, transformation, validation, and loading, so it arrives clean and ready to use.View full definition → before it goes live
Before any price or promo change reaches the shelf, it typically moves through:
1. Request: category or trade marketing team proposes a price or promo (e.g., "20% off, 2 weeks, 400 stores").
2. Approval: pricing governance committee or finance sign-off, checked against margin floors and legal constraints.
3. System entry: input into the TPM or ERP master pricing table.
4. Propagation: sync to POS, e-commerce catalog, retailer EDI feed, and shelf-label systems.
5. Verification: a check that what's live matches what was approved.
Each handoff is a place where the audit trail should capture: timestamp, user ID, old value, new value, and approval reference.
Two fields deserve attention: rpm_review_flag (did legal or compliance confirm this isn't crossing into RPM territory, especially in retailer-facing communications) and live_verified_ts (the timestamp when someone or something confirmed the price actually appeared correctly in-store or online, closing the loop).
Checks that catch errors before shelf edge
Practical, concrete checks a governance team runs:
Reconciliation check: does the price in the ERP match the price in the retailer's EDI feed and the e-commerce listing? Mismatches often surface first as customer complaints, not internal alerts, unless this is automated.
Threshold check: any price change beyond a set percentage (e.g., more than 15% in a week) auto-flags for a second approver. Catches fat-finger errors, like a decimal point shift turning $4.99 into $0.49.
Promo overlap check: does this SKU already have an active promo in that store group? Stacking unintended discounts is a common and costly error.
Reference price check: for "was/now" discount claims, does the system retain the prior price and the date it was last charged, to satisfy discount transparency rules?
RPM language audit: sampling retailer-facing emails, rep call notes, and portal messages for language that could read as "you must sell at X," not just "we suggest X."
Segregation of duties: the person requesting a price change should not be the same person approving it. This is a standard control, borrowed from financial audit practice, applied to pricing.
A minimal automated check (illustrative)
python
# Flag price changes missing an approval reference or exceeding threshold
def flag_pricing_risks(change):
flags = []
if change["approved_by"] is None:
flags.append("missing_approval")
pct_change = abs(change["new_price"] - change["old_price"]) / change["old_price"]
if pct_change > 0.15:
flags.append("large_change_needs_second_approval")
if change["promo_flag"] and change["rpm_review_flag"] is None:
flags.append("rpm_review_required")
return flags
This isn't production code, it's the logic a governance dashboard should be running on every batch of price changes before go-live.
Knowledge check
1. Why is a traceable audit trail (request, approval, system update, verification) especially critical for pricing and promotional data in FMCG, rather than just good practice in general?
2. A manufacturer's sales rep tells a retailer, 'If you sell our detergent below $X, we'll stop supplying you.' What concept does this scenario most directly illustrate?
3. Since the Leegin decision, how is minimum resale price maintenance treated under US federal antitrust law?
MULTIPLE CHOICE
4. Select ALL correct answers about why pricing data is prone to drifting out of sync across systems in a large FMCG company.
Select all the correct answers.
MULTIPLE CHOICE
5. Select ALL correct answers about the potential consequences when pricing data across systems (e.g., shelf-edge labels, e-commerce site, retailer EDI feed) fails to match.
Select all the correct answers.
Who owns this in practice
At most household goods companies, no single team owns the full chain. That's the problem the audit trail is meant to solve.
Trade marketing / category management: originates price and promo requests.
Finance / pricing governance: approves against margin and policy.
Legal / competition compliance: reviews RPM exposure, especially for supplier-retailer pricing communication.
IT / data governance: owns the systems of record and ensures logs are complete, immutable, and retained per policy.
Internal audit: periodically samples the trail to confirm controls actually worked, not just that they exist on paper.
A useful external reference for how competition authorities think about pricing algorithms and data more broadly is the OECD's work on algorithms and collusion, relevant as more FMCG pricing becomes automated.
🎬 [VIDEO: "How Retail Pricing Algorithms Work (and Where They Get Risky)" - https://www.youtube.com/results?search_query=retail+pricing+algorithms+antitrust+risk - Search results for explainer videos on dynamic pricingdynamic pricingAutomatically adjusting prices in real time based on demand, competition or user behaviour to optimise revenue, margin or conversion.View full definition → systems and the competition law risks they raise, useful for seeing how automated repricing tools intersect with RPM concerns]
Key Takeaways
An audit trail for pricing is a structured, timestamped record of request, approval, system entry, and verification, not a general sense that "someone checked it."
RPM (resale price maintenance) is treated as high risk in the US (Sherman Act, FTC/DOJ, rule of reason since *Leegin*, 2007) and presumed illegal in the EU (TFEU Article 101). Audit trails of retailer-facing pricing communications are the evidence base for compliance.
Discount transparency rules (like the EU's Price Indication Directive and various US state unit-pricing laws) require systems to retain prior prices, not just current ones.
Concrete checks (reconciliation across systems, threshold flags, promo overlap detection, segregation of duties) catch errors before they reachreachThe number of unique people exposed to your message in a given period. Unlike impressions, reach counts each person once, no matter how often they see it.View full definition → the shelf edge, where they become customer-facing and regulator-visible.
Ownership is cross-functional: trade marketing, finance, legal, IT, and internal audit each hold a piece, and the audit trail is what stitches their actions into one traceable chain.