The Product Performance Report is a hybrid between a sales report and an inventory on hand report. It allows you to compare your inventory data for a product with sales data such as item's sold per month, cost of goods and revenue.
Note: Composite products are not included in the Product Performance Report. If a composite product is sold, it will not reflect in the Product Performance Report either by the composite or by its component products.
Because the Product Performance Report combines sales data with inventory measures, it can be an incredibly useful tool for future inventory planning. Below are some examples of the sort of information you can expect to get from the Product Performance Report:
If you manage seasonal stock, the Product Performance Report is a great way of seeing how certain brands and types are performing in your store. By enabling the Brand and Type options in the product attributes drop-down arrow on the left you will be able to see the sales and inventory data for these brands and get some further clarity around brand success.
Note: You can't look back at previous seasonal performance just yet, but historical data will be added soon.
Individual Product Performance
The Product Performance Report can also be useful in drilling down to product specific data. By enabling the SKU option in the product attributes drop-down arrow on the left you will be able to look at sales and inventory data for individual products and get a better idea of how these products are selling, how much they have cost you and how much revenue they've brought in to date.
It's good to see how much a certain item has sold and comparing this information alongside inventory data is even better. Sometimes, though, this data alone isn't quite enough when analysing your store's performance. This is where reporting measures step in.
By adding different measures (accessed using the drop-down arrow on the far right of the report) you can surface a range of additional sales and inventory information. Two good measures to try are Return % and Discount %. By matching Items Sold against Return % and/or Discount % you'll be able to see how many of these items were returned or heavily discounted. This will give you a better indication of the product's popularity. If for example, a large portion of a product's sales were discounted or returned, it may mean that these products weren't as popular as others, even if all the stock was sold.
Products That Haven't Sold
Sometimes you might like to see which products haven't sold at all since they were first ordered. To do this, run the Product Performance Report and navigate to the First Sale column. If fields underneath this column are blank, it means the product has never been sold.
A range of different product attributes and measures can be added to your report to help you get the most out of your sales and inventory data.
By default, your product performance report will show all time product data. If you would like to filter your product performance report by a custom range, select 'Date Range' from the date dropdown and pick your 'to' and 'from' dates:
This will generate a custom report for your selected date range.
To access the products attribute selector, click on the down arrow located on the left-hand side of the report. Under here, you will see some product details you can choose to include in your report such as the SKU, Supplier Code, Brand, Supplier, Type and Tag.
By default, your report will include a number of measures. These are:
If you would like to get more data out of this report, you can use the measure dropdown on the top right of the report to add some additional measures. The options here include: