← Back to blog
E-commerce 8 min read

SAP Business One ecommerce integration, now built into Base.

By Simon Lam

ERP integration · SAP Business One

SAP Business One ecommerce integration, now built into Base.

Most SAP Business One ecommerce integrations connect your ERP to one webstore. Base connects it to every channel you already sell on, marketplaces and your own shop alike, and writes those orders into your SAP company database as sales orders and invoices.

Base Team·8 min read·ERP integrations

Available now in every Base account
SAP Business One, connected to every channel you sell on.

You do not pay for middleware, and there is no bridge application to keep running on a PC in the office.

Orders and invoices into SAP
Stock and prices out to channels
No middleware · no bridge app

The problem

One webstore is not your sales channel

Search for a SAP Business One ecommerce integration and the first page of Google fills up with B2B storefronts. They are good products, and they all answer the same question: how do I put a web shop in front of my ERP?

That is not the question a marketplace seller has. If your revenue arrives from Amazon, eBay, a regional marketplace and your own shop at the same time, a storefront connector solves one of those and leaves the rest where they were. Usually that means a spreadsheet, somebody’s inbox, or a person typing orders into SAP on Monday morning.

Storefront connector
SAP + one shop you own

•Answers how to put a web shop in front of the ERP.

•Marketplace orders stay where they were.

•The gap gets filled by spreadsheets and retyping.

SAP Business One in Base
SAP + every channel you sell on

✓Marketplaces and your own shop, treated the same way.

✓One connection, one company database.

✓Every order lands in the same place.

Watch the explainer
SAP Business One integration in Base
How the SAP Business One integration connects your company database to every channel in Base.

What changes

What changes when you connect

Four jobs that usually belong to a person move into the integration. A fifth changes where you answer one of the most useful questions in the business.

Orders stop being retyped
Every order from every connected channel becomes a sales order in your SAP company database. Base matches the customer to the right business partner by CardCode, Federal Tax ID or email, and creates one when there is no match.
Invoices post themselves
Invoices are issued in SAP as orders come in. Cancel or refund an order in Base and the cancellation is mirrored. If you want it, Base can also create the incoming payment once the invoice is settled.
One stock number reaches every listing
Stock on hand comes from the SAP warehouse you choose and goes out to your channels from Base. Overselling usually starts with two systems holding two different numbers. This removes that.
Your SAP price list becomes your channel price
Prices sync from the SAP price list you select into the matching Base price group. Change the list in SAP and the channels follow.

The one that tends to land hardest
“Which channel earned this?” becomes a question you answer inside SAP.

The channel an order came from can be carried onto the documents in SAP, so channel performance is something you read in your ERP rather than rebuild in a spreadsheet.

How it works

How the SAP Business One ecommerce integration works

Base signs in to your SAP Service Layer with your company database, user and password, and keeps the session open. Documents are created and read through the standard Service Layer interface.

Sales channels
Marketplaces + your shop
Amazon, eBay, regional marketplaces and your own store.
Orders & shipping
base.
Matches the customer, writes the documents, handles picking and labels.
Service Layer · port 50000
SAP Business One
One company database per integration instance.

Into SAP
Business partners, sales orders, invoices, cancellations, and incoming payments if you switch them on.
Out of SAP
Products, stock on hand from your chosen warehouse, and prices from your chosen price list.
Optional: SAP API Gateway, usually on port 60020, for generating PDF invoices in SAP.
Orders travel from every channel through Base into SAP. Products, stock and prices travel the other way.

Two things follow from connecting this way, and both matter more than they sound:

✓Nothing has to stay running in your office. There is no desktop application on a machine somewhere that orders depend on to reach SAP.

✓One integration, not a stack of connectors. You are not buying an orders connector, then a stock connector, then a price connector, each billed separately and each able to break on its own.

The main technical prerequisite is that the Service Layer is reachable from outside your network. It usually listens on port 50000. The API Gateway connection is only needed if you want PDF invoices generated in SAP.

Order flow

What happens to an order

From the moment a customer checks out on any channel, this is the path the order takes.

01
The order arrives
An order lands in Base from any connected sales channel.
02
The customer is matched
Base matches the customer to a business partner in SAP, or creates one.
03
The sales order is created
It is written to your company database using the warehouse, price list, payment terms, salesperson and numbering series you configured.
04
The invoice is posted
The invoice goes to SAP, automatically or on export.
05
The order ships
Picking, courier labels and tracking happen in Base, and the shipment is confirmed back to the sales channel from there.

Accounting control

The documents land the way your accounting expects

An integration that creates documents your finance team then has to correct is worse than no integration. So the shape of what Base writes into SAP is yours to set before anything starts flowing.

What you decide

✓The details on every document. The numbering series, the payment terms and salesperson they carry, and the remarks and layout on the invoice.

✓Which documents are created. A sales order and an invoice together, or the invoice exported on its own.

✓What follows payment. Whether an incoming payment is created once the invoice is settled.

✓What follows a cancellation. Whether cancelling in Base cancels the invoice in SAP.

Markets with their own document requirements need extra fields on top of this, and those are configured per market. The help centre covers what each one needs.

The limits, up front

What the integration does not do

We publish this list because a gap you find now costs a conversation, and a gap you find after building a process around it costs considerably more.

Documents

×Sales orders are created once. Editing the order in Base afterwards does not update SAP.

×Sales invoices and cancellations only. No receipts, proforma invoices or credit notes.

×A refund does not create a credit memo in SAP.

×The API Gateway generates PDF invoices in SAP. Printing, emailing and attaching them is not part of this integration.

Data direction & scope

×Products and stock move from SAP into Base, never the other way.

×Tracking numbers are not sent to SAP. Tracking is created in Base and goes from there to your sales channel.

×Orders are not downloaded from SAP into Base.

×One integration instance connects one SAP company database.

Requirements

What you need to switch it on

Five things on the SAP side. Everything else is configured in the Base panel.

SAP Business One prerequisites
SAP Business One version
10.0 FP 2011 or later on Microsoft SQL Server, or 9.2 or later on SAP HANA (9.3 or later recommended)
Service Layer
Reachable from outside your network, usually on port 50000
API Gateway Optional
Only for PDF invoice generation, usually on port 60020
Credentials
A SAP user and password, and the name of the company database to connect
Product codes
SAP item codes that match the SKUs or EANs in Base

Get started

Connect SAP Business One to Base

The integration is available in every Base account. Setup happens in four steps, all inside the Base panel.

01
Add it under Integrations
02
Enter your connection details
03
Map warehouses and price lists
04
Import your products

SAP stays the record for products, stock and prices. Every channel you sell on feeds the same company database.

Add a channel in Base and its orders arrive in SAP the same way as the rest, with no extra connector to buy.

Try the SAP Business One integration free for 14 days

Connect your company database, map your warehouses and price lists, and watch your channel orders arrive in SAP.

Questions

Frequently asked questions

Does SAP Business One have a built-in ecommerce integration?

No. SAP Business One provides the Service Layer, which is a REST interface, but no connector to sales channels. Connecting it to marketplaces and stores means building an integration, buying middleware, or using a platform that connects to both.

What is the difference between this and a B2B webstore with SAP Business One integration?

A B2B webstore connects SAP Business One to one shop that you own. The Base integration connects SAP Business One to every marketplace and store you already sell on, and handles the order flow, shipping and automation across all of them.

Can SAP Business One stay the source of product and stock data?

Yes, and that is the intended setup. Products, stock on hand and prices are read from SAP into Base. Base does not write them back.

Does it work with several sales channels at once?

Yes. Orders from every channel connected to Base become sales orders in the same SAP company database.

Which SAP Business One version do I need?

SAP Business One 10.0 FP 2011 or later on Microsoft SQL Server, or 9.2 or later on SAP HANA. On SAP HANA, 9.3 or later is recommended.