Skip to main content

How does ShopView handle part numbers in inventory management?

Understand how ShopView manages part numbers in inventory, including duplicate prevention, automatic quantity updates for received parts, and common inventory scenarios. Learn how to resolve part number conflicts and keep inventory accurate.

How does ShopView handle part numbers in inventory management?

Overview of Part Numbers in ShopView

ShopView's inventory management system is designed to efficiently organize parts based on unique part numbers, with every number linked to an entry in the Part Library (formerly the Catalog). This approach ensures clarity and prevents duplication, helping businesses maintain an accurate inventory.

Rules for Part Number Handling

  1. Prevention of Duplicate Part Numbers - When creating a part with New Inventory Part, ShopView checks whether the part number is already stocked at your location. A number already stocked is refused, even when it differs only in upper and lower case, hyphens, asterisks, periods or spaces. If that part is inactive (retired), the message says to activate it from the Inactive tab instead of creating a new one. This rule prevents duplicate entries and maintains consistency within the inventory database.

  2. Automatic Attribution of Received Parts - When a received part has a part number matching an existing inventory item, the system attributes the new quantity to the existing entry. This means the received part does not create a separate inventory line but rather increases the quantity of the matched item. - For example, if a part like "High Temp Stud" has the same part number as "Thermostat," the system will add the received quantity to the "Thermostat" entry instead of creating a new standalone entry.

    1. How Part Library linking works when creating a part: when the number you type exactly matches a Part Library entry (same characters, same upper and lower case), the new part joins that entry, and the entry keeps its own description. Any other number gets a Part Library entry of its own.

Common Scenarios and Solutions

How to Update a Part Number Without Creating Duplicates

You can change a part number or description on the part itself, with no second part or Part Library entry created:

  1. Open the part in Edit Inventory Part (from Parts → Inventory), or open its entry in the Part Library and use the Edit (pencil) icon.

  2. Update the Part Number and/or Description as needed.

  3. Click Save to apply the changes.

The part keeps its history and every line that holds it. Open purchase order lines, part requests not yet received, canned jobs and open returns take the new number; 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. Part History at every location records the old and the new value. If the rename is refused because the number already belongs to another Part Library entry, note that two entries can't be combined in this release.

Issue: A part doesn’t appear when attempting to add it to inventory

  • Reason: The part number is already stocked at this location (ignoring upper and lower case, hyphens, asterisks, periods and spaces), and duplicate entries are not allowed. If the existing part is inactive, it won't show on the Active tab.

  • Solution: Search for the part in the existing inventory, including the Inactive tab, and update its details or activate it if required. To update the part number, open the part in Edit Inventory Part, change the Part Number, and Save.

Issue: Received parts appear under another item in the inventory

  • Reason: The part number of the received item matches an existing entry, so the system increases the quantity of the existing part instead of adding a new line.

  • Solution: To correct errors in part numbers, follow these steps:

    1. Create a New Part: Add a new part in the system with the correct name and part number. Receive the item under this newly created part.

    2. Adjust Inventory for the Incorrect Part: Perform a cycle count to reduce the quantity of the incorrectly matched part by 1.

    3. Update Pricing (if necessary): If the incorrectly-matched part had a different price than the new part, update the price on the part so future work orders pull the correct amount. This does not retroactively change pricing on work orders or invoices that already used the incorrect entry — those must be corrected individually if needed.


By understanding these guidelines for part number management in ShopView, users can navigate inventory scenarios more effectively, resolve potential overlaps, and maintain a well-organized system. For retiring parts and inventory tracking, see the article Part Lifecycle: Retire Parts and Inventory Tracking.

Did this answer your question?