Mirakl allows you to sell your products across hundreds of marketplaces from one central dashboard. They also integrate with Shopify so that you can import those orders and fulfil them via your Shopify Admin.

Link My books now has built in functionality to be able to separate your Mirakl orders that are imported to Shopify and separate them by the marketplace source.

With this feature enabled, Link My Books will automatically group your Mirakl settlement summaries by marketplace source.

We'll automatically create tracking codes in Xero for each of the different marketplace sources and then we'll apply those to the relevant lines of the settlement invoice we send to Xero.

Your current account mappings can remain the same, meaning you can still have all Shopify Sales assigned to your chosen sales account etc. as the tracking codes will be doing all the hard work for you.

Hers is what a settlement summary for Shopify would look like:

If we hone in on the detail here you can see that the sales to Sephora UK, Debenhams and Superdrug are all on separate lines in the summary invoice:

The real magic happens when you send the settlement to Xero as then we add a tracking code to each of these lines with the name of the marketplace.

If we punch in we can see that the tracking codes are being applied to each of the different marketplace sources accordingly:

If you run a P&L in Xero, by default it will show all your data together (not split by tracking category).

To run a P&L split by tracking category, follow these steps:

You should end up with something that looks like this:

Now you can see your figures from each of the different Mirakl Marketplaces shown in their own column.

To switch this on, get in touch with our support team and ask us to enable the Shopify channel split on your account. Once we've done that, no further action is needed on your side.

Your Mirakl sales will be automatically separated by marketplace source and the tracking codes will be automatically created in your Xero account.

You do not need to select the marketplace tracking codes yourself. Once the feature is enabled, Link My Books applies the correct marketplace code (e.g. B&Q, Tesco UK) to each line automatically when the settlement is sent. Leave the Primary Tracking Code for the Shopify gateway set to No tracking code under Settings → Settlement Settings → Tracking Codes so the automatic marketplace code can be applied.

Enabling the split applies to settlements sitting in "Ready to Send" status. Those will come through split by marketplace source, with the tracking codes created automatically in Xero.

Settlements you have already sent to Xero will not show the split. If you want it applied to those too, you can roll them back and resend them:

Note that rolled back settlements always need sending manually, even if you have auto-posting switched on. For more detail, see Rollback Feature: How It Works.

If your settlement lines in Xero are already split by marketplace in the description (e.g. "Sales shipped to UK - B&Q", "Sales shipped to UK - Tesco UK") but every line carries the tracking option Shopify instead of the marketplace name, the feature is enabled and working, and a manual tracking code is overriding it.

Xero only allows one tracking option per category on each invoice line. If the Shopify gateway has a Primary Tracking Code set (for example LMB Tracking Codes : Shopify), that manual code takes the slot the automatic marketplace code would use, so the marketplace split cannot be applied.

To fix this:

You will see the marketplace options (e.g. B&Q, Tesco UK) listed in the tracking code dropdown once Link My Books has created them in Xero. This is expected. Do not select them manually; they are applied automatically per line when the setting is left as No tracking code.

If you also use a second tracking category, see Use Two Xero Tracking Codes Per Marketplace.