Dynamics 365 Business Central

We've been testing this back and forth through the versions, and It's getting there. If we weren't selling globally, we'd change to this one in a heartbeat. However, as it does not support multiple currencies, it's impossible to use when trading in different currencies.

When/If it becomes possible to import orders in the same currency the transactions are made in, we'll change to this integration in a second.

We are very happy with this connector which we deployed for two different instances of BC. Synch is reliable and relatively flexible to use. Works well with US sales tax, VAT in multiple European countries, with anonymous customers, or with existing ones.

Things I wish will improve in the future:
- Synch of products that have two sets of variants (color and size, for example) require inverting temporarily the synch from Shopify to BC to get the nested values in and then manually mapping the product variants. I wish there was a more intuitive way.
- Exclude some product fields from synching to Shopify (such as vendor) or at least being able to alter them in the product table in BC.
- Support for synching product descriptions in multiple languages when these are available in BC.
- Support for synching more sales scenarios from BC to Shopify: currently the pickup in store process is not supported in BC and must be dealt with in Shopify (BC will mark the order as shipped, never ready for pickup).
- Being able to create credit notes in BC and synch that back to Shopify. Currently refunds need to be started from Shopify.
- Having more options to sync inventory: currently you can choose between reserved and previous sales orders only. This does not offer enough flexibility.
- Better integration with POS: currently customers who buy from the Shopify POS app can only get a receipt; even when the customer information is added to the order, it is not synched with BC to send them an invoice (required by some customers).
- Possibility to filter incoming orders in BC by country or delivery type. We use third party companies to export in certain countries. Currently we need to tag these orders in BC and then synch them to a different store in BC to invoice the right customer at the end of the month. Wish for a more streamlined solution.
- BC invoices synch to Shopify, happy this one is coming apparently! Hopefully payment information too for B2B customers? Please?

Connector has a lot of features, but I can't get correct vat calculation to work. Prices are including vat, but creating the BC sales order vat is calculated and also with the wrong Country-VAT, that is set in the template.

It will be a nice connector. For the moment, whenever we synchronize an order with fulfilled status (both online and POS) the "location_id" in the Shopify order is wrong. We have to use an extra API call to "fulfillment_orders" method to get the correct location_id.

We initially considered adopting Dynamics 365 Business Central as our new accounting system because of its functionality and native connector. However, we abandoned this plan due to the inefficiency of the synchronization process, which still requires double entry. Our goal was to manage orders entirely through Shopify, including updating order content, marking orders as fulfilled (shipped), confirming payments, and assigning integrated tracking links, not to mention handling returns. Unfortunately, with this connector, double entry remains necessary. While it does receive correct order data, it doesn't capture changes, shipping and payment documents aren't automatically posted in Business Central. Our previous accounting system handled these tasks seamlessly, saving time and reducing error risk. It's 2024, yet automating business processes with Microsoft—one of the world's most experienced companies—remains impossible!