Can Delivery Tracker Integration

I already have a live e-commerce app for water-can delivery and an accompanying admin dashboard. What’s missing is a simple way to know which customer still holds how many cans, so I need a lightweight can-tracking feature added to the existing admin panel.

Scope of work
• Track every can movement by customer ID—this will be the single reference for all records.
• Store two extra data points for each delivery or return:
– Delivery date and time
– Quantity of cans delivered or picked up
• Maintain a running balance per customer and generate a “Pending Cans” list that I can sort, search, and export for GST reconciliation.
• Send an automatic email notification whenever pending cans exceed a set threshold (the threshold value should be configurable in settings).
• Extend the current admin UI so I can log deliveries/returns quickly and view customer-wise balances at a glance.
• Keep the implementation unobtrusive: reuse our existing tech stack, follow current coding conventions, and supply any DB migrations or API updates you introduce.

Acceptance criteria
• Admin successfully logs a delivery or return without breaking existing order flow.
• Pending cans report reflects accurate totals and updates in real time.
• Email alerts trigger once daily and list only customers whose pending balance is above the threshold.
• All added code is clean, commented, and committed to our repository for review.

This is a focused enhancement, not a full rebuild—just the essentials to track cans, surface pending balances, and stay compliant.