How can we help?

The Product Sales report from the system's Back End breaks down your store's product sales according to Vendors and Departments. Use this information to keep track of what is and isn't selling well. Read on to see what insights you can get from this report! 

Product Sales

From the Back End main menu, go to Sales Reports > Products Sales.

Once you've opened the Products Sales page, you can sort and filter entries by Date, Departments, Vendor, and more. Below are full details on the filters and sorting functions.

1. Date Range — Select the range of dates you want. By default, you'll see product sales for the current day.
2. Department — If you want to view your sales information for a Department, select the one you want from this drop-list.
3. Section — Narrow down your results by selecting a Section from the drop-list. This is different from Departments. Sections are areas within a Department. For example, the Canned Goods Department can have different Sections for canned veggies and canned soups. 
4. Vendor — If you want to view your sales information for a Vendor, select the one you want from this drop-list.
5. Product Group — Select a Product Group from the drop-list to narrow down your results.
6. Search Product — Find sales information on a specific product by entering keywords from its Description in this field.
7. Show Movers / Show Non-Movers — This page will Show Movers by default. Movers are products that have been sold throughout your selected date range. Click on Show Non-Movers to view products that did not sell at all throughout the date range.
   
8. UPC — This column lists every item's UPC.
9. Description — This column lists every item's Description, which you set in the Product Maintenance area of the Back End. 
10. Cost — In this column you'll see how much you paid for each item.
11. Price — In this column you'll find the Price that your customers pay for each item.
12. Deal Date — If the item had Special Pricing during the date range you chose, those dates will be listed in this column. 
13. Last Modified — This column shows the date and time each item had its details last updated.
14. Gross Profit Margin (GPM) — This column shows a value that's calculated by subtracting Cost of Goods Sold from Total Revenue, then dividing the result by Total Revenue for the specified date range. The values here are displayed as percentage points.
15. TI Cost — TI Cost is the total for Tenant Improvement fees that are charged by commercial property leasing companies for improvements to the property.  
16. Profit — This column shows how much profit each item earned within the specified date range. The value is in dollar amounts.
17. Quantity Sold — This column shows the total quantity of each item that was sold in the date range.
18. Weight Sold — For items sold by weight, this column will give you the total weight of each item that was sold in the date range.
19. Net Sales — The Net Sales column will show the item's total dollar amount sold within the time period.
20. Action Menu — To open the Action Menu, click on the Three-Dot Stack icon on the far right. In the menu, you can choose to export all or only visible data (if you've chosen to hide some columns), and choose between a CSV or PDF file. You can also hide columns or make them visible. Visible columns will have a checked box. 
    

💡Pro Tip: You can organize your data by sorting the table. Click on any column header, such as UPC, to sort your entries according to that column. Click once for ascending order, and twice for descending order. An arrow next to the column title will indicate ascending (arrow facing up) or descending (arrow facing down) order.

Product Sales From the Last 30 Days

From here, you can also set up your sales report to show what products sold in the past 30 days. To do so, first adjust your date range to cover the last 30 days or another date range of your choosing.

We recommend then sorting your entries by Net Sales, which should be the furthest right column of your table.

Related Articles

Store Sales

Back End Dashboard

The End of Day Report

End of Week Report

Discount Sales

Frequently Asked Questions

Q: I have a question, but I can't find my answer here. How do I get more assistance?

A: If you need immediate assistance, the team is available 24/7. Feel free to contact our support team at 877-752-0625. You can also email us at support@marktpos.com, and we will respond within 24 hours.