bol.com

The Dutch market bol.com is the leading online market in Benelux and offers many different products, including multimedia, electronics, toys, etc.

1. Registering with bol.com

Before setting up bol.com in plentymarkets, you have to register with bol.com .

2. Automated processes

Connecting to this market allows for the following automated processes to take place:

Offers:

stock synchronisation every 15 minutes
hourly price synchronisation
hourly synchronisation of delivery times, visibility of offers etc.
daily deletion of offers for deleted or deactivated variations

Orders:

order import every 15 minutes
hourly import of returns registered on bol.com
Note: Returns are imported with the status [9.00] by default.

3. Setting up bol.com in plentymarkets

Set up bol.com in plentymarkets to sell items on the market bol.com. There are two ways to set up the bol.com interface:

In the assistant Base settings - bol.com (How it’s done)
In the Setup » Markets » bol.com » Settings menu (How it’s done)
Note: You cannot link bol.com delivery times in the Setup menu. Go through the bol.com assistant to map delivery times with plentymarkets.

3.1. Setting up bol.com in the assistant

The basic settings for bol.com are carried out in the Setup » Assistants » Omni-Channel menu with the Basic settings - bol.com assistant. With this assistant, you set up your bol.com account in plentymarkets. You also carry out settings for warehouses and map plentymarkets delivery times with bol.com delivery times.

Carrying out settings in the assistant:

Go to Setup » Assistants » Omni-Channel.
Click on the assistant Base settings - bol.com.
Follow the instructions on the screen. If you need additional information about one of the options, expand the info box shown below this instruction ().
In the step Summary, check your settings to makes sure they are correct.
Tip: Click on the arrow in the step Summary () to show the settings.
If everything is as it should be, click on Finalise.
→ The settings are saved.

Options in the assistant

Setting	Explanation
Step Settings
Select the client that should be used to sell your items.	From the drop-down list Client, select a client. This client is used to generate the item URL in the catalogue and bol.com orders are assigned to this client.
Would you like to activate your bol.com user account?	Account not activated = The settings are saved but the data exchange with bol.com is not started. Account activated = Data exchange with bol.com is started once the assistant is completed. *Recommendation:* Check all settings before activating the user account.
Step Access data
Enter the API access data.	The API access data can be generated in the seller section at bol.com. Client ID (mandatory) = Enter the user ID for the API interface you received from bol.com. Client Secret (mandatory) = Enter the password for the API interface that you received from bol.com.
Step Warehouse
Select how stock for bol.com should be calculated.	Select the stock quantity for the offer export. Select one of the following options: Use stock quantity sum of all sales warehouses Use main warehouse of item Select warehouses = Select one or more warehouses. → The warehouses listed under Warehouses can be selected. Place a check mark to select a warehouse. *Important:* The option Warehouse selection affects the item export. If an item is not linked to the warehouses selected here, then this item will not be exported.
Step Delivery times
Link bol.com delivery times	Link one or more bol.com delivery times with delivery times saved in plentymarkets. The linked delivery times will be shown with your items on bol.com.

Setting

Explanation

Step Settings

Select the client that should be used to sell your items.

From the drop-down list Client, select a client. This client is used to generate the item URL in the catalogue and bol.com orders are assigned to this client.

Would you like to activate your bol.com user account?

Account not activated = The settings are saved but the data exchange with bol.com is not started.
Account activated = Data exchange with bol.com is started once the assistant is completed.
Recommendation: Check all settings before activating the user account.

Step Access data

Enter the API access data.

The API access data can be generated in the seller section at bol.com.

Client ID (mandatory) = Enter the user ID for the API interface you received from bol.com.
Client Secret (mandatory) = Enter the password for the API interface that you received from bol.com.

Step Warehouse

Select how stock for bol.com should be calculated.

Select the stock quantity for the offer export. Select one of the following options:

Use stock quantity sum of all sales warehouses
Use main warehouse of item
Select warehouses = Select one or more warehouses.
→ The warehouses listed under Warehouses can be selected. Place a check mark to select a warehouse.
Important: The option Warehouse selection affects the item export. If an item is not linked to the warehouses selected here, then this item will not be exported.

Step Delivery times

Link bol.com delivery times

Link one or more bol.com delivery times with delivery times saved in plentymarkets. The linked delivery times will be shown with your items on bol.com.

3.2. Setting up bol.com in the Setup menu

In the Setup » Markets » bol.com » Settings menu, you can carry out the basic settings for bol.com. However, note that bol.com delivery times cannot be mapped in this menu. Go through the bol.com assistant to map delivery times with plentymarkets.

Setting up bol.com in plentymarkets:

Go to Setup » Markets » bol.com » Settings.
Carry out the settings. Pay attention to the explanations given in Table 1.
Save () the settings.
→ The settings are saved.
Go to Setup » Assistants » Omni-Channel.
Click on the assistant Base settings - bol.com.
Navigate to the step Delivery times.
Link one or more bol.com delivery times with delivery times saved in plentymarkets.
Complete the assistant.

Table 1. Basic settings for the market bol.com
Setting	Explanation
Activate the automatic data exchange	If the data exchange is activated, offer and order data is exchanged with bol.com. For further information, refer to [processes].
Client ID	Enter the Client ID. The API access data can be generated in the seller section at bol.com.
Client Secret	Enter the Client Secret. The API access data can be generated in the seller section at bol.com.
Client	Select a client. Orders are assigned to this client during the order import.
Warehouse selection	Select the stock quantity for the offer export. Select one of the following options: Use stock quantity sum of all sales warehouses Use main warehouse of item Select warehouses = Select one or more warehouses. → The warehouses listed under Warehouses can be selected. Place a check mark to select a warehouse. *Important:* The option Warehouse selection affects the item export. If an item is not linked to the warehouses selected here, then this item will not be exported.

4. Activating the order referrer

An order referrer tags an order with the sales channel on which the order was generated. You also need to activate the order referrer in order to link items, characteristics etc. with bol.com. Go to Setup » Orders » Order referrer to activate the order referrer.

Activating the order referrer for bol.com:

Go to Setup » Orders » Order referrer.
Activate the option bol.com.
Save () the settings.

5. Setting the variation availability

Tip: The settings you need to activate in order to sell a variation on bol.com are described in the FAQ.

You need to activate all variations that you want to sell on bol.com. This is done in the Availability tab of a variation within the Item » Edit item » [Open item] » Tab: Variation ID menu.

Use group function or batch processing

You can edit the availability of several variations at once by using either the variation group function or batch processing.

Setting the variation availability for bol.com:

Go to Item » Edit item » [Open item] » Tab: Variation ID » Tab: Settings.
Open the variation that you want to sell on bol.com.
Tip: To sell all variations of an item on bol.com, carry out the settings for the item’s main variation. This activates the availability of all variations of the item.
In the Availability area, activate the option Active.
Click on the Availability tab.
In the Markets area, click in the selection field.
→ A list of all available markets is displayed.
Activate the option bol.com.
Click on Add ().
→ The market is added.
Save () the settings.
→ The variation is available for bol.com.

Note: All item data has to be in Dutch for bol.com.

6. Linking categories

Link your online store categories to the bol.com categories in order to display your items in these bol.com categories. Further items from the linked category are assigned automatically.

Linking categories:

Go to Setup » Markets » bol.com » Category link.
Click on Search ().
→ The Select category window opens.
Select the bol.com category that best matches your online store category.
Click on Apply.
→ The name and category path of the bol.com category are displayed.
If you know the name of the bol.com category, enter it directly into the Market category field to link it to your online store category.
Save () the settings.

7. Creating characteristics

Next, create characteristics and link these characteristics to the bol.com characteristics. Matching characteristics to a bol.com category can be found within the bol.com data model file. Download the bol.com data model file here .

Creating a characteristic:

Go to Setup » Item » Characteristics.
Click on the New characteristic tab.
Enter a name for the characteristic under Name (internal).
Select nl for Dutch from the Language drop-down list.
Enter the Dutch name that you want to use for this characteristic into the Name field.
Select the option Text from the Characteristic type drop-down list.
Enter the bol.com characteristic which can be found in the column Attribute name within the bol.com data model file into the line bol.com characteristic.
Save () the settings.

bol_fulfillment is a mandatory field for the offer export. This indicates whether the item is shipped by you or by bol.com. In the line bol.com characteristic, enter the bol.com characteristic bol_fulfillment.

If you want to sell used items on bol.com, you have to indicate this by using the property bol_used. In the line bol.com characteristic, enter the bol.com characteristic bol_used.

8. Defining a sales price

Proceed as described below to define a sales price for the order referrer bol.com. This price is displayed on bol.com.

Defining a sales price for bol.com:

Go to Setup » Item » Sales prices » [Open sales price] » Tab: Settings.
Activate the referrer bol.com.
Save () the settings.

9. Setting up the item export

This section explains how to transfer your items to bol.com. Items are transferred to bol.com with the elastic export. First, create the data format BolItemExport and then send the CSV file to bol.com.

The following fields are mandatory for the item export:

EAN
SKU
Name
Categories
Item description
Image
Manufacturer

Also note that item data has to be in Dutch for bol.com.

Setting up the item export:

Go to Data » Elastic export.
Click on New export.
Carry out the settings. Pay attention to the explanations given in Table 2.
Carry out further settings for item filters and format settings. Pay attention to the explanations given in table 2 on the Elastic export page.
Save () the settings.
→ The export format is given an ID and it appears in the overview within the Exports tab.
In the Data » Elastic Export » Tab: Exports menu, click on Download (arrow icon) to download the file that you have created.

Table 2. Settings for the item export
Setting	Explanation
Settings
Name	Enter a name. The export format is listed by this name in the overview within the Exports tab.
Type	Select the type item from the drop-down list.
Format	From the drop-down list, select the format BolItemExport for the item export.
Limit	Enter a number. If you want to transfer more than 10,000 data records to bol.com, then the output file is not generated again for another 24 hours. This is to save resources.
Provisioning	Select FTPS.
File name, server, Port, User name, Password, path	Enter a parameter. The access data including the password and user name are provided by bol.com. The file name is created based on the pattern <sellerID>.txt. You need to save the file in the folder /SQUARE/feed.
Transfer	Select daily as bol.com allows a maximum of 4 exports per day.

10. Activating the payment method

Activate the payment method Bol.com as described below.

Activating the payment method Bol.com:

Go to Setup » Orders » Payment » Methods.
Activate the option Also show inactive.
Open the folder International.
Click on Bol.com.
→ The Settings tab opens.
Carry out the settings. Pay attention to the information given in [table-payment-method].
Place a check mark next to the option Active.
Save () the settings.

Table 3. Settings for the payment method
Setting	Explanation
Language	The following options are saved for the language selected: Name, Info page, Info page (internal), Logo, and Upload logo. This enables you to enter values for these options in various languages. The values for a language are activated as soon as a buyer selects the language in the online store.
Name	Enter the name that should be displayed in the online store and on invoices etc.
Info page	Select a category page of the type content or enter the URL of a website to provide information about the payment method.
Info page (external)	If you selected the Info page (external) option under Info page, then enter the URL of the info page here.
Countries of delivery	Do not select a country of delivery. You cannot use the payment method in your online store. Therefore, this payment method is only activated in plentymarkets. It is not completely set up.
Logo	Select one of the following options for displaying the logo: Show standard logo = The logo that is saved in plentymarkets for this payment method is displayed. Do not show a logo = The logo that is saved in plentymarkets for this payment method is not displayed. Show upload logo = The options Logo view and Upload logo are displayed.
Logo view	If Show upload logo was selected from the Logo drop-down list, then the logo that was uploaded is displayed here.
Upload logo	If Show upload logo was selected from the Logo drop-down list, then upload an external logo here. Click on Upload files and select the logo that you want to upload for the payment method. Permitted data formats: GIF, PNG, and JPG.
Priority	Select the priority for displaying the payment method in the online store.
Costs: Flat rate or percentage	If the payment method results in additional costs, enter the percentage value or flat rate value. The selection depends on the conditions of your contract. *Important:* Do not enter a value into both fields. For further information, refer to the Statistics page of the manual. For an example of flat rate and percentage costs, refer to the Managing payment methods page.

Permitting the payment method in customer classes

Go to Setup » CRM » Classes to activate or deactivate permitted payment methods.
For further information, refer to the Permitting the payment method in a customer class chapter.

For further information, refer to the Managing payment methods page.

11. Automatically sending shipping confirmations

Set up an event procedure to automatically send shipping confirmations to bol.com when the outgoing items have been booked.

Setting up an event procedure

Go to Setup » Orders » Events.
Click on Add event procedure ().
→ The Create new event procedure window opens.
Enter a distinct name for the event procedure.
Select the event according to Table 4.
Save () the settings.
Carry out the settings according to Table 4.
Place a check mark next to the option Active ().
Save () the settings.

Table 4. Event procedure for automatically sending shipping confirmations to bol.com
Setting	Option	Selection
Event	Order change: Outgoing items booked
Filter 1	Order > Order type	Order
Filter 2	Order > Referrer	bol.com
Procedure	Shipping > Send shipping confirmation to bol.com

12. Automatically sending cancellations

Set up an event procedure to automatically inform bol.com of cancellations. Whenever you are dealing with cancellations, you need to send bol.com a reason for the cancellation. Open the System » Orders » Status menu and create additional order statuses as needed. The following cancellation reasons can be transferred to bol.com:

Out of stock
Cancellation requested by customer
Item is in a bad condition
Higher shipping costs
Incorrect price
Item not available in time
No bol.com warranty
Item ordered twice
Item retained
Technical issue
Item untraceable
Other

Setting up an event procedure

Go to Setup » Orders » Events.
Click on Add event procedure ().
→ The Create new event procedure window opens.
Enter a distinct name for the event procedure.
Select the event according to Table 5.
Save () the settings.
Carry out the settings according to Table 5.
Place a check mark next to the option Active ().
Save () the settings.

Table 5. Event procedure for automatically sending cancellations to bol.com
Setting	Option	Selection
Event	Status change: [8.1] Cancelled by customer
Filter 1	Order > Order type	Order
Filter 2	Order > Referrer	bol.com
Procedure	Order > Send cancellation to bol.com	Customer cancellation

13. Automatically sending the return status

Set up an event procedure to automatically inform bol.com of the status of a return. bol.com requests the status of returns. The following return statuses can be sent to bol.com:

Return received
Item will be exchanged
Return does not meet conditions
Item must be repaired
Customer keeps item
Return accepted after consultation with customer

Setting up an event procedure

Go to Setup » Orders » Events.
Click on Add event procedure ().
→ The Create new event procedure window opens.
Enter a distinct name for the event procedure.
Select the event according to Table 6.
Save () the settings.
Carry out the settings according to Table 6.
Place a check mark next to the option Active ().
Save () the settings.

Table 6. Event procedure for automatically sending return statuses to bol.com
Setting	Option	Selection
Event	New return
Filter 1	Order > Order type	Return
Filter 2	Order > Referrer	bol.com
Procedure	Order > Send return status to bol.com	Select a status.

14. Sending information on direct returns to bol.com

In addition, set up an event procedure to automatically inform bol.com about returns that customers sent back to you directly without registering the return with bol.com first. bol.com requests the status of returns. The following return statuses can be sent to bol.com:

Return received
Item will be exchanged
Return does not meet conditions
Item must be repaired
Customer keeps item
Return accepted after consultation with customer

Setting up an event procedure

Go to Setup » Orders » Events.
Click on Add event procedure ().
→ The Create new event procedure window opens.
Enter a distinct name for the event procedure.
Select the event according to Table 7.
Save () the settings.
Carry out the settings according to Table 7.
Place a check mark next to the option Active ().
Save () the settings.

Table 7. Event procedure to inform bol.com about returns
Setting	Option	Selection
Event	Status change: [9.5] Credit note created
Filter 1	Order > Order type	Return
Filter 2	Order > Referrer	bol.com
Procedure	Order > Create a return at bol.com	Select a status.

15. Viewing log entries

The Data » Log menu contains a history of processes that run via the bol.com interface. For bol.com, you can filter by the identifier bol.com.

Viewing the log:

Go to Data » Log.
From the drop-down list Identifier, select the option bol.com.
Tip: Identifiers are only shown in the drop-down list after the process has run at least once.
Optional: Select a date to only show entries from a specific period.
Click on Search ().
→ The results are shown.
Check all entries for the levels warning and error.
Tip: For further information about the log, refer to the Data log page of the manual.

Use the reference types and reference values listed in Table 8 to filter the search results:

Table 8. Reference types and reference values for bol.com
Reference type	Explanation	Reference value
action	Filters by events.	Select a reference type to filter for specific events. orderImport = Order import CreateOffer = Creation of offers CheckOfferStatus = Checking the successful creation of offers DeleteOffer = Deletion of offers UpdateOffer = Updating delivery time, delivery type (FBB, FBR), SKU and activity state of offers UpdateOfferPrices = Updating prices of offers UpdateOfferStock = Updating stock of offers CancelOrder = Cancellation of the order ShipOrder = Shipping of the order HandleReturn = Confirmation of receipt of a return announced on bol.com CreateReturn = Report receipt of a return not announced on bol.com
orderId	Filters by the order ID of the order in plentymarkets.
externalOrderId	Filters by the bol.com order number of the order.
externalOrderItemId	Filters by the ID of the bol.com order item.

16. FAQ

16.1. Requirements for listing offers on bol.com

Which settings have to be saved to sell a variation on bol.com?

In order to list your variations as offers on bol.com, the following settings have to be carried out:

Table 9. Mandatory fields for the variation
Mandatory data	Explanation
EAN or ISBN	An EAN or an ISBN must be saved for the variation. In the Setup » Item » Barcode menu, an EAN or ISBN must be created and linked to the referrer bol.com. The EAN must be added to the Settings tab of the variation in the Barcode area and a barcode code must be entered.
Price	A price must be saved for the variation. The sales price must be activated for the referrer bol.com in the Setup » Item » Sales prices. The sales price must be added in the Settings tab in the Sales price area of the variation. A price must be saved for the sales price.
Availability	The variation must be available for the market. In the Availability tab of the variation in the Markets area, the marketplace availabilities bol.com or bol.com FBB must be added. Referrer bol.com = You ship orders yourself. Referrer bol.com FBB = bol.com ships your orders.