OrderUnstick

When a payment gateway webhook never reaches your store (after a site migration, a security plugin blocking the callback URL, a CDN rewrite, or a dead endpoint), a customer can pay while the order stays stuck in Pending payment or On-hold. The customer paid, but nothing ships. OrderUnstick scans for those orders and reports possible stuck paid orders: stuck orders older than a configurable age threshold that carry stored Stripe or generic payment metadata. Version 0.1 is strictly read-only. It detects and reports only. What it does:

• Adds a report page under WooCommerce → OrderUnstick (administrators and shop managers only).
• Scans orders in Pending payment and/or On-hold that are older than your age threshold (default 2 hours).
• Looks for payment identifiers already stored on the order by your gateway plugin: Stripe intent, charge, and source ids, and the standard WooCommerce transaction id.
• Shows a report with the order, age, status, customer, total, gateway, the masked payment id found, a conservative risk level, the reason flagged, and the total value across flagged orders.
• Keeps a local scan history with summary counts only.

What it does NOT do, by design, in this version:

• It does not call Stripe, PayPal, Mollie, or any payment gateway or external API.
• It does not change order status, stock, notes, refunds, or payment data.
• It does not send any email.
• It does not auto-fix or recover anything. There is no "mark as paid" button.
• It does not guarantee that any payment succeeded. Payment metadata found is not proof of payment.
• It does not connect to any external service and sends no telemetry. Everything runs inside your site.

Important: gateway confirmation required. A flagged order means only that a stuck order carries stored payment metadata. Always confirm the payment in your gateway dashboard (for example the Stripe dashboard) before acting. Do not fulfill based only on this report. A later version is planned that can re-check candidates against the gateway using a merchant-supplied restricted key, still flag-only. That functionality is not available now and nothing in this version contacts any gateway. OrderUnstick requires WooCommerce. It supports both High-Performance Order Storage (HPOS) and legacy order storage, and reads orders only through the WooCommerce order API.

0.1.0

• Initial release: read-only detector for stuck WooCommerce orders carrying stored payment metadata.
• Scan settings: age threshold, statuses (Pending payment, On-hold), max orders per scan.
• Report with masked payment ids, conservative risk rating, and flagged total value.
• Local scan history with summary counts only.
• No gateway calls, no order changes, no emails, no external services, no telemetry.