WorkCase study 05

Ellementry 360

A 360-degree operations dashboard for an omnichannel retailer

Illustrated mockup

Confidential · NDA

Quick facts

Industry: Retail, e-commerce and omnichannel operations
Our role: Built and maintained the full platform: workflows, dashboards, integrations, reporting, automation and access control
Stack: PHP (CodeIgniter), MySQL, REST integrations

Summary

A central operations dashboard for online orders, store sales, inventory, logistics, returns, refunds, campaigns and business reporting across every sales channel.

The problem

The business's data was spread across e-commerce platforms, retail stores, marketplaces, logistics partners, payment systems, the warehouse and finance. Teams needed fast answers on order status, stock positions, sales, returns, refunds and campaign performance without switching between tools and spreadsheets.

Ellementry 360 is an internal, login-protected system. We can't share access to the dashboards because of client confidentiality.

What we built

Key features

Role-based admin dashboard

for store, marketing, warehouse, CRM, finance and operations teams.

360-degree order view

order, shipment, invoice, return, refund, payment, courier, AWB and turnaround-time details in one report.

Inventory and product management

across web, warehouse and marketplace stock, with product master data, catalogue exports and SKU-level reporting.

Sales and performance reporting

across retail stores, online channels, franchise channels, marketplaces, campaigns, coupons, wishlists and abandoned carts.

Post-order workflows

returns, replacements, refunds, credit notes, reconciliation and quality issues.

Automation and exports

scheduled syncs for orders, shipments, customers, invoices and marketplace data, plus downloadable CSV and Excel reports.

How we solved it

Challenges

01
Challenge
Data arrived from many systems with different structures, naming conventions and update timings.
Solution
Dedicated import flows, scheduled jobs and normalised reporting queries consolidate orders, sales, inventory, shipments and returns into one operational view.
02
Challenge
Each department needed different permissions and workflows inside the same platform.
Solution
Authentication, role and permission management, and department-specific screens, so each team works only with the modules relevant to them.
03
Challenge
Operations teams needed large, filtered reports and exports without slowing down day-to-day work.
Solution
Server-side filtering and pagination, reusable Excel/CSV export utilities, and focused report modules for sales, inventory, logistics cost, reconciliation, returns and reorder planning.

Results

Many business workflows consolidated into one internal dashboard, replacing scattered spreadsheets and separate platform logins.
Clear visibility across orders, inventory, shipping, returns, refunds, sales and campaigns.
Self-service report downloads, reducing reliance on manually prepared reports.
Department-specific reporting and faster exception handling for warehouse, CRM, finance, marketing and store teams.
Ongoing production operations supported by scheduled syncs, automated reports and reusable export tools.

Stack

Backend: PHP (CodeIgniter), MySQL, REST APIs and cURL integrations, cron automation
Frontend: HTML, CSS, JavaScript, jQuery, Bootstrap / AdminLTE, DataTables, Chart.js, Select2
Reporting: PHPExcel spreadsheet exports, CSV exports, scheduled reports
Integrations: Magento, Shopify, Amazon, PayU, Zoho, Shiprocket and logistics systems, internal inventory and order databases