Chemical Stock Matching Tool

Developed for Pell Wall, a small but market-revolutionising brand in the perfumery and scented products industry, this custom Chemical Stock Management Tool was built to streamline the complex procurement process for fragrance professionals. A single perfume project can involve hundreds of individual chemicals, making manual stock-checking a tedious and time-consuming task.

The Challenge

Creating a scented product involves highly specific ingredients, often complicated by the nuances of chemical naming conventions and industry-standard identifiers. Pell Wall needed a resource that could seamlessly handle these bulk enquiries, accurately parsing chemical names and numbers, while directly integrating with their live inventory.

The Solution

We engineered a robust bulk-matching tool that cross-references user-provided lists directly against Pell Wall's live stock database. Key features include:

• Flexible Input Methods: Users can manually type a list of items into a text area or upload a CSV file directly to the tool.
• Intelligent Searching: The system accurately searches by either complex chemical names or specific CAS (Chemical Abstracts Service) numbers.
• Comprehensive Match Results: The tool returns potential matches along with crucial identifying data, including SKUs, CAS numbers, exact pricing, and real-time stock quantities.
• Data Export: Users have the ability to download their matched results—complete with pricing and stock levels—as a neatly formatted CSV file for their own project records.
• Industry-Specific Nuance: The search algorithm was specifically built to understand and process the unique naming conventions and variations found within the perfumery industry.

Business Impact & Value

While primarily intended as a free, highly useful resource for perfumers, the tool acts as a powerful driver for e-commerce. By taking a raw list of ingredients and instantly positioning live stock information, pricing, and direct links to purchase right alongside it, the application directly boosts sales. This seamless transition from planning to procurement perfectly supports Pell Wall's 'one-stop-shop' ethos, helping customers realise their projects faster and with greater confidence.