Inventory Page Overview
The Inventory page shows all stocked parts your shop currently has on hand. It includes quantities, bin locations, vendors, pricing, and cost information. This page is used by the parts department to manage physical inventory, maintain min/max levels, restock parts, and ensure accurate pricing.
As of the 26.47.0 release, the Inventory list has Active and Inactive tabs, and each part has an Inventory Tracking switch. See the article Part Lifecycle: Retire Parts and Inventory Tracking for the full details; the highlights are below.
What the Inventory Page Shows
Each inventory item displays:
Description: The name of the part as it appears in your system.
Part Number: The item's unique identifier or manufacturer number. Used for ordering, searching, and tracking.
Category: Each part belongs to a category (e.g., brakes, engine, electrical). Categories determine which pricing matrix is applied.
Manufacturer: Optional identifier for the brand or maker of the part. (can be added right from the inventory page by clicking any part and filling up the Manufacturer field)
Primary Vendor: The vendor the shop normally purchases the item from.
(Used for restocking and price reference.)Grid / Bin Location: A physical storage location in your shop's parts room (e.g., B11). Helps staff find parts quickly.
Average Cost: The weighted average cost of the part, updated using a FIFO (first-in, first-out) method. This cost changes over time as new stock is purchased at different prices.
Sell Price: The retail price automatically calculated using the pricing matrix tied to the part's category.
If the price is manually overridden, the field turns green.Core: If a part includes a core charge (e.g., remanufactured calipers), the core value appears here.
Quantity On Hand: How many units the shop physically has available. An untracked part shows "Not Tracked" instead of a quantity.
Min / Max Levels: Inventory thresholds set by the shop:
Min = When quantity drops below this number, the part should be reordered.
Max = The preferred maximum stocking level.
Color indicators:
Green = Quantity is between min and max
Orange = Above max
Red = Below min
Active and Inactive Parts
The Inventory list has two tabs under the page title. Active opens every time and lists the parts in use at your location; Inactive lists the parts you've retired. Search, filters, sort, Export and Cycle count work on both tabs and follow the tab on screen.
Retire a part one at a time with the Part Status choice in Edit Inventory Part, or in bulk with Deactivate parts in the Inventory actions menu (the three-dot button that holds Cycle count and Export): tick up to 200 parts, then press Deactivate on the bar.
Every status change asks you to confirm, with an optional note, and Part History records who did it and when.
A retired part keeps its history, stock and QuickBooks records, but is refused on new work orders, estimates, part sales and purchase orders, and canned jobs add without it. Bring it back from the Inactive tab.
Retiring parts and changing tracking need the Delete permission under Part Library & Inventory.
Inventory Tracking
A new switch in the part dialog, on by default. Turn it off for bulk hardware and shop supplies you don't count: the part shows Not Tracked instead of a quantity, is left out of Cycle count, the printed count sheet and the Inventory Value report, and keeps its In Stock badge on work orders whatever its quantity. Turning tracking off clears nothing and writes nothing off, and the part still moves stock and posts to QuickBooks exactly like a tracked part, so expect its bin quantities to drift.
Cycle Counting Inventory
The inventory page supports cycle counting, allowing staff to quickly correct quantity discrepancies.
How to Cycle Count:
Click the three dots (...) in the header section
Select Cycle Count.
Enter the correct quantities for one or multiple items.
Save the updates — the system shows the adjustments made.
If correcting a negative inventory quantity, ensure the updated quantity brings the value to zero or a positive number. For example, if the quantity is -5, adding 5 units will correct the discrepancy.
Additional features:
You can cycle count filtered lists (e.g., specific bin locations).
A print option is available so techs can walk through the parts room and record counts manually. A search finds the part and prints all of its bins; to count a single bin, use the Bin Location filter. Untracked parts are never counted and are left off the printed count sheet.
Updating Inventory Quantities
When you upload an edited inventory file in ShopView, it updates only the quantities for your parts. This process does not affect pricing, cost, or other financial records. You can confidently update your inventory quantities without worrying about unintended changes to your financial data.
Understanding Average Cost (FIFO)
Average cost adjusts based on actual purchase history.
Transcript example:
Buy 5 parts at $10
Buy 5 more at $20
Average cost becomes $15
When selling parts, the system removes the oldest stock first (FIFO), updating the remaining average cost.
This protects shops from:
Outdated pricing
Cost fluctuations
Incorrect margin calculations
Sell Price and Price Overrides
Sell price is normally calculated automatically using the pricing matrix assigned to the part's category.
If a user changes the sell price manually:
The price field turns green
Removing the overridden value restores the calculated price
Min/Max Levels & Reorder Indicators
Min/max settings help maintain correct stock levels.
Indicators:
Green = within desired range
Orange = overstocked
Red = needs restocking
An untracked part keeps its Min and Max, unused while it's untracked, and uses them again when tracking is turned back on. Min and Max changes are recorded in Part History, with the old and new values.
Filtering and Searching Inventory
You can search by:
Part number
Description
Category
Vendor
Bin location
Any keyword (global search)
Filtering allows parts staff to:
View only items below min
Filter by location
Prepare restock lists
Find misplaced stock
Search "not tracked" to list the untracked parts along with the normal matches, and sorting by Total Qty puts untracked parts last in both directions.
Part Library (formerly Catalog)
The Part Library (formerly Catalog) is a historical record of every part ever purchased and used. It includes all parts in your inventory and any other parts that have been used on a work order but not stored in inventory (special order parts). The Part Library acts as the central repository for all part data in ShopView. You can now change a Part Number or Description right in Edit Inventory Part: the part keeps its history and every line that holds it, open purchase orders and part requests take the new number, and completed records keep the number they were written with. The number and description are shared by every location that stocks the part, so a change applies everywhere, and the dialog warns before you save.
A quick distinction:
Inventory
What your shop physically has in stock
Quantities, bin locations, and FIFO cost are tracked here
Part Library
A historical record of every part ever purchased or used
Includes special-order parts
Shows purchase history and linked vendor invoices
Part Library vs Inventory Parts Distinction
Inventory Parts:
Parts currently in stock.
Enables actions like picking for use with detailed stock information.
Part Library Parts:
Parts listed but not stocked, often tied to purchasing and vendor interactions.
Users should ensure correct selection to avoid ordering stocked parts unnecessarily.
How to create a part
Go to Parts → Inventory and click New Inventory Part.
Type the Description and Part Number. Both are required, and there is no Part Library step.
Select the Category (the category decides which pricing matrix is applied), enter the Cost, add a Bin location and the Quantity on hand.
Click Save.
ShopView links the part to the Part Library behind the scenes: when the number exactly matches an existing entry (same characters, same upper and lower case), the new part joins it and the entry keeps its own description. Any other number gets an entry of its own. A number already stocked at your location is refused, even when it differs only in upper and lower case, hyphens, asterisks, periods or spaces; if that part is inactive, the message says to activate it from the Inactive tab.
Using Inventory on Work Orders
When adding a part to a work order:
If the part exists in inventory, selecting it will decrement quantity when picked.
If the part does not appear in inventory, it is treated as a vendor/special-order part.
An inactive (retired) part is refused on new work, however it arrives: the lookup says it's inactive and to activate it from the Inactive tab.
Double-check whether a part is an inventory item or only in the Part Library to avoid unnecessary purchase triggers.
Inventory Part History
When a part quantity looks wrong, the Part History view shows exactly what happened — every pick, adjustment, price change, and quantity update, including who made the change and when. This is the first place to check when inventory doesn't match what you expect. It also records Deactivated and Activated, Tracking turned off and on, part number and description changes, and Min and Max changes.
Common reasons a quantity may be off:
A part was picked for a work order and the WO was deleted without returning the part
A cycle count was entered incorrectly
A purchase order was partially received
A part was used on a work order by a different location
Navigate to Parts, then Inventory, and Click on the Clock with a reverse clockwise arrow to view Part History.
Troubleshooting Inventory Discrepancies
A part is showing as missing or the quantity dropped unexpectedly
Open the part and check Part History (clock icon) to see the last action taken on it.
Look for a recent "Picked" entry — this means the part was used on a work order.
If the WO that consumed it was deleted, the quantity won't be restored automatically. Use Cycle Count to correct it.
If no pick is visible, check whether a different location has separate inventory for this part.
A part I know exists isn't showing up in search
Make sure the search field is cleared of any previous filters.
Try searching by part number, description, and vendor separately — different shops enter parts differently.
Check the Inactive tab — the part may have been retired at your location. Also check the Part Library (formerly Catalog): the part may exist there but not be stocked at your location.
If the part has a quantity of 0 and min/max is not set, it may be filtered out. Use the column filters to show zero-quantity items.
The quantity is a negative number
Negative inventory means more parts were consumed than were recorded as received. To fix it:
Check Part History to identify the source of the extra picks.
If a purchase order was received but the part wasn't updated, receive it now.
Use Cycle Count (three-dot menu in the header → Cycle Count) to set the correct on-hand quantity.
An untracked part's bins drift by design: it still moves stock when used, and nobody counts it. Its quantities are a shelf reference only.
Inventory quantity adjustment needed after a physical count
Use Cycle Count (three-dot menu → Cycle Count) to enter corrected quantities for one or multiple items at once.
You can filter the list to a specific bin location before running a count to make it more manageable.
A print option is also available so staff can walk the parts room and record counts on paper first.
I received a part on a PO but it's not in inventory
If the part number already exists, ShopView increments the existing part's quantity rather than creating a new record
The part looks missing while the quantity moved.
Check Part History on the existing part.
A part sitting at negative on-hand can absorb a receipt and still show unavailable.
Part Library vs Inventory
Part Library entries are shared across locations
Inventory is per-location.
Create the part from the Inventory list with New Inventory Part at that location; ShopView links it to the Part Library automatically.
Cost entered but no sell price generated
The default price matrix only prices Uncategorized parts; it's the fallback.
To price by category you create a separate matrix and attach the category to it. which is also why the category selector looks greyed out on the default matrix. This wasted a long escalation.
Where to change cost vs sell price?
Cost is editable only in Inventory; the work order edits sell price only.
Exporting Inventory
You can download your full inventory list as a spreadsheet file (opens in Excel or any other spreadsheet tool).
Go to Parts > Inventory.
Click the three dots (...) in the top-right of the Inventory header.
Select Export. The inventory file downloads to your computer. Export writes "Not Tracked" in the quantity column for untracked parts, follows the tab on screen, and includes every matching row, including rows not yet scrolled into view.
Summary
The Inventory page is the primary tool for managing stocked parts in ShopView. It helps your shop:
Track accurate part quantities
Maintain min/max levels
Restock efficiently
Use FIFO cost for accurate margins
Locate parts quickly using bin locations
Override pricing when needed
Correct discrepancies through cycle counts
Retire parts you no longer stock, and skip counting the ones you don't track
All of this ensures a smoother workflow for parts staff, service advisors, and technicians, and keeps your parts department tightly organized.


