π₯ 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.
| Img | Date Added | Box ID | Brand | Category | Description | Color | Units | Sizes | Location | Status | Barcode | Pallet | Actions |
|---|
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 to Firebase, 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 Firebase
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.
Settings
App configuration, Firebase connection, collections, and system info.
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.
Receiving Dock
Confirm deliveries, verify box counts, upload signed packing lists, flag discrepancies.
Organize Pallets
Manage pallet inventory, mark status, import CSVJob Queue
Track and manage all warehouse jobs. Drag to reorder priority, update status, and assign team members.
| Job ID | Source | Brand | Title | Requester | Urgency | Status | Assigned | Actions |
|---|
Intake Wizard
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.
Submit Pick Order
Create outbound orders. Select items from inventory, generate a pick list, and confirm deductions.
Create a warehouse pick order. Link to an open service request to tie them together.
Carton Label Printer
Select an intake or shipment to print carton 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 |
|---|
Shipments
Create and track outbound shipments. Link jobs, tasks, or orders as dependencies that must be completed before shipping.
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.
Order History
View completed and recent outbound orders with pick details and timestamps.
π€ AI Email Intake CLAUDE π SECURE
Paste an email thread. AI extracts a summary, detects brand/category, identifies action items, and creates tasks.
Projects
Track end-to-end project lifecycle. View all linked jobs, orders, tasks, shipments, and intakes in one timeline. Resolve dependencies and mark projects complete.