Leroy Merlin: marketplace guide

About this guide

This is a ChannelEngine guide on the Lille-based marketplace Leroy Merlin. Here you can find information on how to request a Leroy Merlin account, how to configure this channel on ChannelEngine, what the specific requirements are, and more.

Table of contents

Commercial information

How to request an account

Associated costs

Marketplace features

Settings and configuration

Marketplace-specific requirements and exceptions

• Setup
• Categorization
• Mappings
• Pricing
• Listed products

FAQs

Commercial information

Founded	1923
Founder	Adolphe Leroy, Rose Merlin
Headquarters	Lille, France
Area served (orders)	France, Italy, Portugal, Spain
Revenue	USD 756.4 million (France)
Number of monthly visits	circa 30 million (leroymerlin.fr)
Website	Leroy Merlin
Setup cost	none
Commission	depends on the category
Other costs	EUR 39.00/month (excl. VAT)
Payment	thrice a month
Product categories	DIY, gardening, furniture/interior design, household appliances, and more
Input language	French, Italian, Portuguese, Spanish
Input currency	EUR
Content creation	yes
Minimum number of SKUs	no
Advertisement options	no
Profile on ChannelEngine	Leroy Merlin

How to request an account

To start selling on Leroy Merlin, fill out their marketplace seller application form.

Associated costs

Leroy Merlin does not charge a setup fee, but it does charge a monthly fee of EUR 39.00 (excl. VAT), as well as a commission fee that varies per category.

Marketplace features

Supported	Not supported
Product content	Marketplace fulfillment service
Product offers (EAN matching)	Repricing
Returns (merchant)	Returns (channel)
Shipments	Automatic relationships
Carrier mapping	Multiple stock locations
Orders
Cancelations
Product variations (size/color)
HTML formatting
Sales channels*

* A marketplace that supports sales channels allows merchants to list and sell products across multiple markets (e.g.: countries, regions, and states), all from the same connection.

Settings and configuration

Setting up each marketplace on ChannelEngine follows the same flow, though not every marketplace includes the steps listed below.

1. Go through the Setup.
2. Create a Product selection.
3. Complete the Categorization.
4. Set up the Mappings: content, offers, and carriers.
5. Configure the Pricing: rules and currency conversion.
6. Finish the Activation.
7. Check the Listed products overview.

Marketplace-specific requirements and exceptions

Setup

On ChannelEngine

Leroy Merlin is a Mirakl-based marketplace, so you can connect it to ChannelEngine using a Mirakl Connect SSO account. For more information on this, check out the Mirakl-based channels: SSO authorization article.

As Leroy Merlin does not support repricing, you can leave the Mirakl seller name field empty.

Leroy Merlin uses the following sales channels, which need to be activated by your account manager at Leroy Merlin before they are visible on ChannelEngine:

• 001 LM FR/BELGIQUE/CORSE - Leroy Merlin France
• 002 LM ES - Leroy Merlin Spain
• 005 LM IT - Leroy Merlin Italy
• 014 BM FR - Bricoman France

For more information on sales channels, check out the article Mirakl-based channels: setting up sales channels.

Invoice uploads

To configure your invoice settings, click Advanced settings. You can then click the dropdown menu Enable invoice uploading, which contains the following options:

• ChannelEngine invoices - when ChannelEngine receives a shipment, it automatically generates an invoice and attaches it to the shipment before exporting it.
• Merchant invoices (optional) - when ChannelEngine receives a shipment, it exports it – even if there is no invoice attached to it.
• Merchant invoices (required) - when ChannelEngine receives a shipment, it only exports it if an invoice is attached to it. If not, you receive a notification.
• None - when ChannelEngine receives a shipment, it takes no action other than notifying you that no invoice is present.

If you select one of the Merchant invoices options, make sure to upload the invoice to ChannelEngine via the Merchant API or via the web interface. To learn more, check out the article ChannelEngine: merchant invoices.

Categorization

Categorization is mandatory if you want to create or update existing product information on Leroy Merlin. Both categorizations and mappings only result in updates if the content connection is enabled, and the relevant credentials have been entered (see the Setup section).

All categories are listed on Leroy Merlin in English, and they may differ from the categories shown in the Leroy Merlin front-end. Make sure to map as many attributes as possible so your products are displayed prominently.

 

Mappings

Content

Products must be validated by an operator before they can be linked to an offer. If not, the offer displays the error "The product doesn't exist".

All products (required)

• EAN - the product's 13-digit EAN or GTIN.
• Identifiant produit - the product's 13-digit EAN or GTIN.
• Marque - the product's brand. If your brand is not listed, make sure to contact Leroy Merlin so they can add it. In the meantime, use Autre (Other).
• Titre du produit [language] - the product's title. Leroy Merlin recommends you to add the product brand and product characteristics (i.e.: color, size, and material) to the product title. The maximum number of characters is 120. Note that you must fill out the title, description, and image according to the language chosen. E.g.: A French title cannot be chosen without Image 1 FR and Description longue FR.
• VAT - shipment-origin (to be filled in with the 2 letter ISO code of the country where the goods are stored). This attribute is mandatory (even if it's not set as mandatory in Mirakl).

• TVA BMFR/LMFR/LMIT (VAT) - the product's VAT. Note that there is a dedicated VAT attribute per sales channel. The percentages associated with each value vary per sales channel.

All products (optional)

• Code à usage interne - the product's SKU or Merchant product number.
• Code parent - the product parent's SKU or Merchant product number.
• Couleur principale - the product's main color.
• Déclaration de performance FR B2B - the product's declaration of performance (DoP), which describes the characteristics of construction products.
• Description longue [language] - the product's long description, in the language indicated by the attribute. The maximum number of characters is 5,000 and simple HTML tags are supported (e.g.: br and p).
• Étiquette COV (VOC label) - the product's volatile organic compound (VOC) label, which indicates the level of VOC emissions. The scale ranges from A+ (very low emissions) to C (high emissions).
• Étiquette ERP énergétique [language] - the product's energy efficiency label.
• Fiche technique FR B2B - the URL of the product's technical data sheet.
• Image 1-5 [language] - the product's image URLs. The minimum resolution supported is 500x500 px and the maximum file size is 10 MB. If possible, the images should have no text.
• Matière principale du produit - the product's main material.
• Notice en PDF [language] - the URL of the product's user manual, in the language indicated by the attribute.
• Photo d'emballage avec pictos de sécurité [language] - the product's packaging photo, with safety pictograms.
• Produit existant LM - ne pas utiliser - used by Leroy Merlin to indicate if the product already exists in their database. Not to be mapped.

Offer

All products (required)

• Price - the product's price.
• Leadtime to shipment - the number of days before you ship the product. Enter a value between 1 and 45.
• Logistic class - although this attribute is marked as optional by Mirakl, it is actually obligatory for Leroy Merlin – and must be mapped according to the settings in the Leroy Merlin back-end under My account, Settings, Shipping. The default value is S, which must be mapped with the value INIT. The list of labels and corresponding codes is below.

Code	Label	Description
XXXS	Logistic class XXXS	A parcel that weighs up to 5 kg. Each dimension must be less than 34 cm, and the total circumference (length + width + depth) must be less than 86 cm.
XXS	Logistic class XXS	A parcel that weighs up to 10 kg. Each dimension must be less than 50 cm, and the total circumference (length + width + depth) must be less than 117 cm.
XSXXS	Logistic class XXS-XS	A parcel that weighs up to 15 kg. Each dimension must be less than 94 cm, and the total circumference (length + width + depth) must be less than 187 cm.
XS	Logistic class XS	A parcel that weighs up to 20 kg. Each dimension must be less than 100 cm, and the total circumference (length + width + depth) must be less than 150 cm.
INIT	Logistic class S (default)	A parcel that weighs up to 30 kg. Each dimension must be less than 100 cm, and the total circumference (length + width + depth) must be less than 150 cm.
SM	Logistic class S-M	A parcel that weighs up to 50 kg. Each dimension must be less than 150 cm, and the total circumference (length + width + depth) must be less than 200 cm.
M	Logistic class M	A bulky package that weighs up to 110 kg. Each dimension must be less than 200 cm, the total circumference (length + width + depth) must be less than 400 cm, and the total volume less than 3 cubic meters.
L	Logistic class L	A bulky package that weighs up to 250 kg. Each dimension must be less than 450 cm, the total circumference (length + width + depth) must be less than 600 cm, and the total volume must be less than 11 cubic meters.
LXL	Logistic class L-XL	A bulky package that weighs up to 1,000 kg. Each dimension must be less than 500 cm, the total circumference (length + width + depth) must be less than 750 cm, and the total volume must be less than 20 cubic meters.
XL	Logistic class XL	A heavy bulky package that weighs up to 2,000 kg. Each dimension must be less than 600 cm, the total circumference (length + width + depth) must be less than 1,000 cm, and the total volume below 30 cubic meters.
Outsized	Logistic class Outsized	A bulky package not covered in previous logistic classes.
FREE	Free shipping	The logistic class dedicated to free shipping fees.

All products (optional)

• Pays de stockage (Country of storage) - although this attribute is marked as optional by Mirakl, it is actually obligatory for Leroy Merlin. Map it with the two-letter ISO code of the country where your products are stored.

Attributes such as Offer state (the condition of your item) and Minimum quantity alert (so you receive a notification if the stock drops below a certain threshold) are common for Mirakl mappings.

Working with discounts

• Do not leave the Discount end date attribute unmapped. If you want to set a permanent discount, use a date in the far future instead. Otherwise the offer is not exported, and errors are shown under the Validation and feedback tab.
• If your discounted price is not lower than the base price, it is not exported.
• If you do not want to set a bulk discount, leave the Discount quantity threshold attribute unmapped – otherwise the export is broken.
• If you do want to set a bulk discount, the Discount quantity threshold must be set to a value higher than 1. E.g.: a value of 2 indicates that two or more of the product must be purchased at the same time for the buyer to benefit from the discount.

Carrier

Carrier mapping is not required on Leroy Merlin. However, you can map your carrier to a specific list of carriers maintained by Leroy Merlin. This allows for working tracking links in the back-end, as well as for the buyer – which are required by Leroy Merlin. If your default carrier is missing, please contact Leroy Merlin.

Pricing

Leroy Merlin requires the prices to be submitted in EUR. If you do not have pricing attributes in EUR, you need to set a currency conversion.

Listed products

If you have problems with products not appearing on Mirakl-based marketplaces – especially if you are trying to create products –, check the Listed products page for more information.

You can either use the Channel status filter (e.g.: products that ChannelEngine has failed to exported, such as those with an empty GTIN or that do not exist on the marketplace yet, are shown as Invalid) or the Validation and feedback tab to see all known errors for specific products.

Alternatively, you can access the marketplace's back-end and download the error report generated by Mirakl. To do so:

1. Log in to the Mirakl back-end and go to Catalog, Product imports.
2. Identify the latest report and click the See details button by it.
3. Download the CSV file Non-integrated products report.

FAQs

I cannot find Leroy Merlin when selecting the marketplace during the SSO setup. What should I choose?

Within Mirakl, Leroy Merlin is identified as Marketplace Adeo – its parent company. Therefore, select Marketplace Adeo when prompted.

I see duplicate attributes, but ChannelEngine does not map them automatically. What should I do?

Although those attributes look like duplicates, they have different IDs. That is why ChannelEngine cannot map them automatically, which means you need to map them twice.

My products are exported successfully, but they are not created on Leroy Merlin. What is happening?

The three most common reasons for products that fail to be created on Leroy Merlin are:

1. You have set up a mapping configuration in the Leroy Merlin back-end, which prevents the automatic content creation done by ChannelEngine.
2. The Product tag for XML file imports, found in the Leroy Merlin back-end under My account, Settings, Imports, must be set to Product.
3. The use of special characters in attributes such as Description longue can also make the import fail. If you use tabs (|) as separators, for instance, make sure to do so consistently. Spaces cannot be used as separators.

How can I delete my products on Leroy Merlin?

Although it is possible to delete offers, it is not possible to delete products on Leroy Merlin.

How often does each task run on Mirakl-based marketplaces?

By default, Mirakl-based marketplaces follow the schedule below:

Task	Frequency
Export product data to marketplace	every 60 minutes
Export product offers to marketplace	every 15 minutes
Import product offers from marketplace	every 15 minutes
Import orders from marketplace	every 15 minutes
Export order shipments to marketplace	every 15 minutes
Export returns to marketplace	every 30 minutes

Can I map attributes on ChannelEngine and in the Mirakl back-end?

No. Mapping attributes in the Mirakl marketplace back-end interferes with ChannelEngine's content export. Therefore, it is recommended to stick to categorizing and mapping content only on ChannelEngine.

Why am I not receiving feedback on my content and/or offer exports?

Chances are you are receiving the feedback. However, different types of error report can take a couple of hours or several days to be generated:

• Offer feedback
  • Error reports are mostly generated automatically, and are imported quickly.
• Content feedback
  • Transformation error report - this is automatically generated, and usually imported within a maximum of one day.
  • Conventional error report - this requires a manual review by the Mirakl-based marketplace, and not all do so. It can take several days for this report to be imported.

Note that the previous feedback report is not removed from ChannelEngine until both the latest transformation and conventional reports have been fully processed by ChannelEngine – or no new reports have been generated because there are no errors to report.