All Projects
Dynamic Inventory Catalog icon

Dynamic Inventory Catalog

inventory catalog excel

Internal product catalog consolidating multiple vendor sources into a searchable system for sales teams, with customer-facing segmented views.

The Challenge

The sales team juggled product information scattered across multiple vendor catalogs—PDFs, spreadsheets, and outdated printouts. Finding accurate specs during a sales call meant fumbling through documents, and customers had no way to browse offerings independently. Worse, the business only carried a subset of each vendor's products, but there was no clean way to filter down to just what they actually sold.

Our Approach

We built a centralized product catalog system that consolidates data from multiple vendor sources into a single, searchable interface. The admin backend allows staff to import vendor catalogs and selectively include only the products they carry, filtering out items they don't stock. The frontend serves dual purposes: an internal tool for sales teams and segmented customer-facing views for self-service browsing.

Key Features

  • Vendor Catalog Consolidation: Import and merge product data from multiple vendors into a unified catalog, eliminating the need to reference separate sources
  • Selective Product Curation: Filter out products the business doesn't carry, ensuring the catalog only shows what's actually available for sale
  • Internal Sales Tool: Staff quickly search and access accurate product specs, images, and pricing during sales calls
  • Customer-Facing Segments: Create filtered catalog views for customers to browse offerings independently, reducing pre-sales support burden
  • The Results

  • Gave sales team instant access to accurate product information during calls
  • Enabled customers to self-serve product research, reducing inbound inquiries
  • Consolidated 5+ vendor catalogs into a single source of truth
  • Streamlined onboarding of new products by filtering at import time

Technologies Used

HTML, CSS, JavaScript, local hosting