Connect your web shop to SAP Business One – without maintaining data twice
Items, prices and stock come from SAP Business One; orders reach the ERP without retyping. We design the integration of your online shop with SAP Business One and implement it.
Which shop system and which integration approach suit your business is something we clarify in a consultation – before a single line of interface code is written.
SAP Business One web shop: what connecting an online shop to SAP Business One means
An SAP web shop – also called an SAP online shop or e-commerce integration – is usually not a shop built into SAP Business One, but a separate shop system connected to the ERP through an interface. SAP Business One remains the leading system: items, prices, stock and customers are maintained there. The online shop displays this data and takes orders.
The integration ensures that both systems share the same data. Item data goes from the ERP to the shop, orders and new customers go from the shop to the ERP, and the order number and delivery status go back again. Technically, such an integration uses either a ready-made connector or the Service Layer, the web interface of SAP Business One.
Which approach suits your shop system and your order volume is something we clarify in a consultation.
- Leading system
- SAP Business One
- Shop system
- based on requirements, no fixed product
- Interface
- Connector or SAP Business One Service Layer
- Typical data
- Items, prices, stock, customers, orders, delivery status
- Shop types
- B2B shop for business customers, B2C shop for consumers
- What init does
- Design, set-up in SAP Business One, implementation, support
- Operation
- Cloud or on-premise
- Partner status
- SAP Gold Partner since 2006
More on interfaces and integration: SAP Business One integration
Where an online shop without an SAP integration costs time and revenue
We often hear these patterns in conversations with companies that sell online. They do not prove that this is the case for you – but they are a good checkpoint.
Items are maintained twice
New items, price changes and descriptions are created in the ERP and entered again for the shop. Every difference between the two systems reaches the customer sooner or later.
The shop shows stock that no longer exists
If stock is reconciled only once a day or by hand, the shop sells goods that have already gone to another customer. Cancellations, queries and rework follow.
Orders are retyped
Every web order is created again in the ERP as a sales order. That costs time per order, delays shipping and produces typing errors in addresses and quantities.
Customers ask for the delivery status by email
Because the shop does not know what happens to the order in the ERP, the sales office clarifies the status by phone or email – instead of the customer seeing it in their account.
Three data flows between SAP Business One and the web shop
Data is maintained once, in the ERP. The integration distributes it to the shop and brings orders and customer data back. Which flows run immediately and which on a schedule is defined in the concept.
Product data
Item number, name, description, prices, stock and user-defined fields are maintained in SAP Business One and transferred to the shop. Values that change often, such as stock and price, are synchronised more frequently than descriptions.
Customer data
When a new customer registers in the shop, a business partner is created in SAP Business One. If the customer later changes their address, the change goes to the ERP. Conversely, customer data maintained in the ERP can be passed to the shop.
Order data
An order placed in the shop is created in SAP Business One as a sales order. The order number and delivery status go back to the shop, so your customer can see the status of their order in their account.
Three ways to connect an online shop to SAP
There is no single SAP shop interface. The right approach depends on the shop system, the order volume and how far the process differs from the standard.
| Approach | How it works | Suitable if | Watch out for |
|---|---|---|---|
| Ready-made connector | An add-on or plug-in connects a specific shop system with SAP Business One and includes the usual data flows. | Your shop system is widely used and your processes largely follow the standard. | The provider's licence fees, the scope of field mapping, maintenance for new versions of shop and ERP. |
| Integration platform | Middleware sits between the systems, translates the data and controls what is transferred when. | Besides the shop, further systems are to be connected, such as marketplaces, a PIM or shipping providers. | One more system to operate, dependence on the platform provider, ongoing costs. |
| Custom interface | The interface is developed for your shop and addresses SAP Business One via the Service Layer. | Your processes differ significantly from the standard, or there is no suitable connector for your shop system. | Higher initial effort, clear documentation and tests with every update. |
We do not commit to a shop system or an integration approach in advance. The recommendation follows from your requirements – and it includes the ongoing costs, not just the set-up.
E-commerce with SAP Business One: how B2B and B2C shops differ
A shop for business customers places different demands on the integration than a shop for consumers. We clarify these points in the concept.
B2B shop for business customers
- Customer-specific prices and discounts from SAP Business One instead of one price list for everyone
- Ordering through the existing customer account, on invoice and with the agreed payment terms
- Reordering based on previous orders
- Several buyers per customer company
B2C shop for consumers
- New customers from the shop are created in SAP Business One as business partners
- Payments from the shop are matched to the orders in accounting
- Shipping status and tracking number go back to the customer
- Returns are recorded in the ERP and become visible in the shop
From the consultation to a running web shop integration
Consultation
You describe your shop system, product range, customer groups and order volume. We tell you which integration approaches are possible and what needs to be in place in SAP Business One.
Data flow concept
We define which data flows in which direction, which system leads for which field and how often data is synchronised.
Prepare master data
Items, prices and customer data in SAP Business One are prepared so that the shop can use them. This step decides the quality in the shop.
Set up and test the integration
The interface is set up and checked with real test orders in a test system before it is connected to the live shop.
Go-live and support
After the start we monitor the transfers and support the integration, including updates to the shop or to SAP Business One.
What a web shop integration does not do
So that expectations are right before the project starts.
It does not replace master data maintenance
The integration transfers what is in SAP Business One. If descriptions are missing or prices are out of date, they appear the same way in the shop.
It does not design or market the shop
Design, copy, search engine optimisation and advertising for the shop are separate tasks. The integration takes care of the data behind it.
Payment, shipping and marketplaces are separate interfaces
Payment providers, shipping providers and marketplaces are connected through their own integrations. Whether and how belongs in the concept.
Not every data flow needs to run immediately
Orders should reach the ERP quickly; item descriptions do not need to be synchronised every minute. Synchronising too often puts load on both systems without any benefit.
Terms used on this page
- Service Layer
- Web interface of SAP Business One. It exposes business objects via HTTP and OData and exchanges data in JSON format.
- Connector
- Ready-made add-on or plug-in that connects a specific shop system with SAP Business One.
- Integration platform
- Software between two or more systems that translates data and controls the exchange. Also called middleware.
- Business partner
- Master record for customers, vendors and leads in SAP Business One.
- Sales order
- Document in SAP Business One that records an order. Delivery and invoice are created from it.
- Leading system
- The system in which a data field is maintained and whose value applies if there are differences.
What companies want to know about integrating a web shop with SAP Business One
Which shop systems can be connected to SAP Business One?
In principle, any shop system that can exchange data through an interface. Ready-made connectors exist for widely used shop systems; for all others, an interface can be developed using the Service Layer of SAP Business One. Which approach is economical is something we clarify in a consultation.
Can we keep our existing online shop?
In many cases, yes. The prerequisite is that your shop system offers an interface for items, customers and orders. Whether that is the case and how much effort is involved is something we check before every recommendation.
Are orders transferred to SAP Business One in real time?
That depends on the integration approach and is defined in the concept. Orders and new customers are usually transferred immediately or at short intervals, item descriptions at longer intervals. What matters is that each data flow runs as often as the business requires.
Where do prices and stock in the shop come from?
From SAP Business One as the leading system. Price lists, special prices for individual customers and stock levels maintained there are passed to the shop. Whether the shop can display customer-specific prices depends on the shop system.
What does it cost to integrate a web shop with SAP Business One?
The costs depend on the shop system, the integration approach, the number of data flows and the state of the master data. With a connector, the provider's licence fees are added. A first estimate for SAP Business One is provided by the project cost calculator; licence prices are on the prices and costs page.
Does the integration work with SAP Business One in the cloud and on-premise?
Both modes of operation are possible. Which interface is used also depends on whether SAP Business One runs on SAP HANA or Microsoft SQL Server and where the system is operated. We check this in the concept.
What needs to be clarified in SAP Business One before the start?
Above all, the master data: complete items with descriptions, maintained prices, correct tax and shipping settings and unambiguous customer data. The cleaner this data is, the shorter the project.
Who supports the integration after go-live?
The same team that implemented it. init consulting AG offers ticket support, a telephone hotline and remote access as well as ongoing maintenance and version upgrades. Go to support
Discuss your web shop integration with us
Tell us your shop system, your customer groups and a typical order volume. We show you which integration approaches are possible and what needs to be prepared in SAP Business One.
How to reach us
- Phone
- +49 8456 2 78 04-0
- Head office
- init consulting AG
Ruppertswies 14, 85092 Kösching, Germany - Contact
- All contact options