Franco Brings Core API & Inventory Intelligence
Backend API powering product mapping, subscription logic, lid usage, and robust email workflows for a dog grass subscription business.
Business Problem
As Franco Brings grew, inventory tracking and subscription logic became too complex for simple spreadsheets: different product IDs, lid restocking rules, subscription vs one-time purchases, and multiple email providers for operational comms.
Solution
Built a dedicated API handling complex product ID mapping, subscription and one-time order logic, lid usage calculations with different restock dates, and robust email delivery with multiple service fallbacks. Added unknown-product detection and alerting to prevent silent failures.
Key Highlights
- Complex product ID mapping system for accurate inventory tracking.
- Differentiates subscription vs one-time purchase logic at the API level.
- Lid usage calculation with separate restock schedules.
- Production-grade date/time handling aligned with Brisbane time zone.
- Robust email delivery with multiple service fallbacks.
- Unknown product detection & alerting system to catch data issues early.
AI & Automation
No core AI features; this project shows senior-level backend, data, and reliability engineering that AI features can plug into.
Outcome & Impact
Turned a fragile, manual inventory process into a reliable backend service. Reduced errors in stock planning and lid restocking, increased confidence in subscription logic, and made operations ready for higher order volumes without extra headcount.
Gallery
