Discuss a project

DL-023 · Case study

Warehouse picking and shipping app for CountryMax

A tablet app for CountryMax that streams Amazon orders in, guides pickers and shippers, and routes orders across warehouses.

Client
CountryMax
Location
New York, USA
Industry
Farm, pet and garden retail
Capabilities
03Build02Stabilize
01

Challenge

  • Orders arrived through daily manual report downloads into MS Access.
  • Pickers and shippers had no shared, live view of order status.
  • A second warehouse meant orders had to be routed by destination.
02

Environment

  • 18 stores, one warehouse and about 1,000 FBM orders a day.
  • Two to three times that volume in November and December.
  • Around 10,000 active SKUs and a warehouse team of about a dozen.
03

Intervention

  • Real-time order intake from SP-API order-change notifications through SQS.
  • Picker, shipper and manager views: trolleys, missing items, custom picklists.
  • Multi-warehouse routing by ship-to state, with fallbacks for unknown SKUs.
  • Fixed database load with an index instead of a larger instance.
04

Outcome

  • Orders are picked and shipped in one app used all day, every day.
  • 2,300 orders shipped on a single day after the second warehouse went live.
  • No database issues after the index fix, with no tier upgrade.
SP-API order-change notifications pass through SQS into a warehouse app that stores orders, drives picker and shipper tablets and routes orders to the right warehouse.notificationsindexedroutingSP-APIOrder changesSQS QUEUEFan-outWAREHOUSE APPNext.js / ECSORDERS DBPostgreSQLPICKER TABLETSTrolleysSHIPPINGBarcode stationWAREHOUSESRouted by state
  1. 01SP-APIOrder changesSQS QUEUEFan-outnotifications
  2. 02SQS QUEUEFan-outWAREHOUSE APPNext.js / ECS
  3. 03WAREHOUSE APPNext.js / ECSORDERS DBPostgreSQLindexed
  4. 04WAREHOUSE APPNext.js / ECSPICKER TABLETSTrolleys
  5. 05WAREHOUSE APPNext.js / ECSSHIPPINGBarcode station
  6. 06WAREHOUSE APPNext.js / ECSWAREHOUSESRouted by staterouting
Fig. 01From order notification to shipped trolleySP-API order-change notifications pass through SQS into a warehouse app that stores orders, drives picker and shipper tablets and routes orders to the right warehouse.Scale NTS

Results, as published.

~1,000
FBM orders a day through the app
2,300
Orders shipped in one day
18
Stores behind one warehouse app

Client notes.

Client notes · DL-023CountryMax
Very happy with the finished product and Raffy and Marcin's help throughout. I'm glad I stumbled upon you guys in a random YouTube video several months ago.
SignedEthan PayneeCommerce Director, CountryMax

Stack and services.

Stack08

  • Amazon SP-API
  • Next.js
  • AWS ECS
  • AWS Lambda
  • Amazon SQS
  • PostgreSQL
  • Amazon Cognito
  • GitHub Actions

Services used02

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project