Overview
Bar Galileo’s inventory system provides complete control over your products, stock levels, suppliers, and pricing. Track every item in your restaurant from purchase to sale.Product Catalog
Manage products with pricing, categories, and brands
Stock Tracking
Monitor inventory levels with automatic history
Supplier Management
Maintain supplier contacts and relationships
Product Images
Upload multiple images per product in WebP format
Product Management
Product Information
Each product in your catalog contains:- nombre: Product name (must be unique)
- precio_compra: Purchase price from supplier
- precio_venta: Sale price to customers
- stock: Current inventory quantity
- descripcion: Optional product description
- activo: Whether product is available for sale
- id_categoria: Product category for organization
- id_marca: Brand or manufacturer
- id_proveedor: Primary supplier
Creating Products
Add New Product
Click to create a new product and fill in the required information:
- Unique product name
- Purchase and sale prices
- Initial stock quantity
- Optional description for staff reference
The system validates that sale price is greater than purchase price to ensure profitability.
Product Validation
Bar Galileo automatically validates products to prevent errors:- Name validation: Product name cannot be empty or whitespace-only
- Price validation: Sale price must be greater than purchase price
- Stock validation: Stock quantity cannot be negative
- Unique names: Each product must have a unique name
Categories
Organize products into logical categories for easier management:- nombre_categoria: Category name (e.g., “Drinks”, “Food”, “Desserts”)
- descripcion: Optional notes about the category
Category Best Practices
Category Best Practices
Create categories that match your menu structure:
- By Type: Appetizers, Main Courses, Desserts, Beverages
- By Temperature: Hot Dishes, Cold Dishes, Frozen Items
- By Preparation: Ready-to-Serve, Cook-to-Order
- By Dietary: Vegetarian, Vegan, Gluten-Free
- Menu organization
- Inventory reports
- Order filtering
- Pricing analysis
Brands
Track product brands to:- Identify premium products
- Analyze brand performance
- Manage supplier relationships
- Maintain consistent quality
- marca: Brand name
- descripcion: Optional brand notes
Suppliers
Supplier Information
Maintain detailed supplier records:- nombre: Supplier company name
- contacto: Primary contact person
- telefono: Contact phone number
- direccion: Supplier address for deliveries and records
You can change a product’s supplier at any time. Historical order data remains unchanged.
Inventory Tracking
Stock System
Bar Galileo maintains detailed inventory history:- id_producto: Which product this stock record tracks
- cantidad: Stock quantity at this point in time
- fecha_hora: When this stock level was recorded
How Stock Tracking Works
Automatic Recording
Every time a product’s stock changes, the system automatically creates a stock history record.
Historical View
View complete stock history to track:
- When inventory was added
- When stock levels decreased
- Current inventory status
- Stock movement patterns
Stock Management Workflows
Receiving New Inventory
Receiving New Inventory
When inventory arrives from suppliers:
- Locate the product in your catalog
- Update the stock field with the new total quantity
- The system automatically records this change with timestamp
- The product is now available for orders
Stock Takes (Physical Counts)
Stock Takes (Physical Counts)
To reconcile physical inventory:
- Count actual products on hand
- Update each product’s stock to match physical count
- Review discrepancies between expected and actual
- Investigate significant differences
- System maintains record of adjustment
Low Stock Monitoring
Low Stock Monitoring
Monitor stock levels regularly:
- Set mental or documented thresholds for reordering
- Check products with low stock quantities
- Review stock history to predict usage patterns
- Order from suppliers before running out
- Update stock when new inventory arrives
Product Images
Image Management
Upload and manage product images:- Multiple images: Each product can have multiple photos
- Automatic format: Images are converted to WebP format for efficiency
- Organized storage: Images stored in
media/productos/{product_id}/ - Supported formats: Upload PNG, JPG, JPEG, or WebP files
Automatic Processing
The system automatically:
- Validates file format
- Converts to WebP (85% quality)
- Stores in product-specific folder
- Links image to product
Images are stored in the media folder, not static files, allowing for dynamic management and updates.
Product Status
Active vs Inactive Products
Control product availability with the activo field:- Active (True): Product appears in order system and can be sold
- Inactive (False): Product is hidden but data is preserved
When to Deactivate Products
When to Deactivate Products
Mark products as inactive instead of deleting them when:
- Seasonal items are out of season
- Supplier discontinues the product
- Menu items are temporarily unavailable
- Testing new products before full rollout
- Keeping historical sales data intact
- Preserves historical order data
- Maintains pricing history
- Can be reactivated easily
- Keeps reports accurate
Pricing Strategy
Purchase vs Sale Prices
The system tracks both prices for profitability:- precio_compra: What you pay the supplier
- precio_venta: What customers pay
- Margin: Automatically calculated (precio_venta - precio_compra)
The system enforces that sale price must exceed purchase price. This validation prevents accidentally selling products at a loss.
Pricing Best Practices
Setting Initial Prices
Setting Initial Prices
When adding new products:
- Enter the actual purchase price from supplier
- Calculate desired markup percentage
- Set sale price to achieve target margin
- Consider competitor pricing
- Factor in preparation costs and overhead
Updating Prices
Updating Prices
When supplier prices change:
- Update the purchase price
- Evaluate if sale price needs adjustment
- Consider market conditions
- Update sale price to maintain margins
- New prices apply to future orders only
Historical Price Data
Historical Price Data
Remember:
- Existing orders retain original prices
- Price changes don’t affect completed transactions
- New orders use current prices
- This ensures accurate historical reporting
Reports and Analysis
The inventory system enables:- Stock levels: Current inventory across all products
- Stock history: Movement patterns over time
- Profit margins: Difference between purchase and sale prices
- Product performance: Which items sell most
- Supplier analysis: Performance by supplier
- Category reports: Sales and inventory by category
All inventory changes are timestamped automatically, providing an audit trail for reconciliation and analysis.