Does Alpha Insights Support WooCommerce HPOS?

Yes! Alpha Insights is fully compatible with WooCommerce High-Performance Order Storage (HPOS), also known as Custom Order Tables.

What is HPOS?

HPOS is WooCommerce's new database structure for storing orders that:

• Improves performance for stores with many orders
• Speeds up order queries and dashboard loading
• Uses dedicated tables instead of WordPress post meta
• Required by WooCommerce for all stores by 2024

Alpha Insights HPOS Compatibility

Automatic Detection

Alpha Insights automatically detects and adapts:

• Detects if your store uses HPOS or legacy storage
• Uses appropriate database queries for your setup
• No configuration needed - works automatically
• Supports switching between HPOS and legacy

Full Feature Support

All Alpha Insights features work with HPOS:

• Order profit calculations
• Historical data processing
• Real-time profit tracking
• All reports and widgets
• Exports and integrations

Checking Your Setup

Is Your Store Using HPOS?

1. Go to WooCommerce → Status → Tools
2. Look for "Custom Order Tables" or check Features section
3. Status shows: Enabled or Disabled

Verifying Alpha Insights Compatibility

1. Go to Alpha Insights → Settings → Advanced
2. Find HPOS Compatibility section
3. Should show: "Auto-detect (Currently: HPOS Enabled)" or "Legacy"

Migration Scenarios

Upgrading to HPOS

If you enable HPOS on existing store:

1. WooCommerce migrates your orders to new tables
2. Alpha Insights automatically detects the change
3. No action needed in Alpha Insights
4. Profit data remains intact

New Store with HPOS

Installing Alpha Insights on HPOS-enabled store:

• Works immediately
• Processes all orders correctly
• No special configuration

Performance Benefits

With HPOS enabled:

• Faster queries: Order data loads 50-300% faster
• Better scalability: Handles 100,000+ orders efficiently
• Improved reliability: Dedicated tables prevent conflicts
• Faster reports: Alpha Insights report generation speeds up

Troubleshooting

Issue: "HPOS compatibility warning"

Rare case: Alpha Insights can't detect HPOS status

Solution:

1. Go to Settings → Advanced → HPOS Compatibility
2. • Force HPOS if you know you're using HPOS
   • Force Legacy if using traditional storage
3. Save settings

Issue: Data missing after HPOS migration

Unlikely but check:

1. Verify WooCommerce migration completed successfully
2. Go to Alpha Insights → Tools → Recalculate All Orders
3. Wait for background processing to complete

Best Practices

• Enable HPOS for better performance (if supported by all plugins)
• Let Alpha Insights auto-detect (don't force unless needed)
• Test Alpha Insights after enabling HPOS (it should work seamlessly)
• Keep both WooCommerce and Alpha Insights updated