📊 Import Work Orders
Upload an Excel or CSV file to import work orders into the database
Import Progress:
Preparing...
❌ Import Errors (0 failed)
✅ Successfully Imported (0 records)
📌 Spreadsheet Format:
Your file should have these columns (case-insensitive):
- WO Number (required) - Work order number
- Make, Model, VIN, Serial Number, Chassis Year
- Body, Body Type, Sold To, Mounting Location
- Chassis Color, Rear Wheel, Engine Type, Wheel Base, Drive Train
🔗 Sync Photos to Work Orders
Scan R2 bucket photos and link them to work orders based on filename patterns (e.g., WO301126_photo.jpg)
Sync Progress:
Scanning...
❌ Sync Errors (0)
| # |
Filename |
WO Number |
Error |
✅ Successfully Synced (0)
⚠️ Skipped - No WO Number Found (0)
⚠️ How it works:
- Scans all photos in R2 bucket
- Extracts WO number from filename (e.g.,
WO301126_photo.jpg → 301126)
- Creates/updates entries in database linking photos to work orders
- After sync, you can filter photos by work order number