Henri Lloyd
How Henri Lloyd Syncs 900+ SKUs in Seconds Between SAP Business One and Shopify with appse ai
North Western Europe
Disclaimer
Henri Lloyd, a company from the APPSeCONNECT customer base. appse ai is APPSeCONNECT's own product, built with significantly more advanced automation and AI capabilities. This case study has been adapted to reflect how Henri Lloyd's use case would run on appse ai today.
SAP Business One ↔ Shopify ↔ Shopify POS, automated with appse ai
- Company
- Henri Lloyd
- Founded
- 1963
- Headquarters
- Manchester, UK
- Industry
- Fashion & Lifestyle — Sailing, Yachting & Golfing Apparel
- Employees
- 201–500
- Website
- www.henrilloyd.com
- Catalog Scale
- 900+ product SKUs with multiple variants
About Henri Lloyd
Founded in 1963 and based in Manchester, UK, Henri Lloyd is a fashion and lifestyle brand known for sailing, yachting, and golfing apparel, with 201–500 employees. The business sells online and in physical stores, running SAP Business One as its ERP, Shopify as its eCommerce platform, and Shopify POS for physical retail.
The Operational Challenge
Henri Lloyd's 900+ SKUs, each with multiple variants, lacked parent-item structures in SAP: master data held an individual entry for every variant, while Shopify requires parent items with variants. Real-time stock and price synchronization between the back end and eCommerce had gaps, and orders needed intelligent routing to specific Business Partners based on the shipping address country.
The problem
Running SAP Business One and Shopify as disconnected systems surfaced specific problems for Henri Lloyd:
- 01
Parent/Variant Structure Mismatch
900+ SKUs with multiple variants existed as individual SAP master data entries, but Shopify requires parent items with variants.
- 02
Real-Time Stock & Price Gaps
Stock and price data between the back end and eCommerce was not synchronized in real time.
- 03
Complex Order Routing
Orders needed to be routed to specific Business Partners based on shipping address country.
This is the exact pattern appse ai exists to remove: a heritage apparel brand whose SAP product structure didn't match Shopify's parent/variant model, with real-time stock and country-based order routing as additional complications.
Why appse ai
Henri Lloyd needed a platform flexible enough to bridge SAP's flat variant-level master data with Shopify's parent/variant structure, keep stock and prices in sync in real time, and apply custom routing logic by country.
appse ai delivered a flexible, configurable architecture with end-to-end mapping across connection points, real-time fully automated sync, and the scalability to handle complex scenarios.
The solution: automated catalog mapping, order routing & invoicing
Instead of manual data exchange, appse ai deployed automated workflows across Henri Lloyd's SAP-to-Shopify cycle:
- SAP Item Code ↔ Shopify Parent/Variant Mapping
A mapping table links SAP item codes to web parent and variant IDs, enabling real-time sync despite the structural mismatch.
- Real-Time Stock & Price Sync
900+ SKUs update in Shopify with the latest pricing and inventory within seconds.
- Automated A/R Invoice Creation
A/R invoices are created automatically upon payment, with transaction IDs captured.
- Country-Based Business Partner Assignment
Orders are routed to the right Business Partner based on shipping address country.
- POS Order Integration
Orders from physical stores flow into SAP automatically.
Each workflow runs as a closed loop: detect the event in one system, resolve it against the other, execute the update, and only surface an exception to a human when judgment is genuinely required.
The results
- 900+ SKUs updated in Shopify with latest pricing and inventory within seconds
- Zero manual data exchange required
- Completely automated order-to-SAP workflow
- Automatic A/R invoice creation on payment with transaction IDs captured
- Country-based order routing to the correct Business Partner
- Physical store (POS) orders integrated
I have been very pleased with the end result…orders, invoices, incoming payments, and inventory are all synced in real time.
Frequently asked questions
How does appse ai integrate SAP Business One with Shopify?
appse ai uses a mapping table that links SAP item codes to Shopify parent and variant IDs, with real-time stock and price sync, automatic A/R invoice creation on payment, and POS order integration.
