What syncs and how¶
How each kind of record moves between Business Central and your store, and the settings that control it.
You can't change which Business Central field goes to which store field. You can choose which record types sync, which stores each record goes to, the company defaults for new records, and how shipping and payment methods are matched.
Store sync settings¶
Each store has its own Store sync settings. To open them, choose Store sync settings on the i95Dev Connect stores page, or Online store > Store sync settings on an item, customer or sales order.
Switch on syncing¶
- Open the store's Store sync settings.
- If Setup lists missing fields, choose Fill in defaults. Business Central fills in what it can and never overwrites a value you chose. Fill in the rest yourself.
- Switch on Sync on. Business Central checks the defaults and starts background sync.
If you can't switch on syncing, the message names the fields to fill in. See Background sync.
Choose what syncs¶
Choose What syncs (or Choose what syncs) to see each record type, such as orders, customers, items and inventory, and its direction. You can switch record types on or off.
Settings for new records and orders¶
| Setting | What it does |
|---|---|
| Customer nos. | Number series for customers created from the store |
| Sales order nos. | Number series for sales orders created from store orders |
| Default customer posting group, Default bus. posting group | Posting groups for customers created from the store |
| Template for individuals, Template for companies | Customer templates for store customers |
| Guest customer no. | The customer that guest checkout orders go on |
| Separate customer per guest | Gives each guest checkout its own customer instead of the guest customer |
| Use one customer for all orders, Customer for all orders | Puts every store order on one customer |
| Default unit of measure, Gen. prod. posting group, Inventory posting group, Tax group code | Values for items created from the store |
| Default location | The location store orders ship from, and whose stock is sent to the store |
| Shipping charge G/L account | The account for shipping charges on store orders |
| Non-item line G/L account | The account for order lines that aren't items, such as tips, fees and custom items without a SKU |
| Gift card G/L account | The account for gift cards sold in the store, such as a gift card liability account. If it's blank, gift cards go to the non-item line account. |
| Sales tax handling, Sales tax liability account | What happens with the tax the store charged. See Sales tax on store orders. |
| Cash receipt journal template, Cash receipt journal batch, Leave store payments in the journal | Where store payments go, and whether they're posted |
| Variant separator, Variant pattern 1–3 | How variant codes are built and read. See Variants. |
The Non-item line G/L account and Gift card G/L account must be posting accounts that allow direct posting and have a Gen. Prod. Posting Group. If the non-item line account is blank, an order with such a line isn't created. It waits in the Store records inbox and comes in whole once you choose an account.
Choose stores¶
Each item, customer and sales order syncs only with the stores you choose for it.
- Open the record.
- Choose Online store > Sync with Shopify, Sync with BigCommerce or Sync with Adobe Commerce. With stores on more than one platform, the action is Sync with online stores.
- Switch each store on or off, then choose OK.
To choose stores for many items or customers at once, select them on the list and choose Online store > Sync selected with .... Stores you switch on are added. Stores you leave off aren't changed.
Switching a store off stops sending updates to it. Nothing is deleted in the store.
Store status and Sync history on the same menu show where the record is and whether its last sync worked.
Shipping and payment methods¶
Stores and Business Central name shipping and payment methods differently, so each store has two lists. Open them from the store's Store sync settings.
Methods on store orders¶
Shipping and payment methods says what each method on a store order becomes on the Business Central sales order.
When a store order has a method that isn't matched yet, the order still comes in, without that method. The method is added to the list with the status To match, with the number of orders it affected.
- Open Shipping and payment methods. Choose Show methods to match to see only the unmatched ones.
- For a shipping method, choose the Shipping agent and, optionally, the Shipping agent service. For a payment method, choose the Payment method.
Orders that come in later get the method. Orders that already came in aren't changed.
Methods sent to the store¶
Methods sent to the store (the page Shipping and payment methods sent to the store) sets the store's own code for each Business Central method, for sales orders you create in Business Central. The store refuses an order with a method it doesn't know.
- On the store's Store sync settings, choose Methods sent to the store.
- Add a row for each method your orders use:
- Shipping: choose a Shipping agent (with or without a Shipping agent service) or a Shipment method.
- Payment: choose a Payment method.
- In Store method, type the store's code exactly. Examples for this store shows typical codes.
| Store | Payment method code | Shipping method code |
|---|---|---|
| Adobe Commerce | The payment code, such as checkmo, banktransfer, cashondelivery or purchaseorder |
The carrier and method code, such as flatrate_flatrate, freeshipping_freeshipping or tablerate_bestway |
| Shopify | The payment gateway name, such as manual or Cash on Delivery (COD) |
The shipping rate name, such as Standard |
| BigCommerce | The payment method name, such as Cash on Delivery |
The shipping method name, such as Flat Rate |
How the row for an order is chosen: first the row for the order's shipping agent and service, then the row for the shipping agent alone (it covers every service of that agent without its own row), then the row for the shipment method.
The code is sent exactly as you type it, with upper and lower case kept. A method without a row is sent as its Business Central code in lower case, which most stores refuse.
No rows are filled in for you, because the methods and codes differ for every company.
Customers¶
From the store: a store customer is matched to a Business Central customer by its link from an earlier sync, then by e-mail address. If there's no match, a new customer is created with the store's numbering and posting groups. The default billing address becomes the customer's address, and every address becomes a ship-to address.
To the store: the customer's name, e-mail address, address and ship-to addresses go to the stores you choose. The customer needs a name and an e-mail address. The name is split at the first space into first and last name.
Items¶
From the store: a new store product becomes an item whose No. is the product's SKU, up to 20 characters. Its name, description, price, cost and weight come with it, and the posting groups and unit of measure come from the store sync settings. A product without a SKU isn't created. Later edits in the store don't come back to Business Central.
To the store: the item's description, search description, unit price, unit cost, gross weight and base unit of measure go to the stores you choose. A blocked or sales-blocked item is disabled in the store.
Variants¶
An item with variants goes to the store as a configurable product, and each variant as a child product.
- Child SKU: the item no., the Variant separator and the variant code, for example
1000_RED. If the separator is blank,_is used. - Options: without a variant pattern, each variant has one option, called Variant, set to the variant code. If your variant codes hold several options, such as size and colour, set Variant pattern 1–3 to name them.
- Price and weight: each variant gets the item's price and weight. Prices per variant aren't supported.
From the store: an order line for a variant is split back into the item and the variant code using the separator. If the item or variant isn't found, that line is left out with a note, and the rest of the order still comes in.
Stock¶
The quantity sent to the store is the item's inventory minus the quantity on open sales orders, counting:
- stock at the store's Default location, and
- stock posted without a location.
Stock at other locations doesn't count, and the quantity is never below 0. A posting at those locations sends the new quantity. When you add an item to a store, its current stock is sent.
For a variant, the stock of that variant is sent.
Inventory must be switched on in What syncs.
Orders¶
Orders from the store¶
Each store order becomes a sales order.
Which customer it goes on:
- With Use one customer for all orders on, every order goes on that customer.
- A guest checkout order goes on the guest customer, or on its own customer with Separate customer per guest on.
- Otherwise, the order goes on the customer synced for it, found by its link or e-mail address.
An order doesn't create its customer. If the customer hasn't synced yet, the order waits in the Store records inbox until it has.
| From the store order | On the sales order |
|---|---|
| Store order number | External Document No. |
| Order date | Order Date |
| Billing address | Sell-to and bill-to name and address |
| Shipping address | Ship-to name and address |
| Shipping method | Shipping agent and service, through Shipping and payment methods |
| Payment method | Payment method, through Shipping and payment methods |
| Lines: SKU, quantity, price, discount | Item lines at the Default location. The item must exist. |
| Shipping charge | A line on the Shipping charge G/L account |
| Tax | Depends on Sales tax handling. See Sales tax on store orders. |
| Lines that aren't items | Lines on the Non-item line G/L account or Gift card G/L account |
A store order is created only once. If it comes again, it isn't duplicated.
Orders created in Business Central¶
A sales order you create goes to a store once you choose the store for it (Online store > Sync with ...). It's sent with its customer, dates, addresses, lines, shipping charge, tax, and the store's codes for its shipping and payment methods from Methods sent to the store.
Before it's sent, the order needs lines, a payment method, and a shipping agent or shipment method. Otherwise it's held with the status Missing information on the Store orders page, and it's sent once you fill in the missing field and save the order.
If the store refused the order (status Failed), change its payment method, shipping agent, service or shipment method and save the order: it's sent again. For other fixes, choose Retry now on the Store records outbox.
Shipments and invoices¶
| Record | What the store gets |
|---|---|
| Posted shipment | The shipped lines and quantities, and the tracking number when the shipment has a Package Tracking No. Partial shipments are supported. |
| Posted invoice | The invoiced lines and quantities |
| Cancellation | Deleting an unshipped store order in Business Central cancels it in the store |
The tracking number is sent with the shipment. Changing it later isn't supported.
Prices¶
Only the item's Unit Price syncs. Customer price groups, price lists, tier prices and customer-specific prices aren't supported at launch, even though Business Central shows Online store actions on those pages. See Supported features.
Store payments¶
On Shopify and Adobe Commerce, a store payment for an invoice goes to the Cash receipt journal batch in the store sync settings, on the invoice's customer, applied to the invoice. It's posted straight away unless Leave store payments in the journal is on.
Each payment carries a Store payment ID, shown on the journal line and on Customer Ledger Entries. A payment that comes again, or a payment for an invoice that's already paid, is skipped with a note.