The Product Performance Report helps you understand the performance of each product individually, and identify the best-selling and most profitable products. This enables you to make product purchasing decisions from suppliers, plan promotional offers, and other matters that contribute to improving inventory management and increasing profits.
ℹ️ Note:
This report does not include shipping/cash on delivery fees from linkage channels (online store).
Data of products deleted from inventory are not displayed or calculated.
Accessing the Report
Go to Reports > Inventory > Product Performance Report.
Click on the report to view details.
Searching the Report
Type the product name or SKU in the designated search field.
Filtering Search Results
Click on "Filter".
You can filter results by:
Date (From–To).
Supplier name.
Brand.
Category.
Location.
Click on "Apply".
Time Selection
Click on the time field.
Select the timeframe you want:
24 hours (default setting).
Choose a custom period (temporary or fixed).
To choose a temporary period:
Click on "Adjust Timeframe (Temp)".
Select the start time and end time.
Click on "Apply".
To add a fixed period:
Click on "New Custom Timeframe".
Add the period name.
Specify the period hours.
Click on "Apply".
Sorting Data
Click on the "View By" field.
Select the appropriate order to display data in the report.
Report Sections
Summary: Displays total sales and profit for all products.
Details: Displays all product data in detail.
ℹ️ Summary and detail data are calculated based on the specified date, time, and filter factors.
Report Data
Product Name/SKU: Based on the data entered in the product section.
Available Quantity Today: Total quantity of the product available in inventory (this number is not affected by time period filtering or any other filtering factors)
Product Cost Today: Average cost of the product in inventory.
Inventory Value Today: Average cost of the product in inventory X product quantity (the inventory value of the product is not calculated by package and bundled product)
Product Supplier, Product Brand, Product Category: Based on your specification of these details within the product data in the product section.
Location: The branch you sold from.
Sales: Total completed sales of the product excluding tax, minus returns and discounts.
Cost of Goods Sold: Total cost of products sold, minus the total cost of products returned.
Profit Value: Product sales excluding tax minus the cost of goods sold.
Sales Tax: Total tax collected for the sale of the taxable product at all rates.
Sales (Including Tax): Total sales of the product minus returns and discounts.
Added Profit Margin: (Sales - Cost of Goods Sold) ÷ Cost of Goods Sold
Profit Margin%: (Sales - Cost of Goods Sold) ÷ Sales
Quantity Sold: Quantity of the product sold without deducting returns.
Quantity Purchased: Total quantity of the product purchased through purchase invoices (manual quantity adjustment is not calculated).
Quantity Returned: The quantity that was returned from the product.
Exporting the Report
1. Click "Export":
To export the report summary: Select summary xlsx.
To export report details: Select: Excel file or PDF file.
The file is downloaded to your device.
FAQs
Can I know the sales of a specific product in a specific branch?
Yes, click on Filter > Choose Location > Click on Apply.How can I know the sales of all products in all branches from the start of the first sale?
Do not specify any time period or any filter option, and you will see the total of all sales.Can I know the sales of a specific category?
Yes, click on Filter > Type the category name > Click on Apply.How can I know the best-selling products?
Click on the "View By" field and choose "Best-selling first".How do I know the number of products sold during a certain period?
Click on Filter > Specify the time period > Click on Apply.Why are not all data displayed in the report?
Use the scroll bar below the table to see all the data, or click on Export to view all data in an Excel file.How can I know the stagnant products that have never been sold or during a certain period?
Stagnant products can be identified through the stagnant inventory report.What is the difference between the Product Performance Report and Exporting Products?
The Product Performance Report displays sales, profits, and profit margins for each product over a specified period — intended for commercial performance analysis. Exporting products outputs a list of all your current products in the system (name, barcode, price, available quantity) — useful for review and backup.What is the difference between the Product Performance Report and the Product Movement Report?
The Product Performance Report focuses on sales and profitability (how much each product sold and its profit margin). The Product Movement Report focuses on the history of each transaction affecting the product quantity (sales, returns, purchases, transfers, inventory) with the quantity before and after each transaction.