With our Bol.com marketplace 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 "unknown EAN code" error in the preview step of your Bol.com marketplace. This means that you manually have to add these new products to the Bol.com EAN database, before our Bol.com marketplace 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 Marketplaces on the lefthand side in Channable. Next, go to the "Preview" step of your Bol.com marketplace, and click on the errors as shown below:
If you see the "Unknown EAN code" error in the next screen, 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 manually have to add these EAN numbers along with the corresponding product information.
Step 1: Download content.txt
To make this process as easy as possible, our Bol.com marketplace generates a content.txt file on the right-bottom side of the screen that contains this product information. You can download this file by clicking on it:
Step 2: Log in to Bol.com
The context.txt has to be uploaded through your Bol.com selling account in order to add the new products to their database. To do so, first go to www.bol.com/sdd/login.bol and log in to your account:
Step 3: Go to the content upload screen
When you are logged in to your Bol.com selling account, go to the following website:
Step 4: Upload the content.txt file
You should now see the following screen:
In this screen you click the button: "Bestand kiezen", which takes you to the screen in which you select the content.txt file that you've downloaded from Channable:
Step 5: Bol.com product information requirements
Once you have opened the content.txt file, Bol.com starts processing the product information and EANs that is inside of it. After a few moments Bol.com will show you an overview of how many products have succesfully been added to the product database and how many couldn't be added to the database. The products that were succesfully added should be visibile in Bol.com after 2 working days.
Most of the time a part of the products could not be added to the Bol.com database. This happens because the product information for those products is not complete enough according to the Bol.com standards.
If you click on "Fouten bekijken & corrigeren" you can download an Excel file which shows you the product information that is missing or invalid per product.
Step 6: Inspecting the errors
Now open up 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. The Excel file should look similar to this one:
The first page you should see in the page above. On top, you get a description of how this file works, which we would advise you to read once. On the bottom you should see one or more tabs for different categories of your products. These tabs contain the products that have been rejected because the product information for these products is not sufficient. Click on a tab to get an overview like this:
Here you can find red highlighted fields which show you which information is missing for each product. In the example above the attribute "product breedte" is mandatory for this type of products. The next step is to add the missing attributes for these products in Channable.
Step 7: Adding attributes in Channable
In the Build fase in your Bol.com marketplace, you can add the attributes required by Bol.com. In the Build fase, go to the tab "Attribute builder".
In the attributes section you will get an overview of your different categories which have their different attributes. Here you can select the category for which you would like to add attributes. After selecting the right category an overview will appear. The red fields are demanded, whereas the grey fields are optional. Make sure to have filled all the demanded fields in the right way - if an invalid value is given the field will stay red.
In the image above you can see that there are a few red fields. We can fill these by adding an attribute value.
Click on the attribute wanted, for example 'Kledingmaat':
In some cases you want to send the same value for this attribute for every product. In that case you can simply type the value you want to send through in the field "Attribute value".
However, inmost cases the information you need to add is different for each product and therefore typing a static value in "Attribute value" is not good enough. In this case it is better to choose a field from Channable that contains the right information. You can do this as shown below:
Make sure that you have a field generated (edit mapping) and filled (rules) if this field is not automatically available from your import feed or connection with your webshop. It is important that the field you select here contains the information you want to add to the selected attribute. You can always check this by going to "Products" on the left menu of Channable and searching the product that you need to add this attribute for. Just click that product and find the field you have selected to see if it contains the right information. If it doesn't contain the right information, you could go to the Rules section in the Bol.com marketplace to add the right information to the selected field (feel free to contact our support team if you don't know how to do this).
By clicking on the 'plus' you will get a dropdown where you can select the field that you want to add as an attribute:
After adding the attribute you will automatically see the effect in our system:
Step 8: Running the marketplace and uploading content.txt again
Once you have added all attributes that were shown in red in your Bol.com preview, you can go to Marketplaces in Channable and click "Run now" on the Bol.com marketplace and wait for it to be finished. The content.txt file will now be updated with the right attributes, which should result in your products being accepted for the Bol.com database.
The final step is to download the new content.txt file and upload it again to Bol.com (see steps 2-5).