Products
Products are the core of your inventory system. Learn how to create, organize, and manage your product catalog effectively.
What is a product?
A product in BREWOPS represents any item you track in your inventory. This could be ingredients, supplies, merchandise, or any other physical goods your business uses or sells.
Product information includes:
Basic Details
Name, description, and product image
SKU / Barcode
Unique identifier for scanning and tracking
Category
Group products for organization and reporting
Unit of Measure
How the product is counted (pieces, kg, liters, etc.)
Reorder Point
Minimum stock level before low-stock alert
Stock Levels
Current quantity at each location
Creating products
Method 1: Add manually
Create products one at a time through the product form. Best for adding a few items or when you need to set up detailed information.
Steps to add a product
Method 2: Bulk import
Import many products at once from a spreadsheet. Ideal for initial setup or migrating from another system.
Learn about importing dataProduct fields explained
Product Name
RequiredThe name displayed throughout the system. Should be descriptive enough to identify the product.
Example: Oat Milk (1L), Espresso Beans - House Blend
SKU (Stock Keeping Unit)
A unique code to identify the product. Useful for scanning and quick lookups. Can be left blank if not needed.
Example: OAT-MILK-1L, ESP-HOUSE-1KG
Category
Groups products together for organization. Makes it easier to find products and generate category-based reports.
Example: Dairy Alternatives, Coffee Beans, Syrups
Unit
How the product is measured and counted. Choose a unit that matches how you track inventory.
Example: pieces, kg, liters, bags, boxes
Reorder Point
The minimum quantity before the system shows a low-stock warning. Set based on your usage patterns and lead time for reordering.
Example: If you use 10 bags/week and reordering takes 1 week, set reorder point to 15-20
Description
Additional details about the product. Useful for notes about suppliers, specifications, or handling instructions.
Example: Barista-grade oat milk, keep refrigerated after opening
Cost
The purchase price per unit. Used for inventory valuation and cost tracking.
Example: $4.50 per liter
Managing products
Finding products
Use the search bar to find products by name or SKU. Filter by category to narrow down results.
Editing products
Click on a product to view details, then click 'Edit' to modify information. Changes apply immediately.
Viewing stock
Each product shows current stock levels. Click to see stock breakdown by location.
Deleting products
Remove products you no longer need. This also removes associated stock records.
Deleting products
When you delete a product, all stock records and transaction history for that product are also deleted. This action cannot be undone. Consider making the product inactive instead if you want to keep historical data.
Low stock alerts
Products with quantity below their reorder point are flagged as low stock. This helps you know when to reorder before running out.
How low stock works:
- Set a reorder point for each product based on your usage and lead time
- When total stock falls below the reorder point, the product is marked as low stock
- View all low stock products in the dashboard or filter the products list
- Create purchase orders directly from low stock items
Tip: Setting reorder points
A good reorder point formula: Average daily usage × Lead time (days) + Safety stock. For example, if you use 5 bags/day, reordering takes 3 days, and you want 2 days safety stock, set reorder point to 5 × 3 + 10 = 25 bags.
Best practices
Use consistent naming
Establish a naming convention (e.g., 'Product - Size - Variant') to make products easier to find and sort.
Categorize everything
Assign categories to all products. This makes filtering, reporting, and organization much easier.
Add SKUs for scanning
If you use barcode scanning, ensure all products have SKUs that match your barcode labels.
Set realistic reorder points
Review and adjust reorder points based on actual usage patterns. Too low means stockouts, too high means excess alerts.