Automated Purchasing System: From Accounting to Cart
Developed an intelligent RPA solution that automatically extracts product data from accounting software and creates purchase orders in the online store, eliminating manual data entry and reducing ordering time by 92%.
Key Results
About Retail Distribution Company
A mid-sized retail distribution company managing inventory across multiple product categories, requiring regular replenishment orders from supplier online stores based on accounting system data.
The Challenge
The client's purchasing team spent hours daily manually copying product information from their accounting software to create orders in supplier online stores. This tedious process was error-prone and prevented the team from focusing on strategic supplier relationships.
Pain Points:
- ⚠️Manual data entry taking 3-4 hours daily per employee
- ⚠️Frequent errors in product codes and quantities (5-8% error rate)
- ⚠️Delayed orders due to time-consuming process
- ⚠️No time for price comparison or supplier negotiation
- ⚠️Inconsistent ordering schedules affecting inventory levels
The Solution
We developed a comprehensive RPA bot that seamlessly integrates with the accounting software, extracts required product information, validates inventory needs, and automatically populates shopping carts in supplier online stores with proper quantities and specifications.
Solution Components:
Accounting System Integration
Automated login and navigation through the accounting software to extract product data, current stock levels, and reorder thresholds.
Intelligent Data Extraction
Smart parsing of product information including SKUs, descriptions, quantities needed, and preferred suppliers.
Multi-Store Cart Automation
Automated navigation across multiple supplier online stores, product search, and cart population with correct items and quantities.
Validation & Error Handling
Built-in validation checks for product availability, price changes, and quantity limits with automatic alerts for exceptions.
Order Summary Reports
Automated generation of detailed order summaries for review before final submission, including price comparisons.
Implementation
Total Timeline: 10 days
Discovery & Analysis
3 days- Accounting system workflow mapping
- Supplier store analysis
- Product data structure review
- Exception scenario identification
Development & Testing
5 days- RPA bot development
- Integration with accounting system
- Multi-store automation setup
- Testing with sample orders
Deployment & Training
2 days- Production deployment
- Team training on monitoring
- Exception handling procedures
- Documentation delivery
The Results
The automation transformed the purchasing workflow, reducing order processing time from 3-4 hours to just 15 minutes, while significantly improving accuracy and freeing the team to focus on supplier relationships and cost optimization.
Performance Improvements:
Order Processing Time
92% reductionOrder Accuracy
4.5% increaseData Entry Errors
90% reductionStaff Time Savings
€45k annual savingsAdditional Benefits:
- ✓Consistent daily ordering schedule improved inventory management
- ✓Team now focuses on price negotiation, saving additional 8% on procurement costs
- ✓Faster order placement improved product availability by 15%
- ✓Automated price tracking alerts team to supplier price increases
- ✓Detailed audit trail for all orders improves compliance
This automation completely changed how our purchasing team works. What used to take the entire morning now happens in minutes, and our team can finally focus on building better supplier relationships instead of copying data between systems.