+1 480 485 7373
Microsoft Teams
Dynamics 365 for retail and ecommerce brands selling online and in stores.
Dynamics 365 for retail and ecommerce makes sense once a brand has outgrown a storefront plus basic accounting. For most growing brands that means Business Central. Orders come from a webstore, a marketplace and maybe a shop or two. Meanwhile, stock sits in a warehouse and a 3PL, and nobody trusts the inventory number. So the goal is one stock figure and one set of books behind every channel.
What breaks first in retail and ecommerce before Business Central
- ✓Stock counts disagree between the storefront, the warehouse and the books, and overselling becomes a weekly customer service problem.
- ✓Payouts arrive net of fees, refunds and chargebacks. As a result, matching them to orders takes someone most of a day.
- ✓Someone estimates cost of goods sold in a spreadsheet, so product margins stay guesses until year end.
- ✓Wholesale accounts, marketplaces and the direct store each keep their own customer and price data.
- ✓Staff track purchase orders to overseas suppliers in email. Also, landed cost never reaches the product.
- ✓The storefront works out sales tax, and then someone keys it again in the books. So collected amounts and filed returns drift apart.
How each retail and ecommerce channel connects to Dynamics 365 Business Central
Shopify connector
Microsoft's own connector syncs products, prices, stock levels and customers with Shopify. It also imports orders, refunds and returns as Business Central documents. In addition, several Shopify stores can link to one company.
- ✓Order import on a schedule
- ✓Stock pushed by location
- ✓B2B company records for Shopify Plus
- ✓Refunds turned into credit memos
Amazon and others
Marketplace orders and settlements come in through AppSource connectors or an integration platform. After all, finance needs the settlement report, not just the orders.
- ✓Order and fee import
- ✓Settlement reconciliation
- ✓FBA stock visibility
- ✓Tax collected by the marketplace
Point of sale
Business Central has no till software of its own. Instead, retailers with physical stores use a POS add-on built on Business Central. Or they run a separate POS that posts daily summaries.
- ✓Retail POS built on Business Central
- ✓Daily sales summary postings
- ✓Store replenishment by transfer order
- ✓Gift card and loyalty handled in POS
Variants, assortments and the product catalog
A retailer with fifty styles in six sizes and four colors does not want twelve hundred separate item cards. Business Central for retail and ecommerce handles that with item variants. For example, one item holds the style, with variant codes for each size and color. The system tracks stock, sales and purchases by variant. Then the Shopify connector maps variants to Shopify's own product options.
However, rich product content is harder. Business Central is not a product information system. Long descriptions, image galleries and SEO copy usually stay in Shopify or a dedicated PIM. Business Central, on the other hand, owns the SKU, cost, price and stock. Deciding that split early saves a lot of sync arguments later.
Retail needs and how Business Central covers them
When a retailer looks beyond Business Central
Business Central with the Shopify connector and a POS add-on covers many brands with a webstore and a handful of shops. Dynamics 365 Commerce is Microsoft's full retail suite, with its own store POS, call center and ecommerce, and it runs on Dynamics 365 Finance and Supply Chain Management rather than Business Central. That makes it a much larger project, suited to chains with many stores and central merchandising. Dynamics 365 Customer Service can sit beside either option for order and returns queries. Store count, channel mix and the team you can staff usually settle the choice.
Dynamics 365 for retail and ecommerce: common questions
Does the Shopify connector cost extra?
No. Microsoft builds the connector and includes it with Business Central online, so there is no separate connector subscription. You still need your Business Central and Shopify plans. The setup work lies in mapping locations, taxes, shipping charges and payment methods.
Should every web order become a Business Central sales order?
Not always. Low-value, high-volume stores sometimes import orders and post them straight to invoices, or summarize them, to keep the database lean. Brands with a warehouse picking from Business Central need each order as a document. We decide based on who ships the goods and how finance reconciles payouts.
Can Business Central run our physical stores?
Only with a point of sale product added. Some retail POS systems run on Business Central, so store sales post straight to the same items and ledger. Others run separately and send daily totals. For one or two stores, a separate POS with a daily summary is often enough.
How do we handle a 3PL warehouse?
You set up the 3PL as a location. Then shipments go to the 3PL through their API or files. Confirmations and stock adjustments come back to Business Central. A regular stock comparison between the 3PL's report and Business Central catches drift before it becomes a write-off.
Can we sell wholesale to other retailers from the same system?
Yes. Wholesale customers get their own price lists, payment terms and credit limits, while direct-to-consumer orders flow from the webstore. Margin reports can split the two channels. If big-box retailers require EDI, plan for an EDI add-on.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.