Your store should plan for a physical full-store inventory count once a year. Every salable product is counted, regardless of location (e.g. sales floor, back stock, warehouse, etc.). Physical inventory counts are performed by store section, not by category. This method ensures no products are missed during the count.

Selecting an Inventory Date

At least a month beforehand, you should pick out a day for the full-store inventory. When choosing the date, consider the following:

1. Expect your physical inventory count to take a full day and schedule your employees accordingly.
2. The shop needs to be closed to customers during your inventory. This is key to help you maintain accurate numbers for products scanned, or physically counted. It also stops you from getting distracted every few minutes with customer questions.

Note: Close on the slowest day of the week. Use Ascend's Sales > Sales by Day of Week report to help you determine the best day for closing.

Inform your employees and customers of your inventory date. Display the date prominently. Update your social media accounts, send an email or two, put posters up in the shop and around town, buy billboards, rent planes! Do whatever you need to do to ensure everyone knows when you'll be closed.

Closing for Inventory

Best practice recommendation is to close your store for inventory. This keeps the focus on inventory without distractions and interference from customers. 

While your store is closed for a physical inventory count:

1. Do not allow customers to drop off products for work orders or returns.
2. Do not process sales, layaways, or work orders.
3. Scan all products currently for sale (on the sales floor or in backstock).
4. Do not scan:
   1. Items on layaway transactions.
   2. Items on work order transactions.
   3. Unreceived orders.
   4. Non-inventory items (e.g.: miscellaneous hardware for repairs).
   5. Multi-store retailers: Pending transfer items.

One Month Before

Reduce your inventory as much as possible. Only order necessary products. Use the Inventory > Aged Inventory by Date report to view a list of products that are not selling through. Many retailers use this time to create a sales Promotion for older items.

Audit Product Labels

Audit your product labels using your EA520 or EA660 inventory scanner. You can easily have a staff members work on this if they have down time. Give them a scanner and have them start scanning items. 

Make sure they get all “good beeps”. "Good beeps" should pull up the right product information on the scanner screen, including Description, MSRP, and UPC or In-Store SKU.

If they’re getting “bad beeps”, address the issue and get the product a new label. Doing this in advance will save time on inventory day and keep items that don’t scan to a minimum.

Review the Ascend Inventory Process

One Week Before

Address Tools and Reports

1. Duplicate Products: Run the Remove Duplicate In Store Products utility under Tools > Advanced Database Functions in Ascend. Resolving duplicate SKUs and UPCs ensures that each product in your store is labeled with a unique SKU or UPC.
   1. Note: Duplicate products cannot be reconciled in your system. Resolve these issues ahead of time to minimize time spent addressing product issues on the day of inventory.
2. All Products Categorized: Use the Products - Category Mapper to address products currently in inventory which are not assigned to a category.
3. Products with Cost Issues:
   1. Reports > Products Sold with No Category because it affects reporting and the sales information in QuickBooks integration.
   2. Reports > Inventory with Cost Greater Than MSRP report as well and remedy any products configured with an invalid cost.

Obtain Inventory Supplies

1. Blue Painter's tape for marking store sections 
   1. Note: It’s important that you specifically get painter’s tape. You do not want to permanently divide up your sales floor by accident.
2. Paper you can print the section numbers on. You can find section numbers by logging into Ascend Sharefile > US Downloads > Other Files > Physical Inventory Section Numbers.
3. Markers, pens or pencils for initialing completed sections
4. Boxes or other containers to hold "bad beep"" items (items not recognized by the inventory scanners)
5. Assign the roles employees will assume on your inventory date.
   1. Product Investigator(s)
      1. Adds missing product to Ascend.
      2. Re-labels products which cannot be scanned.
      3. Investigates count discrepancies.
   2. Inventory Point Person
      1. Inventory scanner preparation.
      2. Saves scan files to the computer.
      3. Reconciles the count with Ascend (accepting final count)
      4. Your point person should be extremely comfortable with Ascend. 
         1. Note: For multi-store retailers, if possible, have a single Inventory Point Person go between all locations to assist with inventory to help things go smoothly (and consistently!) across all your stores.
   3. Counters
      1. Physically counts items.
      2. Keeps track of completed sections.
   4. Scanners
      1. Scans products with the inventory scanners.
6. Ensure employees have the appropriate user permissions for their roles. Article: Users - User Permissions 
7. Consider pre-counting large quantities of small parts that are sold very infrequently (e.g. spokes, CO2 cartridges, bearings) using a high-quality scale.
   1. Note: Clearly label pre-counted product as such. If any pre-counted products are sold prior to your inventory, ensure that the labeled quantity is updated accordingly.

Two Days Before

1. Create an Inventory Event for your event in the Inventory Center in Ascend. Article: Inventory Center - Creating and Navigating Inventory Events.
2. Fully charge inventory scanner and, if available, spare batteries. Check the battery life indicator on the device.
3. Complete any pending warranty items. Article: Warranty an item.
4. Make sure any Layaways or Work Orders with items that have left your store are converted to finished sales. Article: Sales - Create a Layaway.
5. Stop receiving orders, and quarantine any new products until after completing your inventory.
6. Multistore retailers should also be sure to verify all pending transfers and halt transfers between stores until your physical inventory count is complete. Article: Multi-Store - Transfers Between Locations.

One Day Before

1. If you are using Unitech EA520 or EA500 Plus inventory scanners, you can configure the scanners with your Inventory Event today (to save time tomorrow if there are any issues connecting via your WiFi network).
2. Organize products for ease of scanning.
   1. Label bin and display items. Or, place these items in boxes with scannable barcodes.
   2. Move hard to reach to items within easy reach.
   3. Turn items so that barcodes face front.
3. Using painter's tape, section off your store into small areas for scanning. Be sure to divide the store into sections that can be scanned easily. 
   1. We recommend keeping sections small; no more than 50 to 75 items at most. As you’re dividing up your shelves and sales floor with section numbers, remember to write any special notes about that section on the section number (such as: include items on the mannequin). 
   2. For additional details and tips, see the Inventory Center - Preparation: Setting Up Sections article. 
4. Designate your box/area for "bad beep" or mystery items that do not scan.
5. Now make a copy of your Ascend database by running a backup from your server machine. Article: Configuration - Stay Secure and Updated.

Day of Inventory

1. Before you begin inventory be sure to Save or Email yourself a copy of your Inventory by Category Summary Report (Reports > Inventory > Inventory by Category Summary) so you have a before inventory total.
   1. Note: Be sure you Save or Email yourself a copy of the Inventory by Category Summary post reconcile as well.

Additional Resources

KB22-112