Replace a bol.com offer with the v.2.3 Excel file

Which bol.com Excel file replaces the live offer?

It is the file from Items, then Manage offers via Excel, then Download under Download offers. If you have no offers yet, the article says the document is empty and you can fill it as a template. The workbook has two tabs. You edit the offer on the tab named bol item import help v2.3. The Explanation tab describes the columns. Only version v.2.3 is accepted for this upload. The version number is in cell A2, so download a new file rather than reusing an older workbook.

Save it as .xlsx. The file has to contain at least one item, or the upload fails. If offers are already online, this file overwrites them. The article’s example is 100 items online and a file of 100 items: only the 100 in the file stay online. Leaving a row out removes that offer. Add items in bulk is the upload the same article says adds to the range instead of replacing it.

Which fields does the offer tab require?

The article says an item can be put up for sale with an EAN, a Condition, a Stock, a Price, Fulfilment by, and a Deliverycode. The EAN is the 13-digit EAN or ISBN. Condition is new unless you sell second-hand items, and second-hand is only possible for media items. Stock is the quantity you have, and bol updates it when an item sells. Price is the selling price. Fulfilment by is you, or bol through Shipping via bol. Deliverycode is the delivery time.

Optional fields on the same tab are Reference, for your own code; Offer description, only as an explanation of a second-hand item; For sale, which the article says leaves the item for sale when the cell is blank; and Title, which is saved for an item bol does not know yet. The article recommends Title when you think the item is new to bol. It does not say Title is one of the minimum fields. It also does not print the header spellings or say which row holds them. Read those labels on the downloaded tab. Cell A2 is the version, not a product row.

How do you map a supplier file without dropping the rest of the offer?

1. Download the current offer from Manage offers via Excel. Check that cell A2 shows version v.2.3. If offers are already online, keep every offer you still want to sell in that workbook.
2. In Golanto, choose bol.com. Record that the file is Manage offers via Excel v.2.3, not Add items in bulk, plus the download date.
3. Map your columns onto EAN, Condition, Stock, Price, Fulfilment by, and Deliverycode on the bol item import help v2.3 tab. Leave the Explanation tab and cell A2 unchanged.
4. Leave For sale blank only when you want the item for sale. The article says a blank For sale cell puts the item up for sale. Include a Title when you believe bol does not know the item yet.
5. Upload the .xlsx under Upload your offer. The article says the status of the latest upload appears within half an hour, including rows processed, error messages, items created, and items modified. Download the feedback file for items that are not for sale.

Worked example

A supplier price row is not a complete bol.com offer

ean,price,stock
0950123456789,18.00,12

These headings are a supplier sketch. The English article also requires Condition, Fulfilment by, and Deliverycode before an item can be put up for sale. Type them on the bol item import help v2.3 tab of the file you just downloaded. Keep the 13-digit EAN as text. If offers are already online, a file that contains only this mug replaces the rest of the offer.

Official references

• bol Partnerplatform: Adding multiple items via Excel (opens in a new tab)

Schema review: bol-manage-offers-excel-v2-3-2026-11-01. Examples are synthetic. Store-specific and unpublished requirements are outside these checks.

Common questions

Continue reading

• Add bol.com items in bulk without replacing the offer
• Map a product file to a marketplace template
• Preserve leading zeros in SKUs and barcodes