Sales by item type Report
Overview
The Sales by Item Type report in RepairDesk is designed to provide users with valuable insights into the total number of items sold and the revenue generated from those sales. This report allows users to identify the most popular items sold over a specific period of time. In addition to inventory items, users can also track the popularity of repairs performed during that time.
1. Search Filters
Users can apply filters to narrow down their search and customize the report according to their requirements. The available search filters are:
Stores: Users can filter the report based on stores. They have the option to view data for all stores or select multiple stores. The search functionality is also available while selecting multiple stores.
Type: Users can select the type of items they want to include in the report. The available types are:
- Repair Tickets
- Unlocking
- Products
- Trade-in
- Causal items
Criteria: The criteria for the report are based on the selected type. For example, if the user selects repair tickets, the criteria will include all the repairs. Users can also filter the report based on repair categories set for each repair service.
Criteria as Product: If the user selects the type as "Product," they will have the following criteria to choose from:
- Product Category
- Item SKU
- Serial Number
- Employee
- Manufacturer
- Device
Date: Users can select the date range for the report from predefined templates or specify a custom date based on their requirements.
2. Export Options
Once you have applied the desired filters, you can take further actions on the generated report:
- CSV
3. Report Columns
The columns included in the Sales by Item Type report vary depending on the selected type. Here is an overview of the columns for different types:
3.1. Repair Tickets and Unlocking
- Stores: Displays the most popular SKU(s) based on one or multiple stores.
- Manufacturer: Shows the manufacturer of the products (e.g., Apple, Samsung).
- Device: Displays the device name (e.g., iPhone 7).
- Device Issue: Represents the specific issue with the device (e.g., Screen Replacement).
- QTY: Total quantity of the products sold.
- Sub-Total: Total gross amount generated from the sales.
- Tax: Amount of tax applied to the sales.
- Total: Total amount after adding tax (Sub Total + Tax).
- COGS: Cost of Goods Sold.
- Gross Profit: Profit calculated based on Total - COGS.
- Margin: Margin calculated as Gross Profit / Total.
3.2. Product, Causal, and Trade-in Items
- Stores: Displays the most popular SKU(s) based on one or multiple stores.
- Manufacturer: Shows the manufacturer of the products (e.g., Apple, Samsung).
- Device: Displays the device name (e.g., iPhone 7).
- Category: Represents the category of items (e.g., Network Unlocks, Products, Trade-ins, Casual Items).
- Product Name: Displays the name of the product (e.g., iPhone 7+ screen, Camera).
- SKU: SKU of the product.
- Supplier: The supplier attached to the item.
- QTY: Total quantity of the products sold.
- Sub-Total: Total gross amount generated from the sales.
- Tax: Amount of tax applied to the sales.
- Total: Total amount after adding tax (Sub Total + Tax).
- COGS: Cost of Goods Sold.
- Gross Profit: Profit calculated based on Total - COGS.
- Margin: Margin calculated as Gross Profit / Total.
Note: By default, the default supplier attached to the item will be shown in the report. In the case of exporting to Excel and PDF formats, only the default supplier will be displayed.
Key Takeaway
This Sales by Item Type report in RepairDesk provides valuable insights into your most popular selling items. By analyzing this report, you can identify which items require promotions or discounts, helping you optimize your sales strategies and increase revenue.
Contact Support
If you have any questions or require further assistance, please visit our website atwww.repairdesk.co or email us at [email protected]. Our support team is ready to help you with any queries or concerns you may have.
How can I view refund reasons in the item-wise sales report?
In the item-wise sales report, you can now view refund reasons associated with refunded items. You can also export the report data to an Excel file to see these refund reasons. This feature helps you better understand and track the reasons for refunds.