+1 480 485 7373
Microsoft Teams
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 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
Business Central retail and ecommerce 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.