{"id":14204,"date":"2022-04-28T13:37:27","date_gmt":"2022-04-28T17:37:27","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=14204"},"modified":"2023-06-15T13:01:52","modified_gmt":"2023-06-15T17:01:52","slug":"slow-moving-inventory-report","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/slow-moving-inventory-report\/","title":{"rendered":"Slow Moving Inventory Report"},"content":{"rendered":"\n<p><span style=\"background-color: #ffff99;\"><em>This article is currently under construction<\/em><\/span><\/p>\n<p>To keep track of items that aren&#8217;t being sold, we suggest using the &#8220;<strong>Slow Moving Inventory Report<\/strong>.&#8221; This report looks for items that have <em>more inventory<\/em> <em>than sales<\/em> and breaks this information down by date and amount sold.<\/p>\n<p>A common solution to slow-moving inventory is to put the items on sale or simply move them to a different part of the store that&#8217;s more noticeable to customers. Either way, this report can help you make an informed decision about how you want to resolve these non-selling products.<\/p>\n<p><strong>Note: <\/strong>Make sure you have posted your Day End for the selected date range in the report. Otherwise, sales made within that date range will not show. Click <strong><a href=\"https:\/\/certek.com\/kb4\/shift-closing-sales-by-station-or-shift\/\">here<\/a><\/strong> to learn how to post a Day End.<\/p>\n<h3>Accessing the Report<\/h3>\n<p>There are two ways you can access this report.\u00a0<\/p>\n<p>\u00a0Click on &#8220;<strong>Reports<\/strong>,&#8221; &#8220;<strong>Merchandising Reports<\/strong>,&#8221; and &#8220;<strong>Slow Moving Inventory Report<\/strong>&#8221; from the toolbar.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h50_54.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14207 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h50_54.png\" alt=\"\" width=\"530\" height=\"330\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h50_54.png 530w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h50_54-300x187.png 300w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p>Or, click on the &#8220;<strong>Reports<\/strong>&#8221; button on the &#8220;<strong>Main Menu<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_47.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14208 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_47.png\" alt=\"\" width=\"681\" height=\"486\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_47.png 831w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_47-300x214.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_47-768x548.png 768w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><\/a><\/p>\n<p>Next, click on &#8220;<strong>Merchandising Reports<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_54.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14209 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_54.png\" alt=\"\" width=\"685\" height=\"484\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_54.png 836w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_54-300x212.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h51_54-768x543.png 768w\" sizes=\"auto, (max-width: 685px) 100vw, 685px\" \/><\/a><\/p>\n<p>Then, select &#8220;<strong>Slow Moving Inventory Report<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h52_02-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14211 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h52_02-1.png\" alt=\"\" width=\"675\" height=\"477\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h52_02-1.png 839w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h52_02-1-300x212.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h52_02-1-768x543.png 768w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/><\/a><\/p>\n<p>Either way, you&#8217;ll end up at the following screen. This screen will default to preset fields, and the date range will automatically default to the month you&#8217;re currently in.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h54_13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14213\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h54_13.png\" alt=\"\" width=\"925\" height=\"666\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h54_13.png 925w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h54_13-300x216.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_11h54_13-768x553.png 768w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/a><\/p>\n<p>However, you may adjust the fields as necessary. You can also save these adjustments and set them to automatically appear the next time you open the report by selecting &#8220;<strong>Save as Defaults for this Report (except dates).<\/strong>&#8220;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h17_44.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14278 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h17_44.png\" alt=\"\" width=\"432\" height=\"66\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h17_44.png 432w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h17_44-300x46.png 300w\" sizes=\"auto, (max-width: 432px) 100vw, 432px\" \/><\/a><\/p>\n<p>This report might be multiple pages depending on the size of your inventory. Keep this in mind if you are going to print the report.<\/p>\n<h2>Setting Up Your Report<\/h2>\n<p>The following section goes over the individual settings you can customize for your report.<\/p>\n<h3>Group By<\/h3>\n<p><strong>Category or Vendor<\/strong><\/p>\n<p>Decide if you want your items broken down by category or vendor first. In the next step, you can choose a secondary category to fine-tune the organization.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h19_56.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14281 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h19_56.png\" alt=\"\" width=\"336\" height=\"142\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h19_56.png 336w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h19_56-300x127.png 300w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/a><\/p>\n<p><strong>Group By Receive Date\/Time:<\/strong> This includes the date the items were received into Artisan as well as a timestamp (ex. January 13, 2022, 12:29:24 PM EST).\u00a0<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h45_18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14220 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h45_18.png\" alt=\"\" width=\"628\" height=\"173\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h45_18.png 628w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h45_18-300x83.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><strong>Group By Receive Date: <\/strong>This only displays the date received into Artisan (ex. January 13, 2022).<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h47_00.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14221 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h47_00.png\" alt=\"\" width=\"614\" height=\"166\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h47_00.png 614w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_12h47_00-300x81.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>\u00a0<\/p>\n<h3>Secondary Group<\/h3>\n<p>Choose your secondary group: vendor or category. Or, you may select &#8220;<strong>No Grouping<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h05_34.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14271 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h05_34.png\" alt=\"\" width=\"349\" height=\"158\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h05_34.png 349w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h05_34-300x136.png 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/a><\/p>\n<ul>\n<li>For example, this is the report with &#8220;<strong>Group By<\/strong>&#8221; and &#8220;<strong>Secondary Group<\/strong>&#8221; to &#8220;<strong>Category<\/strong>.&#8221;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h13_23.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14226 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h13_23.png\" alt=\"\" width=\"399\" height=\"586\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h13_23.png 399w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h13_23-204x300.png 204w\" sizes=\"auto, (max-width: 399px) 100vw, 399px\" \/><\/a><\/p>\n<p>Notice how the categories are sorted alphabetically, and the items within those categories are sorted alphabetically as well.<\/p>\n<ul>\n<li>Main and secondary group set to &#8220;<strong>Vendor<\/strong>.&#8221;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h17_18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14227 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h17_18.png\" alt=\"\" width=\"387\" height=\"515\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h17_18.png 387w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h17_18-225x300.png 225w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/a><\/p>\n<p>Notice how the vendors are sorted alphabetically, and the items within those vendor groups are sorted alphabetically as well.<\/p>\n<p><strong>By Category, No Grouping:<\/strong><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h06_40-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14274 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h06_40-1.png\" alt=\"\" width=\"584\" height=\"297\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h06_40-1.png 584w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h06_40-1-300x153.png 300w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a>With no secondary group selected, you&#8217;ll only see the category name and items listed.<\/p>\n<p><strong>By Vendor, No Grouping:<\/strong><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h07_38.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14273 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h07_38.png\" alt=\"\" width=\"598\" height=\"288\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h07_38.png 598w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h07_38-300x144.png 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/a><\/p>\n<p>With no secondary group selected, you&#8217;ll only see the vendor name and items listed.<\/p>\n<h3>Sort By<\/h3>\n<p>This is how the items within the groups will be sorted. For example, if you choose &#8220;<strong>By Item Code<\/strong>,&#8221; the items will be ranked alphabetically by their item code.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h29_56.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14297 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h29_56.png\" alt=\"\" width=\"635\" height=\"534\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h29_56.png 635w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h29_56-300x252.png 300w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/a><\/p>\n<p>You can also sort by vendor P\/N number.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h32_48.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14299 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h32_48.png\" alt=\"\" width=\"619\" height=\"359\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h32_48.png 619w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h32_48-300x174.png 300w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><\/a>Or alphabetically by description.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h34_33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14300 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h34_33.png\" alt=\"\" width=\"601\" height=\"172\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h34_33.png 601w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h34_33-300x86.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<p><strong>Show Stock Unit Detail?<\/strong><\/p>\n<p>If selected, this shows the number of items you currently have on hand. For example, we have 18 of the Classic Dark Baseball Hats in stock:<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h31_15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14232 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h31_15.png\" alt=\"\" width=\"453\" height=\"95\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h31_15.png 453w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_13h31_15-300x63.png 300w\" sizes=\"auto, (max-width: 453px) 100vw, 453px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\"><strong>Show Detail Row?<\/strong><\/span><\/p>\n<p><span style=\"color: #000000; background-color: #ffff99;\">Instructions coming soon<\/span><\/p>\n<p><strong>Custom Sale Date Range<\/strong><\/p>\n<p>Input the sales information you want to see for a specific date range. For example, from April 1 to April 30, 2022.<\/p>\n<p><strong>Sales Threshold (Units)<\/strong><\/p>\n<p>The amount of money that specific items generated. For example, if you want to exclude items that generated more than $100 in sales, input 100 into this field.\u00a0<\/p>\n<p><strong>Sales Over QOH %<\/strong><\/p>\n<p>This number is the percentage of items sold versus what you have in stock. For example, only one item is sold within the date range but there are 10 in stock. You set the Sales Over QOH percentage to a higher number (say, 50%). That item will appear on the list. In other words, items with percentages <em>below<\/em> the number you put here will display.\u00a0<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h09_03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14234 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h09_03.png\" alt=\"\" width=\"611\" height=\"34\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h09_03.png 719w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h09_03-300x17.png 300w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\" \/><\/a>\u00a0<\/p>\n<p><strong>Inventory Site<\/strong><\/p>\n<p>If you have multiple sites, you can choose to view information from all of your sites or narrow it down to one site in particular.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h18_20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14237 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h18_20.png\" alt=\"\" width=\"309\" height=\"100\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h18_20.png 309w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h18_20-300x97.png 300w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/a><\/p>\n<p><strong>Inventory Is Received Before<\/strong><\/p>\n<p>Any items received after this date will not be counted in the report. For example, any items accepted in Artisan after March 27th will\u00a0<em>not\u00a0<\/em>appear on the report, but items received before that end date (and within the Custom Sale Date Range) will appear.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h17_49.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14236 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_14h17_49.png\" alt=\"\" width=\"290\" height=\"33\" \/><\/a><\/p>\n<p>You can narrow down your report further by including specific items, descriptions, vendors, and so forth. In this example, we only want to show the item &#8220;<strong>BL-WHTSM<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_35.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14267 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_35.png\" alt=\"\" width=\"775\" height=\"243\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_35.png 775w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_35-300x94.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_35-768x241.png 768w\" sizes=\"auto, (max-width: 775px) 100vw, 775px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_43.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-14268 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_43.png\" alt=\"\" width=\"741\" height=\"190\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_43.png 741w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-27_15h47_43-300x77.png 300w\" sizes=\"auto, (max-width: 741px) 100vw, 741px\" \/><\/a><\/p>\n<h3><a id=\"reading-your-report\"><\/a>Reading the Report<\/h3>\n<p>Let&#8217;s go over how to read the report so you can identify your lowest-selling items. Your report might look different depending on the fields you selected.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h46_06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14284 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h46_06.png\" alt=\"\" width=\"397\" height=\"193\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h46_06.png 397w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h46_06-300x146.png 300w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><\/a><\/p>\n<p><strong>1. Received: <\/strong>This column shows when the items were accepted into Artisan.<\/p>\n<p><strong>2. Item Code: <\/strong>This column displays the item codes of the products.<\/p>\n<p><strong>3. Description:\u00a0<\/strong>This is the items&#8217; description.\u00a0<\/p>\n<p><strong>4<\/strong>.\u00a0<strong>Vendor P\/N:\u00a0<\/strong>If the item has a vendor part number, it will show here.\u00a0<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h49_51.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14285 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h49_51.png\" alt=\"\" width=\"507\" height=\"81\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h49_51.png 507w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_08h49_51-300x48.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/a><\/p>\n<p><strong>5.<\/strong> <strong>Sales Over QOH: <\/strong>This percentage is calculated by the amount sold within the custom date range divided by the quantity you currently have in stock. In other words, what percentage of the inventory did you sell?<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h49_10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16271\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h49_10.png\" alt=\"\" width=\"826\" height=\"200\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h49_10.png 826w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h49_10-300x73.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h49_10-768x186.png 768w\" sizes=\"auto, (max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<p><strong>6. Units:\u00a0<\/strong>This is your quantity on hand. For example, there are 18 Dark Gray Classic Baseball Hats in stock.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h00_13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14287 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h00_13.png\" alt=\"\" width=\"660\" height=\"162\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h00_13.png 660w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h00_13-300x74.png 300w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p><strong>7. Cost: <\/strong>This is the amount you&#8217;ve spent purchasing these items. For example, we bought 18 Dark Gray Classic Baseball Hats for $15 each, which totals to $270.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h04_45.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14288 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h04_45.png\" alt=\"\" width=\"511\" height=\"118\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h04_45.png 511w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h04_45-300x69.png 300w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/a><\/p>\n<p><strong>8. Retail:\u00a0<\/strong>This is the amount the quantity of hand is worth according to the retail price. For example, if we sell each Dark Gray Classic Baseball Hat for $25 each, the total of what we have in stock is $450.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h06_41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14289 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h06_41.png\" alt=\"\" width=\"595\" height=\"118\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h06_41.png 595w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-28_09h06_41-300x59.png 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/a><\/p>\n<p><strong>9. Units \/ Retail Sold from&#8230;:\u00a0<\/strong>This section is the number of items sold within the date range you selected.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h52_20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16272 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h52_20.png\" alt=\"\" width=\"426\" height=\"81\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h52_20.png 426w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h52_20-300x57.png 300w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/a><\/p>\n<p><strong>10. Units \/ Retail Sold by Age:<\/strong> This section is separated into date ranges\/how long it took an item to sell (0 to 30, 31 to 60, 61 to 90, 91 to 120, 121 to 180, and 181 to 365 days).<\/p>\n<p>The numbers underneath the date ranges indicate how many units of the item were sold and for how much.\u00a0<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h57_22.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16273 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h57_22.png\" alt=\"\" width=\"446\" height=\"218\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h57_22.png 446w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-09-14_08h57_22-300x147.png 300w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is currently under construction To keep track of items that aren&#8217;t being sold, we suggest using the &#8220;Slow Moving Inventory Report.&#8221; This report looks for items that have more inventory than sales and breaks this information down by date and amount sold. A common solution to slow-moving inventory&#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":[336],"ht-kb-tag":[],"class_list":["post-14204","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-inventory-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/14204","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=14204"}],"version-history":[{"count":50,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/14204\/revisions"}],"predecessor-version":[{"id":19141,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/14204\/revisions\/19141"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=14204"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=14204"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=14204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}