{"id":16279,"date":"2022-09-14T15:43:37","date_gmt":"2022-09-14T19:43:37","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=16279"},"modified":"2023-06-16T11:35:30","modified_gmt":"2023-06-16T15:35:30","slug":"variant-sales-analysis-report","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/variant-sales-analysis-report\/","title":{"rendered":"Variant Sales Analysis Report"},"content":{"rendered":"\n<p>Artisan has a variety of reports to help you gain insight into your store. One of these powerful reports is the &#8220;<strong>Variant Sales Analysis Report<\/strong>.&#8221; Use this report to see each variant&#8217;s performance within a time range that you set.<\/p>\n<hr \/>\n<h3><strong>Accessing the Report<\/strong><\/h3>\n<p>There are two ways you can access this report. Head to the top of the screen and select \u201c<strong>Reports<\/strong>,\u201d \u201c<strong>Merchandising Reports<\/strong>,\u201d and \u201c<strong>Variant Sales Analysis Report<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h46_44.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16282 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h46_44.png\" alt=\"\" width=\"521\" height=\"324\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h46_44.png 521w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h46_44-300x187.png 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/a><\/p>\n<p>Or, from the \u201c<strong>Main Menu<\/strong>,\u201d select \u201c<strong>Reports.<\/strong>\u201c<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16226 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10.png\" alt=\"\" width=\"677\" height=\"482\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10.png 677w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_11h35_10-300x214.png 300w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/a><\/p>\n<p>Click on \u201c<strong>Merchandising Reports<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_13h03_27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16242 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_13h03_27.png\" alt=\"\" width=\"650\" height=\"459\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_13h03_27.png 650w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-13_13h03_27-300x212.png 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p>Then, select \u201c<strong>Variant Sales Analysis Report<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h47_56.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16284 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h47_56.png\" alt=\"\" width=\"473\" height=\"530\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h47_56.png 473w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h47_56-268x300.png 268w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/a><\/p>\n<p>Either way, you\u2019ll end up at the following screen.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_10h11_49.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-16285 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_10h11_49.png\" alt=\"\" width=\"820\" height=\"578\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_10h11_49.png 836w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_10h11_49-300x211.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_10h11_49-768x541.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/a><\/p>\n<p>These fields will automatically default to certain fields, such as \u201c<strong>Group By<\/strong>\u201d set to \u201c<strong>Category<\/strong>\u201d and the date range reflecting your current date. You can change the fields on this page if desired.<\/p>\n<hr \/>\n<h3><strong>Report Fields<\/strong><\/h3>\n<p><strong>Group By &#8211; <\/strong>Decide if you want your items broken down by category or vendor first.\u00a0<\/p>\n<p><strong>Show Detail? &#8211;\u00a0<\/strong>Selecting &#8220;yes&#8221; will list the individual variant items within each category, with their Item Code.\u00a0<\/p>\n<p><strong>Select Date Range &#8211; <\/strong>Enter a date range manually or use the dropdown calendar. This is the range Artisan will pull data from.<\/p>\n<p><strong>Select Primary Variant &#8211;\u00a0<\/strong>Select which variant will display first in the report. For example, if &#8220;colors&#8221; is selected, and there are both color variants and size variants, the color variants will display first, then the sizes.<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p><strong>Price Range:\u00a0<\/strong>Leave as-is to use the default amounts or enter a specific price range.<\/p>\n<p><strong>Unit Cost Range:\u00a0<\/strong>Leave as-is to use the default amounts or enter a specific Unit Cost Range.<\/p>\n<hr \/>\n<p>\u00a0<\/p>\n<h3><strong>Example Report<\/strong><\/h3>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h26_47.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16280\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h26_47-1024x669.png\" alt=\"\" width=\"1024\" height=\"669\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h26_47-1024x669.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h26_47-300x196.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h26_47-768x502.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/09\/2022-09-14_09h26_47.png 1265w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><em>Click to enlarge.<\/em><\/p>\n<p>Your report might look different depending on the fields you selected.\u00a0<\/p>\n<p>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.<\/p>\n<p><strong>Sales<\/strong><\/p>\n<p>Amount &#8211; The sales generated from each individual variant type. For example, the blue accessories variant generated $430.00 in sales.\u00a0<\/p>\n<p>Units &#8211; The quantity that each individual variant type sold. The blue accessories variant sold 11.\u00a0<\/p>\n<p>Percentage of Total &#8211; How much each individual variant makes up for the overall sales.\u00a0<\/p>\n<p><strong>Markdowns<\/strong><\/p>\n<p>Amount &#8211; How much each individual variant&#8217;s price was lowered.<\/p>\n<p>Units &#8211; How many items were sold at that lowered price.<\/p>\n<p>Percentage of Total &#8211; The percentage of sales made at that lowered price.<\/p>\n<p><strong>On Hand<\/strong><\/p>\n<p>Units &#8211; The number of items you currently have in stock.<\/p>\n<p>Percentage of Total &#8211; The percentage of each item that is currently in stock.<\/p>\n<p><strong>On Order<\/strong><\/p>\n<p>Units &#8211; The number of items you currently have created purchase orders for and are waiting to receive.<\/p>\n<p>Percentage of Total &#8211; The percentage of each item that is currently on order.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Artisan has a variety of reports to help you gain insight into your store. One of these powerful reports is the &#8220;Variant Sales Analysis Report.&#8221; Use this report to see each variant&#8217;s performance within a time range that you set. Accessing the Report There are two ways you can access&#8230;<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[334],"ht-kb-tag":[],"class_list":["post-16279","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-merchandising-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=16279"}],"version-history":[{"count":7,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16279\/revisions"}],"predecessor-version":[{"id":19913,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16279\/revisions\/19913"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=16279"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=16279"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=16279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}