📥 Intake Reports
Receiving history and intake records for the selected brand.| INTAKE ID | LEGACY REF | EVENT | CARTONS | UNITS | LOCATION | SOURCE | ACTIONS |
|---|
📦 Order Reports
Services, orders, and fulfillment history for the selected brand.| JOB ID | SOURCE | REF # | TITLE | URGENCY | STATUS | ASSIGNED | CREATED |
|---|
Activity Timeline
Inventory changes, services, and team comments. Use comments to confirm migration status.Organize Pallets
Scan to Pallet
Scan to Location
Warehouse Map
Pallet View (WMS)
Pallet Recon
Assign Location
Assign intakes, pallets, or individual cartons to warehouse locations.Select an intake, pallet, or carton and assign it to an available warehouse location.
| Img | Date Added | Box ID | Brand | Category | Description | Color | Units | Sizes | Location | Status | Barcode | Pallet | Actions |
|---|
QuickBooks Export
Paste a published Google Sheets URL. The sheet must be published to web as CSV.
1. Open your Google Sheet
2. File → Share → Publish to web
3. Choose "Comma-separated values (.csv)"
4. Click "Publish" and copy the URL
Select all data in Google Sheets (including headers), copy, and paste below.
Connect a Google Sheet to sync inventory bidirectionally. Changes in the sheet push, and changes in TITOL push back to the sheet.
Download current inventory as CSV. Respects active filters — export the full database or a filtered subset.
QuickBooks Integration
Import inventory items, invoices, and purchase orders from QuickBooks Online into TITOL.1. Go to developer.intuit.com → Create an app → Get Client ID & Secret
2. Set Redirect URI to:
https://titolwms.firebaseapp.com/qb-callback3. Enter credentials above → Save → Click Authorize
4. QuickBooks will redirect back with access tokens stored in the database
Export a report from QuickBooks as CSV/Excel, then upload it here. TITOL will map the columns to inventory fields.
TITOL auto-detects these QuickBooks column names during import:
| QB Column | TITOL Field | Notes |
|---|---|---|
| Item Name / Product/Service | description | Primary product name |
| SKU | brandSku | Product SKU code |
| Qty on Hand / Quantity | totalUnits / units | Current stock quantity |
| Asset Value / Amount | value | Inventory value in $ |
| Type / Category | category | Product type |
| Description | ecomTitle | Long product description |
| Purchase Cost / Rate | cost | Unit cost |
To export from QuickBooks: Reports → Inventory Valuation Summary → Export 📄 → CSV. Or Products & Services → ⚙ → Export.
Firebase Database Tables
Manage Brands, Services, and Warehouse Locations. These tables power dropdowns and validation across the app.
| Logo | Brand Name | Code | Contact | Items | Units | Status |
|---|
| Service Name | Code | Category | Description | Status |
|---|
| Location | Zone | Capacity | Boxes | Units | Status |
|---|
| Order Type | Code | Description | Orders | Status |
|---|
| Carrier | Code | Description | Shipments | Status |
|---|
| Category | Code | Sub-Categories | Items | Status |
|---|
| Icon | Task Type | Deliverables | Count | Status |
|---|
| Role | Name | Title | Brand | Status |
|---|
Enter a Box ID, SKU, or any value to generate a scannable barcode.
Scan or type a barcode value to find the associated inventory item.
APIs & Integrations for TITOL WMS
Tools and services for barcodes, visualization, shipping, and automation.Upload your legacy CSV to cross-check against current Firebase inventory. This tool will: match records by Box ID + Description composite key, flag differences, generate missing SKUs, and let you apply updates or import new items.
Upload your Barcode Master CSV (columns: Group, IID, SKU, Name, Color, Size, STYLE/COLOR/SIZE, Barcode). This tool fuzzy-matches product names against your live inventory descriptions and backfills SKU and Barcode data.
This migration scans all existing records and re-indexes IDs to the unified sequential format: PREFIX-XXXXX-BRANDCODE. Old values are backed up for lookback.
SVC-00001-CJ · jobId: 10001000 (matched to linked service)ORD-00001-LB · jobId: 1003IN-00001-GUN · jobId: 1004TSK-00001-DRU · jobId: 1001_old_* fields on each record + full backup in _migration_backup/
Recomputes numCartons on every intake by counting unique boxId values. Tries intake.cartons[] / intake.boxIds[] first, then falls back to scanning inventory/ records joined by intakeRef for older intakes. Each row shows [intake] or [inventory] so you can see which path was used. Original values preserved as _old_numCartons for safety.
📦 Fulfill Pick Order
Pick, pack and confirm a pick order.Scan Progress
Box Labels
| Job ID | Source | Brand | Title | Requester | Urgency | Status | Assigned | Actions |
|---|
Intake Wizard
(legacy) Receive inbound shipments step-by-step. Identify the brand, log carton contents, assign a location, and print labels.Identify the shipment: who is it from, how many cartons, and the event or intake reference.
Create Pick Order
Create outbound orders. Select items from inventory, generate a pick list, and confirm deductions.Create a warehouse pick order. Optionally link it to a task above to inherit the Brand/Artist and Due Date.
▸ More details — delivery, ship to, priority, due date, notes
Label Studio
Carton labels from an intake or shipment, plain Stealth labels, and Pallet labels.| Box ID | Contents | Sizes | Units | Location |
|---|
Packing List Generator
Build packing lists for outbound shipments. Select items, add shipping details, and generate a printable packing list.| Box ID | Description | Color | Sizes | Units | Location |
|---|
Service Quote Builder
Build itemized quotes for clients. Rates pull from your service pricing table below.Default per-unit rates for each service type. Edit below — rates auto-fill when adding line items.
| Service | Code | Category | Rate/Unit ($) | Min Charge ($) |
|---|
| Quote # | Brand | Title | Lines | Total | Status | Date | Actions |
|---|