How It Works
Enter part number, name, price, and quantity. Set minimum stock levels for automatic low-stock alerts.
When you use a part on a job, log it. Inventory updates automatically. Part cost is added to job invoice.
See which parts are used most, track costs, and get low-stock alerts. Never run out of critical parts.
Never Lose Money on Parts
When you log a part used on a job, its cost is automatically added to the customer invoice. No manual calculation needed.
Set minimum quantity thresholds. Get notified when parts run low so you can reorder before you run out.
Track quantities across all parts. See what's in stock, what's been used, and what needs to be ordered.
See which parts are used most frequently. Identify trends and optimize your stock levels.
How It's Built
Parts Catalog
The parts table stores your complete inventory: name, partNumber, price, quantity, minQuantity, supplier, and category. Each part is scoped to your organizationId.
Job-Parts Relationship
The jobParts table links parts to jobs. When you use a part, it records jobId, partId, quantityUsed, unitPrice, and totalPrice. This creates a complete usage history.
Automatic Inventory Updates
When you log a part used on a job, Convex mutations automatically decrease the quantity in the parts table. No manual inventory adjustments needed.
Cost Calculation
Total parts cost is calculated from jobParts and added to job.partsCost. Combined with job.laborCost and job.serviceFee, this gives you job.totalCost for accurate invoicing.
Low Stock Notifications
Convex monitors parts.quantity vs parts.minQuantity. When stock drops below minimum, a notification is created in the notifications table with type "part_low_stock".
Common Parts to Track
- Compressor start relays
- Defrost timers
- Door gaskets
- Water filters
- Drive belts
- Water inlet valves
- Door switches
- Drain pumps
- Heating elements
- Spray arms
- Door latches
- Pump motors