Invoice Product Name Standardization

Background:
Your company receives purchase invoices from multiple suppliers. Each supplier may use
different names
for the same product (e.g., "A4 Paper 500sh", "A4 Copy Paper 500 sheets", "500 Sheets A4").
When entering this data into the accounting system, you need to map these varying names to
standardized product names used by the buyer.
Task:
Create a system that:
● Allows manual matching of product names for first-time entries
● Builds and maintains a mapping dictionary for automatic matching
● Handles new variations of product names intelligently
Requirements:
● Handle basic text variations (case, spacing, common abbreviations)
● Allow easy updates to the mapping dictionary
● Handle edge cases and provide clear feedback
Expected Output:
● Working prototype
● Assumptions made
● Identify use cases your system can handle / can’t handle
● Future improvement ideas
Test Product names:
“A4 Paper 500sh", "A4 Copy Paper 500 sheets", "500 Sheets A4", "Sticky Notes 3x3", "Post-it
Notes 3x3 Yellow", "3x3 Yellow Sticky Notes"