Reporting Dashboard
Data integration between Magento and MongoDB for ERP-like reporting
Concession: Perhaps this one exceeds method classification into app realm.
Merchant utilizing Magento 1.x needed better reporting to help business line managers in marketing, purchasing and operations make better decisions in the absence of an ERP system. Off-the-shelf Magento reporting extensions were insufficient.
Method
- Pipe Magento product, inventory and sales data to MongoDB
- Build a middleware API layer on Node.js
- Produce a Vue.js frontend to build reports / queries to MongoDB via API
- Host the Vue.js frontend on Firebase
- Incorporate cron scheduling for CSV report generation and email delivery
Status: Remains in operation as of January 2025.