Projects

All projects02 / 05Imported goods trading

The employee sees where to
place the goods, and the bin is reserved for them

A warehouse workspace that closes the loop from order to shipment: an order arrives from the CRM and becomes a work order by bin on the 3D plan, receipts and write-offs are recorded as documents with print forms, the inventory count runs on the same bins, and stock and documents go back to the CRM.

Scale
Several warehouses, about 3,000 SKUs
Deliveries
Imports, boxes of mixed goods
Employees
No dedicated warehouse worker, experience varies
Devices
Tablet and phone, several at once

Warehouse mapA 3D plan of the warehouse: racks divided into bins, the bin color shows the product category, and the warehouse summary, categories and minimap are on the right.

Context

The company trades in imported goods and runs several warehouses, with about 3,000 items in its range. There is no dedicated warehouse worker: employees with varying experience handle the goods, often at the same time and from different devices.

Constraint

An employee spent more time working out where to put the goods than on moving them.

The spot was chosen from memory and by verbal agreement, so two people could take the same bin, and a newcomer depended on experienced colleagues.

How it was

Every putaway required three decisions from a person: what the product is, where to put it and whether the spot is taken. A mistake only became visible at reconciliation.

Hypothesis

If the physical layout of the warehouse becomes part of the interface, and the system itself suggests a spot and reserves the bin for the employee, manual entry and disputes over space drop out of the flow.

Operation model

An order from the CRM becomes a work order: the items, bins and pick path are visible on the 3D plan. Receipts, write-offs and transfers are recorded as warehouse documents, printed for the warehouse and the driver, and posted to the CRM. The storage location is part of the flow, not a field in a database: while the employee carries the goods, the bin is reserved for them.

Delivery boxmixed goods
Product lookup in the systemby name, by hand
Finding a storage spotfrom memory
Verbal agreement“this shelf is free”
Manual entrybin and quantity
Reconciliationdiscrepancies at end of day
spot found from memoryWarehouse employee workspace
01Orderarrives from the CRM
02Work orderitems and bins
03Visualizationpick path on the plan
04Storagereceipt and location
05Inventory countrecount by bin
06Fulfillmentshipping and write-off
07Syncstock and documents to the CRM

Interface

Warehouse employee workspace

  1. A 3D plan of the warehouse: racks divided into bins, the bin color shows the product category, and the warehouse summary, categories and minimap are on the right.

    1. 1Bin color shows the product category
    2. 23D plan: rotation, compass, top view
    3. 3Warehouse summary: racks, bins, filled
    4. 4The layout is edited in 2D
  2. Orders arrive from the CRM, and a work order with bins is created for each one; the shipping status goes back.

    1. 1Statuses: new, picking, picked, shipped
    2. 2A work order and bins for every order
    3. 3Sync with the CRM
  3. The order's bins are highlighted on the 3D plan, and the picker checks off items along the way; after picking come shipping and write-off.

    1. 1Order bins on the plan
    2. 2Order items with their bins
    3. 3Picked items are checked off
    4. 4Work order printing, shipping and write-off
  4. The employee selects a bin on the plan, marks the category and adds a product from the catalog by name or SKU.

    1. 1The selected bin on the plan
    2. 2Category as large buttons
    3. 3Catalog product with photo and stock
    4. 4Move the contents to another bin
  5. Receipts, write-offs, transfers and inventory counts are recorded as warehouse documents with a print form; a posted document changes stock in the CRM.

    1. 1Document type and basis
    2. 2Posting status in the CRM
    3. 3Print form for the warehouse and the driver
    4. 4Post to CRM
  6. On a tablet the bin card slides up from the bottom and the buttons are large, so the work can be done standing at the rack.

Specification for the technical team

Based on the code of the live platform. The workflow is shown in full: posting of orders and documents is switched on when the CRM portal is connected.

Data sourcesCRM: ordersCRM: catalog and stockComputers and tablets
Operations layerWork ordersVersioned binsBin reservationWarehouse documentsSync log
Roles and devicesEmployee, tabletEmployee, computerWarehouse manager
Scale
Several warehouses, about 3,000 SKUs, imported deliveries in boxes of mixed goods.
Interface
Plain JavaScript with no build step and no dependencies. The 3D plan is drawn in WebGL with custom shaders: an orthographic camera, compass directions, a top view and a shelf cross-section.
Server and data
Cloudflare Pages Functions and a D1 database: bins with versions and change history, bin photos, devices, a sync log, daily warehouse snapshots.
Concurrent work
A bin is reserved for a device while it is being edited, so two operations never take the same spot; every record carries its device and time.
Catalog
The product catalog with photos is pulled from the CRM by a separate sync worker.
Orders and documents
Orders arrive from the CRM and become work orders by bin. Receipts, write-offs, transfers and inventory counts are recorded as warehouse documents with print forms and posted to the CRM together with stock.
Access
Devices are approved, and failed sign-in attempts are rate-limited by address.

What changed in how the operation runs

The changes are described qualitatively. Figures are published once the client approves them.

  • 01Storage locationThe bin is chosen within the receiving flow, not entered by hand afterwards.
  • 02No disputes over spaceTwo operations never take the same bin: the spot is reserved until confirmation.
  • 03New employeesAn employee with no experience follows the prompts on the screen, not colleagues' memory.

Metrics

  • Putaway time per itemtracked
  • Discrepancies at reconciliationtracked
  • Share of goods with an exact storage locationtracked
  • Time for a newcomer to reach working pacetracked