Listen on Spotify

ERP says in stock. Store says sold out.

Cold open

At 10:06 a.m., the merchandiser opens the ERP and sees 47 units available. At 10:08, customer support checks WooCommerce and sees the product marked sold out. At 10:11, marketing asks whether the paid campaign can stay live. The answer depends on which tab you are emotionally prepared to believe.

Meanwhile, customers are doing their own audit. Some can add the product to cart. Others cannot. One has already messaged support with the kind of sentence that begins politely and ends with a screenshot.

HR-Z0 case note: when inventory has two truths, customers pay for the argument.

The horror

Inventory drift between WooCommerce and the ERP creates instant operational damage:

Symptoms

The symptoms are always recognizable:

  • paid traffic lands on unavailable products
  • support cannot answer stock questions confidently
  • merch teams stop trusting storefront availability
  • ops teams manually reconcile counts
  • customers receive mixed signals before they even buy

This is not just a stock problem. It is a promise problem. Once the storefront stops reflecting operational reality, every channel starts making commitments somebody else has to absorb.

Cost

The cost is not abstract.

  • Time: every disputed order triggers a mini war room across storefront, ERP, and fulfillment.
  • Money: avoidable exceptions turn operational friction into chargebacks, credits, and expedited shipping costs.
  • Trust: repeat buyers vanish when order promises feel probabilistic.

The root cause

Checkout drama is rarely a checkout bug alone. It is usually a state-model mismatch across the stack.

1

Source-of-truth rules are unclear

The ERP may be the intended system of record, but if WooCommerce can still hold conflicting availability states without clear precedence, the business has not actually defined control.

2

Sync logic is too brittle

Inventory adjustments, bundles, reservations, returns, and timing differences create edge cases. If the sync only works on happy paths, stock truth will drift under normal trading conditions.

3

Exception handling is missing

Teams often discover inventory mismatches only after customers or support do. That means the integration has no credible queue for disagreement and no owner for resolution.

4

Transaction truth fragments across systems

Teams often discover inventory mismatches only after customers or support do. That means the integration has no credible queue for disagreement and no owner for resolution.

The fix

We start by reconciling business truth across checkout, ERP, and CRM, then automate enforcement.

1

NorthStar maps the inventory promise chain

NorthStar identifies how stock moves between ERP, WooCommerce, and the teams making commercial decisions around it. The 30-day plan defines the operational rules for inventory truth, escalation, and exception handling.

2

Mercury fixes the packaged stack

Mercury brings the WooCommerce, ERP, and CRM environment into one governed operating model, including:

  • a clear inventory source of truth
  • sync rules between ERP and WooCommerce
  • exception queues for mismatches
  • visibility for merch, support, and ops
  • operational ownership for stock drift

The goal is that the storefront stops freelancing.

3

Order-state governance is automated, not hoped for

Status transitions are normalized across systems with owner-bound exception queues. Support no longer needs three screenshots to answer one customer.

Inventory should not require a vote.

HR-Z0
HR-Z0
Comms Officer

Comms Officer HR-Z0 (a.k.a. “H.R. Zero”) is Galaxie’s deadpan broadcast voice for the Office Horror Stories series — part dispatcher, part incident historian, part morale damage control.
Built from equal parts helpdesk transcripts, post-mortems, and calendar trauma, HR-Z0 doesn’t “tell stories.” It files reports from the front lines of messy operations — where ownership evaporates, folders time-travel, and a “quick change” becomes a six-month saga.

Give us a call

Available from 9am to 8pm, Monday to Friday.

Send us a message

Send your message any time you want.

Our usual reply time: 1 Business day