> For the complete documentation index, see [llms.txt](https://helpcenter.channable.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://helpcenter.channable.com/list-advertise/bol/list-items-on-bol/how-to-set-up-a-bol-channel/importing-your-existing-bol-product-data-into-channable.md).

# Import existing bol product data into Channable

Learn how to export your live bol listings and import them into Channable, so your first channel run doesn't delete them.

When you run a bol channel for the first time, bol deletes any of your live listings that the channel doesn't include. If you already sell on bol, import those listings into Channable before your first run so they stay online.

### <i class="fa-memo-circle-check">:memo-circle-check:</i> Before you start <a href="#before-you-start" id="before-you-start"></a>

**You'll need**

* A bol seller account with live listings.
* A Channable project.
* A Google account, to put the file online with Google Sheets.

**Good to know**

* Bol lets you download up to 150 products at a time. If you have more, you'll download several files and combine them.
* If you already import product data from your webshop, you don't need to replace that import. Add the bol file as a second import and [combine the imports](https://helpcenter.channable.com/import-data/import-how-to/combine-multiple-imports).

***

{% stepper %}
{% step %}

### Download your listings from bol

1. Sign in to your bol seller account.
2. Go to **Artikelen** > **Mijn artikelen**. You'll see your current listings, including their status and details.
3. Select the products you want to export. You can select up to 150.

<figure><img src="https://3067532480-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FF8GepmoSonQRG6RnHOxJ%2Fuploads%2Ffv7jmlyoC5UF10YuPRVu%2Fmceclip4.png?alt=media&amp;token=36711acf-f9a9-4889-95f2-03cdfc80d55a" alt=""><figcaption></figcaption></figure>

4. Click **Bewerk productinformatie**.
5. Click **Download Excel-bestand**.

<figure><img src="https://3067532480-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FF8GepmoSonQRG6RnHOxJ%2Fuploads%2Ft0tBvnmd9XGFxlxHNXws%2Fmceclip8.png?alt=media&amp;token=b2949d86-e836-40a8-bf67-d67f9a3b69d7" alt=""><figcaption></figcaption></figure>

If you have more than 150 products, repeat steps 3 to 5 until you've downloaded all of them.
{% endstep %}

{% step %}

### Prepare your file

1. Upload the file to Google Drive and open it with Google Sheets, or upload it to other spreadsheet software. If you downloaded several files, paste all rows into one sheet.
2. Make sure the first row contains the column names. Delete any rows above it.
3. Check that the sheet has columns for the attributes your bol channel needs in the **Item** section: **EAN**, **Stock**, **Price**, and **Title**. If a column is missing, add it and fill it in.
   * Make sure that every row has an EAN. Bol only accepts products with an EAN.
4. [Share the sheet](https://helpcenter.channable.com/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets/share-a-google-sheet-make-publicly-available.md) so anyone with the link can view it.
   {% endstep %}

{% step %}

### Import the file into Channable

1. In Channable, open your project.
2. Go to **Setup** > **+ Setup import** or [**Combine import**](https://helpcenter.channable.com/import-data/import-how-to/combine-multiple-imports.md).
3. Select the **Google sheets** file type.
4. For **Name**, enter a name that tells you what the import contains, such as "bol existing listings".
5. For **Google sheets url**, paste the URL of your sheet.
6. Click **Start import**.
7. On the **Edit mapping** page, check that the EAN column is linked to the `ean` project field, then save your mapping.

For details on each setting, see [Import from Google Sheets](https://helpcenter.channable.com/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets.md).
{% endstep %}

{% step %}

### Set up a bol channel

Continue with the steps in:

{% content-ref url="/pages/9c28552f4ad6430eee95bc2d58df137888ffa45d" %}
[How to set up a bol channel](https://helpcenter.channable.com/list-advertise/bol/list-items-on-bol/how-to-set-up-a-bol-channel.md)
{% endcontent-ref %}
{% endstep %}
{% endstepper %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://helpcenter.channable.com/list-advertise/bol/list-items-on-bol/how-to-set-up-a-bol-channel/importing-your-existing-bol-product-data-into-channable.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
