Solution

From scattered data to a single system — the insight, execution, and capabilities behind Qook.

The Insight

The data to solve this already existed — it was just scattered. The POS system knew what we sold. Recipes defined what ingredients each dish consumed. Supplier catalogs had the prices and units. The missing piece was something to connect them and do the math automatically.

What if I could:

  1. Upload yesterday's sales report
  2. Have the system deduct ingredients from inventory based on recipes
  3. Compare what's left against minimum thresholds
  4. Generate a ready-to-send order list, grouped by supplier

That would turn a 3-hour manual process into a 2-minute upload.

What I Built

Qook is a chat-based inventory management tool that connects POS sales data to inventory tracking and generates predictive reorder recommendations.

The user interacts through a conversational interface — asking questions like “How much salmon do we have left?” or “Generate my order list for Tuesday”, and the system responds with real data pulled from the restaurant's inventory.

Key Capabilities

1. Sales-Driven Inventory Updates

expand_more
Upload an Excel export from the POS system. The app parses the sales data, maps each sold item to its recipe, breaks the recipe into individual ingredients, applies unit conversion factors, and deducts the consumed quantities from inventory — all automatically.

2. Predictive Reorder Recommendations

expand_more
The system compares current inventory levels against configurable critical thresholds. When stock falls below the threshold, it calculates how much to order, rounds up to practical quantities, and groups the list by supplier. Orders are staged as "pending" so the user can review and modify before confirming.

3. Natural Language Inventory Queries

expand_more
Ask the chatbot about stock levels, best-selling items, or ingredient costs, and it routes the query to the right function — no menus or forms needed.

4. Recipe & Cost Management

expand_more
Register recipes (including via photo using OCR), track per-ingredient costs, and see how menu item profitability changes as supplier prices shift.

5. Multi-Supplier Support

expand_more
Handles ingredients split across multiple suppliers with separate inventory tracking and supplier-specific order lists.