You can customize your inventory reports to get the most detailed information you need to ensure your business's success.
Navigate to Reporting > Inventory reports. Select one of the three inventory reports from the top tabs:
- Inventory summary report: an overview of your inventory position at a certain point in time.
- Inventory performance report: identify which products, brands, suppliers, and outlets are giving you the best return on your investment.
- Inventory replenishment report: helps to plan the purchase of products you reorder frequently.
Use the following information to customize 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 type, 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 type
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.
*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 Type
- 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.
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.