Holland & Barrett doesn't run EDI. Traditionally that meant re-keying every purchase order by hand. Supply Lens changes that. We receive your Holland & Barrett orders by email, read the Excel purchase order attached and turn it into a sales order in your ERP automatically, with nothing typed in twice.
Supply Lens watches a dedicated inbox for Holland & Barrett purchase orders, reads the Excel file attached to each one and creates the matching sales order in your ERP, so your team never opens a spreadsheet or types an order by hand.
Reading an Excel purchase order reliably takes more than opening the file. Supply Lens handles the detail.
Excel purchase orders drift over time: columns move, formats change, the odd blank row appears. Supply Lens handles the mess so a bad sheet never becomes a bad order.
The mapping lives at the Supply Lens layer, not hardcoded in a script. When the sheet changes, one update at the mapping keeps every order flowing without touching your ERP.
Multiple purchase orders or sheets in a single email are separated and read individually, so each one becomes its own sales order rather than one jumbled import.
Unrecognised codes are caught before the order is created. The order goes to an exception queue with a clear note, so nothing is guessed at or silently dropped.
Every Holland & Barrett email is picked up the moment it lands, so an order cannot sit unread in an inbox waiting for someone to notice it.
Supply Lens sets up the inbox and the mapping. You provide a sample purchase order and confirm how the sheet maps to your ERP items.
No EDI project and no re-keying. Most customers are live within a couple of days.