Inventory Tracking & Reorder Report

Track the quantity on hand (QoH) of your inventory items. Generate a reorder report that displays items you’re running low on, so you can efficiently reorder from your suppliers.

Table of Contents

Set an Order Trigger and Recommended Order value to help determine when you’re running low.

Order Trigger

The low-quantity alert. When an item’s QoH reaches this number, it will appear in the Reorder Report.

This number serves as a reminder in the Reorder Report of how many units should be on hand at full stock.

  1. From the BackOffice, choose 'Items', then 'Item List'.
  2. Select an existing item to edit, or add a new item.
  3. Click the 'Additional Details' tab.
  4. Enter a value for 'Order Trigger' and 'Recommended Order'.
  5. Click 'OK' to save your changes.

Quantity on Hand History

You can see when any item was sold, returned, received, or adjusted within ShopKeep by viewing the QoH History for that item (if Inventory Method for the item is set to ‘tracked’).

Receiving events display an Adjustment Reason of “[per-unit cost of received items] / item”.

  1. From the BackOffice, choose 'Items' and 'Item List'.
  2. Choose any item from the list.
  3. Click the QoH History link.
  4. Select a week-range to view from the pulldown.

    Your item’s history of additions or removals will be generated for that specific range.

Generating a Reorder Report

The Inventory Reorder Report is populated by items with a Quantity on Hand that is less than or equal to their Order Trigger. Use this report to know which items to reorder from your suppliers.

  1. Choose 'Analytics' from the sidebar.
  2. Under Inventory, click 'Reorder Report'.

Below is a sample Reorder Report. Toggle between Stock Items and Raw Goods to see what needs to be ordered. Sort in ascending or descending order by clicking one of the column headers.

‘Cost’ displays the current average cost and ‘Last Cost’ shows the per-unit cost at the last receiving event. If an item does not have an average cost or last cost, the current cost displays. If you do not want to use weighted average cost, follow the steps here to disable the feature.

Click to Enlarge

Download a spreadsheet copy to your computer. Viewable in any spreadsheet software.

Click to Enlarge