What does the error look like in Channable?
With our Bol.com API you can easily send your products to Bol.com with their stock and pricing information updated every day. However, the first time you send your products to Bol.com (or when you have added new products that have not been sent to Bol.com before), you might get the "UNMATCHED_OFFER" error in the preview step of your Bol.com API. This means that you have to add these new products to the Bol.com EAN database, before our Bol.com API can send and update these products every day.
To find out if there are products that have to be added to the Bol.com database, first go to APIs on the left-hand side in Channable. Next, go to the Preview step of your Bol.com API, and click on the errors tab.
If you see the "Unmatched Offer" error here, this means that there are some products of which the EAN number is not yet known to the Bol.com database. Bol.com will only accept products from our marketplace for which the EAN number is added to the Bol.com database. This means that you have to add these EAN numbers along with the corresponding product information.
Bol.com seller account
In your Bol.com seller account you will also see an error for these products. In the products overview they will contain the message "Productinformatie zwak (offline)". Furthermore, the stock for these "Unmatched offer" products will be set to 0 since it is not possible to sell these products before adding the product information to the EAN database. The images of these products will also not be visible in Bol.com when the EAN codes are not known in the Bol.com EAN database.
How do I solve the error?
Step 1: Get a content FTPS account
To add this product information to Bol.com, you need to use their content FTPS solution to transfer this product information to Bol.com. With content FTPS we can send a content file with this additional product content to Bol.com, so that they can process it automatically. To make use of the content FTPS, you have to apply for a content FTPS account, Channable customers have to use the following form:
After filling in this form Bol.com will send you an email containing a user name and password for your content FTPS account. Then, you can add these credentials to the Bol.com connection. Go to 'Connections' via your name in the top right corner and edit your Bol.com connection.
Note: After Bol.com sends you the FTPS credentials, it can take 24 hours before the FTPS-account is ready to use. If you try to send information to the account before it is ready, an error will show: "SQUARE-map is missing". If you see the error, try to run the API now and then. The error message should disappear within 24 hours.
Step 2: Fill out the Categories and Attributes steps in your Bol.com API
Navigate to the Categories step in your Bol.com API and add categories to your products. You can use the generate categories function to help you setup the categories, or you can manually add categories. You can further check out the smart categorization feature to make the categorizing of your products even easier.
Navigate to the Attributes step in your Bol.com API and here you will see all the categories that you have set up in the Categories step. The attributes differ for each category, so make sure to go through them all using our attribute builder support article.
If you have filled out the categories and attributes in your Bol.com API, navigate to the APIs overview and run the API by clicking on the blue "Run now" button.
Step 3: Get the Bol.com feedback file
Now that you have sent your product information to Bol.com, they will review it and prepare a feedback file with any errors that are left. This process can take up to 48 hours, so don't be alarmed if you don't immediately see any changes in your Bol.com seller account.
If products are not visible in your Bol.com account after 48 hours the product information for those products is not complete enough according to the Bol.com standards and Bol.com will have created a feedback Excel-file that contains the specific errors for your products. You can request this file by sending an email to email@example.com. In the email please include your Channable account ID and your content FTPS user name. We will then send you your feedback file.
Step 4: Inspect the feedback file from Bol.com
Open the Excel file to find out what information needs to be changed or added in order to successfully add the refused products to the Bol.com database.
On the first page of the file you will see a description of how to work with the feedback. We advise you to read this page at least once before processing the feedback. On the bottom you will see different tabs that each mention a category which contains products with insufficient product information.
Clicking on a tab will provide you with an overview of the insufficient products. Here you can find red highlighted fields that show you which information is missing for each product. For example, the attributes "product breedte" and "product lengte" are missing for some products and are highlighted in red to show this.
Step 5: Optimize your data in Channable
Now that you have an overview of the missing or incorrect information navigate to your Bol.com API in Channable to fix the information. Use the rules to optimize your data and use our attribute builder support article as a guide to optimize the Attributes step in your Bol.com API.
After you have optimized the data in Channable, navigate to the APIs overview and run the API by clicking on the blue "Run now" button.
Step 6: Repeat until all errors are solved
It might be that one round of error solving does not solve all the "UNMATCHED_OFFER" errors. If you still see the "UNMATCHED_OFFER" error in the Preview step of your Bol.com API repeat step 3, step 4, and step 5 until the error has disappeared from the Preview.