Product, Inventory & Pricing Management System
Overview
A platform that matches product data automatically, processes Excel files locally, and computes real profitability.
Business Context
Thousands of products accumulated between the store and the accounting system, and matching and counting relied on manual steps taking days.
The Problem
Thousands of products and manual matching between the store and the accounting system, with real profitability hard to know.
Objective
Remove manual matching, improve data accuracy, and provide a clearer view of profitability.
My Role
- Requirements analysis
- System design
- App development
- Database
- Matching engine
- Automation
- Testing
The Solution
An automatic matching system that processes data, reveals discrepancies, and improves counting and matching.
Implementation
I analyzed requirements, designed the database and matching engine, and built the app with automation and testing.
Technology
- Database
- Matching engine
- Local Excel processing
- Automation
Results
- 5,000+ productsProcessed automatically
- Under 3 minutesInstead of 5 days for matching and counting
- 95%+Matching accuracy above 95%
- 120+ hoursSaved monthly working hours
Business Impact
Key result
5 days → under 3 minutes
Inventory matching and counting time
Live Demo
Lessons & Insights
- When repetitive manual work disappears, it's not just time that improves — decision-making speed improves too.
Have a store problem or an AI app idea?
Tell me about your current situation, and I will help you identify the best way to work on it.