Online product sales report
Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.
Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.
Audience: Inventory manager, e-commerce manager, center admin
The online product sales report shows e-commerce product sales — orders placed through Webstore V2 and the Customer Mobile App (CMA) and fulfilled by a center. Use this report to track online product revenue, analyze Webstore sales trends, and compare online sales against in-center POS (Point of Sale) sales.
This is a legacy report available under the classic reporting framework.
Scope: This report covers Webstore V2 and Customer Mobile App (CMA) sales. Webstore V1 historical sales appear in the Inventory sales report instead, because Webstore V1 routed through the same POS-checkout pipeline. "Online catalog" in older configuration screens is unrelated to vendor catalog integration — it refers to the Webstore product catalog (the customer-facing online store), not vendor sourcing.
Data refresh: Real-time on Refresh. Values reflect orders captured at the moment of click.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Worked example
- Tips
- Troubleshooting
- Related articles
Before you begin
- Your organization must have Webstore V2 or Customer Mobile App enabled.
- Enable the report for your organization under Configuration > Reports > List of reports.
Permission: Online Product Sales under View Inventory Reports in the Inventory Manager section of the security role — Required to access the Online product sales report.
Run the report
- Navigate to Reports > Inventory.
- Select the Online Product Sales report.
- Set the date range and filters from the Filter reference.
- Click Refresh.
To export the report, click the Excel or CSV icon.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Date range | From / To dates | Filters by order placement date. |
| Center | Configured centers | Limits to orders fulfilled by the selected center(s). |
| Brand | Configured brands | Filter by product brand. |
| Category / Sub-Category | Configured | Product classification filters. |
| Channel | Webstore V2 / CMA | Filter by origin channel. |
Column reference
| Column | Type | Description |
|---|---|---|
| Order Number | Identifier | The unique online order number. |
| Order Date | Date | When the customer placed the order. |
| Payment Timestamp | Datetime | When payment was confirmed (may differ from order date for delayed-tender flows). |
| Channel | Enum | Webstore V2 or CMA. |
| Product Code / Name / Type | Text | The product on the order line. |
| Quantity | Number | Units ordered on the invoice line. |
| Sale Price | Currency | Per-unit sale price recorded on the invoice line. |
| Discount | Currency | The discount applied at online checkout (net price = sale price − discount). |
| Promotion | Text | The promotion(s) applied to the line. The report does not identify the discount's source type. |
| Tax | Currency | The tax amounts recorded on the invoice at sale time. |
| Payment Type | Text | All tenders used on the invoice, as a combined list (for example card, gift card with number, membership with name). For split-tender orders every tender appears. |
| Guest Name / Email / Phone | Text | Guest details for fulfillment and contact. The Loyalty membership flag is captured separately on the loyalty reports. |
| Fulfillment Center | Text | The center assigned to fulfill the order (typically the guest's base center; geo-based assignment depends on Webstore configuration). |
Shipping charges appear in the dedicated ShippingCharge column — the invoice-level shipping charge apportioned across the invoice's product rows. They are not folded into Sale Price, so include the column deliberately when reconciling gross online revenue.
Returns handling: guest returns of online-ordered products are recorded on a return invoice that inherits the original order's delivery record, so returns can appear here alongside the original sale rows (they also appear in the Product returns report). The report has no order-status filter — it always shows all matching rows for the period.
Worked example
A center wants to identify the top-performing Webstore promotion for the month.
- Set Date range: 2026-04-01 to 2026-04-30.
- Channel: Webstore V2.
- Click Refresh, then sort the export by the Promotion column.
Sample (4 lines):
| Order | Product | Qty | Sale Price | Discount | Promotion | ShippingCharge | Payment Type |
|---|---|---|---|---|---|---|---|
| WO-3041 | Hair Oil | 1 | $40 | $4 | Spring Promo | $2.50 | Card |
| WO-3055 | Shampoo | 2 | $25 | $5 | Spring Promo | $3.00 | Card, Gift Card #1042 |
| WO-3062 | Face Cream | 1 | $60 | $9 | New Guest | $2.50 | Card |
| WO-3071 | Conditioner | -1 | $32 | $0 | — | $0 | Card |
The negative-quantity row is a return (returns share the original order's delivery record and appear alongside sales). Spring Promo produced $76 net product revenue across 2 orders; New Guest produced $51 across 1 order.
Tips
- Webstore V1 vs V2 disambiguation. If you don't see expected online orders, verify your org is on Webstore V2. Webstore V1 orders appear under the Inventory sales report.
- Cross-link to margin analysis. Pair this report with Cost of goods report for online margin analysis.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Expected online orders missing | Org is on Webstore V1 (orders go to Inventory sales report) OR org has CMA disabled. | Check the Inventory sales report for V1 orders; verify CMA enablement in Webstore configuration. |
| Tax shown does not match guest's home jurisdiction | Tax is computed against the fulfillment center, not the billing address. | Verify the Fulfillment Center column; consult that center's tax configuration. |
| Return rows unexpectedly present in totals | Returns share the original order's delivery record and appear alongside sales; the report has no status filter. | Exclude negative-quantity rows in your export when you need gross sales only. |
| Promotion column blank | The line's discount did not come from a promotion. | The report does not identify the discount's source type; the Discount column still carries the amount. |
| Permission denied | The user role lacks Online Product Sales under View Inventory Reports. | Confirm the role permission. |