How to Create an Inventory Management System in FlutterFlow

Create a products collection with fields: sku (String, unique), name (String), category (String), currentStock (Integer), reorderLevel (Integer), costPrice (Double), sellPrice (Double), supplierId (String), imageUrl (String), location (String for warehouse or shelf position), lastUpdatedAt (Timestamp). Create a stock_movements collection with fields: productId (String), type (String: received, sold, adjustment, return), quantity (Integer, positive for additions, negative for removals), reference (String for order number, PO number, or audit ID), userId (String, who performed the action), notes (String), timestamp (Timestamp). Add indexes on products for category plus currentStock filtering and on stock_movements for productId plus timestamp ordering.

Create an InventoryPage with a TextField for search at the top. Add ChoiceChips for category filtering. Below, add a ListView with a Backend Query on products, filterable by category and searchable by name or SKU. Each product row displays the name, SKU, currentStock as a number, and a stock-level color indicator: a Container with background color green when currentStock is above reorderLevel times 2, yellow when between reorderLevel and reorderLevel times 2, and red when at or below reorderLevel. Show the location text and costPrice. Tap a product to navigate to ProductDetailPage showing full details, stock movement history, and action buttons.

Add a barcode scan IconButton on the InventoryPage header. Create a Custom Widget using the mobile_scanner package that opens the camera and detects barcodes. When a barcode is scanned, query the products collection where sku equals the scanned value. If found, navigate to the ProductDetailPage. If not found, show an option to create a new product with the SKU pre-filled. For receiving stock, on the ProductDetailPage add a Receive Stock button that opens a BottomSheet with quantity TextField (numeric), reference TextField (PO number), and a Scan button that scans the product barcode for verification. On submit, call a Custom Action that uses FieldValue.increment to atomically add the quantity to currentStock and creates a stock_movement document with type 'received'.

1// Custom Action: receiveStock
2import 'package:cloud_firestore/cloud_firestore.dart';
3
4Future<void> receiveStock(
5  DocumentReference productRef,
6  int quantity,
7  String reference,
8  String userId,
9) async {
10  // Atomic increment - safe for concurrent updates
11  await productRef.update({
12    'currentStock': FieldValue.increment(quantity),
13    'lastUpdatedAt': FieldValue.serverTimestamp(),
14  });
15  // Log the movement
16  await FirebaseFirestore.instance.collection('stock_movements').add({
17    'productId': productRef.id,
18    'type': 'received',
19    'quantity': quantity,
20    'reference': reference,
21    'userId': userId,
22    'timestamp': FieldValue.serverTimestamp(),
23  });
24}

On the ProductDetailPage, add a ListView below the product details querying stock_movements where productId equals the current product, ordered by timestamp descending. Each movement row shows the type as a colored badge (green for received, red for sold, blue for adjustment, orange for return), the quantity with plus or minus prefix, the reference, the user who performed it, and the timestamp. Add a Stock Adjustment button for inventory corrections. The adjustment BottomSheet has a DropDown for adjustment reason (damage, theft, count correction, expiry), a quantity TextField (positive or negative), and a notes TextField. Submit creates a stock_movement with type 'adjustment' and updates currentStock with FieldValue.increment of the quantity value.

Create a DashboardPage with summary cards at the top: Total Products count, Total Inventory Value (sum of currentStock times costPrice across all products, calculated by a Custom Function), and Low Stock Count (products where currentStock is at or below reorderLevel). Below the summary, add a Low Stock Alerts section: a ListView querying products where currentStock is less than or equal to reorderLevel, ordered by currentStock ascending. Each alert card shows the product name, current stock in red, reorder level, and a Reorder button. Add a second section for Recent Activity: a ListView of the most recent stock_movements across all products. Optionally add a Custom Widget with fl_chart showing a BarChart of stock value by category.

Create a Stock Audit flow: a page listing all products in a scrollable form where each row shows the product name, system stock count, and a TextField for the physical count entered during a warehouse walk. On submit, compare physical counts against system counts. For mismatches, automatically create stock_movement documents with type 'adjustment' and the difference as quantity. Display a summary report showing total matches, total mismatches, and net variance. Add a Cloud Function for generating reports: query stock_movements for a date range grouped by product, calculate turnover rate (sold quantity divided by average stock), and identify slow-moving items (zero sales in 30 days). Export as CSV to Firebase Storage.