C
John Lewis Network routed · Premium Department Store Last reviewed: August 2026
🇬🇧 UK Network

John Lewis EDI,
working in the background.

Supply Lens automates the John Lewis Partnership supplier document cycle. Purchase orders, sales reports and inventory reports in, invoices out, mapped to your ERP or IMS with the right branch codes, supplier IDs and John Lewis tolerance rules built in.

Orders in
Purchase orders handled automatically
Every John Lewis purchase order lands in your ERP without manual intervention
Network managed
No account needed on your side
John Lewis route through a managed network, and we hold that relationship for you
Sell-through data
Sales and stock reports land in your ERP
See what actually sold and what is left on shelf, without waiting for a monthly statement
99.9%
Uptime SLA
Monitored around the clock, helping keep documents within transmission windows
Supply Lens · John Lewis Live Flow Live
John Lewis PO COP-2026-40817 received via managed network · 36× line A · 60× line B · depot routing resolved PO IN
EANs mapped · location resolved Depot code matched · supplier code confirmed · pricing applied PROCESSING
Sales order SO-31776 created ERP / IMS · 96 units · ref COP-2026-40817 CREATED
Sales report received Units sold by branch · matched to your product records REPORT
Invoice transmitted to John Lewis £6,140.20 · validated against PO · confirmed received SENT
Inventory report received On-shelf position by branch · updated in your ERP REPORT
John Lewis-Specific Requirements

Orders and reports in, invoices out.
The detail is in the rules.

John Lewis's flow looks straightforward on paper. The work is in the supplier and branch codes, the tolerance rules on every invoice and landing the sales and inventory reports somewhere your team will actually use them. Get any of it wrong and you eat a deduction. Supply Lens is configured for those rules out of the box.

Network managed connection

John Lewis receive supplier documents through a managed network rather than a point-to-point link. Supply Lens holds that network relationship, the routing and the partner profile on your behalf, so you need no account, subscription or gateway of your own.

Partnership infrastructure

John Lewis and Waitrose sit under the same Partnership infrastructure, sharing location structures, supplier codes and routing. If you already trade with one, you are most of the way to trading with the other, and Supply Lens carries the same configuration across both.

EAN to item code mapping

John Lewis identifies products by GS1 EAN and an internal product reference. Supply Lens maintains a cross-reference table mapping both to your own item codes, so the order lands correctly in your ERP regardless of which identifier John Lewis sends.

Invoice tolerance rules

John Lewis applies strict invoice matching on price and quantity. Supply Lens validates the invoice against the originating purchase order and your agreed cost list before transmission, flagging any discrepancy for review rather than sending it and risking a deduction later.

Branch and depot routing

Each John Lewis purchase order names a destination branch or depot by code. Supply Lens maps every active Partnership location to the correct routing in your warehouse system, so the order lands against the right destination in your ERP without manual intervention.

Sales and inventory reporting

John Lewis send sales and inventory reports back over the same connection. Supply Lens lands them in your ERP against the right products and branches, so you can see what sold and what remains on shelf without anyone rekeying a spreadsheet or waiting for a monthly statement.

Document Flow

Every document.
Every direction.
Automatically.

Supply Lens handles the full John Lewis document set inbound and outbound, so documents are produced and transmitted automatically, without manual rekeying.

  • Purchase orders received and validated against your supplier profile
  • Invoices pre-validated against the purchase order and your agreed John Lewis cost list before transmission
  • Sales reports received and matched to your product records by branch
  • Inventory reports landed against the right products so on-shelf position is visible in your ERP
  • Tolerance, depot and pricing rules applied per message automatically
  • All John Lewis-specific document structures generated and read correctly without your team seeing the format
John Lewis document cycle
Purchase Order INBOUND
John Lewis
Sales report INBOUND
John Lewis
Invoice (pre-validated) OUTBOUND
John Lewis
Inventory report INBOUND
John Lewis
What's mapped automatically
John Lewis reference Resolved automatically
Branch and depot location codes
Pre-loaded
Product EANs and John Lewis product references
Resolved per order
Cost list and promotional pricing
Applied per line
Tax and currency
UK VAT, GBP
Configuration

Configured for John Lewis.
Connected to your
system.

Supply Lens holds John Lewis's rules and the connection itself so you don't have to. Your team provides credentials, product mappings and the agreed cost list. Everything else lives in the Supply Lens layer.

1

John Lewis supplier onboarding

Your John Lewis supplier code, GLN and trading partner profile registered with John Lewis's gateway. Supply Lens manages the connection identifiers and certificates, so there is no setup needed your side.

2

EAN and product cross-reference

John Lewis EANs and product references mapped to your item codes. Pack-size variants, promotional lines and multi-pack SKUs are handled automatically once their cross-reference is established.

3

Branch routing and entity mapping

Each John Lewis branch and depot code mapped to your correct warehouse, customer account or entity in your ERP, so orders route cleanly on receipt and reports land against the right location.

4

Tolerance and pricing rules

Your agreed John Lewis cost list registered for invoice validation. Tolerance rules applied per supplier agreement, so price discrepancies surface your side first.

EAN → item code cross-reference
John Lewis reference Your item code
50142880031001 AMB-BEAN-400G
50142880031002 AMB-SOUP-400G
50142880031003 CHL-CHED-200G
prd:6620418-A SUPP-CO-6620418
Order ingest
Network routed
ON
SO creation
On PO ingest
ON
Sales reports
Inbound, by branch
ON
Invoice out
On despatch
ON
Inventory reports
On-shelf position
ON
Exception queue
Email + dashboard
CONFIG
John Lewis Edge Cases

The situations that
catch suppliers out.

Supply Lens handles the scenarios that typically cause invoice rejections, deductions or document mismatches in the John Lewis flow.

"John Lewis send documents in a format our system cannot read. We've been doing it manually for months."

The format never reaches your system. Supply Lens turns John Lewis's purchase order into a clean payload your ERP already understands and renders every outbound document in the structure John Lewis requires on the way back out. Your team works in their normal interface, the format conversion happens in the Supply Lens layer.

"John Lewis deducted against an invoice because the unit price was a few pence off the agreed cost list."

Invoice values are validated against the originating purchase order and your agreed John Lewis cost list before submission. Discrepancies are flagged before the invoice is sent, giving your team a chance to correct or query rather than receive a John Lewis deduction weeks later.

"John Lewis send us sales and stock data and it just sits in a spreadsheet nobody reads."

Both reports are landed in your ERP against the products and branches they refer to, not left as a file to open. Sell-through and on-shelf position sit next to your own stock and order data, so replenishment decisions are made on what actually sold rather than on what was last ordered.

"A new John Lewis EAN started arriving and our system rejected the order because the product wasn't mapped."

Unrecognised EANs go to an exception queue immediately. The order is held, your team is notified with the full John Lewis context, the mapping is added and the order is re-triggered. No silent drop, no late invoice, no missed delivery window.

Getting Set Up

What you need to
go live with John Lewis.

John Lewis onboarding involves their supplier team, the connection setup and your internal product and pricing data. Supply Lens manages the configuration, the gateway and the format conversion. You provide the inputs.

  • John Lewis supplier code and any associated GLNs
  • Product EAN list with your internal item codes
  • John Lewis product reference cross-reference where used
  • Active depot routing confirmation
  • Agreed John Lewis cost list for invoice validation
  • Where sales and inventory report data should land in your ERP
  • ERP or IMS credentials (Unleashed, Enterpryze or other)
  • Sample John Lewis purchase orders where available
  • Tolerance rules confirmation per supplier agreement
Typical delivery timeline
Day 1

Supplier data & credentials

John Lewis supplier code, GLNs, ERP credentials and cost list received

Day 2–3

Mappings built

EAN cross-reference, depot routing and pricing configuration completed in staging

Day 4–5

End-to-end test

Test purchase order processed, reports ingested and invoice generated, validated against John Lewis's specification

Live ✓

Go live

Production enabled, first live John Lewis purchase order processed end-to-end

ERP & IMS Connections

Connect John Lewis to your back-office system.

Supply Lens routes John Lewis purchase orders directly into Unleashed, Enterpryze or other connected ERPs with the right item codes, document series and depot routing.

Ready to automate
your John Lewis EDI?

Most suppliers are live within five days. No long contracts, nothing to set up on your side. We handle the John Lewis-specific configuration, you confirm the mappings.