Stock, sales and commitment
Chan avatar
Written by Chan
Updated over a week ago

The Stock, sales and commitment report lists your historic sales and stock cover, where "commitment" refers to the current stock available for sale plus incoming stock (i.e. everything already ordered/paid for).

This report can help with planning, replenishment and identifying what products are overstocked.

To access the Stock, sales and commitment report, click on Reports in the left menu, then Stock & commitment.

Filtering the Stock, sales and commitment report

You can use the dropdown menus on the top left-hand side to filter the Stock, sales and commitment report by warehouse and dimension such as categories, vendors, products, variants, etc.

You can also run the report for the following time periods:

  • Yesterday

  • Last 7/14/30/90/365 days

  • Last month

  • Last year

  • Week to date

  • Month to date

  • Year to date

  • Custom range

Stock, sales and commitment metrics

The metrics available on the Stock, sales and commitment report are:

Metric

Description

Sales

The number of units sold for the selected period, less returns.

This data is taken from your sales platform.

Sales %

The percentage of total sales attributed to this field (variant, product, category, etc.).

Sales % = Number of units sold for one variant ÷ Number of units sold for all variants

Revenue

The revenue received from sales made during the selected period.


Revenue = Gross revenue - Discounts - Returns

Return %

The returns as a percentage of sales.

Return % = Returns units / Gross sales

Profit

The profit made from sales made during the year

Profit = Revenue - COGS - Platform fee

Margin

The profit as a percentage of the revenue

Margin = Profit ÷ Revenue

Avg ROS

Average return on sales. Only available on this report.

Avg ROS = Profit ÷ number of units sold

In stock

The current stock level in the selected warehouse

Avg cover (in months)

How many months of sales you can fulfill with your current stock level. Only available on this report.

Avg cover = Number of units in stock ÷ Average monthly sales

On order

The number of units on active purchase orders to vendors.

Avg PO cover (in months)

How many months of sales you can fulfill with your on order stock level.

Avg PO cover = Number of units in non-closed purchase orders ÷ average monthly sales

On order overdue

The number of units yet to be delivered after the expected delivery date.

Did this answer your question?