Count Sheets XX Store Closeout Check

This report lists SKUs that are on your current Count Sheets with Count Type XX, indicating an item with very low sales volume in your store and peers.  Many times these SKUs are "phantom inventory" where they exist in your computer system but have not been part of your store's assortment for a long time.  Risk: the SKUs in this report are active in your RSC and risk being reordered if zeroed out during Count Sheet processing.

SKUs on this report

  • Are on your current Count Sheets to be inventoried as XX Count Types.
  • Have Store Closeout set to N (can be reordered). 
  • Are Active or Closeout in your RSC (can be replenished).
  • Are very slow sellers in your store and in peer stores.
  • Are not part of a "collection" (e.g. v-belts, numbered drill bits, paint bases, etc.).
  • Are not Discovery SKUs.
  • Are not COM excluded SKUs (Loc2 = XDR, for stores using COM).
  • Steps to process this report:

    1. Decide if the SKU should be reordered if zeroed during counting. 
    2. If the SKU should be reordered then do nothing, skip to the next SKU.
    3. if you do not want the SKU reordered then:
      1. Display the SKU in Inventory Maintenance.
      2. Change to the Codes tab in Inventory Maintenance.
      3. Change the Store Closeout flag to "Y" (3rd Column).
      4. Press Change.
    • K - TTM Units: the number of sales units for the SKU for the twelve trailing months. 

      L - RSC Status: indicates if the SKU is on closeout or active in your warehouse.  A Closeout status means the SKU will be canceled as soon as RSC inventory is depleted. 

      M - SKU Status: shows if the SKU is "obsolete", meaning the SKU has not sold in over two years. 

      N - Peer Units: the twelve trailing months sales units for the typical peer store.  

    MEGA Report Count Sheer XX Store Closeout Check Report

  • Steps to process this report:

    1. Decide if the SKU should be reordered if zeroed during counting. 
    2. If the SKU should be reordered then do nothing, skip to the next SKU.
    3. if you do not want the SKU reordered then:
      1. Select the Products Menu.
      2. In the search box, type a SKU from your report and press Enter.
      3. In the Stock & Sell tab, set Store Closeout to Yes.
      4. Press Save in the upper-right.
      5. Repeat these steps for each SKU listed.
    • K - TTM Units: the number of sales units for the SKU for the twelve trailing months. 

      L - RSC Status: indicates if the SKU is on closeout or active in your warehouse.  A Closeout status means the SKU will be canceled as soon as RSC inventory is depleted. 

      M - SKU Status: shows if the SKU is "obsolete", meaning the SKU has not sold in over two years. 

      N - Peer Units: the twelve trailing months sales units for the typical peer store.  

    MEGA Report Count Sheer XX Store Closeout Check Report