Product consumption 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, service-operations manager, center admin
The product consumption report shows product usage during service delivery β how many units of each retail or consumable product were consumed against appointments and bulk checkouts over a date range. Use it to understand consumption patterns, identify high-consumption products to negotiate vendor pricing, and reconcile consumption against the Bill of materials report for waste analysis.
This is a legacy report available under the classic reporting framework.
Note β disambiguation among related reports:
- This report β center-level OR organization-level summary by product (the two are H2 sub-sections of this article β pick the scope from the Run the report section).
- Bill of materials report β per-appointment breakdown comparing planned vs. actual consumption per service.
Bookmark this report for product-summary analysis. Bookmark BOM for per-appointment forensic analysis.
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
- Required setup β Service-product consumption mappings (BOM) MUST be configured for the products you want surfaced. See Track product consumption for services. Without mappings, auto-tracked consumption rows are missing entirely.
- Enable the report at the organization level under Configuration > Reports > List of reports.
Permission: Consumption under View Inventory Reports in the Inventory Manager section of the security role β Required to access both the per-center and organization-wide variants of this report.
Run the report
This report has two scopes β Single center and Organization-wide. Choose the scope based on your analysis intent.
Single center
Use when comparing consumption per product at a single center, or troubleshooting consumption issues at a specific location.
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory.
- Select the Consumption report.
- Set the date range, product type, and additional filters from the Filter reference.
- Click Refresh.
Organization-wide
Use when comparing consumption between centers, identifying organization-wide trends, or aggregating consumption for vendor negotiations.
- Navigate to Reports > Inventory at the organization level (no center selection required β your role must include org-level access).
- Select the Organization Consumption report.
- Set the date range, product type, and additional filters from the Filter reference.
- Click Refresh.
To export either variant, click the Excel or CSV icon.
Consumption recording β auto vs. manual. The report blends both sources:
- Auto-tracked consumption β fired automatically on appointment closure based on configured service-product mappings (per Track product consumption for services).
- Manually logged consumption β recorded via Manage Stock > Consumption for products consumed outside an appointment context (e.g., training, internal use, sample handouts).
A row in the report does not distinguish the source by default; use BOM for the auto-tracked-only view.
Restock-status setting context: The Consumption value column reflects products that were deducted from stock per the org-level restock-status setting. When the setting is OFF, products marked as consumed in service-product mappings appear in this report but do NOT actually reduce on-hand stock. Confirm the setting state if Consumption value seems disconnected from stock movement.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Date range | From / To dates | Filters by consumption date. |
| Product Type | Retail / Consumable / Both | Three-state classification: Retail, Consumable, or Both. |
| Category | Configured categories | Limits results to a category. |
| Sub-Category | Configured sub-categories | Further narrows category. |
| Center | (Org variant only) | Limit to specific centers within the org for cross-center comparison. |
Column reference
Single-center variant
| Column | Type | Description |
|---|---|---|
| Product Code / Name | Text | The product consumed. |
| Product Type | Enum | Retail or Consumable. |
| Category / Sub-Category | Text | Product classification. |
| Consumed Quantity | Number | Total units consumed in the date range. Decimal display supported (e.g., 0.25 of a 250 ml bottle). |
| Consumption Value | Currency | Consumed Quantity Γ Perpetual Average Cost (the org-level costing-method setting). For FIFO orgs, the value reflects FIFO basis. |
| Center | Text | The reporting center (constant for single-center variant). |
Organization-wide variant
| Column | Type | Description |
|---|---|---|
| Product Code / Name | Text | The product consumed. |
| Product Type | Enum | Retail or Consumable. |
| Category / Sub-Category | Text | Product classification. |
| Center Name | Text | The center where consumption occurred (one row per center per product). |
| Consumed Quantity per Center | Number | Center-specific consumption total. |
| Aggregated Total | Number | Sum of Consumed Quantity across all centers for the product (repeated on each row for the product). |
| Comparison view | Display | Side-by-side rendering: each row groups all centers for one product, allowing direct comparison. |
Worked example
A multi-center org (3 centers) wants to compare retail product consumption for April.
- Set scope: Organization-wide.
- Date range: 2026-04-01 to 2026-04-30.
- Product Type: Consumable.
- Click Refresh.
Sample (1 product across 3 centers):
| Product | Center | Consumed Qty | Aggregated Total |
|---|---|---|---|
| Hair Color B-3 | Downtown | 12 | 30 |
| Hair Color B-3 | Mall | 14 | 30 |
| Hair Color B-3 | Airport | 4 | 30 |
Insight: Hair Color B-3 consumption is ~3.5Γ higher at Mall vs. Airport. Either Mall has more color-service appointments, OR Airport has under-reporting (manual consumption not logged, or service-product mapping missing for some color services). Cross-check with BOM for the same date range to identify gaps.
Tips
- Identify high-consumption products to negotiate vendor pricing. Sort the export by Consumed Quantity descending; the top-10 list often correlates with the highest-impact vendor contracts.
- Spot waste. Compare Consumption Value here against the Bill of materials' planned consumption β large variances flag waste, dosage drift, or missing mappings.
- Cross-center comparison. Use the org-wide variant grouped by Product to flag uneven consumption patterns across the org. High variance often points to training gaps or process inconsistency, not stock issues.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Report shows zero rows for a product known to be consumed | No service-product mapping (BOM) configured for the service that consumes the product. | Configure the mapping per Track product consumption for services, then re-run after the next appointment. |
| Consumption Value seems disconnected from stock movement | Org-level restock-status setting is OFF (consumption logged but stock not deducted). | Verify the setting; reconcile with Stock ledger report for the same period. |
| Numbers differ from BOM | This report aggregates per product; BOM is per appointment. Override consumption events on individual appointments may shift BOM totals. | For per-appointment forensics use BOM directly. |
| Permission denied | The user role lacks Consumption under View Inventory Reports, or the user lacks org-level access for the org-wide variant. | Confirm the role permission and org-level scope. |