Sales By Item Report

The Sales by Item Report allows you to track the business’s sold items. See which items sell best, discover which are most profitable, and view other types of sales data on an item-by-item basis. It displays records of sales by UPC, including QOH. This report can be useful in calculating replenishment levels.

Criteria Selections for Sales by Item Report

Make entries in the following fields to determine report output:

• Start Date: Enter the starting date you want to include in the report.

• End Date: Enter the ending date you want to include in the report 

Note:

The Start Date and End Date fields can be left empty if you select a relative date option (Current Day, Previous Day, Current Month, Previous Month)

Details

Here's the description of the fields included in the Sales By Item Report:

• Event: To view all event details, including the start and end dates, and location, ensuring full visibility of transaction data linked to specific events.
• Store: The name of the store where the sales occurred.
• Item ID: A unique identifier for the item sold.
• Master SKU: The master stock-keeping unit (SKU) assigned to the item.
• UPC: The Universal Product Code, a barcode representation of the item.
• Product ID: An identifier specific to the product.
• Item Name: The name or description of the item.
• Department: The department to which the item belongs.
• Category: A more specific category within the department.
• Sub Category: A further subdivision of the category.
• Style: The style or design of the item.
• Color: The color of the item.
• Size: The size of the item.
• Brand: The brand or manufacturer of the item.
• Season: The season or collection associated with the item.
• Team: To categorize products based on different teams.
• QTY Sold: The quantity of the item sold during a specified period.
• Vendor: The supplier or vendor of the item.
• Total Sales: The total sales revenue generated by the item.
• Tax: The amount of tax collected for the item.
• Discount Amt.: The total amount of discounts applied to the item.
• Net Sales: The net sales amount after deducting discounts and taxes.
• COGS: Cost of Goods Sold, the direct cost associated with producing or acquiring the item.
• QOH: Quantity On Hand, the current inventory level of the item.
• Unit Selling Price: The price at which each unit of the item is sold.
• Cost Price: The cost incurred to purchase or produce each unit of the item.
• Pending PO Qty: The quantity of the item on pending purchase orders that haven't been received yet.

This report provides valuable insights into the performance of individual items, helping businesses analyze sales trends, identify popular products, manage inventory, track costs, and make informed decisions to optimize their sales strategies.

Printing Reports

Users have the option to print reports on Console, 

1. Navigate to Reports and select the report

2. Select the Date Range that you wish to get the report for.

3. Select filters that are necessary for your report. 

   Note: Default Settings will create a Report with all the necessary information, but if you want a more detailed report, add or remove filters. 

4. Navigate to the Print button on the top right corner of the screen, clicking on the button will show a popup window to choose the printing options.
5. Make your selection and hit Print

Click Save.

Export/ Download Reports

Users have the option to download reports on Console, 

1. Navigate to Reports and select the report
2. Select the Date Range that you wish to get the report for.
3. Select filters that are necessary for your report.
   
   Note: Default Settings will create a Report with all the necessary information, but if you want a more detailed report, add or remove filters.
   
   
4. Navigate to the  Download button on the top right corner of the screen, By clicking on the button, the report will be automatically downloaded as an Excel file.

Note: If you have custom attributes enabled on your account, it will show a popup window to enter the email to which the report will be exported. Only the default settings/filters on the report will get exported in this case. Filters such as Start Date, End Date, and Group By are supported.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more