Artisan has a variety of reports to help you gain insight into your store. One of these powerful reports is the “Variant Sales Analysis Report.” Use this report to see each variant’s performance within a time range that you set.
Accessing the Report
There are two ways you can access this report. Head to the top of the screen and select “Reports,” “Merchandising Reports,” and “Variant Sales Analysis Report.”
Or, from the “Main Menu,” select “Reports.“
Click on “Merchandising Reports.”
Then, select “Variant Sales Analysis Report.”
Either way, you’ll end up at the following screen.
These fields will automatically default to certain fields, such as “Group By” set to “Category” and the date range reflecting your current date. You can change the fields on this page if desired.
Report Fields
Group By – Decide if you want your items broken down by category or vendor first.
Show Detail? – Selecting “yes” will list the individual variant items within each category, with their Item Code.
Select Date Range – Enter a date range manually or use the dropdown calendar. This is the range Artisan will pull data from.
Select Primary Variant – Select which variant will display first in the report. For example, if “colors” is selected, and there are both color variants and size variants, the color variants will display first, then the sizes.
You may further filter this report to include only specific items, descriptions, vendors, vendor purchase numbers, item keywords, and categories. Simply type in the item code, description, vendor code, etc or use the magnifying glass to locate them.
There are other fields to the right of this section to include and exclude other items by discontinued, variants, consignment, non-inventory, out-of-stock, and other options.
Price Range: Leave as-is to use the default amounts or enter a specific price range.
Unit Cost Range: Leave as-is to use the default amounts or enter a specific Unit Cost Range.
Example Report
Click to enlarge.
Your report might look different depending on the fields you selected.
In this report, we chose to include variants by color and view data from all of our sites. We also chose to not include discontinued products.
Sales
Amount – The sales generated from each individual variant type. For example, the blue accessories variant generated $430.00 in sales.
Units – The quantity that each individual variant type sold. The blue accessories variant sold 11.
Percentage of Total – How much each individual variant makes up for the overall sales.
Markdowns
Amount – How much each individual variant’s price was lowered.
Units – How many items were sold at that lowered price.
Percentage of Total – The percentage of sales made at that lowered price.
On Hand
Units – The number of items you currently have in stock.
Percentage of Total – The percentage of each item that is currently in stock.
On Order
Units – The number of items you currently have created purchase orders for and are waiting to receive.
Percentage of Total – The percentage of each item that is currently on order.