6. Public vs Private Mismatch

Overview

A public vs private mismatch occurs when the inventory data visible to external-facing systems (public catalogs, customer portals, partner APIs) diverges from the actual internal inventory records (private warehouse management, procurement logs, and fulfillment databases). In the context of Cup Source's wholesale drinkware operations, this mismatch can impact order accuracy, delivery timelines, and partner trust.

⚠️ Why This Matters

Even a 2–3% mismatch rate between public listings and private stock can result in fulfillment delays, cancelled orders, and dissatisfied B2B clients. Cup Source maintains a target mismatch rate below 0.5% across all product categories.

Public vs Private Data Flow — Mismatch Points
🌐
Public Catalog
Customer Portal / API
Mismatch Zone
Data Sync Gap
🏭
Private Inventory
WMS / ERP System

Types of Mismatch

Understanding the specific types of mismatches helps in diagnosing and resolving them quickly. Cup Source categorizes mismatches into four primary types:

Type Description Example Severity
Quantitative Stock counts differ between public and private records Catalog shows 5,000 cups; warehouse has 4,200 🟡 Medium
Qualitative Product specifications or attributes don't match Listing shows "compostable"; actual batch is "recyclable" 🟠 High
Temporal Timing lag causes stale public data Sold-out item still appears available for 4–6 hours 🟡 Medium
Structural Data format or schema incompatibility SKU mapping errors between catalog and WMS 🔴 Critical

Root Causes

At Cup Source, mismatches typically stem from one or more of the following root causes:

  • Sync delays — The automated pipeline between the warehouse management system (WMS) and the public-facing catalog operates on a scheduled interval (typically 15-minute cycles). Real-time events like rush orders or returns can create temporary gaps.
  • Manual overrides — Warehouse staff may adjust private inventory counts manually during audits or damage assessments without the changes propagating to the public layer.
  • Multi-warehouse complexity — Cup Source operates across 4 distribution centers. Aggregating stock levels from private systems into a unified public view introduces reconciliation challenges.
  • Supplier lead-time variance — When a supplier shipment arrives earlier or later than expected, the private system updates immediately, but the public catalog may still reflect the original projected arrival window.
  • Custom product configurations — Branded/custom cups have unique SKUs that may not map cleanly between the public order portal and the private production queue.

"The key insight is that mismatches are not always errors — sometimes they're byproducts of system architecture. The goal is to minimize the gap window and have robust detection in place." — Supply Chain Engineering Team

Detection & Monitoring

Cup Source employs a multi-layered detection strategy to identify mismatches before they impact customer orders:

1

Automated Reconciliation Engine

Runs every 15 minutes across all SKUs. Compares public catalog quantities against private WMS records. Flags any discrepancy exceeding the 0.5% threshold.

2

Real-Time Alert System

Critical mismatches (quantitative gaps >5% or any qualitative/structural mismatch) trigger instant alerts to the inventory management team via Slack and email.

3

Pre-Fulfillment Validation

Before any order enters the picking stage, a final validation check confirms that the public order data aligns with private stock availability at the assigned warehouse.

4

Post-Order Reconciliation

After fulfillment, a retrospective check ensures that shipped quantities match both the public order confirmation and private dispatch records.

Business Impact

Unresolved public vs private mismatches can cascade across Cup Source's operations:

  • Order cancellations — When a customer order references stock that isn't available in the private system, the order must be cancelled or back-ordered, damaging client trust.
  • Overstock or stockout risks — False public availability can lead to overselling, while underreporting can result in missed sales opportunities.
  • Financial discrepancies — Mismatched data can cause revenue recognition errors and complicate accounting reconciliation.
  • Compliance exposure — For eco-friendly product lines (compostable, biodegradable), qualitative mismatches can create regulatory compliance issues.
  • Partner friction — B2B clients and distribution partners rely on accurate public data for their own planning. Mismatches disrupt their supply chain.
📊 KPI Dashboard

Cup Source tracks the following metrics to monitor mismatch health:

  • Mismatch Rate — Target: < 0.5% of total SKUs per cycle
  • Resolution Time — Target: < 2 hours for critical, < 8 hours for medium
  • Customer Impact Score — Orders affected per 10,000: Target < 3
  • Sync Latency — Target: < 15 minutes between private update and public reflection

Resolution Workflow

When a mismatch is detected, the following standardized resolution process applies:

  1. Triaging — Classify the mismatch type and severity level using the automated tagging system.
  2. Root-cause identification — Trace the discrepancy back to its origin (sync delay, manual override, data entry error, etc.).
  3. Immediate correction — Update the public-facing data to align with private records. If the private record is suspect, initiate a physical stock count.
  4. Client communication — If orders have already been placed for mismatched stock, notify affected clients proactively with alternative fulfillment options.
  5. System fix — Address the underlying cause (e.g., adjust sync intervals, fix mapping rules, update training procedures).
  6. Documentation — Log the incident in the mismatch tracker with root cause, resolution steps, and preventive measures.
✅ Best Practice

Always validate against the private system of record (WMS/ERP) when resolving mismatches. The public catalog is a reflection layer — the private inventory is the source of truth. When in doubt, trigger a physical count rather than guessing.

Prevention Strategies

Cup Source continuously invests in prevention to reduce mismatch frequency:

  • Real-time sync upgrades — Transitioning from 15-minute batch syncs to event-driven real-time updates across all high-volume SKUs (paper cups, cold cups, lids).
  • SKU standardization — Implementing a unified SKU nomenclature across all product lines to eliminate structural mapping errors.
  • Automated audit cycles — Scheduled physical inventory audits using barcode scanning, cross-referenced against private records weekly.
  • Change management protocols — Any manual inventory adjustment must be accompanied by a reason code and triggers an automatic public data refresh.
  • Supplier integration — Direct EDI/API connections with major suppliers to synchronize incoming shipment data with private inventory projections.

Next Steps

If you're responsible for inventory management at Cup Source or you're a partner integrating with our systems, here's what to do next:

  • Review the API Reference → Inventory Sync documentation for technical integration details.
  • Set up monitoring alerts using the Dashboard → Mismatch Tracker panel.
  • Schedule a quarterly reconciliation review with your assigned account manager.
  • Report suspected mismatches through the Support → Submit Ticket form, selecting "Inventory Discrepancy" as the category.
🔗 Related Sections

See Section 5 — Reconciliation Methods for detailed procedures on aligning data across systems, and Section 7 — Resolution Workflows for step-by-step incident response templates.