Data Hygiene for WooCommerce

Description

Data Hygiene for WooCommerce detects, quarantines, and fixes data corruption in WooCommerce Analytics — safely, with a dry-run preview and a full undo log for every destructive action.

If your WooCommerce reports show inflated revenue, duplicate orders, or numbers that just don’t add up, this plugin finds out why and helps you fix it without ever losing data.

The Problem

WooCommerce stores commonly suffer from analytics data corruption:

• Orphan orders in analytics tables with no matching order record
• Test orders from admin emails polluting revenue reports
• Duplicate orders from double-clicks or payment retries
• Status mismatches — completed orders with no payment method
• Invalid dates — future dates or impossible timestamps
• Amount anomalies — negative totals or zero-amount completed orders

What This Plugin Does

1. Smart Scanning — 6 specialized scan modules analyze your orders for common data issues
2. Dry-Run Mode — preview every change before anything is touched
3. Quarantine System — suspicious data is moved to quarantine, not deleted. Full undo support.
4. Audit Log — every destructive operation is recorded with user, time, and reason
5. Data Confidence Score — a 0-100% score showing how trustworthy your analytics data is
6. Payment Reconciliation — match WooCommerce orders against Stripe / PayPal records
7. Weekly Auto-Scan — automatic weekly scans with email alerts when your score drops
8. WP Dashboard Widget — see your confidence score at a glance

Key Differentiators

• Analytics-specific — understands WooCommerce Analytics data structure
• Safety-first — dry-run + confirmation modal + audit log on every destructive op
• Quarantine, not delete — move data to review, never lose it
• Full undo — restore any quarantined item to its original state
• Gateway reconciliation — verify WooCommerce totals match Stripe / PayPal
• HPOS-ready — works with the new high-performance order storage

Supported Payment Gateways

• Stripe (WooCommerce Stripe Gateway)
• PayPal (WooCommerce PayPal Payments, PayPal Standard)

Privacy

All scanning and cleaning runs locally on your own server. No order, customer, or payment data ever leaves your WordPress install. Reconciliation calls are sent directly from your server to Stripe / PayPal using credentials you provide. See PRIVACY.md in the plugin folder for full details.

External services

This plugin includes an optional Payment Reconciliation feature. When — and only when — you enable it and enter your own payment gateway API credentials, the plugin contacts the third-party services listed below to match your WooCommerce order totals against the payment processor’s own records. If you do not enable reconciliation, the plugin makes no external calls and operates entirely on your own server.

Stripe

Used to retrieve your own Stripe charge and balance-transaction records so they can be reconciled against your WooCommerce orders.

• What is sent: your Stripe secret API key (as an Authorization header) and request parameters for the date range and pagination. No customer personal data is transmitted.
• When: only when you run a reconciliation that includes Stripe, or during the optional weekly auto-scan if Stripe reconciliation is enabled.
• Endpoint: https://api.stripe.com
• Terms of Service: https://stripe.com/legal/ssa
• Privacy Policy: https://stripe.com/privacy

PayPal

Used to retrieve your own PayPal transaction records so they can be reconciled against your WooCommerce orders.

• What is sent: your PayPal client ID and secret (to obtain a short-lived OAuth token) and request parameters for the date range. No customer personal data is transmitted.
• When: only when you run a reconciliation that includes PayPal, or during the optional weekly auto-scan if PayPal reconciliation is enabled.
• Endpoints: https://api-m.paypal.com (live) and https://api-m.sandbox.paypal.com (sandbox/testing)
• Terms of Service: https://www.paypal.com/us/legalhub/useragreement-full
• Privacy Policy: https://www.paypal.com/us/legalhub/privacy-full

Development

The admin interface is built with React using the official @wordpress/scripts (webpack) build tooling. The complete, un-minified, human-readable source is included in this plugin under the src/ directory, and the compiled output it generates lives in build/.

The public development repository (full source and build tooling) is available at:
https://github.com/mohannadshaddy-businesskhana/data-hygiene-for-woocommerce

To rebuild the compiled assets from source:

npm install
npm run build

The build scripts are defined in package.json at the plugin root. The source in src/ is what generates build/index.js.