IT encyclopedia · How to…?

How to connect an online store to inventory and accounting?

Short answer

The online store is connected to the inventory and accounting system via an API or regular data exchange: products and stock levels flow from the warehouse to the store, while orders and payments flow from the store to the warehouse and accounting. That way stock levels are always up to date and invoices don’t have to be entered by hand.

What data needs to flow

From the warehouse to the online store:

  • products, prices, stock levels;
  • delivery times.

From the online store to the warehouse and accounting:

  • orders and customers;
  • payments;
  • returns.

The most common problems without integration

  • A product gets sold that isn’t in the warehouse.
  • Orders are retyped by hand.
  • Stock levels differ between the shop, the online store and the warehouse.
  • Invoices reach accounting with a delay.

How to build it

  1. Check what integration options the online store platform and the inventory or accounting system offer.
  2. Decide which system is the master for each type of data.
  3. Build the integration with an error log and notifications.
  4. Test with real orders, including returns and cancelled orders.

Example

The SelfNamed platform integrates printing, delivery, payment, e-mail, business analytics and marketing services, so an order is processed all the way from payment to delivery. More: how to automate order processing.

Our service Software integrations We connect accounting, banks, state registers and other systems.

How we did it

SelfNamed cosmetics products with a personalised brand

SelfNamed.com · Madara Cosmetics · E-commerce

Print-on-demand cosmetics platform

A platform where anyone can create their own cosmetics line under their own brand.

Grand Prix "E-commerce Star 2023" (E-komercijas zvaigzne)

More questions?

Ask us — we'll answer and tell you what it would look like in your business.