Inventory Software With Tracking Integration

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.