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.
- Role
- Founder & Backend Engineer
- Industry
- Pet / Subscription E-commerce
The challenge
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.
The 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
Like what you see?
I'd love to hear about what you're building. Let's figure out how I can help.
Get in touch