How to Build Inventory system with V0

1// Paste this prompt into V0's AI chat:
2// Build an inventory management system. Create a Supabase schema with these tables:
3// 1. products: id (uuid PK), sku (text UNIQUE), name (text), description (text), category (text), unit_price (numeric), reorder_point (int), created_at (timestamptz)
4// 2. warehouses: id (uuid PK), name (text), location (text)
5// 3. inventory: id (uuid PK), product_id (uuid FK to products), warehouse_id (uuid FK to warehouses), quantity (int), last_counted_at (timestamptz)
6// 4. movements: id (uuid PK), product_id (uuid FK to products), warehouse_id (uuid FK to warehouses), movement_type (text CHECK IN 'in','out','transfer','adjustment'), quantity (int), reference (text), created_at (timestamptz), created_by (uuid FK to auth.users)
7// Add RLS policies so authenticated users can read all inventory but only insert movements.
8// Generate the SQL migration and TypeScript types.

1// Paste this prompt into V0's AI chat:
2// Create an inventory dashboard at app/inventory/page.tsx.
3// Requirements:
4// - Fetch all products joined with inventory levels grouped by warehouse
5// - Display in a shadcn/ui DataTable with columns: SKU, Product Name, Category, Warehouse, Quantity, Reorder Point, Status
6// - Status column shows a Badge: green 'In Stock' if quantity > reorder_point, yellow 'Low Stock' if quantity <= reorder_point and > 0, red 'Out of Stock' if quantity = 0
7// - Add column sorting (click headers) and a search Input to filter by SKU or product name
8// - Add a Select dropdown to filter by warehouse
9// - Add a Button 'Receive Stock' that links to /inventory/receive
10// - Show summary Cards at the top: Total Products, Low Stock Items, Out of Stock Items

1import { createClient } from '@supabase/supabase-js'
2import { NextRequest, NextResponse } from 'next/server'
3
4const supabase = createClient(
5  process.env.SUPABASE_URL!,
6  process.env.SUPABASE_SERVICE_ROLE_KEY!
7)
8
9export async function POST(req: NextRequest) {
10  const { product_id, warehouse_id, quantity, reference } = await req.json()
11
12  if (!product_id || !warehouse_id || !quantity || quantity <= 0) {
13    return NextResponse.json(
14      { error: 'Invalid input' },
15      { status: 400 }
16    )
17  }
18
19  const { data, error } = await supabase.rpc('receive_stock', {
20    p_product_id: product_id,
21    p_warehouse_id: warehouse_id,
22    p_quantity: quantity,
23    p_reference: reference || 'Manual receipt',
24  })
25
26  if (error) {
27    return NextResponse.json({ error: error.message }, { status: 500 })
28  }
29
30  return NextResponse.json({ success: true, data })
31}

1// Paste this prompt into V0's AI chat:
2// Create a product detail page at app/inventory/[productId]/page.tsx.
3// Requirements:
4// - Fetch the product by ID from Supabase with all inventory records joined by warehouse
5// - Show product info in a Card: name, SKU, category, unit price, reorder point
6// - Show stock per warehouse in a Table with columns: Warehouse, Quantity, Status Badge, Last Counted
7// - Below that, show a movement history Table with columns: Date, Type (Badge colored by type), Quantity, Reference, User
8// - Movement types: 'in' = green Badge, 'out' = red Badge, 'transfer' = blue Badge, 'adjustment' = yellow Badge
9// - Add a Dialog button for quick stock adjustment (select warehouse, enter quantity +/-, add reference note)
10// - Use Tabs to switch between 'Stock Levels' and 'Movement History'

1-- Run this in Supabase SQL Editor
2CREATE OR REPLACE FUNCTION receive_stock(
3  p_product_id uuid,
4  p_warehouse_id uuid,
5  p_quantity int,
6  p_reference text DEFAULT 'Manual receipt'
7)
8RETURNS json AS $$
9DECLARE
10  v_inventory_id uuid;
11  v_new_quantity int;
12BEGIN
13  -- Upsert inventory record with row lock
14  INSERT INTO inventory (product_id, warehouse_id, quantity, last_counted_at)
15  VALUES (p_product_id, p_warehouse_id, p_quantity, now())
16  ON CONFLICT (product_id, warehouse_id)
17  DO UPDATE SET
18    quantity = inventory.quantity + p_quantity,
19    last_counted_at = now()
20  RETURNING id, quantity INTO v_inventory_id, v_new_quantity;
21
22  -- Insert movement record
23  INSERT INTO movements (product_id, warehouse_id, movement_type, quantity, reference, created_at)
24  VALUES (p_product_id, p_warehouse_id, 'in', p_quantity, p_reference, now());
25
26  RETURN json_build_object('inventory_id', v_inventory_id, 'new_quantity', v_new_quantity);
27END;
28$$ LANGUAGE plpgsql SECURITY DEFINER;

1// Paste this prompt into V0's AI chat:
2// Add a low-stock alerts section to the inventory dashboard.
3// Requirements:
4// - Query products where inventory.quantity <= products.reorder_point
5// - Display as a list of AlertDialog-style Cards with: product name, SKU, current quantity, reorder point, warehouse
6// - Each card has a 'Reorder' Button that pre-fills the receive stock form
7// - Sort by urgency (out of stock first, then lowest percentage of reorder point)
8// - Show the count in a red Badge on a 'Low Stock Alerts' tab
9// - If no low-stock items, show a success message with a check icon