RackBaddie is a mobile app + Python toolkit that turns chaotic warehouse inventory into organized, searchable Excel workbooks. Snap photos, OCR-extract part data, auto-generate part numbers, and export it all.
Open the mobile app, point at a pallet or spool, and snap a photo. Fill in specs with the guided data entry form.
Run the Python OCR scripts on your photos. Part numbers, descriptions, and specs are pulled automatically.
The part number engine creates standardized SKUs based on gauge, stranding, color, and material type.
Get an organized Excel workbook with per-pallet sheets, consolidated views, and parts matching reports.
Snap photos of wire spools (10 AWG THHN, 6 AWG XHHW), cable reels, heatshrink tubes, small parts bins, and conduit bundles. Guided data entry with auto-calculated weight-per-foot and length estimation for every item on the rack.
Place a reference ruler or known-size object next to a cable spool and snap a photo — the app estimates spool diameter, width, and core size automatically. Supports metric and imperial units. Works for reels, drums, and coils so you can log physical dimensions without a tape measure.
Extract part numbers, descriptions, and specs from pallet photos using Tesseract OCR. Reads manufacturer labels, UL style numbers, spool tags, pallet manifests, and shipping labels — no manual data entry needed.
Auto-generate standardized SKUs: W10-THHN-19-BLK (10 AWG black THHN), CBL-SEOOW-12/3 (portable cord), HS-3/8-PO-RED (heatshrink). Consistent part numbers across your entire warehouse.
Per-pallet breakdowns, gauge summary pivots, vendor reconciliation sheets, and weight-vs-length calculators. Consolidated All_Inventory view with CCCOA parts matching reports ready to share.
Track inventory by pallet (Pallet_1 through Pallet_N), named rack positions (A1-R1, B3-R2), floor staging zones, and truck/trailer loads. Status tracking for Cut, Full, and Opened items so you always know what’s where.
Log the physical dimensions of every item — spool diameter, width, height, weight, and core size. Capture measurements from photos with the camera module or enter manually. Each item gets a size profile used for rackspace allocation, weight-limit checks, and shipping estimates.
Define your rack layout with shelf dimensions (L × W × H), weight capacity per shelf, and clearance zones. The system maps items to open positions based on size profiles, shows remaining capacity per shelf, and flags overweight or oversized placements before they happen.
Multi-strategy matching engine: exact, fuzzy, gauge+color, and customer part number formats. Cross-reference Southwire vs. Cerro vs. CCCOA part numbers and match customer POs to warehouse stock.
Generate and print QR codes for every pallet, rack location, and spool. Scan with the mobile app to instantly pull up item details, history, and location. Link QR codes to digital inventory records for instant look-up from anywhere in the warehouse.
Individual user accounts with role-based access. Log every withdrawal with quantity taken — by weight (lb), length (ft), or unit count — plus timestamp and digital sign-off. Full audit trail per user: who took what, when, and how much.
Automatic discrepancy detection when current stock doesn’t match expected amounts. Flags missing inventory and traces back to the last user who signed off on that item. Generates variance reports with a full user accountability chain.
Export inventory data in formats compatible with Sage 50, Sage 200, QuickBooks, and other popular warehouse management systems. CSV and XML export templates mapped to standard ERP import schemas — sync stock levels, part numbers, and transactions without double-entry.
One-time purchase. Lifetime access. All future updates.