Reports
How to pull and interpret reports on the reservations site.
The reservations site has both WooCommerce built-in analytics and custom reports in WP Admin. These serve different purposes and may show different numbers — this is expected, not a bug.
Available Reports
WP Admin > Reports (Custom)
Custom reports built specifically for MoC's needs:
| Report | Purpose |
|---|---|
| Pickup Report | Primary report stores rely on. Filterable by store, exportable as CSV. |
| Product Sales Report | Sales by product with PLU, Item, Qty, Dollars, and Store columns. |
| Return Supper Club Customers | Identifies repeat SC customers for loyalty incentives. |
WooCommerce > Analytics (Built-in)
Standard WooCommerce analytics dashboard with revenue, orders, products, categories, coupons, and taxes reports.
Pulling the Pickup Report
Navigate to Reports
Go to WP Admin > Reports on reservations.marketofchoice.com.
Select the Pickup Report
Choose the report and set the date range and store filter.
Export
Click the CSV export button to download. This is the report stores use for daily prep planning.
Why Numbers Differ Between Reports
WooCommerce built-in analytics and custom reports use different:
- Order status filters — one may include statuses the other excludes
- Date range logic — order date vs. completion date
- Data collection methods — WooCommerce analytics uses its own data tables, custom reports query orders directly
When MoC asks "why don't the numbers match", explain that the reports measure slightly different things. The custom Pickup Report is the authoritative source for operational planning.
Caching and Reports
Never enable WP Engine EverCache on the reservations site. It caches report data via memcached, causing reports to show empty or stale results.
The custom reports include a cache-bypass fallback added after the November 2025 EverCache incident. They check for empty values and attempt an alternate lookup that bypasses WP Engine's memcached layer.
If reports show empty or missing data:
- Check if EverCache was accidentally enabled (WP Engine dashboard)
- Try a hard refresh
- Clear the WP Engine server-side cache
Google Analytics / GA4
GA4 is installed on both sites but has limitations:
- Doesn't differentiate between catering and Supper Club orders
- Item ID prefix: Google Listings & Ads plugin prefixes product IDs with
gla_when syncing to Merchant Center. Tracking must include this prefix for Google to match events to products. - For Supper Club-specific metrics, use the custom WordPress reports, not GA4
Store Notification Emails
Stores receive email notifications for new orders. These are configured per-store:
| Store | Email Format |
|---|---|
| Ashland | [email protected] |
| Belmont | [email protected] |
| Bend | [email protected] |
| Cedar Mill | [email protected] |
| Corvallis | [email protected] |
| Delta Oaks | [email protected] |
| Franklin | [email protected] |
| Hillsboro | [email protected] |
| Medford | [email protected] |
| West Linn | [email protected] |
During holiday seasons, group emails may be turned off so only Sella receives all-store notifications. Remember to re-enable after the season.