Skip to content
P26 Consultancy

Not Just A Patch: inventory that reorders itself

In short

A weekly n8n workflow that reads Amazon sales and warehouse stock, works out what to reorder, gets a manager's approval and emails each manufacturer its order. P26 built it for a client in Australia. Industry: E-Commerce, Supply Chain, Automation, Healthcare.

Industry
E-CommerceSupply ChainAutomationHealthcare
Location
Australia
What we did
Build
Video

The impact

Watch

Built by P26

Reorders, worked out every Monday.

Summary

Not Just A Patch makes waterproof patches for diabetes sensors and pods, and sells them on Amazon and its own store around the world.

With dozens of patch sizes, colours and pack counts, someone had to check sales and stock by hand every week, work out what to reorder, and chase each manufacturer by email. Fast sellers ran out and slow ones piled up.

What we did

Weekly run

  • An n8n workflow on a weekly schedule

Data in

  • Weekly sales and inventory from Amazon MWS
  • Live warehouse stock from the Borderless API

Reorder logic

  • Weekly sales velocity, SKU thresholds, available stock and vendor mapping, per SKU

Approval

  • A reorder sheet and a summary email for the inventory manager
  • A Slack alert, and nothing is sent without approval

Orders out

  • Each manufacturer emailed its order on approval

Master data

  • Thresholds, vendors, manager contacts and Slack and email settings in Google Sheets the team edits
  • Deployed to production with documentation

Built with

  • n8n
  • Amazon MWS
  • Borderless API
  • Google Sheets
  • Slack
  • Gmail

More work.

Start a project.

Tell us what you need in four short steps, or book a call with the founder. We reply within one business day.