Create a Bol.com instance in Odoo¶

To create your Bol.com instance in Odoo, navigate to Marketplaces ‣ Configuration ‣ Instance and click CREATE.

Name: Choose a meaningful name for your instance (e.g. Bol.com NL).
Marketplace: Select Bol.com from the drop-down.

Credentials¶

On the Credentials tab, enter the API credentials issued by Bol.com.

Client ID: Paste the Client ID generated from your Bol.com seller account.
Client Secret: Paste the corresponding Client Secret.

If you don’t have API credentials yet, follow Bol.com official guide:

Test the Connection¶

Click Test Connection.
If the credentials are valid, the connection will succeed.
If the test fails, Odoo displays: “Test Connection Failed: Invalid Credentials.” Verify the Client ID and Client Secret and that your Bol.com app has the required scopes.

Let’s begin with the instance configuration process for the Bol Odoo Connector. By following configurations you’ll be able to set up and customize the integration according to your business needs. Let’s get started!

Last Processed On¶

Last Processed On stores the date and time of the most recent successful execution of each operation (orders, stock, price, etc.).
These fields are typically set when Automatic Jobs run, and the connector uses them as the from date for incremental synchronization.

Configurations¶

Use Operation For: Select the fulfillment method. You can choose between FBR, FBB, or FBR & FBB.
Import Return for Status: Choose the type of returns you wish to import. You can select either Unhandled, or Handled.
Warehouse: This warehouse will be utilized for FBR orders and also for exporting stock to Bol.com.
FBB Warehouse: this warehouse will be utilized for FBB orders and also for importing stock from Bol.com.
Company: Choose company related to instance.
Log Level: choose which type of log level would you like to have. You can choose between All, Success, or Error. default to Error. The system will retrieve logs for each marketplace operation. To view the logs, navigate to Marketplaces ‣ Queues ‣ Logs
Queue Batch Limit: default to 100 records. we aren’t suggesting to change this.
Country and Language: Set the country and language context for the instance.

Note

To modify the Log Level, Queue Batch Limit, Country, Language, and API Fetch record limit?, activate the developer mode and navigate to Marketplaces ‣ Configuration ‣ Instance and click on Configuration tab.

Product Configurations¶

Sync Listings Based On: Parameter used to match Bol.com offers to Odoo products during sync. Choose Barcode, SKU, or Barcode or SKU.

Tip
Bol.com offers always have unique barcodes, so matching by Barcode is strongly recommended.

Pricelist: Pricelist used for price import and export. When the order currency from Bol.com matches the pricelist currency, the pricelist is applied to imported orders. Leave blank to let the connector create a default Bol.com pricelist.
Export Odoo Product’s Sale Price?: When enabled, the connector exports the product’s sale price directly, bypassing the configured pricelist. Disabled by default.
Create Odoo Products?: When enabled, the connector automatically creates a new Odoo product if no match is found via Sync Listings Based On.

Tip
If you already have existing products in your Odoo ERP system, it is not recommended to enable the Create Odoo Products? option in the Instance.
Managing Excluded Taxes on Odoo Product?: Enable this if you are managing excluded taxes on products.
Update Category in Odoo Products?: When enabled, the connector updates the product category in Odoo during offer sync.
Sync Listing Images?: When enabled, product images are synchronized from Bol.com to Odoo.

Default Offer/Product Settings¶

These defaults are applied when a new listing is created from an Odoo product.

Default Condition Category: Condition of the product on Bol.com. Options: New, Second hand, Refurbished. Default: New.
Default Condition State: Required when condition is Second hand. Options: As new, Good, Moderate, Reasonable.
Default Refurbished Grade: Required when condition is Refurbished. Options: A - near-mint, B - light scratches, C - low cosmetic quality.
Default Margin Adjustment: Enable for refurbished products where VAT was already paid (0% tax rate).
Default Fulfilment Schedule: Controls delivery promise shown on Bol.com. Options: My delivery promise, Shipping via bol, Bol delivery promise. Default: Bol delivery promise.
Default Min Days To Customer / Default Max Days To Customer: Delivery window in days. Default: 2 – 3.
Default Ultimate Order Time: Latest order time for next-day delivery promise (12:00–23:00). Required when min=0 and max=1.

Stock Configurations¶

Stock Based On: When exporting Inventory from Odoo to Bol.com, you can choose Free To Use Quantity, Quantity on Hand or Forecasted Quantity configuration based on your requirements, ensuring accurate inventory management between Bol.com and Odoo.
- Forecasted Quantity (Quantity on Hand - Outgoing + Incoming)
- Quantity on Hand (the exact physical stock currently in your warehouse)
- Free To Use Quantity (Quantity on Hand - Reserved Quantity)

Validate Inventory Adjustment?: The system automatically confirms the inventory adjustment after importing inventory data from Bol.com to Odoo. By enabling Validate Inventory Adjustment?, the inventory adjustment is automatically marked as validated without requiring manual intervention.

Orders Configurations¶

Use Marketplace’s Order Sequence?: Allows you to name orders in Odoo based on the Bol.com order number rather than using the default Odoo sequence. This ensures that the order names in Odoo correspond directly to the order numbers generated by the Bol.com platform, providing consistency and easier cross-referencing between Odoo and the Bol.com.
- Order Prefix: Allows you to specify a prefix that will be added to the names of imported orders. When importing orders from Bol.com to Odoo, the connector will automatically set the order name with the given prefix. This helps to easily identify and distinguish the imported orders in Odoo.
- Order Prefix (Fulfilment by Marketplace): Prefix for fulfillment by Bol.com (FBB) orders.
  
  Example
  if you set the prefix as BOL-, an order number/name “12345” will become BOL-12345 after importing.
Delivery Product (Only visible in developer mode): The product used to model the delivery charge for orders or while creating new delivery method.
Sales Team: By configuring this, you can ensure that all imported orders from Bol.com are automatically assigned to the specified default Sales Team in Odoo.
Salesperson: Select a salesperson who will be responsible for processing the orders received from Bol.com. It is important to ensure that the assigned user has sufficient access rights in Odoo.
Import Order After: You can import orders from Bol.com that have been generated after a particular date. By defining this date, any orders generated prior to the specified date will be skipped during the import process.
Analytic Account: The configured analytic account will be assigned to all sales orders created by the connector. This means that the Analytic Default Rule set up in Odoo will not be applied to Marketplace orders.
Create Single Invoice? (Only visible in developer mode): When enabled, the system will wait to create an invoice until all products within the order are fully ready to be invoiced, preventing multiple partial invoices for a single order.
Order Status (Only visible in developer mode): Filter orders by their fulfillment status at the time of Import Orders. default to OPEN.
Use Marketplace’s Order Currency?: When enabled, the order currency from Bol.com is used instead of the instance pricelist currency.
Discount Product: Product used to represent discounts on imported orders.
Payment Terms: Specify the default payment terms that will be automatically applied to all imported Bol.com sales orders.
Export Invoices to Bol.com?: Enable this feature to automatically export generated invoice PDFs back to Bol.com when an invoice request is received from a customer.
- Invoice Report: Select the specific Odoo PDF report template used to generate the invoice document.
- Invoice Export Delay (Days): Define the number of days the system should wait before exporting the invoice to Bol.com after the request is received.

Customer Configurations¶

Receivable Account: Allows you to specify the default account for receivables when creating customers. By setting this field to Account Receivable instead of the default account, you ensure that the receivable transactions, such as invoices and payments, associated with the customer are correctly accounted for in the Odoo.

Workflow Configurations¶

FBR Workflow & FBB Workflow: It enables the automatic processing of imported orders. This workflow automates various steps, including confirming orders, creating invoices, validating invoices, and registering payments.

Automatic Jobs Configurations¶

Automatic Jobs Configurations allow for the automation of various tasks related to exporting and importing data between Bol and Odoo. These jobs are scheduled to run automatically at specified intervals to keep the data synchronized and up to date. You can configure Interval Number, Interval Unit, and Active for each job. Here’s an explanation of each Automatic Job.
For each job, you can customize the Interval Number and Interval Unit (e.g., every 15 minutes, or every 1 day). Toggle the Active switch to enable or disable a job, or click the Run Manually button to execute a synchronization instantly.

Note

All scheduled jobs are created automatically when the instance is first saved. Use the Refresh button on this tab to recreate or update jobs if they are missing or misconfigured.

Important

Price Export Note: When executing the price export scheduled action, the system only updates the prices of variant type price rules within the configured pricelist. Additionally, the system will completely skip exporting product prices if the price is set to zero.

Available Scheduled Actions¶

Export Invoice to Bol
- Automatically exports generated Odoo invoice PDFs back to the Bol.com portal. This job only processes exports if the Export Invoices to Bol.com? configuration is enabled. It ensures that invoices are only sent if the order is fully invoiced, posted, and the configured export delay has passed.
Export Order Status/Tracking Information to Bol
- This automatic job enables the automatic export of order status and tracking information from Odoo to Bol.
- It ensures that the order updates, such as shipment status and tracking numbers, are reflected accurately in Bol.
Export Product’s Price to Bol
- This automatic job enables the automatic export of product prices from Odoo to Bol.
- Any changes in product prices in Odoo will be automatically reflected in the corresponding products on Bol.
- Pricelist will be used while exporting price to Bol.
Export Product’s Stock to Bol
- This automatic job the connector automatically exports the inventory levels of products from Odoo to Bol.
- It helps keep the product stock information synchronized between the two platforms, ensuring accurate stock availability on your Bol store.
- Stock Based On configuration will be used while export stock.
Import FBB Shipments For Open Order
- Automatically retrieves shipment and tracking details from Bol.com for open orders that are being fulfilled by Bol.com (FBB), updating the records in Odoo.
Import FBR & FBB Order
- Automatically fetches new customer orders from Bol.com and creates Sales Orders in Odoo. This process respects your Order Configuration and automatically triggers the automation steps defined in your Workflow Configuration.
Import FBR Shipments For Open Order
- Retrieves shipment updates from Bol.com for your open FBR orders (useful if shipments were manually processed via the Bol.com Seller Dashboard instead of Odoo).
Import Invoice Request
- Automatically periodically contacts Bol.com to check if any customers have explicitly requested a VAT invoice and links the request to the corresponding Odoo Sales Order.
Import LVB/FBB Product’s Stock
- Automatically pulls your FBB (Fulfillment by Bol.com) / LVB (Logistiek via bol.com) warehouse stock levels into Odoo. This process respects the Validate Inventory Adjustment? setting.
Import Returns
- Automatically fetches customer returns from Bol.com and processes them in Odoo based on the return status configured in your General settings.

Note

It’s highly recommended not to schedule all your processes to run at the exact same interval because it can consume a significant amount of your system resources. Instead, it’s recommended to gap between them. This helps ensure that your system resources are not overuse and can handle the workload more efficiently.

Notification & Alerts¶

Activity Configuration
- When a queue job line process fails, the system create an activity based on the specified configuration.
- By configuring Activity, Due Date In and Responsible the system can automatically generate an activity when a queue job line process fails. The activity will be assigned responsible person and categorized based on the specified type of activity. This helps ensure that appropriate follow-up actions are taken to address and resolve any issues or errors encountered during the Queue job process.
Smart Notification Configuration
- By configuring Smart Notification Configuration, users will receive timely updates regarding the success or failure of order processing and product imports. This helps them stay informed and take appropriate actions promptly when needed.

Confirming Instance¶

Once you are satisfied with the configuration, click the Confirm button. Upon pressing the Confirm button, your Bol Odoo Instance will be confirmed.
To revert a confirmed instance back to draft, click the Reset button.

The instance moves to Confirmed state. The connector is now ready to import offers, orders, returns, and invoice requests, and to export stock, prices, tracking information, and invoices.