I need a streamlined system that lets me register every inventory product, assign a unique tracking ID, and manage the entire lifecycle in one place. The platform must handle expiration tracking so I’m alerted well before any batch is close to its use-by date, forecast demand from sales history to spot trends, and—most critically—generate purchase orders automatically whenever stock levels breach the rules I set. Alongside the back-office functions, customers and staff have to be able to key that tracking ID into a widget or API on our website and instantly see the item’s current status and location inside our workflow. A clean, browser-based interface is ideal, but I’m open to you custom-building this or extending a framework such as Odoo, ERPNext, Zoho Inventory, Laravel, or a Python/Django stack—whatever you’re fastest and most comfortable with. Key deliverables: • Cloud-hosted inventory module with expiration tracking, demand forecasting, and rule-driven automated reordering • Automatic generation of OP (order placement) documents ready for approval or direct dispatch to suppliers • Public-facing tracking lookup embedded or integrated into our existing website • CSV/Excel import-export and multi-user access controls Please outline your proposed tech stack, timeline, and any similar projects you’ve completed so I can gauge fit right away.