GeminiPOS
Recipe Management & Inventory BOM Breakdown
Link finished products to raw ingredients (e.g. 1 Latte deducts 18g beans + 150ml milk) for automated stock deduction.
Recipe Management & Inventory BOM Breakdown
Recipe & Bill of Materials (BOM) lets you define the raw kitchen ingredients used in each menu item, so GeminiPOS automatically deducts raw-material stock every time that item is sold at the counter — no manual counting required.
Before You Start
- This feature only appears once the Recipe & BOM module is enabled (it is automatically on for F&B and Bakery business types). For other business types, enable it under Settings → Modules & Integrations → Recipe & BOM.
- You need access to MyStore Web Admin.
Step 1: Register Raw Materials
Tip: Items marked Raw Material never appear on the cashier sales grid on the Android POS app — they stay in the system only for stock-in records and cost calculations.
- Open MyStore Web Admin → Products.
- Click Add Product.
- On the Product Type segment, choose Raw Material (instead of Sellable Menu).
- Fill in the Product Name (e.g. *AAA Fragrant Rice*), the supplier Cost Price, and the Stock Unit (e.g. kg, liter, pcs).
- Click Save.
Step 2: Build the Recipe for a Menu Item
If you haven't registered a raw material yet, you can use Quick Create Raw Material directly from the recipe screen without leaving the Products list.
- Open an existing sellable menu item (e.g. *Kampung Fried Rice*) — make sure its Product Type segment is set to Sellable Menu.
- Scroll down to the Recipe & Bill of Materials (BOM) section.
- Click Add Ingredient, then Select Raw Material from the ingredients registered in Step 1, and enter the quantity needed per one unit of the menu item (e.g. AAA Fragrant Rice × 0.2 kg).
- Repeat for every ingredient in the recipe.
- Review the Food Cost card — it automatically shows the estimated ingredient cost, Gross Profit, and Food Cost % based on the registered ingredient cost prices.
- Click Save Product.
Step 3: Sync to the Android POS
No manual export or sync button is needed. Saved recipes replicate to every connected POS device automatically, usually within seconds.
Step 4: At the Counter
When the cashier sells that menu item and the transaction completes, GeminiPOS automatically deducts stock for every ingredient in the recipe (recorded as a recipe_deduction stock movement, linked to the transaction ID). Remaining ingredient balances can be checked via the MyStore stock reports. The system allows an ingredient's balance to go negative so that customer orders are never blocked during a rush — negative balances are fully logged for a later stock adjustment.
Step 5: Cancellation (Void / Refund)
When a transaction that used a recipe is voided or refunded, GeminiPOS looks up the stock movements tied to that transaction and automatically creates a compensating refund_restore movement to return the ingredients to stock — no manual calculation needed.
Database Schema Reference
For engineers and administrators managing data integrations:
recipe_items table
- id — UUID (PK) — Unique identifier for the recipe row
- tenant_id — UUID (FK) — Multi-tenant isolation
- product_id — UUID (FK) — Target sellable menu item
- ingredient_product_id — UUID (FK) — Deducted raw ingredient ID
- ingredient_variation_id — UUID (FK, optional) — Specific variation of the ingredient
- modifier_option_id — UUID (FK, optional) — Optional add-on modifier linkage (e.g. Extra Cheese)
- quantity — NUMERIC — Ingredient quantity needed per 1 unit of the menu item
- uom — TEXT — Unit of measure (kg, g, ml, l, pcs)
products table addition
- is_ingredient (BOOLEAN, default false): flags whether an item is strictly a raw material or a sellable menu item.