Advanced reporting inventory reports allow you to dig deeper into your inventory, helping you uncover new insights about your business, like how soon certain products will run out, what to purchase, and where you need to shift slow-moving stock.
Navigate to Reporting > Inventory reports then select one of the default inventory reports from the tabs:
- Inventory summary: an overview of your inventory position at a certain point in time.
- Inventory performance: identify which products, brands, suppliers, and outlets are giving you the best return on your investment.
- Inventory replenishment: helps to plan the purchase of products you reorder frequently.
- Dusty inventory: identify which products to put on clearance or discontinue. Compare the last sale date to the sell-through date to determine if products are moving slower than expected.
- Recently out of stock: helps prioritize reordering by displaying products with zero or negative inventory alongside sales and revenue data.
- Sell through: shows the percentage of inventory sold over a period to further prioritize reordering. Filter by category, brand, supplier, product, outlet or SKU.
You can use the below metrics to further customize your inventory reports to suit your requirements.
By default, your report will display either products or SKUs (variants). You can also choose to review higher-level trends (brand, product category, etc.).
Click the Report type drop-down and select the report type you wish to view. Products in your inventory reports can be grouped by the following:
- SKU name
- Product category
Once selected, click Search to apply your selection.
Filter your results to focus on different views of your product catalog. Click the Measure drop-down and select a measure to suit your requirements:
- On-hand inventory: only include products that you have available to sell.
- Low inventory*: only show products that are below their minimum reorder point.
- All inventory: includes all active products.
- Out of stock: only displays products that have zero or negative inventory levels.
*Low inventory measure not available for merchants on Lite plan.
Once selected, click Search to apply your selection.
You can choose to review inventory data in a specific period. A great indicator of how the future might pan out is to review a similar period in the past.
Select the Date range drop-down and click Specify dates. Here you can specify your desired date range by selecting a From date and To date.
Once your desired dates have been selected, click Apply, and then click Search to apply your selection.
The filters bar can help you fine-tune your data so you can dig deeper. To open the filters bar, click More filters.
Select whether to Include or Exclude the filter type from the drop-down. If you wish to Include and Exclude specific filters, add the first filter and click + Exclude or + Include, depending on your initial selection.
The following filter types can be applied to the inventory report:
- Product Name
- Product SKU
- Product category
- Product Tag
- Variant Attributes
- Customer (search by name or email address)
- Customer Group
- Outlet Name
- Supplier Name
- Brand Name
Because you can add multiple filters, it is important to understand the way they work together:
- Adding an extra filter of the same type causes the filters to work as "either/or". For example, Supplier: Nike and Supplier: Adidas will show data for sales with products that have either the supplier Nike or Adidas.
- Adding an extra filter of a different sort causes the filters to work as "and". For example, Supplier: Nike and Type: Shoes will show data for sales with products that have both the supplier Nike and the type Shoes.
- Adding another filter tag of the same sort will give you MORE results, as it broadens the results you can see already.
- Adding another filter tag of a different sort will give you FEWER results, as it restricts the results you can see already.
You can also choose to include inactive inventory into your reporting by clicking the Include inactive inventory toggle. This setting is disabled by default.
Have multiple stores? Click Format results and select By outlet, and then click Apply to see customer demand and inventory in each store and plan your stock transfers.
When using the Product and SKU Name report types, you can see more information about each row by clicking the + (plus) icon.
Select which product details to include in your report, or select all of these by selecting All. Once you've made your selection, click Apply.
If you would like to dig deeper, you can add even more information by clicking the + (plus) on the right side of the report table to access additional measures.
Lite, Pro, Enterprise, and Advanced plan merchants have the following measures available:
- Gross profit: Total revenue in the specified period less the total cost of products sold for that period.
>Customer Count: Number of unique, registered customers served in the specified period.
>Avg. Cost: Average supply price of a single item.
>Retail Value (Excl. Tax):>Total value of inventory on hand, using retail price.
>Inventory Cost: Total value of inventory on hand, using average cost.
Current Inventory: Amount of inventory as at today.
>Reorder Point:>Threshold for inventory being low.
>Start Date Inventory:>Amount of inventory as of the start of chosen dates.
Reorder Amount: Default quantity ordered when added to a Purchase Order.
Return Count: Number of sold items returned by customers.
In addition to the measures above, the following optional measures are also available to Pro, Enterprise, and Advanced plan merchants:
Revenue: Total value of items sold.
Margin (%): Percentage of revenue that you keep as gross profit.
Sale count: Total number of sales and returns in the specified period.
>Items Sold: Total number of items sold.
>Items Sold per Day: Average number of items sold per day.
Avg. items per sale: Average number of items per sale.
- Avg. sale value: Average transaction/sale value.
Discounted %: Average discount given on total sale value (excluding tax).
- >Cost of Goods Sold: Total cost of products sold.
- Stock on transfer: Amount of incoming inventory from other outlets.
>Sell-through Rate: Percentage of sold items out of all items available to be sold.
>Days Cover: Estimated number of days current inventory will last.
Returns (%): Percentage of sold items that have been returned by customers.
>Created: Date this product was first added to your store.
First sale: Date the product was first sold.
Last sale: Date the product was last sold.
Select which measures you wish to apply and click Update report.
If you are unsure what plan you are on, navigate to Setup > Billing and your plan will be listed as You’re currently on the X plan.
(Click to enlarge)
- Click Export report.
- Choose XLSX format.
- Download the file and open in a spreadsheet application, such as Excel or OpenOffice.
Saving a customized report is only available to merchants with the advanced reporting module.
Admin and manager user roles can save customized reports to be used in future. For more information, refer to Saving customized reports.