Verified against Lovable · 2026-07-10
Build an internal inventory and order-management admin dashboard
A Lovable brief for an internal inventory and order-management dashboard — invite-only auth, role-based permissions, and the exact stock-adjustment logic spelled out so the tool enforces real business rules instead of shipping two disconnected CRUD tables.
The prompt
Ready to copy — highlighted parts are example details you can swap.
Build an internal admin dashboard called StockDesk for a 6-person warehouse team at a small furniture importer to track inventory and orders. This is an internal tool — no public sign-up, only invited staff. Data model: - User: id, name, email, role (admin or staff). - Product: id, sku, name, category, unit_cost, reorder_threshold, quantity_on_hand. - Supplier: id, name, contact_email, lead_time_days. - Order: id, product_id (references Product), supplier_id (references Supplier), quantity, status (pending, shipped, or received), ordered_at, expected_at. - StockMovement: id, product_id (references Product), change_qty (positive or negative), reason (restock, sale, adjustment, or damage), created_by (references User), created_at. Screens: 1. Login — invite-only, no public sign-up form. 2. Dashboard: products below their reorder_threshold, pending orders, and a 7-day stock-movement activity feed. 3. Products table: sortable and filterable by category, inline-editable quantity_on_hand, a visual flag on low-stock rows. 4. Product detail page: the full StockMovement history for that product, plus a "create purchase order" action that opens the Order form pre-filled with a suggested quantity of 2 times the reorder_threshold. 5. Orders table: filter by status. Marking an order as received must automatically create a matching StockMovement and increase quantity_on_hand — these two actions are one transaction, not two separate manual steps. 6. Admin-only screen: manage Users and their roles. Constraints: - Use Lovable's Supabase integration for auth — invite-only, with public sign-up disabled in the auth settings — and for the database. - Role-based access: staff can view everything and log stock movements; only admin can add or remove users or edit unit_cost. - No branding beyond a simple wordmark — this is never client-facing. - This tool is used on a warehouse-floor tablet as much as a desktop — the Products and Orders tables must stay usable at a 10-inch tablet, roughly 1280x800, landscape orientation, not just at desktop width.
Customize the highlighted detailsoptional — the prompt above already works
Why this works
An internal tool has a different failure mode than a customer-facing SaaS: the risk isn't a bad first impression, it's a dashboard that looks complete but doesn't actually enforce the business rule that matters — in this case, that receiving an order has to update stock, not just change a status label. Spelling out that state-machine behavior, the role-based permission split, and invite-only auth up front is what makes Lovable build one connected system instead of two unrelated CRUD tables you have to notice are disconnected after someone's already trusted the numbers.
What you get back
An invite-only Lovable dashboard where marking a pending order as received automatically logs a stock movement and increases quantity_on_hand on the product detail page, with the Products table remaining usable at tablet width.
Verified against
Lovable Lovable web app (Supabase-integrated chat builder) · 2026-07-10
Changelog
- 2026-07-10 — Initial version, made the order-received-to-stock-movement transaction explicit after a first draft shipped Orders and StockMovement as unrelated screens.
Need this built into your business?
If a prompt isn't enough — custom software, built and maintained for you — that's Scult's day job.
EXPLORE CUSTOM SOFTWARE

