--- title: Monitor Inventory in Salesforce With an Inventory Level Object | Lookup Helper Use Case Library description: Use case for inventory management. See how companies with multiple locations can easily identify when product inventory is low for each location. image: https://www.passagetechnology.com/hubfs/LH%20use%20case%20image%20inventory%20-png.png --- [GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779 [![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com) - Solutions - By User Type - [Admins](https://www.passagetechnology.com/en/solutions/salesforce-admin) - [Getting Around Rollup Limitations](https://www.passagetechnology.com/en/solutions/salesforce-admin#rollup-limitations) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-admin#Reports) - [GDPR Compliance](https://www.passagetechnology.com/en/solutions/salesforce-admin#GDPR) - [Data Cleanup](https://www.passagetechnology.com/en/solutions/salesforce-admin#cleanup) - [Project Managers](https://www.passagetechnology.com/en/solutions/salesforce-project-managers) - [Managing Internal Projects](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#internal-projects) - [Collaborate on External Projects & Client Status Reporting](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#External) - [Project Analytics](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#Analytics) - [Salesforce Training for Project Management Success](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#SF-training) - [C-Suite](https://www.passagetechnology.com/en/solutions/c-suite) - [Business Insights](https://www.passagetechnology.com/en/solutions/c-suite#business-insights) - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/c-suite#decision-making) - [Project Planning & Managing Execution](https://www.passagetechnology.com/en/solutions/c-suite#managing-execution) - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/c-suite#custom-solutions) - [IT Managers](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce) - [Security & Compliance](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#security) - [Enabling Salesforce Users](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#enabling-team-members) - [Managing IT Projects](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#projects) - [Avoiding Technical Debt](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#avoid-technical-debt) - [Salesforce Analysts](https://www.passagetechnology.com/en/solutions/salesforce-analysts) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-analysts#reports) - [Project Management](https://www.passagetechnology.com/en/solutions/salesforce-analysts#project-management) - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/salesforce-analysts#custom-solutions) - By Industry or Cloud - [Software](https://www.passagetechnology.com/en/solutions/computer-software-industry) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/computer-software-industry#reports) - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/computer-software-industry#decision-making) - [Project Management](https://www.passagetechnology.com/en/solutions/computer-software-industry#project-management) - [Security & Compliance](https://www.passagetechnology.com/en/solutions/computer-software-industry#security) - [Healthcare & Life Sciences](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud) - [Project Management](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#project-management) - [HIPAA Compliance](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#hipaa) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#reports) - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#custom-solutions) - [Financial Services](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud) - [Relating Custom Objects](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#custom-objects) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Reports) - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#data-quality) - [Compliance](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Compliance) - [Nonprofit](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#reports) - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#data-quality) - [Project Management](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#project-management) - Products - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview) - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview) - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview) - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview) - [Work Trail](https://www.passagetechnology.com/work-trail-overview) - [Support](https://www.passagetechnology.com/support) - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-training) - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-training) - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-training) - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-training) - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-training) - [Work Trail](https://www.passagetechnology.com/work-trail-training) - [Services](https://www.passagetechnology.com/developmentservices) - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/) - [Log a Support Case](https://www.passagetechnology.com/contact-us) - [Resources](https://www.passagetechnology.com/resources) - [Blog](https://www.passagetechnology.com/passage-technology-blog) - [Customer Success Stories](https://www.passagetechnology.com/customer-success) - [Essential Guides for Business Transformation with Salesforce](https://www.passagetechnology.com/en/essential-guides-for-business-transformation-with-salesforce) - [Use Case Libraries](https://www.passagetechnology.com/use-case-libraries) - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/) - [Release Notes](https://www.passagetechnology.com/release-notes) - [Company](https://www.passagetechnology.com/about) - [About Us](https://www.passagetechnology.com/about) - [Press & Testimonials](https://www.passagetechnology.com/press-testimonials) - [Contact Us](https://www.passagetechnology.com/contact-us) - [Partners](https://www.passagetechnology.com/partners) - [Careers](https://www.passagetechnology.com/working-at-passage) - [Search](https://www.passagetechnology.com/search) # Monitor Inventory in Salesforce With an Inventory Level Object [![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers) ## Problem: Companies with multiple locations need the ability for each location to easily identify when product inventory is low, however, this can be difficult to achieve in Salesforce®. For example, as the manager of a busy inventory department at an automotive repair shop, Joe needs to quickly identify parts that are running low on inventory. How can Joe accomplish this? ## Solution: Lookup Helper can help Joe see all parts that are running low on inventory in one related list with the click of a button. In the example below, we’ll walk through how to achieve this. The first step is to create a Salesforce Object called Part. - Add a field named Amount - Add a formula field named Inventory Level, which returns Text.  - Then set the formula to: IF(Amount__c > 20, "High", IF(Amount__c > 10, "Medium", "Low") )  ![Formula Field](https://www.passagetechnology.com/hubfs/LH%20use%20case%20inventory%20screen%20shot%201-png.png) Next, create a Salesforce Object called Inventory Level.  Now you can create a lookup relationship field on the Part Object, and relate it to the Inventory Level Object. The last step is to create a Lookup Helper Setting: - Child Object: Part - Parent Object: Inventory Level - Child Field: Inventory Level - Parent Field: Inventory Level Name - Enable Category Record Creation *The image below shows how a Child Part field (Inventory Level) can be matched to a Parent Inventory Level field (Inventory Level Name).*   ![Matching Criteria](https://www.passagetechnology.com/hs-fs/hubfs/image%20(32).png?width=807&name=image%20(32).png) Now when a Part Record Amount is 25, it will be related to the “High” Inventory Level record.  Because we also enabled Category Record Creation, a new Inventory Level record named “Low” will be created the first time the Amount of a Part record dips below 11. Since the “Low” Inventory Level record has been created, any other part with an Amount value below 11 will also be related to the “Low" Inventory Level record. Have a use case you’d like to share? *If you have a Lookup Helper Use Case, we’d love to hear from you! Just *[*submit it using this form*](https://www.passagetechnology.com/share-your-story)*. Submitting use cases allows everyone to get the most from their investment in Salesforce.*   Have questions?  [![Schedule Demo](https://no-cache.hubspot.com/cta/default/4130736/7f11138e-273e-446e-9889-6e6fb453e4c5.png)](https://cta-redirect.hubspot.com/cta/redirect/4130736/7f11138e-273e-446e-9889-6e6fb453e4c5) Tags: [Lookup Helper](https://www.passagetechnology.com/lookup-helper-use-cases/topic/lookup-helper), [Inventory Level](https://www.passagetechnology.com/lookup-helper-use-cases/topic/inventory-level), [low inventory](https://www.passagetechnology.com/lookup-helper-use-cases/topic/low-inventory), [monitor inventory in Salesforce](https://www.passagetechnology.com/lookup-helper-use-cases/topic/monitor-inventory-in-salesforce) | [** e-Commerce: View Products by Category in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/e-commerce) | [Lookup Helper Use Case Library](https://www.passagetechnology.com/lookup-helper-use-cases) | [ How Can I Overcome Limitations with Salesforce Queues? ** ](https://www.passagetechnology.com/lookup-helper-use-cases/parent-child-filter) | | --- | --- | --- | [ Tracking Open Cases on Contacts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/track-open-cases-on-contacts-in-salesforce) [ Tracking Open Cases on Accounts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/track-open-cases-on-accounts-in-salesforce) [ Relate Contacts to their Assistants in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/relate-contacts-to-their-assistants-in-salesforce) [ Automatically Link Contacts to Individuals in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/automatically-link-contacts-to-individuals-in-salesforce) [ Automatically Link Contacts to Account Owners in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/automatically-link-contacts-to-account-owners-in-salesforce) [ Link Child Accounts to Ultimate Parent Account in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/ultimate-parent-account) [ Set Queue Custom Object on Any Standard Object ](https://www.passagetechnology.com/lookup-helper-use-cases/top-use-case-set-queue-custom-object-on-any-standard-object) [ Display Related List of Grandchild Records on the Parent Record ](https://www.passagetechnology.com/lookup-helper-use-cases/top-use-case-link-cases-and-opportunities-to-parent-accounts) [ Relating Cases to Accounts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/relating-cases-to-accounts-in-salesforce) [ Assign Lead to Account Owner and Send New Lead Notification ](https://www.passagetechnology.com/lookup-helper-use-cases/assign-lead-to-account-owner-and-send-new-lead-notification) ![Salesforce certified services by trusted Passage Technology](https://www.passagetechnology.com/hubfs/Salesforce/SF%20Partner%20Badges%202026%20(for%20footer).png) Explore - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview) - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview) - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview) - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview) - [Work Trail](https://www.passagetechnology.com/work-trail-overview) Services - [Custom Development Services](https://www.passagetechnology.com/developmentservices) - [Milestones PM+ Starter Packs](https://www.passagetechnology.com/milestones-pmplus-starter-packs) Learn - [Support Portal](https://www.passagetechnology.com/support) - [Resources Portal](https://www.passagetechnology.com/resources) Company - [About](https://www.passagetechnology.com/about) - [Careers](https://www.passagetechnology.com/working-at-passage) - [Press & Testimonials](https://www.passagetechnology.com/press-testimonials) - [Partners](https://www.passagetechnology.com/partners) Questions? - [Contact Us](https://www.passagetechnology.com/contact-us) - +1 (224) 655-6779 [GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) © 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496) - [** ](https://www.facebook.com/passagetech) - - [** ](https://www.linkedin.com/company/passage-technology) - [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Carrie Brown", "url" : "https://www.passagetechnology.com/lookup-helper-use-cases/author/carrie-brown" }, "dateModified" : "2026-07-30T17:53:55.768Z", "datePublished" : "2022-10-19T21:28:15.000Z", "headline" : "Monitor Inventory in Salesforce With an Inventory Level Object", "image" : [ "https://www.passagetechnology.com/hubfs/LH%20use%20case%20image%20inventory%20-png.png" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/lookup-helper-use-cases/monitor-inventory", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png" }, "name" : "Passage Technology LLC" } } ```