commerce operations and integration · field note

Ask PG: What is the list of banned sites and why are they banned?

A working diagnosis of this problem and the sequence that actually resolves it, written from the operational side rather than the marketing side.

Reported context: It's not true that killed stories can't be seen by anyone except the submitter. They can be seen by everyone else who has showdead turned on. You can easily check whether a site is banned by submitting something from it and seeing if it gets killed immediately. I.e. if it's visible on the new page to someone who's not logged in. (You may have to wait a minute because the new page is cached.) Here is the complete list

What is actually going on

Integration failures usually trace to schema drift: a plugin update changes a field name and the sync silently writes nulls.

Order lifecycle bugs appear when the system of record for status is ambiguous between storefront, ERP, and fulfilment.

The sequence that works

  1. Pin integration versions and add a schema assertion that fails loudly when an expected field disappears.
  2. Declare a single system of record per entity: orders in the storefront, inventory in the ERP, fulfilment status in the warehouse system.
  3. Add reconciliation jobs that compare counts across systems daily and alert on divergence.
  4. Log every state transition with a correlation id so a single order can be traced end to end.
  5. Test the failure path, not only the happy path: cancelled order, partial refund, address change after dispatch.

Where people lose time

Verify before you trust it

Run the checks above against your own data instead of adopting them at face value. The failure modes are specific enough that a single afternoon of measurement will either confirm this diagnosis or rule it out — both outcomes are useful, and guessing is not.

Launch Readiness Checker
A ready-to-use package for exactly this workflow — $27.55, delivered immediately.
Get Launch Readiness Checker · $27.55
Sold via Gumroad, which acts as merchant of record and handles payment and applicable taxes. All sales are final; see the return policy before purchase.