## 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