Integration

Retailer EDI
to NetSuite

Last reviewed: September 2026

Retailer purchase orders arrive. NetSuite sales orders are created against the right subsidiary and customer. Acknowledgements, despatch advice and invoices fire back out to each retailer's own rules, without anyone touching a spreadsheet or rekeying a line.

50+
Retail EDI partners supported
PO to invoice
Full document cycle
99.9%
Uptime SLA
Supply Lens live flow monitor Live
Tesco PO TES-2026-88341 received 24× EAN 5000123 · 12× EAN 5000124 · delivery wk 38 PO IN
Codes translated and validated EANs → NetSuite items · depot DC47 → Tesco ship-to Bristol PROCESSING
NetSuite SO-9041 created UK Ltd subsidiary · customer Tesco Stores · PO ref carried CREATED
Order acknowledgement sent Acknowledgement → Tesco EDI network · all lines accepted ACK SENT
Despatch advice and invoice sent From item fulfilment · pallet PAL-3812 · £486.00 ASN + INV
Core capabilities

PO in. Sales order created.
Documents out.

Supply Lens translates retailer purchase orders into NetSuite sales orders and returns every required response document to the trading partner automatically. NetSuite stays the system of record and each retailer gets documents built to their own rules.

  • Retailer purchase orders ingested from managed networks, direct connections or file drops
  • Retailer codes translated to your NetSuite items, customer records and locations
  • NetSuite sales orders created with full line items, delivery details and the retailer's PO reference
  • Orders routed to the right subsidiary where retailers are served from more than one entity
  • Order acknowledgements generated and sent automatically
  • Despatch advice fired from the NetSuite item fulfilment record
  • Invoices built from NetSuite invoice data and submitted to the retailer
  • Depot and store codes held as ship-to addresses on the retailer customer record
Document flow
Purchase Order Order
Retailer / EDI Network
Sales Order created NETSUITE
NetSuite ERP
Order Acknowledgement acknowledgement
Retailer / EDI Network
Despatch Advice / ASN Despatch advice
Retailer / EDI Network
Invoice Invoice
Retailer / EDI Network
Credit Note OPTIONAL
Retailer / EDI Network
Trading partners

50+ retail EDI partners already configured.

Supply Lens has existing configurations for the major UK and Irish retail EDI networks. New trading partners are added as required, with each retailer's document rules, codes and compliance requirements handled individually. The retailer side does not change because the ERP behind it is NetSuite.

Tesco UK & ROI
Sainsbury's UK
Waitrose UK
Morrisons UK
ASDA UK
Co-op UK
Ocado UK
M&S UK & ROI
Lidl UK & ROI
Aldi UK & ROI
Iceland UK
Booker UK
Booths UK
A F Blakemore UK
Bestway UK
Nisa UK
Musgrave ROI
BWG Foods ROI
Dunnes Stores ROI
+35 more retailers →
Optional flows

Extend beyond the core loop.

Once the core PO to order flow is live, Supply Lens can activate additional handling depending on your retailer requirements and how NetSuite is set up.

Multi-subsidiary routing

Route POs across NetSuite subsidiaries, brands or legal entities based on retailer, product range or depot code, with the invoice raised from the entity that supplied.

Part fulfilment

Short shipments handled from the NetSuite fulfilment record, including split despatch advices, part line acceptance and amended quantity acknowledgements.

Invoice validation

Invoices checked against each retailer's agreed tolerance rules before transmission, so price and quantity variances are caught at your end rather than as deductions at theirs.

Credit memos

NetSuite credit memos transmitted back to the retailer in their required format when returns, claims or price corrections arise.

Exception queues

POs with unrecognised codes, missing mappings or data errors go to a review queue with the full PO context. Never silently dropped, always visible.

New trading partner onboarding

Won a new listing? Supply Lens configures the document spec, code mappings and compliance requirements for each new retailer individually, without touching the ones already live.

Configuration

Retailer rules are gloriously chaotic.
We handle that.

Every retailer has its own codes, document formats, timing rules and compliance requirements. Supply Lens is configured per trading partner rather than forced into one template, and the NetSuite side is mapped once.

1

Trading partner identifiers

GLN, supplier codes, buyer identifiers and network routing captured per retailer. Each partner is isolated so a change to one does not affect another.

2

Product cross-reference

Retailer EAN, buyer article number or internal code mapped to your NetSuite item, at line level and per retailer. Unmapped codes go to the exception queue.

3

Customer, depot and subsidiary mapping

Each retailer becomes a NetSuite customer with depots and stores as ship-to addresses. Where a retailer is served from more than one entity, the subsidiary is decided per depot or product range.

4

Document rules and timing

Which documents fire, when, in what format and with which mandatory fields: configured per trading partner, with the retailer's PO reference carried on every one.

Code cross-reference
Retailer codeNetSuite record
5000123456789PROD-MALT-250G
5000987654321PROD-MALT-500G
DC47Tesco Stores · Bristol DC
SUPP-00441UK Ltd subsidiary
PO ingestion
Network and direct file
ON
Order acknowledgement
Auto on sales order creation
ON
Despatch advice
On item fulfilment
ON
Invoice
On NetSuite invoice
ON
Credit memos
Not enabled
OFF
Subsidiary routing
By depot code
CONFIG
Edge cases handled

Retail EDI breaks in very specific ways.

Every retailer has their own quirks, and NetSuite adds a few of its own. These are the four we hear about most, in the words customers use.

"The retailer sent a product code we don't recognise: it's not in our cross-reference table."

Unrecognised codes go to an exception queue with the full PO context. Your team resolves and re-triggers. Nothing is dropped silently and the retailer gets a timely acknowledgement either way.

"The retailer changed their depot codes and the orders went to the wrong ship-to."

Depot and store code changes trigger exception flags before a sales order is written. Supply Lens catches the mismatch rather than posting against a stale NetSuite address.

"We shipped 22 units but the PO said 24. The despatch advice has to say 22."

Documents are built from the NetSuite item fulfilment, not from the original order. The retailer receives an accurate despatch advice and an invoice for what actually shipped.

"Two retailers are served from different subsidiaries and the invoice came from the wrong one."

Subsidiary is decided at PO ingestion, per retailer, depot or range, so the sales order, fulfilment and invoice all sit in the entity that supplied the goods.

What you'll need

Structured onboarding. No surprises.

EDI onboarding is more involved than a standard API integration. Document specs, code lists and compliance rules all need to be in place before go-live, and the NetSuite customer and item structure needs agreeing. Supply Lens manages the process.

  • Retailer document specifications or message samples
  • Trading partner identifiers: GLN, routing details, supplier codes
  • Product cross-reference: retailer codes → NetSuite items
  • Depot cross-reference: retailer codes → NetSuite ship-to addresses
  • NetSuite account ID, integration access and subsidiary structure
  • Sample POs, real examples from each retailer where possible
  • Test scenarios: standard PO, part shipment, unknown code, invoice
  • Exception handling preferences: who gets notified and how
Typical delivery timeline
1
Scope
Document specs, code lists, subsidiary structure and retailer rules collected.
2
Configure
Trading partner and NetSuite mappings built in a sandbox.
3
Test
Retailer test cycle run end to end, including part shipments and invoices.
Go live
Retailer by retailer, with monitoring on from the first PO.

Ready to automate your retail EDI?

Tell us which retailers you trade with and how your NetSuite entities are set up. Twenty minutes is usually enough to size the work.