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.
While your store is closed for a physical inventory count:
- Do not allow customers to drop off products for work orders
- Do not process sales, layaways, or work orders.
- Scan all products currently for sale (on the sales floor or
- Do not scan:
a. Items on layaway transactions.
b. Items on work order transactions.
c. Unreceived orders.
d. Non-inventory items (e.g. miscellaneous hardware for repairs).
e. (multi-store retailers) Pending transfer items.
One Month Before
At least a month beforehand, you should pick out a day for the full-store inventory. When choosing the date, consider the following:
a. Expect your physical inventory count to take a full day and schedule your employees accordingly.
b. Pick out a day for the full-store inventory. 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.
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 count 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.
If you require additional inventory scanners for your inventory, reserve the required number of rental units from Ascend support.
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.
Familiarize your staff with full process to be followed on the actual date of your inventory count.
a. Read through our knowledge base articles.
b. Complete our training modules.
Audit your product labels. 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 the right price and 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.
One Week Before
- Run the Remove Duplicate InStore 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.
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.
- Use the Category Mapper utility to address products currently in inventory which are not assigned to a category.
- Head to Reports > Products Sold with No Category because it affects the sales information in Quickbooks integration.
- Run the Reports > Inventory with Cost Greater Than MSRP report as well and remedy any products configured with an invalid cost.
- Obtain your inventory supplies:
a. Painter's tape for marking store sections (It’s important that you specifically get painter’s tape. You do not want to permanently divide up your sales floor by accident!),
b. Paper you can print the section numbers on,
c. Markers, pens or pencils for initialing completed sections,
d. and boxes or other containers to hold "bad beep" items (items not recognized by the inventory scanners).
- Assign the roles employees will assume on your inventory date.
a. Product Investigator(s)
i. Adds missing product to Ascend.
ii. Re-labels products which cannot be scanned.
iii. Investigates count discrepancies.
b. Inventory Point Person
i. Inventory scanner preparation.
ii. Saves scan files to the computer.
iii. Reconciles the count with Ascend (accepting final count
iv. Your point person should be extremely comfortable with Ascend.
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.
i. Physically counts items.
ii. Keeps track of completed sections.
i. Scans products with the inventory scanners.
- Ensure employees have the appropriate user permissions for their roles.
- Consider pre-counting large quantities of small parts that are sold very infrequently (e.g. spokes, CO2 cartridges, bearings) using a high-quality scale.Sherpa Tip: 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.
a. Weigh one item. Write down the weight.
b. Weigh all items. Write down the weight.
c. If weighing items in a container, weigh the empty container. Write down the weight.
d. If necessary, subtract the recorded container weight from the recorded weight of all items. Write down the adjusted weight.
e. Divide the adjusted weight of all items by the weight of one item, e.g. 100 (all items) divided by 25 (single item) equals 4 (quantity of all items).
f. Record the calculated quantity.
Two Days Before
- Create an Inventory Event for your event in the Inventory Center in Ascend.
- Fully charge inventory scanner and, if available, spare batteries. Check the battery life indicator on the device.
- Complete any pending warranty items.
- Make sure any Layaways or Work Orders with items that have left your store are converted to finished sales.
- Stop receiving orders, and quarantine any new products until after completing your inventory.
- Multistore retailers should also be sure to verify all pending transfers and halt transfers between stores until your physical inventory count is complete.
One Day Before
- If you are using Unitech 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).
- If you are using MC2180 scanners for your inventory, create a specific folder for storing your physical inventory count files.
a. From the Windows® Desktop, right-click in a blank area.
b. From the displayed menu, select New > Folder.
c. Enter a descriptive name, e.g. Physical Inventory - <YYYY>.
d. On the keyboard, press [Enter].
- If you are using an MC2180 or MC1000 inventory scanner, verify an SD memory card is installed in the inventory scanner:
a. MC1000 model: 2 GB standard only.
b. MC2180 model: Up to 32 GB microSD.
- Organize products for ease of scanning.
a. Label bin and display items. Or, place these items in boxes with scannable barcodes.
c. Move hard to reach to items within easy reach.
d. Turn items so that barcodes face front.
- 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. We recommend keeping sections small; no more than 50 to 75 items, tops! 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).
An average store has 150+ sections.
- Designate your box/area for "bad beep" or mystery items that do not scan.
- Now make a copy of your Ascend database by running a backup from your server machine.
Article: Set up an Inventory Event
Article: Analyze inventory scan results
Article: Reconcile my inventory
Trek University Video: Inventory Management