E‑commerce Order Management System
Tools: Airtable | Softr |
Make.com
Description:
End‑to‑end order management system for an online store. Tracks products, customers, orders, and inventory in real time. When a customer places an order, stock is automatically deducted, and confirmation emails are sent to both the customer and the admin. Includes a dashboard for order status tracking (Pending → Processing → Shipped → Delivered) and low‑stock alerts.
Key features:
· Airtable tables: Products, Customers, Orders, Order Items (linked records, rollups for totals)
· Softr admin dashboard: view all orders, update status, see low‑stock products
· Softr customer portal (optional): customers can view order history
·
Make.com automation:
· On new order → deduct inventory, send order confirmation email to customer
· On status change → send shipping notification email
· Daily stock check → email alert if any product stock < 5
· Mobile‑responsive design
Built independently – full database schema, frontend dashboards, and multi‑step automation logic