Case study · BBCS-02
Northwind · wholesale & fashion
Wholesale that runs itself, synced live to Shopify
A UK fashion brand sells through selling agents and retail partners around the world, and the whole operation ran on emailed orders, per-partner price lists and commission spreadsheets. We designed and built the platform end to end: it syncs live to the brand's Shopify store, then runs pricing, partner storefronts, ordering and agent commissions on top of it.
Sector
Wholesale & fashion
Region
UK / global partners
Scope
Design to production
Roles
Brand HQ / agents / retailers
Output
Platform + live Shopify sync
What the platform does
Wholesale, priced and ordered in one place
The wholesale operation on one platform, from B2B ordering through to agent commissions, live to the store.
B2B commerce
Order management
Inventory sync
Partner storefronts
Partner CRM
Pricing rules
Commission tracking
Shopify sync
The problem
Sell everywhere, keep it all straight on email and spreadsheets
The brand sells through selling agents and dozens of retail partners, each on its own terms. The record of who buys what, at which price, and which agent earns on it lived across inboxes, PDFs and spreadsheets.
01
Price lists that go stale the day they are sent. Every retail partner buys on its own terms, kept in spreadsheets and PDFs, so what a partner sees and what HQ intends drift apart, and nobody is sure which version is current.
02
Orders arrive as emails and CSVs. Someone re-keys each one into the store, with the errors and delays that come with re-keying, and the day only has room for so many orders.
03
Commissions settled in spreadsheets nobody fully trusts. Which agent sold what, at which rate, across which partners, reconstructed by hand each period and argued over when the numbers disagree.
The cost of getting it wrong
B2B e-commerce share
~⅓
Of revenue for B2B suppliers that sell online now comes from e-commerce, ahead of in-person sales.
Would switch supplier
54%
Of B2B buyers would abandon a purchase or switch supplier after a poor digital experience.
The compliance hook
UK law requires a commission statement for every agent each quarter, with how it was calculated, and agents can inspect the records behind it - confirmed in force February 2025.
Source: McKinsey B2B Pulse 2024; Commercial Agents Regulations 1993, reg 12
What we built
The whole wholesale operation on one platform, live to the store
Five screens from the platform, each shown as it runs on the device you are reading this on. Resize the window and the tour follows.
Shopify Sync
Product sync dashboard
Connected
to northwind-apparel.myshopify.com
Last sync: 2 minutes ago
Next sync: 13 min
847
Products Synced
23
Need Wholesale Pricing
Manage
12
Updated This Week
Review
3
Deleted from Shopify
Review
0
Sync Errors
Action Required
23 products need wholesale pricing
They can't be added to orders until pricing is set. Use pricing rules to automate, or set prices manually.
3 products deleted from Shopify
Archived locally; 2 have order history and are preserved. Review and decide whether to keep active or remove.
12 products updated in Shopify this week
Retail prices and descriptions changed; wholesale pricing is unaffected unless auto-pricing rules are set.
Wholesale Pricing
Rules, bulk & manual overrides
Create automated pricing rules based on cost or retail price, or set prices individually and in bulk.
23 need pricing
Product Status
Active, archived & deleted
Manage which synced products are active for wholesale.
847 active · 3 archived
Field Mappings
Shopify to Wholesale mapping
Configure which Shopify fields map to wholesale fields and which can be overridden locally.
8 mapped · 1 manual
Recent Sync Activity
Auto sync completed - 847 products checked, 0 changes
2 min ago
5 new products detected - SS26 Tech Shell range Pricing needed
4 hrs ago
3 products updated - Price changes on Essential Hoodie range
6 hrs ago
2 products deleted from Shopify - Archived locally (14 and 3 orders)
Yesterday
Shopify Sync
Product sync dashboard
Connected
to northwind-apparel.myshopify.com
Last sync: 2 minutes ago
Next sync: 13 min
847
Products Synced
23
Need Wholesale Pricing
Manage
12
Updated This Week
Review
3
Deleted from Shopify
Review
0
Sync Errors
Action Required
23 products need wholesale pricing
Can't be added to orders until wholesale pricing is set.
3 products deleted from Shopify
Archived locally; 2 have order history and are preserved.
12 products updated in Shopify this week
Retail prices and descriptions changed; wholesale pricing is unaffected.
Recent Sync Activity
Auto sync completed - 847 products checked, 0 changes
2 min ago
5 new products detected - SS26 Tech Shell range Pricing needed
4 hrs ago
3 products updated - Price changes on Essential Hoodie range
6 hrs ago
2 products deleted from Shopify - Archived locally (14 and 3 orders)
Yesterday
Wholesale Pricing
Rules, bulk & manual overrides
23 need pricing
Product Status
Active, archived & deleted
847 active · 3 archived
Field Mappings
Shopify to Wholesale mapping
8 mapped · 1 manual
NORTHWIND
APPAREL CO
AC
Shopify Sync
Product sync dashboard
Connected
northwind-apparel.myshopify.com
Last: 2 min ago
Next: 13 min
847
Synced
23
Pricing
12
Updated
3
Deleted
0
Errors
Action Required
23 products need wholesale pricing
They can't be added to orders until pricing is set.
3 products deleted from Shopify
Archived locally; 2 have order history and are preserved.
12 products updated this week
Retail prices and descriptions changed; wholesale pricing is unaffected.
Recent Sync Activity
View LogAuto sync completed - 847 checked, 0 changes
2 min ago
5 new products detected - SS26 Tech Shell range
Pricing needed · 4 hrs ago
01Operations dashboardOrders, partners and store sync health across the whole operation in one view.
Essential Oversized Hoodie - Black
Variable ActiveNWA-HD-001-BLK
Product Details
Name
Essential Oversized Hoodie - Black
SKU
NWA-HD-001-BLK
Type
Variable
Category
Hoodies
Barcode
5060412345678
Weight
0.65 kg
Supplier
Main Collection
Tax Class
Standard · 20%
Source
Shopify API Live
Added
5 Jan 2026
Pricing
Margin calculated cost to wholesaleShopify Retail
£65.00
Synced
Cost Price
£14.50
Synced
OVERRIDE
Wholesale
£32.00
Set manually
Margin
54.7%
Cost to Wholesale
Retailer Price Overrides
Retailer
Override
Discount
Margin
Vantage Retail
£28.00
-12.5%
48.2%
Size Variants
6 sizes · 204 availableSize
Cost
Wholesale
Margin
🇬🇧 UK
🇪🇺 EU
Avail.
XS
£14.50
£32.00
54.7%
18
12
30
S
£14.50
£32.00
54.7%
32
18
44
M
£14.50
£32.00
54.7%
42
24
58
L
£14.50
£32.00
54.7%
36
22
52
XL
£15.50 (+£1.00)
£32.00
51.6%
10
8
14
XXL
£16.50 (+£2.00)
£34.00
51.5%
4
2
6
Shopify Sync
In SyncShopify ID7284619301
Last Synced2 mins ago
Retail Price£65.00
Wholesale£28.00 (Rule 1)
Local Overrides1 field
Stock Summary
In stock🇬🇧 UK
142
🇪🇺 EU
86
Reserved: 24
Available: 204
Quick Stats
Total Units Sold
1,247
Across 38 orders
Total Revenue
£38,656
Top Retailer
Vantage Retail
486 units ordered
Essential Oversized Hoodie - Black
Variable ActiveNWA-HD-001-BLK
Product Details
Name
Essential Oversized Hoodie - Black
SKU
NWA-HD-001-BLK
Type
Variable
Category
Hoodies
Barcode
5060412345678
Weight
0.65 kg
Tax Class
Standard · 20%
Source
Shopify Live
Pricing
Retail
£65.00
Synced
Cost
£14.50
Synced
OVERRIDE
Wholesale
£32.00
Manual
Margin
54.7%
Cost to WS
Retailer Price Overrides
Retailer
Override
Discount
Margin
Vantage Retail
£28.00
-12.5%
48.2%
Shopify Sync
In SyncShopify ID7284619301
Last Synced2 mins ago
Retail Price£65.00
Wholesale£28.00 (Rule 1)
Overrides1 field
Size Variants
6 sizes · 204 availableSize
Cost
Whlsl
Margin
UK
EU
Avail
XS
£14.50
£32.00
54.7%
18
12
30
S
£14.50
£32.00
54.7%
32
18
44
M
£14.50
£32.00
54.7%
42
24
58
L
£14.50
£32.00
54.7%
36
22
52
XL
£15.50 (+£1)
£32.00
51.6%
10
8
14
XXL
£16.50 (+£2)
£34.00
51.5%
4
2
6
Totals
142
86
204
Stock Summary
In stock🇬🇧 UK
142
🇪🇺 EU
86
Reserved 24
Available 204
NORTHWIND
APPAREL CO
AC
Essential Oversized Hoodie - Black
NWA-HD-001-BLK
Variable
Active
Hoodies · 6 sizes
Wholesale
£32.00
54.7% margin
Pricing
GBPShopify Retail
£65.00
Synced
Cost Price
£14.50
Synced
OVERRIDE
Wholesale
£32.00
Set manually
Margin
54.7%
Cost to WS
Retailer Overrides
1 retailer
Vantage Retail
£28.00
-12.5%
48.2%
Size Availability
204 totalXS
30
S
44
M
58
L
52
XL
14
XXL
6
Stock
🇬🇧 UK142
🇪🇺 EU86
Available204
Sync
In SyncLast sync2m ago
Retail£65.00
Overrides1 field
02Pricing controlEvery partner's terms set once at HQ and applied everywhere that partner buys.
SM
Sarah Mitchell
ActiveAgent · Benelux · since Jan 2023
Retailers
7
Orders (YTD)
15
Revenue (YTD)
£73,300
Commission Owed
£5,864
Assigned Retailers
Retailer
Orders
Revenue (YTD)
Rate
Commission
Last Order
Van der Berg Stores
6
£34,200
8%
£2,736
20 Jan 2024
Lowlands Retail
4
£18,600
8%
£1,488
16 Jan 2024
Meridian NL
3
£12,400
6%
£744
11 Jan 2024
Brussels Trading Co
2
£8,100
10%
£810
8 Jan 2024
Total (4 retailers)
15
£73,300
6-10%
£5,778
Recent Orders
Last 5Order
Retailer
Date
Order Total
Commission
Commission
#WO-2024-0892
Van der Berg Stores
20 Jan 2024
£14,800
£1,184
Awaiting pay
#WO-2024-0886
Lowlands Retail
16 Jan 2024
£9,200
£736
Uninvoiced
#WO-2024-0879
Meridian NL
11 Jan 2024
£6,400
£384
Invoiced
#WO-2024-0871
Van der Berg Stores
5 Jan 2024
£11,200
£896
Paid out
#WO-2023-0862
Brussels Trading Co
28 Dec 2023
£4,800
£480
Paid out
Commission Invoices
Invoice
Period
Orders
Gross
Commission
Status
#SBI-2024-0012
Jan 2024
2
£21,200
£1,696
Sent to Sage
#SBI-2023-0009
Dec 2023
3
£16,000
£1,280
Paid
#SBI-2023-0006
Nov 2023
2
£12,400
£992
Paid
Profile
Email[email protected]
Phone+44 7700 123456
CompanyMitchell Sales Ltd
Agent sinceJan 2023
StatusActive
Territory
Benelux
Belgium · Netherlands · Luxembourg
7 retailers in territory
Assigned Linesheets
3SS26 Core Collection
86 products
AW25 Outerwear
42 products
Essentials
120 products
SM
Sarah Mitchell
ActiveAgent · Benelux · since Jan 2023
Retailers
7
Orders (YTD)
15
Revenue (YTD)
£73,300
Commission Owed
£5,864
Assigned Retailers
4 activeRetailer
Orders
Revenue
Rate
Comm.
Van der Berg Stores
6
£34,200
8%
£2,736
Lowlands Retail
4
£18,600
8%
£1,488
Meridian NL
3
£12,400
6%
£744
Brussels Trading Co
2
£8,100
10%
£810
Total
15
£73,300
6-10%
£5,778
Recent Orders
Last 5Order
Retailer
Total
Comm.
Status
#WO-2024-0892
Van der Berg Stores
£14,800
£1,184
Awaiting
#WO-2024-0886
Lowlands Retail
£9,200
£736
Uninvoiced
#WO-2024-0879
Meridian NL
£6,400
£384
Invoiced
#WO-2024-0871
Van der Berg Stores
£11,200
£896
Paid out
#WO-2023-0862
Brussels Trading Co
£4,800
£480
Paid out
Commission Invoices
3Invoice
Period
Commission
Status
#SBI-2024-0012
Jan 2024
£1,696
Sent to Sage
#SBI-2023-0009
Dec 2023
£1,280
Paid
#SBI-2023-0006
Nov 2023
£992
Paid
Profile
Territory
Benelux
Belgium · Netherlands · Luxembourg
Linesheets
3SS26 Core Collection
86 products
AW25 Outerwear
42 products
Essentials
120 products
NORTHWIND
APPAREL CO
AC
SM
Sarah Mitchell
ActiveAgent · Benelux
7
Retailers
15
Orders
£73.3k
Revenue
£5,864
Owed
Assigned Retailers
Rev · CommVan der Berg Stores
£34,200£2,736
Lowlands Retail
£18,600£1,488
Meridian NL
£12,400£744
Brussels Trading Co
£8,100£810
Recent Orders
Last 3#WO-2024-0892
Van der Berg Stores
£14,800Awaiting
#WO-2024-0886
Lowlands Retail
£9,200Uninvoiced
#WO-2024-0879
Meridian NL
£6,400Invoiced
Commission Invoices
#SBI-2024-0012
£1,696Sent to Sage
#SBI-2023-0009
£1,280Paid
Profile
Email[email protected]
Phone+44 7700 123456
Territory
Benelux
3 linesheets assigned
03Agent commissionsEvery order attributed to its selling agent, with statements built for each period.
Van der Berg Stores
Active[email protected]·Sarah Mitchell · Benelux
Details
Agent & Commission
% of paid invoice total
Sarah Mitchell manages this retailer across the Benelux territory. Commission is calculated from paid invoices only and appears on her self-billed commission invoices.
Tax & Warehouse
The tax region determines whether VAT is charged. As a Benelux export, orders are zero-rated. Within UK orders, tax rates are applied at product level - e.g. kids clothing is automatically zero-rated by its tax class.
Custom Fields
Assigned Linesheets
View allSS26 Core Collection
🇪🇺 EU · 86 SKUs
AW25 Outerwear
🇪🇺 EU · 42 SKUs
Price Overrides
| SKU / Product | Base | Override |
|---|---|---|
NWA-HD-001-BLK Essential Hoodie - Black | £32.00 | £28.00 |
NWA-HD-001-GRY Essential Hoodie - Grey | £32.00 | £28.00 |
Recent Orders
6 this year| Order | Date | Total | Status |
|---|---|---|---|
| #WO-2024-0892 | 20 Jan 2024 | £14,800 | Pending |
| #WO-2024-0871 | 5 Jan 2024 | £11,200 | Paid |
Invoices
| Invoice | Date | Amount | Status |
|---|---|---|---|
| #INV-2024-0458 | 20 Jan 2024 | £14,800 | Pending |
| #INV-2024-0445 | 5 Jan 2024 | £11,200 | Paid |
Van der Berg Stores
Active[email protected]·Sarah Mitchell · Benelux
Details
Agent & Commission
% of paid invoice total
Sarah Mitchell manages this retailer across the Benelux territory. Commission is calculated from paid invoices only and appears on her self-billed commission invoices.
Tax & Warehouse
The tax region determines whether VAT is charged. As a Benelux export, orders are zero-rated. Within UK orders, tax rates are applied at product level - e.g. kids clothing is automatically zero-rated by its tax class.
Custom Fields
Assigned Linesheets
View allSS26 Core Collection
🇪🇺 EU · 86 SKUs
AW25 Outerwear
🇪🇺 EU · 42 SKUs
Price Overrides
| SKU / Product | Base | Override |
|---|---|---|
NWA-HD-001-BLK Essential Hoodie - Black | £32.00 | £28.00 |
NWA-HD-001-GRY Essential Hoodie - Grey | £32.00 | £28.00 |
Recent Orders
6 this year| Order | Date | Total | Status |
|---|---|---|---|
| #WO-2024-0892 | 20 Jan 2024 | £14,800 | Pending |
| #WO-2024-0871 | 5 Jan 2024 | £11,200 | Paid |
Invoices
| Invoice | Date | Amount | Status |
|---|---|---|---|
| #INV-2024-0458 | 20 Jan 2024 | £14,800 | Pending |
| #INV-2024-0445 | 5 Jan 2024 | £11,200 | Paid |
NORTHWIND
APPAREL CO
AC
Van der Berg Stores
ActiveSarah Mitchell · Benelux
Details
Agent & Commission
% of paid invoice total
Sarah Mitchell manages this retailer. Commission is calculated from paid invoices only.
Tax & Warehouse
As a Benelux export, orders are zero-rated. UK orders apply tax at product level by tax class.
Custom Fields
Assigned Linesheets
2SS26 Core Collection
🇪🇺 EU · 86 SKUs
AW25 Outerwear
🇪🇺 EU · 42 SKUs
Price Overrides
NWA-HD-001-BLK
Essential Hoodie - Black
£32.00£28.00
NWA-HD-001-GRY
Essential Hoodie - Grey
£32.00£28.00
Recent Orders
6 this year#WO-2024-0892
20 Jan 2024
£14,800Pending
#WO-2024-0871
5 Jan 2024
£11,200Paid
Invoices
#INV-2024-0458
20 Jan 2024
£14,800Pending
#INV-2024-0445
5 Jan 2024
£11,200Paid
04Retailer recordA private record per retail partner, each with its own catalogue, prices and orders.
Reporting
Reconciliation, exports & financial summaries
Total Revenue
£142,860
12.3% vs last month
Orders
38
5 more than Dec
Invoices Raised
34
4 orders uninvoiced
Outstanding
£61,020
2 invoices overdue
Overview
Reconciliation
Exports
Agent Commission
Inventory
Uninvoiced Orders (4)
#WO-2026-0035 - Tread Active
28 Jan • £4,120
#WO-2026-0033 - Stride & Co
25 Jan • £3,840
#WO-2026-0031 - Tread Active
22 Jan • £2,960
#WO-2026-0028 - Halcyon Stores
18 Jan • £5,480
Overdue (2)
#INV-2026-0445 - Stride & Co
£15,200Due 28 Dec 2025 - 47 days overdue
#INV-2026-0452 - Tread Active
£9,180Due 5 Jan 2026 - 39 days overdue
Sage Sync Queue (6)
| Invoice | Retailer | Amount | Status | |
|---|---|---|---|---|
| #INV-2026-0461 | Halcyon Stores | £8,240 | Not sent | |
| #INV-2026-0460 | Apex Sportswear | £5,600 | Not sent | |
| #INV-2026-0459 | Van der Berg Stores | £12,400 | Not sent | |
| #INV-2026-0457 | Marchmont | £3,180 | Not sent | |
| #INV-2026-0453 | Halcyon Stores | £6,840 | Out of sync | |
| #INV-2026-0448 | Stride & Co | £4,200 | Error Sage rejected: VAT number mismatch |
Sage Sync
Invoices synced28 of 34
4
Not Sent
1
Out of Sync
1
Error
Quick Actions
Monthly Reconciliation
| Retailer | Orders | Invoiced | Paid | Outstanding | Sage |
|---|---|---|---|---|---|
| Halcyon Stores | 12 | £48,240 | £24,580 | £23,660 | Synced |
| Carraway & Hale | 8 | £37,840 | £37,840 | £0 | Synced |
| Apex Sportswear | 10 | £32,400 | £32,400 | £0 | Synced |
| Stride & Co | 5 | £15,200 | £0 | £15,200 | Pending |
| Tread Active | 3 | £9,180 | £0 | £9,180 | Not sent |
| Total | 38 | £142,860 | £94,820 | £48,040 |
Monthly reconciliation
Use Export for Sage in the Exports tab to generate a file with all invoices, nominal codes, and tax breakdowns pre-formatted. Check Out of Sync invoices before month-end. The Revenue by Retailer export can be cross-referenced with your Sage aged debtors report.
Use Export for Sage in the Exports tab to generate a file with all invoices, nominal codes, and tax breakdowns pre-formatted. Check Out of Sync invoices before month-end. The Revenue by Retailer export can be cross-referenced with your Sage aged debtors report.
Export Centre
Orders Report
Excel • All order data
Full order data for the selected period. Includes retailer, products, quantities, and totals.
Invoice Report
Excel • All invoices
Invoice summary with amounts, status, dates, and payment tracking for reconciliation.
Export for Sage
CSV • Sage-ready format
Pre-formatted with nominal codes, tax breakdowns, and Sage field mapping for direct import.
Revenue by Retailer
Excel • Revenue breakdown
Revenue split by retailer with order count, average order value, and payment status.
Agent Commission Summary
Commission rates are set per retailer. Each agent may earn different rates across their retailers.
| Agent / Retailer | Territory | Orders | Revenue | Rate | Earned | Pending |
|---|---|---|---|---|---|---|
| Sarah Mitchell (4 retailers) | Benelux | 7 | £38,400 | 6-10% | £2,496 | £736 |
| Van der Berg Stores | 3 | £26,000 | 8% | £2,080 | - | |
| Lowlands Retail | 2 | £9,200 | 8% | - | £736 | |
| Meridian NL | 1 | £6,400 | 6% | £384 | - | |
| Brussels Trading Co | 1 | £3,200 | 10% | £320 | - | |
| Marcus Johnson (3 retailers) | Northern Europe | 5 | £22,100 | 7-8% | £980 | £567 |
| Nordmann Group | 2 | £12,600 | 7% | £882 | - | |
| Boreal Retail | 2 | £6,300 | 8% | £98 | £406 | |
| Fjord Retail | 1 | £3,200 | 7% | - | £161 | |
| Emma Wright (2 retailers) | Middle East | 3 | £9,800 | 10-12% | £420 | £560 |
| Gulf Luxe | 2 | £6,200 | 10% | £420 | £200 | |
| Dune & Pearl | 1 | £3,600 | 12% | - | £360 | |
| Total (3 agents) | 15 | £70,300 | £3,896 | £1,863 |
Agent commission workflow
Commission rates are set on each retailer's profile, not on the agent. Commission is only earned on paid invoices. Create self-billed commission invoices from the Commission Invoices page, then send to Sage for payment through your normal AP process.
Commission rates are set on each retailer's profile, not on the agent. Commission is only earned on paid invoices. Create self-billed commission invoices from the Commission Invoices page, then send to Sage for payment through your normal AP process.
Total Stock Value
£482,640
at wholesale price
Total Units
14,832
across 847 SKUs
Reserved
1,247
from 8 pending orders
Low / Out of Stock
23
SKUs need attention
Stock by Warehouse
🇬🇧 UK Warehouse
Total Units
9,248
Stock Value
£301,520
Reserved
892
Available
8,356
🇪🇺 EU Warehouse
Total Units
5,584
Stock Value
£181,120
Reserved
355
Available
5,229
Low & Out of Stock SKUs
| SKU | Product | UK | EU | Reserved | Available | Status |
|---|---|---|---|---|---|---|
| NW-BAG-001-BLK | Gym Duffle Bag - Black | 0 | 0 | 0 | 0 | Out of stock |
| NW-TS-015-WHT | Signature Logo Tee - White | 6 | 2 | 0 | 8 | Low stock |
| NW-JK-003-NVY | Padded Puffer Jacket - Navy | 4 | 0 | 2 | 2 | Low stock |
| NW-HD-008-GRY | Oversized Hoodie - Grey Marl | 3 | 4 | 2 | 5 | Low stock |
Reporting
Reconciliation, exports & financial summaries
Total Revenue
£142,860
12.3% vs last month
Orders
38
5 more than Dec
Invoices Raised
34
4 orders uninvoiced
Outstanding
£61,020
2 invoices overdue
Overview
Reconciliation
Exports
Agent Commission
Inventory
Uninvoiced Orders (4)
#WO-2026-0035 - Tread Active
28 Jan • £4,120
#WO-2026-0033 - Stride & Co
25 Jan • £3,840
#WO-2026-0031 - Tread Active
22 Jan • £2,960
#WO-2026-0028 - Halcyon Stores
18 Jan • £5,480
Overdue (2)
#INV-2026-0445 - Stride & Co
£15,200Due 28 Dec 2025 - 47 days overdue
#INV-2026-0452 - Tread Active
£9,180Due 5 Jan 2026 - 39 days overdue
Sage Sync Queue (6)
| Invoice | Retailer | Amount | Status | |
|---|---|---|---|---|
| #INV-2026-0461 | Halcyon Stores | £8,240 | Not sent | |
| #INV-2026-0460 | Apex Sportswear | £5,600 | Not sent | |
| #INV-2026-0459 | Van der Berg Stores | £12,400 | Not sent | |
| #INV-2026-0457 | Marchmont | £3,180 | Not sent | |
| #INV-2026-0453 | Halcyon Stores | £6,840 | Out of sync | |
| #INV-2026-0448 | Stride & Co | £4,200 | Error Sage rejected: VAT number mismatch |
Sage Sync
Invoices synced28 of 34
4
Not Sent
1
Out of Sync
1
Error
Quick Actions
Monthly Reconciliation
| Retailer | Orders | Invoiced | Paid | Outstanding | Sage |
|---|---|---|---|---|---|
| Halcyon Stores | 12 | £48,240 | £24,580 | £23,660 | Synced |
| Carraway & Hale | 8 | £37,840 | £37,840 | £0 | Synced |
| Apex Sportswear | 10 | £32,400 | £32,400 | £0 | Synced |
| Stride & Co | 5 | £15,200 | £0 | £15,200 | Pending |
| Tread Active | 3 | £9,180 | £0 | £9,180 | Not sent |
| Total | 38 | £142,860 | £94,820 | £48,040 |
Monthly reconciliation
Use Export for Sage in the Exports tab to generate a file with all invoices, nominal codes, and tax breakdowns pre-formatted. Check Out of Sync invoices before month-end. The Revenue by Retailer export can be cross-referenced with your Sage aged debtors report.
Use Export for Sage in the Exports tab to generate a file with all invoices, nominal codes, and tax breakdowns pre-formatted. Check Out of Sync invoices before month-end. The Revenue by Retailer export can be cross-referenced with your Sage aged debtors report.
Export Centre
Orders Report
Excel • All order data
Full order data for the selected period. Includes retailer, products, quantities, and totals.
Invoice Report
Excel • All invoices
Invoice summary with amounts, status, dates, and payment tracking for reconciliation.
Export for Sage
CSV • Sage-ready format
Pre-formatted with nominal codes, tax breakdowns, and Sage field mapping for direct import.
Revenue by Retailer
Excel • Revenue breakdown
Revenue split by retailer with order count, average order value, and payment status.
Agent Commission Summary
Commission rates are set per retailer. Each agent may earn different rates across their retailers.
| Agent / Retailer | Territory | Orders | Revenue | Rate | Earned | Pending |
|---|---|---|---|---|---|---|
| Sarah Mitchell (4 retailers) | Benelux | 7 | £38,400 | 6-10% | £2,496 | £736 |
| Van der Berg Stores | 3 | £26,000 | 8% | £2,080 | - | |
| Lowlands Retail | 2 | £9,200 | 8% | - | £736 | |
| Meridian NL | 1 | £6,400 | 6% | £384 | - | |
| Brussels Trading Co | 1 | £3,200 | 10% | £320 | - | |
| Marcus Johnson (3 retailers) | Northern Europe | 5 | £22,100 | 7-8% | £980 | £567 |
| Nordmann Group | 2 | £12,600 | 7% | £882 | - | |
| Boreal Retail | 2 | £6,300 | 8% | £98 | £406 | |
| Fjord Retail | 1 | £3,200 | 7% | - | £161 | |
| Emma Wright (2 retailers) | Middle East | 3 | £9,800 | 10-12% | £420 | £560 |
| Gulf Luxe | 2 | £6,200 | 10% | £420 | £200 | |
| Dune & Pearl | 1 | £3,600 | 12% | - | £360 | |
| Total (3 agents) | 15 | £70,300 | £3,896 | £1,863 |
Agent commission workflow
Commission rates are set on each retailer's profile, not on the agent. Commission is only earned on paid invoices. Create self-billed commission invoices from the Commission Invoices page, then send to Sage for payment through your normal AP process.
Commission rates are set on each retailer's profile, not on the agent. Commission is only earned on paid invoices. Create self-billed commission invoices from the Commission Invoices page, then send to Sage for payment through your normal AP process.
Total Stock Value
£482,640
at wholesale price
Total Units
14,832
across 847 SKUs
Reserved
1,247
from 8 pending orders
Low / Out of Stock
23
SKUs need attention
Stock by Warehouse
🇬🇧 UK Warehouse
Total Units
9,248
Stock Value
£301,520
Reserved
892
Available
8,356
🇪🇺 EU Warehouse
Total Units
5,584
Stock Value
£181,120
Reserved
355
Available
5,229
Low & Out of Stock SKUs
| SKU | Product | UK | EU | Reserved | Available | Status |
|---|---|---|---|---|---|---|
| NW-BAG-001-BLK | Gym Duffle Bag - Black | 0 | 0 | 0 | 0 | Out of stock |
| NW-TS-015-WHT | Signature Logo Tee - White | 6 | 2 | 0 | 8 | Low stock |
| NW-JK-003-NVY | Padded Puffer Jacket - Navy | 4 | 0 | 2 | 2 | Low stock |
| NW-HD-008-GRY | Oversized Hoodie - Grey Marl | 3 | 4 | 2 | 5 | Low stock |
NORTHWIND
APPAREL CO
AC
Reporting
Reconciliation & exports
Jan 2026
Total Revenue
£142,860
12.3%
Outstanding
£61,020
2 overdue
Orders38
Invoices34
Overview
Reconciliation
Exports
Commission
Inventory
Uninvoiced Orders (4)
#WO-2026-0035
Tread Active • 28 Jan • £4,120
#WO-2026-0033
Stride & Co • 25 Jan • £3,840
#WO-2026-0031
Tread Active • 22 Jan • £2,960
#WO-2026-0028
Halcyon Stores • 18 Jan • £5,480
Overdue (2)
#INV-2026-0445£15,200
Stride & Co • 47 days overdue
#INV-2026-0452£9,180
Tread Active • 39 days overdue
Sage Sync
Invoices synced28 of 34
4
Not Sent
1
Out Sync
1
Error
Sync Queue (6)
#INV-2026-0461
Halcyon Stores
£8,240Not sent
#INV-2026-0459
Van der Berg Stores
£12,400Not sent
#INV-2026-0453
Halcyon Stores
£6,840Out of sync
#INV-2026-0448
Stride & Co • VAT mismatch
£4,200Error
Monthly Reconciliation
Halcyon StoresSynced
12 ordersInv £48,240Out £23,660
Carraway & HaleSynced
8 ordersInv £37,840Out £0
Apex SportswearSynced
10 ordersInv £32,400Out £0
Stride & CoPending
5 ordersInv £15,200Out £15,200
Tread ActiveNot sent
3 ordersInv £9,180Out £9,180
Total • 38 orders£48,040
Use Export for Sage to generate a pre-formatted file with nominal codes and tax breakdowns. Check Out of Sync invoices before month-end.
Orders Report
Excel • All order data
Full order data for the period - retailer, products, quantities, totals.
Invoice Report
Excel • All invoices
Invoice summary with amounts, status, dates and payment tracking.
Export for Sage
CSV • Sage-ready format
Pre-formatted with nominal codes, tax breakdowns and Sage field mapping.
Revenue by Retailer
Excel • Revenue breakdown
Revenue split by retailer with order count, AOV and payment status.
Commission rates are set per retailer. Each agent may earn different rates across their retailers.
Sarah Mitchell
Benelux • 4 retailers • 7 orders
£38,400
Revenue
£2,496
Earned
£736
Pending
Marcus Johnson
Northern Europe • 3 retailers • 5 orders
£22,100
Revenue
£980
Earned
£567
Pending
Emma Wright
Middle East • 2 retailers • 3 orders
£9,800
Revenue
£420
Earned
£560
Pending
Total (3 agents)
£3,896£1,863
Stock Value
£482,640
Total Units
14,832
Reserved
1,247
Low / Out
23
Stock by Warehouse
🇬🇧 UK Warehouse
Units
9,248
Value
£301,520
Reserved
892
Avail
8,356
🇪🇺 EU Warehouse
Units
5,584
Value
£181,120
Reserved
355
Avail
5,229
Low & Out of Stock
NW-BAG-001-BLK
Gym Duffle Bag - Black
0Out
NW-TS-015-WHT
Signature Logo Tee - White
8Low
NW-JK-003-NVY
Padded Puffer Jacket - Navy
2Low
NW-HD-008-GRY
Oversized Hoodie - Grey Marl
5Low
05ReportingSales, margin and partner performance across the operation, period by period.
Our part
The calls we made
Paul Banks
Founder & Lead Consultant
Led end to end by a senior team, from the first call through to handover.
The retail store already worked. We argued to keep it as the source of truth and have the platform sync live to it, so the brand never runs two catalogues or reconciles two sets of numbers.
Each partner's terms are set once as rules at head office and applied wherever that partner buys. A price change becomes one decision, not forty spreadsheet edits sent out by email.
Each retailer and agent signs in to only its own catalogue, prices and orders - a partner-grade experience, not a shared back office everyone can see into.
Attribution happens the moment an order is placed, so the agent statement is generated from the record rather than reconstructed, and argued over, at the end of the period.
Built by a senior team end to end and handed over with the client owning the platform outright.
Paul Banks
Founder & Lead Consultant
Led end to end by a senior team, from the first call through to handover.
Outcome
An order placed by a partner never passes through a person
Partners order on their own terms, orders flow to the store without re-keying, and every one is attributed to its agent the moment it is placed. The commission statement is generated, not argued.
Processed every year
£10m
In wholesale orders now move through the platform every year - placed by partners, attributed automatically, synced straight to the store.
18
Selling agents, each attributed automatically
50
Retail partners, each on its own terms
10days
Of admin removed every month
The team now spends more time marketing and selling to retailers than clearing admin.
Built to standard
Handled to the standard the work demands
Partner-grade access
Every retailer and agent sees only its own world - catalogues, prices and orders are isolated per partner.
UK data protection
Partner and order data handled to UK GDPR expectations.
Client-owned
Built senior-only and handed over with the client owning the platform outright.
