Skip to content
Bitta Apps

Business Central advisory

Business Central and Shopify integration

Plan the flow from online orders to fulfillment and financial reconciliation. Start with the Microsoft connector, agree on data ownership, and test the exceptions that your operations team needs to manage.

Confirm the connector fits your environment

Microsoft provides a Shopify Connector for Business Central online. It requires the relevant Business Central and Shopify licenses and is not available for Business Central on-premises. Review the Microsoft connector FAQ before choosing an architecture.

The connector supports connected ecommerce operations, but installation is only the starting point. Your store configuration, Business Central setup, item identifiers, customer model, locations and fulfillment process determine how the integration should behave. Use the connector overview and getting-started guide to identify the standard capabilities and prerequisites.

Bitta Apps offers Business Central integration and AL development services. We can discuss connector configuration, a failing workflow or a requirement that needs further technical scoping. Custom work should address a documented gap after the standard connector has been evaluated.

Agree on a system of record for each flow

Before scheduling synchronization, create a mapping sheet with an owner, direction, identifier and exception procedure for each dataset.

  • Products and variants: identify how Shopify products match Business Central items, which system owns descriptions and prices, and how new variants are introduced.
  • Inventory: agree on the Business Central locations included in online availability and how reservations, safety stock and fulfillment timing should affect the quantity presented to shoppers.
  • Customers: define matching and creation rules, guest-checkout behavior and how business customers differ from retail consumers.
  • Orders: map payment methods, shipping charges, discounts, taxes and currencies to the Business Central processing model.
  • Fulfillment and returns: define who ships, when tracking is available, how partial shipments are handled, and how exceptions reach the right person.

These decisions are implementation requirements to validate against the selected connector version and store configuration. They are not a promise that every custom storefront behavior is handled automatically.

Test an order through posting and fulfillment

Microsoft documents a staged order process: Shopify orders synchronize into Business Central, then become sales documents according to the configured process. The order synchronization guide explains order handling and fulfillment.

Use representative transactions to verify your intended operation. Include a normal order, a discount, shipping charges, a partial fulfillment, a cancellation and a return or refund scenario where these apply. Check the resulting Business Central documents and postings as well as the status visible in Shopify.

Define the acceptance evidence for each scenario: source order identifier, Business Central document reference, expected quantities and totals, fulfillment status and the person approving the result. An order appearing in both applications is insufficient evidence if the accounting or warehouse outcome is wrong.

Plan reconciliation and error handling

Agree on how operations will find orders that did not synchronize, documents that could not be created and fulfillment updates that did not reach the store. Microsoft provides connector-specific diagnostic guidance in Troubleshoot Shopify synchronization.

The support procedure should identify the failing record, preserve the diagnostic details, correct the underlying mapping or configuration and verify the result before replaying work. Test retry behavior so a repeated operation does not create a second business transaction. Assign an escalation owner for errors that need the app publisher or another connected provider.

Finance should separately define its settlement reconciliation: sales, tax, shipping, discounts, refunds, fees and the amount deposited by each payment provider. Do not assume that order synchronization alone completes payout reconciliation. Determine which standard features, imports, additional applications or custom work are needed for the agreed accounting process.

Scope the delivery and ongoing ownership

A useful proposal identifies the stores, Business Central companies, locations, data flows, transaction examples and go-live criteria included in the engagement. It also lists exclusions such as storefront redesign, third-party fulfillment changes or historical cleanup unless explicitly included.

Plan for a test environment, suitable test data, controlled access and a production cutover checklist. Name the owners of credentials, scheduled synchronization, monitoring, failed records and future changes. Include the connector in your Business Central update testing: Microsoft notes that the Shopify API lifecycle and Business Central update window do not always align in its technical FAQ.

For a custom extension, agree on source ownership, deployment documentation, supported extension points and regression tests. A working integration needs a supportable operating procedure as well as a successful first synchronization.

Frequently asked questions

Does the Microsoft Shopify connector work on-premises?

Microsoft documents the connector for Business Central online. For an on-premises environment, assess a separate supported integration approach or a move to Business Central online before committing to the project.

Is installing the connector the whole project?

No. Item and customer matching, locations, processing rules, permissions, synchronization schedules, testing and support ownership still need to be configured and validated for your operation.

Can it handle our custom Shopify workflow?

Describe the workflow and provide a non-sensitive example. We first compare it with the standard connector behavior, then identify configuration changes, third-party dependencies or separately scoped AL development.

Will orders and payment-provider payouts automatically reconcile?

Define those as separate acceptance criteria. Order synchronization does not by itself establish that your settlement, fees and refund accounting process is complete. The required reconciliation approach must be scoped and tested.

Next step

Map your first end-to-end order flow

Bring your deployment type, store count, fulfillment approach and the main issue or requirement. We will discuss the standard connector fit and the next steps needed to scope the work.