Quick Answer (TL;DR)
Etsy does not connect natively to Business Central, so a requires a connector app or custom API build. The key is mapping each Etsy variation (like size or color) to a Business Central item variant with its own SKU, while routing personalization text to sales order lines. This keeps inventory, costs, and fulfillment accurate for handmade products.
Key Takeaways
- Business Central includes a built-in Shopify connector but no native Etsy connector. You will need an AppSource app, middleware, or a custom integration built on the Etsy Open API v3.
- SKUs are the backbone of the integration. Every sellable Etsy variation combination needs a unique SKU that matches a Business Central item and variant code.
- Item variants work best for stocked combinations like size and color. One-of-a-kind pieces usually work better as separate items or with serial number tracking.
- Personalization, such as engraved names or custom text, should flow to sales order lines as text or custom fields. It should not become new variants.
- Made-to-order products need a different sync logic than ready-to-ship stock. The logic should be based on component availability or production capacity rather than finished goods on hand.
- Etsy collects and remits US sales tax as a marketplace facilitator. Your integration must avoid posting that tax a second time in Business Central.
Why Handmade Sellers Outgrow Manual Etsy Management
Most Etsy shops start with spreadsheets and the Etsy dashboard. That works until you are selling the same necklace in four metals and three chain lengths, taking custom engraving requests, and listing the same products on your own website. At that point, stock counts drift, costs get guessed, and a sold-out variation stays live long enough to create an order you cannot fulfill.
Connecting Etsy to Microsoft Dynamics 365 Business Central solves this by giving you one system of record for inventory, costing, and accounting. The hard part is not moving orders from one system to another. The hard part is translating Etsy's flexible, buyer-friendly variation model into Business Central's structured item data. That translation is where a well-planned makes or breaks the project.
This guide explains how the two data models differ, how to map variations correctly, and how to handle the edge cases that are unique to handmade products.
Plan Your Etsy Integration
Our team maps your Etsy variations, SKUs, and personalization workflows to Business Central before a single order syncs.
How Etsy and Business Central Think About Products Differently
Etsy is built around the listing. A single listing can carry variations on up to two properties, such as Color and Size. Within the listing editor, you choose whether price, quantity, and SKU vary by those properties. Etsy also offers a separate personalization field, where buyers type free text like a name or date.
Business Central is built around the item. An item has one item number, a base unit of measure, costing information, and posting groups. Variations of that item are stored as item variants, each with its own variant code. Stock can then be tracked per variant and per location through stockkeeping units.
The table below shows how the core concepts line up.
| Etsy Concept | Business Central Equivalent | Notes |
|---|---|---|
| Listing | Item | One listing usually maps to one item |
| Variation combination (e.g., Silver / 18 inch) | Item Variant | Each combination gets its own variant code |
| Variation SKU | Item Reference or Variant Code | Must be unique and match exactly |
| Personalization text | Sales line description or custom field | Should never create new variants |
| Listing quantity | Available inventory per variant | Calculated in BC, pushed to Etsy |
| Etsy order | Sales Order | Created in BC from Etsy receipts |
| Etsy fees and payouts | G/L entries and bank reconciliation | Often posted as a daily or payout-level summary |
If you sell across several channels, this same mapping discipline carries over to your wider setup. It keeps Etsy, your website, and wholesale orders drawing from the same stock pool.
Your Integration Options
Option 1: A Third-Party Connector App
Several AppSource and middleware vendors offer Etsy connectors for Business Central. These are the fastest route for straightforward catalogs. Before you buy, check three things: whether the app supports two-property variations, whether it can map personalization to order lines, and whether it syncs inventory at the variant level rather than only at the item level.
Option 2: Middleware or iPaaS
Integration platforms sit between Etsy and Business Central and let you build mapping rules visually. They suit businesses that already use middleware for other channels. They also make sense if you are connecting Etsy alongside marketplaces through an existing .
Option 3: Custom Integration
A custom integration uses the Etsy Open API v3 (with OAuth 2.0 authentication) on one side and Business Central's standard APIs or custom AL extensions on the other. This option gives you full control over variation logic, made-to-order rules, and fee posting. It is usually the right choice when your catalog has unusual structures that off-the-shelf apps cannot model. Etsy reviews apps that request API access, so build that approval time into your plan. A partner experienced in can scope this accurately.
A useful point of comparison: Business Central's native Shopify connector already handles product variants and order import out of the box. If you also sell on Shopify, a dedicated can be set up alongside your Etsy connection, and both should share the same SKU conventions.
Mapping Etsy Variations to Business Central Item Variants
Step 1: Build a SKU Convention Before You Sync Anything
Every integration issue we see with handmade catalogs traces back to inconsistent SKUs. A simple, readable pattern works best:
[Product Code]-[Property 1]-[Property 2]
For example, NCK-LEAF-SLV-18 for a silver leaf necklace on an 18 inch chain. Apply this pattern to every Etsy variation combination and every Business Central variant. The integration can then match records on SKU without any guesswork.
If your existing SKUs are a mix of old listing codes, blanks, and duplicates, clean them before go-live. The approach is the same one we describe in our guide to : audit, standardize, deduplicate, then load.
Step 2: Decide What Becomes a Variant and What Does Not
Not every Etsy option should become a Business Central variant. Use this rule of thumb:
- Make it a variant when the option changes what physically sits on the shelf, such as color, size, or material.
- Keep it as an order detail when the option only changes how you finish the item after the sale, such as engraving text, a monogram, or a gift note.
- Make it a separate item when the piece is truly one of a kind, such as a single hand-thrown vase or a vintage find. Alternatively, keep one item and use serial numbers so each unique piece is tracked individually.
This distinction prevents variant explosion. If every personalized name created a new variant, your item list would grow endlessly and your stock data would become meaningless.
Step 3: Use Item References for Channel-Specific Codes
Business Central's Item Reference feature lets you link an external code to a specific item and variant. If your Etsy SKUs cannot be changed to match your internal numbering (for example, because long-running listings would lose history), store the Etsy SKU as an item reference. The integration then resolves each Etsy order line to the correct item and variant automatically.
Step 4: Map Variation Pricing Carefully
Etsy lets price vary by variation. In Business Central, you can reflect this with sales prices defined per variant, often in a price list dedicated to the Etsy channel. Decide which system owns the price. In most setups, Business Central is the master for price and quantity, while Etsy is the master for orders.
Handling Personalization and Custom Orders
Personalization is where handmade businesses differ most from standard retail. A buyer who orders a "Custom Name Bracelet" might select Gold and Medium as variations, then type "Amara, 2019" in the personalization box.
The integration should:
- Resolve Gold and Medium to the correct item variant, so inventory and cost are correct.
- Write the personalization text to the sales order line, either in an extended description or in a dedicated custom field.
- Carry that text through to pick lists, production or assembly documents, and packing slips, so the maker sees it without opening Etsy.
Standard Business Central does not have a dedicated personalization field on sales lines. A small that adds one, and prints it on warehouse documents, is often the highest-value change in the whole project.
For fully custom commissions that Etsy sellers handle through custom listings, create a generic "Custom Order" item or a nonstock item in Business Central. Capture the specifics on the order line. That way, you record revenue and costs correctly without cluttering your item catalog with pieces you will never sell again.
Syncing Inventory for Ready-to-Ship vs Made-to-Order Products
Ready-to-Ship Stock
For finished goods, the logic is simple: Business Central calculates available quantity per variant (on hand minus reserved and open orders) and pushes it to the matching Etsy variation. Consider holding back a small buffer on fast sellers, so a sale on another channel does not oversell Etsy between sync runs.
Made-to-Order Products
Many handmade items are not sitting in stock at all. They are made after the order arrives. Pushing a quantity of zero would hide them, and pushing a high fixed number risks promising more than you can make.
Two approaches work well:
- Component-based availability. Set up the product as an assemble-to-order item with an assembly BOM (for example, a pendant, a chain, and a clasp). The integration calculates how many finished pieces the available components can produce and publishes that number to Etsy. Businesses with multi-step making processes can extend this with production BOMs, the same foundation used in .
- Capacity-based availability. Publish a set weekly capacity per product, reduced as orders come in. This suits makers whose limiting factor is time rather than materials.
Also align your Etsy processing times with realistic production lead times. Your integration can keep listings accurate, but it cannot fix a promise the workshop cannot keep.
Tracking Materials With Batch Differences
Handmade materials vary between batches. Hand-dyed yarn, glazes, and leather hides are common examples. Business Central's lot tracking lets you record which batch went into which order. This helps when a customer wants a matching second item or when a batch has a quality issue. If you ship from more than one location or use a third-party fulfillment partner, review how affects lot and variant visibility.
Order, Fee, and Tax Handling
Order Import
Etsy orders (called receipts in the API) should become Business Central sales orders on a regular schedule. Map the buyer to either an individual customer record or a single "Etsy Customer" account, with shipping address details stored on the order. Most small handmade businesses prefer the single-customer approach, since it keeps the customer list clean.
Marketplace Tax
In the US, Etsy collects and remits sales tax as a marketplace facilitator. If your integration imports the tax amount onto the sales order and then posts it to your tax liability account, you will overstate what you owe. Configure the Etsy channel so marketplace-collected tax is recorded for reference but not posted as your liability. Confirm the setup with your accountant, since rules differ outside the US.
Fees and Payouts
Etsy deducts transaction fees, payment processing fees, listing fees, and advertising costs before paying you. Post these as expense entries and reconcile each payout against your bank statement. Posting one summarized journal per payout, rather than one per order, keeps your general ledger readable.
Common Mistakes to Avoid
- Syncing before SKUs are clean. Mismatched SKUs cause failed order imports and orphaned stock.
- Turning personalization into variants. This bloats your item list and breaks inventory reports.
- Letting both systems edit quantities. Choose one master for stock, or you will chase conflicting numbers.
- Relying purely on default setup. Handmade workflows rarely fit a standard configuration, which is a pattern we cover in .
- Skipping testing with real variation data. Test with your most complex listings, not your simplest ones.
Practical Go-Live Checklist
- Audit every Etsy listing and export its variations and SKUs.
- Standardize SKUs and create matching items, variants, and item references in Business Central.
- Define ownership rules: BC owns price and quantity, Etsy owns orders.
- Set up personalization handling on sales lines and warehouse documents.
- Configure made-to-order logic (assembly BOMs or capacity rules).
- Configure marketplace tax, fee posting, and payout reconciliation.
- Run a parallel test period with a small set of listings.
- Roll out to the full catalog and monitor sync error logs daily for the first few weeks.
For a broader view of what to verify before switching on, our covers data, users, and cutover planning in more detail.
Getting More Value After the Integration
Once Etsy data flows cleanly into Business Central, you can see real margins by variation. That often reveals that your best-selling color is not your most profitable one. Connecting Business Central to turns that data into dashboards for sell-through by variation, material usage, and channel profitability.
Business Central's Copilot features can also help with catalog work. For example, it can draft marketing text for new items, which you can then refine for your Etsy listings. We explain what these features really do in practice in .
What Does It Cost?
Costs depend on your integration route. A connector app has a subscription fee and modest setup time. A custom integration costs more upfront but fits unusual catalogs exactly. Licensing, data cleanup, and customization all add to the total. Our breakdown of walks through each component so you can budget realistically. Growing makers can also explore our options.
Estimate Your Integration Cost
Use our free calculator to estimate licensing, setup, and customization costs for your Business Central project.
Frequently Asked Questions
Does Business Central have a native Etsy connector?
No. Business Central includes a built-in Shopify connector, but Etsy requires a third-party app, middleware, or a custom integration built on the Etsy Open API v3.
How do Etsy variations map to Business Central?
Each Etsy variation combination maps to a Business Central item variant under a parent item. A unique, matching SKU or item reference links the two, so orders and inventory updates reach the correct variant.
Should personalized products be set up as variants?
No. Personalization text such as names or dates should be stored on the sales order line. Only options that change the physical stock item, like color or size, should be variants.
How do I sync inventory for made-to-order items?
Calculate availability from component stock using assembly BOMs, or publish a fixed production capacity that decreases with each order. Both methods prevent overselling without hiding listings.
Will Etsy sales tax be recorded twice?
It can be if the integration is not configured correctly. Because Etsy collects US sales tax as a marketplace facilitator, set up the Etsy channel so that tax is recorded for reference only and not posted as your liability.
Ready to Connect Etsy to Business Central?
If your handmade business is juggling variations, personalization, and multiple sales channels, a structured integration will save hours every week and protect your margins. Not sure whether your data and processes are ready? Start with an , or about your catalog.