> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.bottlebooks.me/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to Manage Reference Codes

Reference Codes are a unique internal identifier that you assign to each exhibitor/member or supplier in your Bottlebooks account. These codes are especially useful for aligning data between Bottlebooks and your internal systems or workflows.

If needed, Bottlebooks also supports assigning 2 reference codes to the same partner if, for example, they appear in different systems or have multiple identifiers.

You can import Reference Codes in bulk using Excel.

1. Open your event registration.
2. On the **Partners** page, click on **Export list**. This will generate and export an Excel file containing your exhibitors' information.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/c/6/c/4c6c4ee4049c1800/screenshot-2025-06-12-at-17121_1kap0dv.png =650x243)

3. In the exported file, add a new column for/with the reference codes, next to Company Id.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/c/6/c/4c6c4ee4049c1800/screenshot-2025-06-12-at-17510_2oqh00.png =450x88)

4. Copy both columns (for all exhibitors).
5. Go back to Bottlebooks.
6. Open your event registration.
7. Go to **Settings**.
8. Click on **Admin tools** and then on **Import reference code**.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/c/6/c/4c6c4ee4049c1800/screenshot-2025-06-12-at-17203_1nh1aml.png =650x161)

9. On the text box, paste the data you've copied from the Excel file.
10. Tick the box stating your data has a header row.
11. Click on **Next step**.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/c/6/c/4c6c4ee4049c1800/screenshot-2025-06-12-at-17553_1ptiysm.png =650x273)

12. Assign the column headers to the proper fields.
13. Then, click on **Next step**.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/c/6/c/4c6c4ee4049c1800/screenshot-2025-06-12-at-17554_ppl08.png =650x263)

14. Review the information entered and, once satisfied, click on **Import**.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/c/6/c/4c6c4ee4049c1800/screenshot-2025-06-12-at-17561_13fiay1.png =650xauto)

15. Your import will be complete.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/c/6/c/4c6c4ee4049c1800/screenshot-2025-06-12-at-17354_fa6g5v.png =650x322)