API DevelopmentSystem Integration

Connecting a Wholesaler's Systems So Orders Flow Automatically

CodeCrackers built a secure trade API for a UK wholesale distributor and connected its warehouse, Xero and courier systems. Retailers now place orders and check live stock automatically. Orders flow from checkout to dispatch without anyone re-keying a single line.

The trade API on a laptop and a phone (designed product screens)
Orders via the API58%
Fewer Order Errors76%
Faster Order Processing45%
Client
Confidential UK Wholesale Distributor
Industry
Wholesale Distribution
Platform
Node.js · REST API · AWS
Services
API Development, System Integration, Shopify & WooCommerce Connectors, Developer Portal
Duration
9-Week Build
About the Project

300 Retailers, Orders Arriving by Email

The client is a UK wholesale distributor of health and beauty products, supplying more than 300 independent shops, salons and online sellers. Its 20-person team runs a warehouse in the West Midlands and dispatches orders across the UK every day.

Almost every order arrived by email or spreadsheet and was typed into the warehouse system by hand. Stock levels went out in weekly spreadsheets, and nothing was connected to Xero or the couriers. The directors asked CodeCrackers to connect everything so orders could flow automatically.

Initial Requirements

  • Let retailers place orders automatically
  • Share live stock levels and trade prices
  • Connect the warehouse, Xero and couriers
  • Send tracking and invoices without manual work

Main Objective

Connect every system so trade orders flow automatically from retailer to dispatch.

Success Measure

More automated orders, fewer errors and faster dispatch.

Scope of Work

API StrategyREST API DevelopmentShopify ConnectorWooCommerce ConnectorWarehouse IntegrationXero IntegrationCourier APIsDeveloper Portal
The Challenge

Understanding the Challenge

The business had a strong product range and loyal retailers, but four connected problems were slowing every order down. Each one made the others worse.

Orders by Email

Retailers sent orders by email and spreadsheet, and the team typed every line into the warehouse system.

What wasn't working

Slow processing and keying errors.

Out-of-Date Stock

Retailers' websites showed stock from weekly spreadsheets, so they sold items the distributor no longer had.

What wasn't working

Cancelled orders and frustrated retailers.

Disconnected Systems

The warehouse system, Xero and the courier accounts didn't talk to each other, so data was copied between them by hand.

What wasn't working

Hours of double entry every day.

Tracking Requests

Retailers emailed for tracking numbers and invoices, and staff looked them up and sent them one by one.

What wasn't working

Constant “where's my order?” emails.

What the client wanted to achieve: one connected set of systems where retailers order and check stock automatically and orders go straight to the warehouse. Tracking and invoices would go back to retailers without anyone lifting a finger.

Research & Strategy

Our Approach & Strategy

Before writing any code, we mapped every system the business used and traced how a single order moved between them.

Systems Audit

We reviewed the warehouse system, Xero, the courier accounts and retailers' platforms, checking what each API could and couldn't do.

Retailer Research

We spoke with retailers of different sizes to learn which platforms they used and how they wanted to order.

Data Mapping

We mapped every field, from product codes and prices to delivery addresses, so data would move cleanly between systems.

Why This Solution

With one central API and integration layer, each system only needed to connect once, instead of relying on fragile links between every pair.

Confidential UK Wholesale Distributor project planning board
Design & Development Process

Bringing the Vision to Life

A structured nine-week approach kept every stage transparent and on time. Select a stage to see what happened.

Stage 1 of 7 · Week 1

Discovery

We started by mapping every system the business used and following real orders from email to dispatch. We then agreed the priorities with the directors.

Key deliverables
  • Systems and order audit
  • Stakeholder interviews
  • Integration priorities
Before & After

The Transformation

Drag the handle to compare how orders were handled before and after the integration.

The trade API dashboard (designed product screen)
Illustration of how the work was done before The trade API
BeforeAfter

Both views are illustrations: the “before” shows the old way of working, the “after” shows the new system. Client data is not shown.

Problems with the Previous Version

  • Orders emailed and re-keyed by hand
  • Stock levels shared in weekly spreadsheets
  • Warehouse, Xero and couriers not connected
  • Tracking and invoices sent one by one

Key Improvements

  • Orders placed automatically through the API
  • Live stock and prices on retailers' sites
  • One integration layer connecting every system
  • Tracking and invoices sent automatically
Our Solution

The Solution We Delivered

Four connected workstreams, each one solving a specific part of the challenge.

Trade Orders API

A Secure API for Every Retailer

A secure REST API lets retailers' systems place orders directly, each with its own access key. Ready-made Shopify and WooCommerce connectors mean smaller retailers can connect without a developer.

Solves: orders arriving by email and being typed in by hand.
Trade Orders API: designed screens on desktop and mobile
Live Stock & Pricing

Stock Levels That Are Always Right

Stock and trade prices update from the warehouse system every few minutes. Retailers' websites pull them automatically, so retailers only sell what's actually on the shelf.

Solves: out-of-date stock and cancelled orders.
Live Stock & Pricing: designed screens on desktop and mobile
System Integration

Warehouse, Xero and Couriers, Connected

A central integration layer sends each order to the warehouse, books the courier through DPD or Royal Mail and creates the invoice in Xero. Nothing is copied by hand.

Solves: hours of double entry every day.
System Integration: designed screens on desktop and mobile
Webhooks & Developer Portal

Updates Sent the Moment They Happen

Webhooks send dispatch confirmations, tracking numbers and invoices to retailers automatically. A developer portal with clear documentation and a sandbox helps new retailers connect quickly.

Solves: constant emails asking for tracking and invoices.
Webhooks & Developer Portal: designed screens on desktop and mobile
Final Project Showcase

Explore the Final Experience

The finished developer portal, API documentation and order dashboard on desktop and mobile.

Full page of Trade API · operations dashboard on desktop
Desktop

Hover over a screen and scroll through the product screens.

Results & Impact

The Results That Matter

Measured results in the first 90 days after launch.

58%

Orders via the API

Trade orders placed automatically through the API and connectors.

76%

Fewer Order Errors

Wrong items, quantities or addresses, compared with the previous quarter.

45%

Faster Order Processing

Average time from receiving an order to it being ready for dispatch.

Connecting every system turned a manual, email-driven operation into an automated one. Retailers order whenever they like, stock is always accurate, and the team spends its time picking and packing instead of typing.

  • The trade API took orders out of the inbox
  • Live stock feeds stopped retailers overselling
  • Webhooks sent tracking and invoices automatically
Testimonial

What Our Client Says

★★★★★
“We were typing hundreds of order lines a day from emails and spreadsheets. CodeCrackers connected all our systems and gave our retailers a proper way to order. Orders now arrive automatically, stock is always right, and our team has hours back every day.”
WDConfidential UK Wholesale DistributorClient
shape
shape
GET IN TOUCH

Let’s Improve Your Digital Strategy
for UK Business Growth

Schedule a Free Discovery Call