Product returns 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, retail manager, center admin
The product returns report shows guest-side product return transactions — returns by date, product, category, refund method, and financial impact. Use this report to track return volumes, identify frequently returned products, and understand the revenue impact of returns.
This is a legacy report available under the classic reporting framework.
Scope: This report covers guest returns only — returns initiated through POS (Point of Sale) or Webstore by or on behalf of a guest. Vendor returns (return purchase orders, where the center sends stock back to a vendor) are NOT in this report; they appear in the Inventory orders report. The report covers BOTH in-center POS returns AND online (Webstore V2 / CMA (Customer Mobile App)) returns.
Data refresh: Real-time on Refresh.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Worked example
- Tips
- Troubleshooting
- Related articles
Before you begin
- Enable the report for your organization under Configuration > Reports > List of reports.
- The setting Allow to restock returned products at Configuration > Inventory > Stock actions controls whether returned products can be restocked. If you see Restock Status values you didn't expect, verify this setting.
Permission: Returns under View Inventory Reports in the Inventory Manager section of the security role — Required to access the Product returns report.
Run the report
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory.
- Select the Returns report.
- Set the date range, product type, and additional 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 return transaction date. |
| Product Type | Retail / Consumable / Both | Three-state classification: Retail, Consumable, or Both. |
| Guest | Search guest | Filter to returns by a specific guest. |
| Restock Status | Yes / No / Partial | Filter by restock disposition (see Column reference). |
| Return Reason | Configured reasons (per Set up stock actions) | Filter by reason code. |
| Channel | POS / Webstore V2 / CMA | Origin channel of the return. |
Column reference
| Column | Type | Description |
|---|---|---|
| Return Date | Date | When the return was processed. |
| Invoice Reference | Identifier | The original sale invoice the return relates to. |
| Product Code / Name | Text | The product returned. |
| Product Type | Enum | Retail or Consumable. |
| Quantity Returned | Number | Units returned (always positive in this report). |
| Return Value | Currency | The refund amount before tax adjustments. Equals Sale Price × Quantity, unless adjusted at return. |
| Tax Adjustment | Currency | Sales tax reversed on the refund. |
| Refund Method | Enum | How the refund was issued: Original Tender, Store Credit, Gift Card, Cash, Cheque. For partial refunds split across methods, this column shows a comma-separated list. |
| Return Reason | Text | Configured reason from the Configuration > Inventory > Stock actions reasons list. |
| Restock Status | Enum | Yes (returned to stock), No (discarded), Partial (partial restock + partial discard for the same return). |
| Restocked Quantity | Number | The number of returned units actually returned to stock. May be < Quantity Returned when Restock Status is Partial. |
| Discarded Quantity | Number | The number of returned units written off (Quantity Returned − Restocked Quantity). |
| Guest Name / Phone / Email | Text | The returning guest. |
| Channel | Enum | POS, Webstore V2, or CMA. |
Worked example
A center wants to identify the top return reasons for April.
- Set Date range: 2026-04-01 to 2026-04-30.
- Product Type: Retail.
- Click Refresh.
Sample (4 returns):
| Return Date | Invoice | Product | Qty | Return Value | Refund Method | Return Reason | Restock Status | Restocked | Discarded |
|---|---|---|---|---|---|---|---|---|---|
| 2026-04-04 | INV-2055 | Shampoo A | 1 | $25 | Original Tender | Wrong product | Yes | 1 | 0 |
| 2026-04-12 | INV-2098 | Hair Oil C | 2 | $80 | Store Credit | Damaged on receipt | No | 0 | 2 |
| 2026-04-18 | INV-2118 | Conditioner B | 3 | $96 | Original Tender, Gift Card | Skin reaction | Partial | 1 | 2 |
| 2026-04-25 | INV-2140 | Hair Oil C | 1 | $40 | Cash | Damaged on receipt | No | 0 | 1 |
Insight: "Damaged on receipt" accounts for 3 of 4 returns. Discarded units (5 of 7) cost the center $200+ in lost stock. Investigate vendor packaging or receiving handling. The split-tender refund on INV-2118 (Original Tender + Gift Card) is captured in the Refund Method column.
Tips
- High return rates by product. If you see frequent returns for the same product, review product quality, shelf life, vendor packaging, or guest expectations. Frequent returns may indicate a product listing issue or a mismatch between the product description and the actual product.
- Restock vs. discard analysis. Sum Restocked Quantity vs. Discarded Quantity to estimate the actual stock recovered through returns. High Discarded percentages flag receiving / handling issues at the center.
- Reconcile against Inventory sales. The same returns appear as negative-quantity rows in the Inventory sales report. For net-revenue calculations use that report; for returns-only analysis use this one.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Return rows missing | Date range excludes the return date OR the user lacks permission. | Verify date range; verify the Returns check box under View Inventory Reports. |
| Restock Status shows blank or unexpected values | The org-level Allow to restock returned products setting was changed mid-period; older returns reflect the prior policy. | Document the policy change date; segment the report by date range. |
| Tax Adjustment is zero on a return | The original sale was tax-exempt OR the return was processed with no tax reversal. | Inspect the original invoice for tax application. |
| Refund Method shows multiple values | The return was split-tender-refunded (e.g., partial Original Tender + partial Store Credit). | Review the comma-separated values; cross-check against the return record on the invoice. |