Artisan makes it easy to see your best-selling items, vendors, manufacturers, and categories. You can even see which customers buy the most items, and sort by quantity sold, amount sold, and profit. Run the “Best Sellers” report to view this data.
Accessing the Report
From the toolbar, select “Reports,” “Sales Reports,” and “Best Sellers” report.
Or, from the “Main Menu,” select “Reports,” “Sales Reports,” and “Best Sellers” report.
Either way, you’ll end up at the “Best Sellers Report” field screen.
Report Fields
Select Date Range: Determine a date range for this report. Best-selling data will show between these dates. Use the dropdown arrow to select the calendar or input dates manually.
Sales Site: If you have more than one location, you can choose to view best-selling items from all store locations or a specific location.
Summarize By: This determines what data you want to see. For example, if you want to see the best-selling items, including their codes and descriptions, this will appear on the report. If you just want to see the best-selling categories, then select “Category,” and so on.
Group By: This determines how your data is separated, paired with the “Summarize By” field. For example, selecting Sort by “Item” and Group by “Category” will list each item(s) under the relevant category.
Category Roll Up: Starting in 4.8, you can include how “deep” you want Artisan to drill down. For example, if you only want to show parent categories, select “1.” If you want to show child categories, select a number 2-9.
Sort By: This determines how the data is arranged for each section.
Like most Artisan reports, you can utilize multiple fields to narrow down your data. You can choose to show only one or a few specific items by searching for or entering their item code(s) or descriptions. You can include or exclude vendors and vendor purchase numbers, keywords, categories, and much more.
You can also save any changes you make as defaults by selecting the “Save as Defaults” option. The next time you open this report, your saved specifications will appear. The only thing that won’t save is the date range.
Report Examples
There are many areas of this report to customize how you see fit. Here are a few examples.
Summarize By Vendor, No Grouping, Rank By Qty Sold:
In this example, we can see that our data is ranked by the quantity each vendor sold. A percentage is included of how many items sold compared to the other vendors on the list.
Summarize By Vendor, No Grouping, Rank By Amount Sold:
In this example, our data is ranked by the amount each manufacturer sold – the items that were ordered from this vendor and ended up being sold.
Summarize By Vendor, No Grouping, Rank By Profit:
In this example, our data is ranked by the profit gained from each vendor.
Summarize By Item, Group By Vendor, Rank By Qty Sold:
In this example, each section is broken down into the vendor, with their items listed, and ranked by the number sold.
Summarize By Category, Group By Category, with Category Roll Up
With category roll-up enabled, it can be applied to the parent category (ex. Apparel) or just focus on child categories (ex. Men’s Apparel).
