DemandBridge

ERP Integrations

ERP Integrations: What Connects to What?

An ERP does not need every piece of information from every system a business uses.

It needs the information required to do its part of the work.

"Connect Commerce to ERP" sounds like a requirement. It is really the beginning of several questions.

What does Commerce need from ERP before a customer places an order? What needs to come back after the order is submitted? Does anything change again after fulfillment?

Those questions define the integration much better than the names of the two systems.

Every connection needs a reason

Move the information another system needs to do its part of the work.

ERP sits at the centre, handling orders, inventory, purchasing and billing. Four systems connect to it, each for its own reason: commerce sends an order in, payments sends payment status in, shipping exchanges information in both directions, and item and quantity go out to a supplier.

ERP

Orders · Inventory · Purchasing · Billing

Commerce

Customers · Items · Orders

Payments

Payment status

Shipping

Shipment · Tracking

Supplier

Item · Quantity · Job details

Start with what the other system needs to do

Take Commerce.

The storefront may need customer and shipping information, products and relevant inventory data so the customer can place an order.

ERP needs the resulting transaction so the distributor can process the work.

There is no reason for the two applications to become copies of each other.

Each needs enough information to perform its job.

For a closer look at the customer-ordering side, see B2B Ecommerce for Print & Promo Distributors.

Financial systems depend on who owns what

Accounting creates a different boundary.

Some ERP environments include substantial financial functionality. Other businesses keep a separate accounting platform.

If both systems contain customer or financial information, decide which one owns what before deciding how the integration works.

  • Where is the invoice created?
  • Where is a payment recorded?
  • Which system is authoritative for the general ledger?

The answers determine what needs to cross between them.

That may be a relatively narrow set of transactions rather than an attempt to keep two financial databases synchronized.

Connecting ERP to Your Accounting System goes deeper into ownership, timing, identifiers and reconciliation.

Payments have their own context

Payment processing introduces another system with a specific job.

It needs to authorize and process the transaction.

The distributor may need the result connected to an invoice or order so customer service, receivables or another team knows what happened.

DBPay supports payments within Commerce as well as invoice-oriented Pay by Link.

Those begin in different places. One starts with an ecommerce order. The other starts with an invoice.

In both cases, the payment becomes more useful to the rest of the business when its relationship to the underlying transaction remains clear.

For more on that boundary, see Integrated Payments in Distributor Workflows.

Shipping needs information in both directions

Shipping happens late enough in the order that it can look like an endpoint.

It usually isn't.

The shipping process needs information about what is being sent, where it is going and how it should be shipped.

Once that work happens, the rest of the business may need information back.

  • Did it ship?
  • How was it sent?
  • Is there tracking information?

DemandBridge supports shipping information moving between its distributor, ecommerce and third-party shipping workflows so relevant shipping and tracking details can return to the order.

That return path is easy to miss when integrations are described only as "sending the order."

The people managing the customer transaction still need to know what happened afterward.

Supplier connections are part of the same picture

A supplier may be responsible for producing or fulfilling part of an order.

That creates another information boundary, even if the connection does not look like a traditional enterprise-system integration.

The supplier needs enough information to execute the work correctly: the item, quantity, shipping details and whatever job information applies.

The distributor needs to know whether that work has moved forward.

Current Commerce workflows include vendor transmission processing, while ERP connects supplier and purchasing activity to customer orders.

Again, the useful question is fairly ordinary:

What does the next party need to do the work, and what does the distributor need to know afterward?

More integration is not automatically better

Once teams start drawing system diagrams, it is easy to add arrows.

Customer data can go here. Product data can go there. Perhaps this field should synchronize too.

Every additional connection creates something that has to be defined, tested and maintained.

If another system does not need a piece of information to do its job, moving that information simply because it exists may add complexity without improving the process.

A smaller integration with clear ownership can be much easier to understand than a broad synchronization where nobody is quite sure which copy of the data is authoritative.

This is particularly important when the systems have overlapping records.

Two applications may both display a customer, product or order without needing to own the same details.

Map the transaction before drawing the architecture

Take one common customer transaction and write down which systems actually touch it.

Perhaps the customer places an order through Commerce.

Commerce needs information before that happens.

ERP receives the order.

Purchasing or a supplier may become involved.

Fulfillment and shipping complete the physical work.

Payment and financial information have their own paths.

Now ask why information crosses each boundary.

If you cannot explain what the receiving system is supposed to do with it, the integration requirement probably needs another look.

That exercise produces a much more useful architecture than starting with a diagram full of application names and connecting everything to everything else.

DemandBridge brings ERP, Commerce and DBPay into the same distributor environment, with DemandBridge Services supporting integration work around those systems and the other applications a business intends to keep.

Each system needs a clear job, and the information crossing between them needs a reason to be there.