Adding product information for several articles via Excel

On this page you can read all about how product information is structured and how you can add this information to multiple articles simultaneously via Excel.

How is product information structured?

Good product information is important for successfully selling your product range via bol.com. In fact, this information helps the Customer to form a clear impression of a potential purchase. The more information that is known about an article, the more likely the Customer is to make a purchase. Also, your article will be more findable if its product information is complete – both within bol.com and via external search engines such as Google. However, not all information is equally essential and it is therefore useful to know what levels there are:

– Basic information: basic information necessary for a Customer to see what kind of article it is.
– Preparation for sale: minimum information required to put your article online.
– More findable: information that helps Customers find the article better. For example, this information is used in the filters on list pages.
– Higher conversion: additional information that helps Customers get an even better idea of the product.

How do you add information to several products simultaneously via Excel?

It is possible to add or change product information for several articles simultaneously via Excel. You do this by following the steps below:

1. Go to your offer

In the Supplier Portal, click on ‘Articles’ at the top and then choose ‘My Offers’.

2. Find the articles you want to edit

Find the articles whose product information you want to edit. This can also be done by typing the EAN, ISBN or title into the search bar.

3. Select several articles and click on 'Edit product information' in the top left-hand corner, then click on 'Edit via Excel' in the pop-up in the bottom right-hand corner.

4. Edit the file in Excel

Click on ‘Edit via Excel’ and make your changes to the downloaded file. You can find more information under the tab ‘Data definitions’. Save the file when you are done.

5. Upload the modified file

The supplier portal explains how to upload your saved file.

6. Check the report

After uploading your Excel file with added product information, you will receive a report in your Supplier Portal. Here you can see which articles have been successfully changed and which ones have not. You can review and correct the errors in the information that could not be processed.

7. And then... Please wait!

Additions or changes will be processed within 8 hours and will then be visible via bol.com. It is also possible that your changes are not visible on bol.com after 8 hours. This could be due to priority being given to existing or other new product information from other Suppliers or brands.