🔗Connecting an inventory management system to a shop system of your choice📦

Today I'll guide you through the points that matter in practice. No boring theory. Just clear decisions that will make your shop more stable. And yes, I'll also throw in a bit of harsh reality, because we've all been there: at 23:47 pm, we've all made a quick manual stock adjustment. And then it was somehow even worse.

What means "Shop system, inventory management" in practice

Many people mean the same thing when they say "shop system inventory management," but they use different terminology. It usually refers to the seamless integration of an online shop and inventory management system. The shop is your sales floor. The inventory management system is your warehouse brain. And when you add ERP and CRM , you get a setup that clearly organizes stock levels, orders, customers, purchasing, shipping, and accounting.

One point is crucial: the systems don't have to do everything. They just need to work together seamlessly. An online shop excels in product marketing, checkout, payment, content, and SEO. An inventory management system excels in stock control, purchasing, storage locations, order picking, suppliers, replenishment, and often also in multi-channel operations. An ERP system then adds financial processes and reporting. A CRM system keeps customer data, sales opportunities, service cases, and communication together.

If you're looking for a neutral assessment of what a merchandise management system should be able to do in retail, then this overview from the Chamber of Industry and Commerce (IHK) is a good starting point: IHK article on merchandise management systems in retail

Why the connection between shop and inventory management saves so much stress

Most problems in e-commerce don't arise because a shop is "broken." They arise because data is entered twice. Or because no one knows which system is telling the truth. Then the shop sells something that isn't in stock. Or the inventory management system shows the item as available, but the shop indicates it's sold out. And your support team gets the brunt of the frustration, even though they're only reading the emails.

If you properly integrate your shop and inventory management system, you will gain measurable benefits:

• They reduce overselling because inventory levels are adjusted more quickly.
• You save time because articles, prices and texts are not entered twice.
• They speed up shipping because pick lists and labels are based on clear data.
• They see better numbers because order status and returns are reflected cleanly.
• They make your shop more stable because processes become predictable.

Which architecture suits you best: direct connection, middleware, or iPaaS?

There are three typical ways to technically implement inventory management in a shop system. None of them is inherently "the best". The best way is the one that suits your team, your budget, and your growth.

1) Direct connection between shop and merchandise management system

Direct means: The shop communicates directly with the inventory management system via API or plugin. This is often quick to set up. It's beneficial if you only have a few systems and clear processes. However, things can become complex as soon as you add marketplaces, a second warehouse, POS systems, or multiple shops.

2) Middleware as a hub

Middleware sits between the systems. It translates data formats, controls flows, and logs errors. This might sound like "yet another system," but it brings stability. You can build rules, for example: "If shipping country is Switzerland, then different tax logic applies" or "If item set, then split positions for order picking."

3) iPaaS Integration Platform

iPaaS is a platform that offers integration as a service. This can be worthwhile if you have many tools, such as newsletters , CRM, helpdesk, marketplaces, PIM, and analytics. In that case, you don't want to maintain ten separate solutions, but rather manage flows centrally. It's important to pay attention to data sovereignty, logs, and proper error handling.

The most important data objects to ensure your setup remains stable.

When you connect your online store and inventory management system, everyone talks about interfaces. I'll talk about data first. Because if the data logic is unclear, even the best interface will only create a faster error.

Articles and variants

Define where product master data originates. Does the product come from the inventory management system, an ERP system, or a PIM system? And what happens in the online store? In many projects, the inventory management system is the source for SKUs, EANs, purchase prices, inventory logic, and delivery times. The online store receives marketing copy, media, categories, filters, and landing pages.

Stock levels and reservations

This is a classic scenario. Inventory levels need to be synchronized at defined intervals or in real time. Additionally, you need a reservation logic. Otherwise, you might have stock, but two people could buy the last item at the same time. Then you need rules for when stock in the shop is reduced: upon receipt of payment, upon receipt of an order, or when picking begins. This depends on your business.

Pricing, customer groups and B2B logic

In B2C, you can control many things directly in your online store. In B2B, you often want to import price lists from your ERP or inventory management system. This includes tiered pricing, customer-specific pricing, net prices, minimum order quantities, and delivery terms. Plan this early, otherwise it will be expensive later, and you'll end up with workarounds that nobody likes.

Orders, status and documents

An order is more than just "paid." You need clear statuses: new, checked, in picking, partially shipped, shipped, canceled, returned. This includes documents such as invoices , delivery notes, and credit notes. Define which system generates which documents and how they reach the customer.

Shop system inventory management integration – General – Integration of an inventory management system into a shop system

The process from click to package – that's what a clean supply chain looks like.

If I were to explain shop system inventory management as a process, I'd like to use this chain. It's simple, but it covers 90 percent of practical application:

• The shop accepts the order, checks the payment, and saves the order.
• The shop sends an order to the merchandise management system, including items, shipping method, and payment status.
• Inventory management checks stock levels, reserves goods, and creates a pick list.
• The warehouse picks, packs, and generates shipping labels.
• The tracking number is sent back to the shop, and the customer receives a shipping email.
• An invoice is generated depending on the setup in the ERP system, the inventory management system, or the online shop.
• Status updates run automatically so that support doesn't have to guess.

If you have returns, add a second supply chain. Otherwise, processing returns will remain a black hole. And yes, returns are a topic that can kill the mood. But with a clean process, at least it becomes predictable.

What you should pay attention to when choosing: the shop system and inventory management must be compatible.

You can't seamlessly integrate every shop system with every inventory management system. On paper, everything seems possible. In reality, what matters is how well APIs, data models, and access control concepts fit together.

Checklist for your shop system

• Does the shop have a stable API that accurately reflects orders, customers, products, and inventory?
• Are there webhooks or events so you don't just have to poll?
• Can the shop map multiple warehouses or stock sources as you grow?
• Can the shop implement B2B logic if needed, for example roles, approvals, net prices?
• Is the plugin ecosystem active so that you don't need a special solution for each tool?

Checklist for inventory management

• Can it display variants, bundles, sets and bills of materials the way you sell?
• Can it provide storage locations, batch numbers, or serial numbers if you need them?
• Are there clear import and export methods, APIs, or file interfaces with logs?
• Can it be multi-channel if you are planning marketplaces, POS or multiple shops?
• Is there a clear rights concept in place so that not everyone can click everything?

To make the two checklists more tangible, here's a real-world example. If you're running JTL-Wawi and your shop on Magento 2 , then these points are crucial for project success: variant mapping, inventory management across multiple warehouses, and the return of orders to the ERP system. We've outlined this step by step here: connecting JTL-Wawi to Magento 2, and importing orders.

The middle ground in the project: accounting and data service without any headaches

At the latest when you want to get a handle on invoices, payments, and tax logic, your shop system's inventory management system meets accounting. That's the moment many teams get nervous because suddenly terms appear that sound like bureaucratic jargon. But don't worry. You don't need to study accounting. You just need to define clear handover points.

ERP-CRM Integration Connecting JTL-Wawi to Magento 2: Importing orders and purchase orders

For example: You want your tax advisor to receive accurate data. Then you plan which documents will be transferred and how: invoices, credit notes, payment status, fees. If DATEV plays a role in your operations, this overview of ERP and inventory management interfaces will help you: DATEV page on ERP and inventory management systems and interfaces

And if you're looking for a clear, concise definition of what an inventory management system should do, this article is a good reference: Haufe's explanation of inventory management, its functions and benefits.

10 practical tips you can implement immediately

Now things are getting concrete. These are things that constantly come up in projects. And yes, I've already learned them all the hard way.

1) Define a leading system for each data type.

Establish where the truth lies: article numbers, stock levels, prices, customer data, order status. Write it down. Otherwise, you'll be discussing it every time.

2) Start with a minimal dataset

You don't need 120 fields to get started. You need SKU, name, price, tax rate, stock level, weight, shipping class, images, and variant. Expand later.

3) Plan for errors before they happen.

What happens if the inventory management system rejects the order? What happens if the stock level goes negative? What happens if an item can't be found? These aren't isolated incidents. This is Monday morning.

4) Use clear IDs, not just names.

Names change. IDs should remain stable. Work with SKUs, internal IDs, and EANs. And use mapping tables in the middleware if systems think differently.

5) Log everything, absolutely everything.

Without logs, you're like looking for a sock in a washing machine. With logs, you see: request, response, payload, timestamp, retry, error message.

6) Use webhooks or events if possible.

Polling is okay, but it creates load and latency. Events are often faster and cleaner if your shop offers them.

7) Clarify the inventory logic for each channel

Shop, marketplace , POS, B2B portal. Do you need separate allocations? Or a single inventory with reservations? Decide early.

8) Build a staging system

Test updates and interface changes first in a staging environment. Otherwise, test in the live shop. And have your customer test along with you.

9) Automate status communication

The customer wants to know: Is it coming? When will it arrive? Send status emails from the system that actually knows the status. This is usually the inventory management system or the ERP system.

10) Plan training sessions without a PowerPoint marathon

Conduct short sessions. 30 to 45 minutes. Per process: order, pick, shipping, return, cancellation. And document click paths directly on the system.

Typical pitfalls to avoid paying twice

Duplicates at customers

If both your shop and CRM create customer accounts, you'll quickly end up with duplicates. Define rules, for example: the CRM takes precedence, the shop gets the CRM ID, and matching is done via email plus customer number.

Variant chaos

One system thinks in terms of variants, the other in terms of "one item with attributes." This can work, but you need a clean mapping. Otherwise, size L ends up as a separate item in the warehouse and as a variant in the shop. And then good luck with inventory management.

Pricing logic in the wrong place

Managing discounts in three different places is a recipe for conflict. Define whether promotional prices are created in the online store or in the ERP system. And how you handle vouchers.

Too many special rules too soon

I love clever rules, but putting them on too early can ruin everything. Start with a clear, standard process. Then add special cases step by step.

Project plan: how to achieve a stable setup in 30, 60, or 90 days

Days 1 to 30, gaining clarity

• Map out the processes, from order to shipment, including returns.
• Define leading systems, assign data types.
• Check interfaces, APIs, webhooks, data models.
• Define the minimum data set and specify mandatory fields.
• Collect test data and test cases, including error cases.

Days 31 to 60, building integration

• Set up product and inventory synchronization, first in staging.
• Set up order sync, including status and shipping methods.
• Activate logs and monitoring, define alerts.
• Check the rights concept in the WWS and in the shop.
• Team training, short process sessions.

Days 61 to 90, Stabilizing and expanding

• Check performance, fine-tune sync intervals.
• Integrate the returns process, credit notes, and status updates.
• Add B2B special logic if needed.
• Set up reports and KPIs so you can see what's happening.
• Create a go-live plan, including a rollback option and clearly defined responsibilities.

KPIs and tests so you can not only feel progress, but also see it.

If you take your shop system's inventory management seriously, you're not just measuring sales. You're measuring process quality. That sounds unromantic, but it's the reason you'll sleep more soundly later.

Meaningful key performance indicators

• Overselling rate: how often does the shop sell despite lack of stock?
• Order processing time until shipment, median and outliers.
• Error rate in interfaces, per flow and per day.
• Return time, from receipt to refund.
• Duplicate rate for customers, before and after CRM integration.

Tests you should schedule

• Load test: 200 orders in a short time, what happens in the shop and WWS.
• Edge Cases: Set items, partial delivery, cancellation after pick start, address change.
• Error cases: API timeout, missing item, incorrect tax rate.
• Rights matrix: Who is allowed to cancel, who is allowed to change prices, who is allowed to export.

Technical depth, data model, mapping and API flows

Once the processes are in place, it's worth taking a look at the technical implementation. This is where synchronization, data model, mapping, security, and specific API flows come together to ensure your shop system/inventory management integration remains clean and scalable.

Synchronization types

• real timeWebhooks or events trigger updates immediately. Use this for inventory and payment status.
• Near real-timeThey synchronize every few minutes. Good for pricing and content.
• BatchThey load large amounts of data on a timed basis. Suitable for catalog imports or legacy systems.

Choose the appropriate strategy for each data type. Inventory and order status need quick updates. Catalog texts can wait.

Data model and standards

Adhere to standards. Use unique identifiers. Use GTIN for global product identification, as described by GS1. This reduces duplicates and facilitates trading on marketplaces.

• The SKU remains stable internally. Use clear rules for variants.
• GTINs and manufacturer numbers are supplementary. Define priorities.
• Standardized units of measurement. Define basic units, such as grams and millimeters.
• The control logic is centralized in the ERP system. The shop consumes the values ​​either pre-calculated or according to a set of rules.

Mapping and transformation rules

Create a mapping table. Map fields in the ERP system to fields in the shop. Define how texts, attributes, categories, and media are transferred.

• Title. ERP field Article description on Shop field Name.
• Description. Long text trimmed, HTML cleaned up.
• Attributes: Color, size, material. Use fixed value ranges.
• Categories. Create assignments if structures differ.
• Images. Specify paths or media IDs. Check formats and minimum sizes.
• Prices. Base price, tiered pricing, B2B terms.

Security and access issues

• Use API keys with minimal privileges.
• Separate production and Test environment.
• Log all write operations. Record correlation IDs.
• Set rate limits and backoff strategies.

Implementation example using API flows

Products from ERP to the shop

• The ERP system sends product data in batches. The shop creates items and variants.
• The shop confirms the installation with IDs. The ERP system saves the assignment.
• Subsequent changes are delta-based. Only changed fields are transferred.

Orders from the shop to the ERP system

• The shop will send the order after payment has been received.
• The ERP system reserves stock. It creates delivery notes and invoices.
• The ERP system sends back tracking information. The shop informs its customers.

Which platform offers you which integration options?

For WooCommerce, you get open REST endpoints for products, orders, customers, and more. See Documentation for the REST APIFor Adobe Commerce, i.e., Magento, REST and GraphQL are available, including permissions and tokens; see [link/reference]. Create an integration and the overview of Commerce Web APIs.

Why market context helps when you want to set priorities

E-Commerce News - Tips & Tricks Simply explained: What is a multi-source inventory?

Sometimes someone asks me, "Do I really have to do all of this?" My answer is: You don't have to do everything immediately. But you do need a plan. The market is constantly evolving; customers expect quick delivery information, clear availability, and effective communication. If you want to back up your priorities with data, an industry association offers a collection of market data and studies that can help you with your team's arguments: bevh Market Data and Studies on E-Commerce in Germany

Storetown Media implements shopsystem merchandise management in projects.

At Storetown Media , we connect shop systems with inventory management, CRM, and ERP in a way that your team can work with seamlessly. It's not just about the technology working; it's about the process working smoothly. This includes clean data models, clear responsibilities, and integration that doesn't get flustered with every update.

Typical building blocks that we cover in projects

• Selection and setup of a shop system, for example Shopware, WooCommerce or Magento, depending on the goal.
• Integration of inventory management and ERP systems, including stock levels, prices, orders and documents.
• CRM integration for leads, existing customers, support, and campaigns.
• Technical monitoring, logs, alerts, and clean test tracks.
• Process design for warehousing, shipping, returns and accounting handovers.

What you can prepare for it

• A list of your sales channels, shops, marketplaces, and points of sale.
• Their most important product types, variants, sets, and digital products.
• Their shipping logic, warehouse locations, and delivery countries.
• Their goals for 12 months, product range, order volume, internationalization.
• Your tools that should remain: Payment, Newsletter, Helpdesk, Analytics.

Now it's your turn, and I really mean that.

If you've read this far, then you're either really keen on getting your system organized, or you're currently dealing with a process that's driving you crazy every day. Tell me in the comments what's causing you the most trouble. Is it inventory? Is it shipping status? Is it the handover to accounting? Or is it that little monster called variants?

And if you already have an integration with an online store's inventory management system: Share an example. What helped you? What would you do differently today? I like to collect real-world examples because you learn more from them than from any slide.

Mini checklist to take with you

If you only take three things with you today, make them these:

• Define leading systems for each data type, otherwise you're creating a double truth.
• Start small, log everything, test for errors before customers discover them.
• Think process first, interface later.

If you like, we can look at it together.

If you like, briefly describe your setup. Which shop system? Which inventory management or ERP system? How many orders per day? And where are the current problems? Then I can suggest specific next steps that are tailored to your situation.

If you don't want to implement the connection yourself

This article describes how to technically connect an inventory management system to an online store – from selecting the interface and data mapping to typical sources of error during operation. If you'd like to outsource the implementation: Storetown Media has been connecting inventory management, ERP, and CRM systems to Magento, WooCommerce, Shopware, and Shopify since 2012. Details on what's involved, which systems we connect, and the costs can be found on our ERP, CRM, and Inventory Management Integration page . If you operate a Magento store, go directly to Connecting Inventory Management to Magento – there you'll find detailed information on the systems, interface options, and costs for Magento 2.