--- title: Import of suppliers description: "If you need to create or update multiple Suppliers at once, this can easily be done via import.\nSee this guide for instructions." --- [Skip to content](https://helpdesk.rackbeat.com/knowledge/ht-00228#main-content) - [English](https://helpdesk.rackbeat.com/knowledge/ht-00228) - [Dansk](https://helpdesk.rackbeat.com/da/knowledge/ht-00228) - [Norsk – Norge](https://helpdesk.rackbeat.com/no-no/knowledge/ht-00228) English Show submenu for translations [Contact us](https://helpdesk.rackbeat.com/knowledge/kb-tickets/new?hsLang=en) Open main navigation Close main navigation - - [English](https://helpdesk.rackbeat.com/knowledge/ht-00228) - [Dansk](https://helpdesk.rackbeat.com/da/knowledge/ht-00228) - [Norsk – Norge](https://helpdesk.rackbeat.com/no-no/knowledge/ht-00228) English Show submenu for translations - [Contact us](https://helpdesk.rackbeat.com/knowledge/kb-tickets/new) - [AI Chat](https://chat.applai.io/chatbot/W5EFe14XJ8mW0OlrIzTS) [AI Chat](https://chat.applai.io/chatbot/W5EFe14XJ8mW0OlrIzTS) How can we help you? - There are no suggestions because the search field is empty. 1. [Helpdesk](https://helpdesk.rackbeat.com/knowledge?hsLang=en) 2. [TIPS & TUTORIALS](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en) 3. [Import](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en#import) # Import of suppliers ## If you need to create or update multiple Suppliers at once, this can easily be done via import. See this guide for instructions. See this guide on how to manually create Suppliers: [How to create Suppliers](https://helpdesk.rackbeat.com/knowledge/ht-00012?hsLang=en) Guide to general import setup in Rackbeat: [Import in Rackbeat](https://helpdesk.rackbeat.com/knowledge/ht-00194?hsLang=en) --- ### Table of Contents - [Creating new Suppliers](https://helpdesk.rackbeat.com/knowledge/ht-00228#creatingnew) - [What can be added/updated via import?](https://helpdesk.rackbeat.com/knowledge/ht-00228#whatcanbe) - [Updating existing Suppliers](https://helpdesk.rackbeat.com/knowledge/ht-00228#updateexisting) - [Supplier-specific prices](https://helpdesk.rackbeat.com/knowledge/ht-00228#supplierspecific) - [Contacts (references)](https://helpdesk.rackbeat.com/knowledge/ht-00228#contacts) - [Addresses](https://helpdesk.rackbeat.com/knowledge/ht-00228#addresses) We always recommend using the sample file. Go to:Purchases → Suppliers → Import / Export → Import → Sample file ![image-png-Sep-29-2025-01-18-20-1333-PM](https://helpdesk.rackbeat.com/hs-fs/hubfs/image-png-Sep-29-2025-01-18-20-1333-PM.webp?width=640&height=198&name=image-png-Sep-29-2025-01-18-20-1333-PM.webp) --- ### Creating new Suppliers How to create or update your Suppliers via import: 1. Click the **“Purchases”** tab → **“Suppliers”**. 2. Click **“Import / Export”** and select **“Import”**. 3. Click **“Select file”**. 4. Choose the CSV file to upload from your computer. Click **“Open”** and then **“Upload file”**. 5. Before uploading, you need to match the columns in the pop-up with the columns in your CSV file. See \[this guide\] for instructions. 6. Finish by clicking **“Import”**, and your Suppliers will be uploaded. To create new Suppliers via import, the following fields are mandatory: - **SupplierNo**: Enter the supplier’s unique number. - **Name**: The supplier’s name. - **Group**: The number of the supplier group the supplier belongs to. - **VAT Zone**: Indicate the VAT zone. 1 (Domestic), 2 (EU), 3 (Abroad), 4 (Domestic, without VAT). - **Payment Terms**: Enter the number of the payment terms to be used for the supplier. - **Currency**: Enter the currency using the code (DKK, EUR, USD, etc.). See the codes under *Company Settings – Currency*. - **Language**: Enter the supplier’s language using a language code, e.g., DA or EN. - **Layout**: Enter the layout number you want to use for the supplier. --- ### These fields can be updated via import: - **Address1**: The supplier’s address. - **Address2**: Second address line. - **Postal Code**: Postal code of the supplier. - **City**: Supplier’s city. - **Country**: Supplier’s country. - **VAT No.**: Supplier’s VAT number. - **Email**: Supplier’s email address. - **Phone**: Supplier’s phone number. - **Delivery Terms**: Enter the delivery terms number (can be found under *Settings → Delivery Terms*). - **Blocked**: Specify if the supplier is blocked. Enter “1” for blocked, leave empty or “0” for active. - **Payment Type** + **Payment Information**: \*Payment type and Payment information must both be filled out, for the import to work. - Payment Type: - +71 - +73 - +04 - Bank Transfer - IBAN - Entry Only - +75 - Payment Information: Enter details related to the selected payment type. - **Bank Account**: Supplier’s bank account number. - **Markup**: Supplier’s cost price markup percentage. When the file is ready, save it as **CSV UTF-8** and upload it to Rackbeat. If you used the headers above, the columns will be mapped automatically before import. --- ### Updating existing Suppliers To update existing suppliers via import, check **“**Update existing**”** after uploading the file. ![image-png-Sep-29-2025-01-38-31-1082-PM](https://helpdesk.rackbeat.com/hs-fs/hubfs/image-png-Sep-29-2025-01-38-31-1082-PM.webp?width=670&height=261&name=image-png-Sep-29-2025-01-38-31-1082-PM.webp) The file must include the SupplierNo column along with the column(s) you want to update. Example: To update Layout for suppliers, include: - **SupplierNo** - **Layout** --- ### Supplier-specific prices and product numbers If suppliers have unique prices or you want to specify their own product numbers, you can import these as well. 1. Click “Purchases”. 2. Click “Suppliers”. 3. Open any supplier (the file defines which supplier is updated). 4. Go to the “Products” tab in the supplier master data. Columns required for product data import: **Mandatory marked with \*** - **Supplier Nmber**: Supplier’s unique number. - **Product Number**: The product number the line applies to. - **Alternative Number**: Supplier’s product number (if different from yours). - **Cost Price**: Expected purchase price. - **Discount Percentage**: Specific discount rate from supplier. - **Enabled**: Enter “1” if product is active. - **Min. purchase quantity**: Minimum order quantity for the product. Save as CSV UTF-8 and upload to Rackbeat. #### Example: | SupplierNo | Productno | Alternative Number | Cost price | | --- | --- | --- | --- | | 1001 | 1375-1 | 2022 | 75 | | 1001 | 1375-2 | 2023 | 55 |   --- ### Notes You can import internal notes to suppliers. 1. Go to Purchases → Suppliers. 2. Open any supplier. 3. Go to the “Notes” tab. Columns required: - **SupplierNo:** Supplier’s unique number. - **Note:** The note text to be imported. --- ### Contacts You can import supplier contacts, used as “their reference.” 1. Go to Purchases **→** Suppliers. 2. Open any supplier. 3. Go to the **“**Contacts” tab. \**Columns required (mandatory marked with ):* - ***\*SupplierNo***: Supplier’s unique number. - ***\*ContactNo***: Contact person’s unique number (if not given, Rackbeat generates one). - ***Name***: Contact person’s name. - **Email**: Contact person’s email. - **Phone**: Contact person’s phone. - **Job**: Contact person’s role. --- ### Addresses You can import different billing addresses for suppliers, which can later be selected when creating orders/invoices. This is useful if a supplier uses one account but invoices are sent to different departments. \**Columns required for address import (mandatory marked with \*):* - *\***SupplierNo***: Supplier’s unique number. - ***\*Type*:** Address type (any/billing/delivery). - **Name**: Name of the billing address. - **Address1**: Street address. - **Address2**: Additional address line. - **Postal Code**: Postal code. - **City**: Supplier’s city. - **Country**: Supplier’s country. - **Phone**: Phone number. - **Email:** Billing email address. - [GETTING STARTED / SETUP](https://helpdesk.rackbeat.com/knowledge/getting-started-setup?hsLang=en#main-content) - [For new agreements](https://helpdesk.rackbeat.com/knowledge/getting-started-setup?hsLang=en#for-new-agreements) - [General Setup](https://helpdesk.rackbeat.com/knowledge/getting-started-setup?hsLang=en#general-setup) - [Add-ons](https://helpdesk.rackbeat.com/knowledge/getting-started-setup?hsLang=en#add-ons) - [Sales](https://helpdesk.rackbeat.com/knowledge/getting-started-setup?hsLang=en#sales) - [Products](https://helpdesk.rackbeat.com/knowledge/getting-started-setup?hsLang=en#products) - [Purchasing](https://helpdesk.rackbeat.com/knowledge/getting-started-setup?hsLang=en#purchasing) - [TIPS & TUTORIALS](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en#main-content) - [Export](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en#export) - [Import](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en#import) - [Rackbeat](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en#rackbeat) - [Reporting](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en#reporting) - [Frequently asked questions](https://helpdesk.rackbeat.com/knowledge/tips-tutorials?hsLang=en#frequently-asked-questions) - [RACKBEAT MOBILE APP](https://helpdesk.rackbeat.com/knowledge/rackbeat-mobile-app?hsLang=en#main-content) - [Sales](https://helpdesk.rackbeat.com/knowledge/rackbeat-mobile-app?hsLang=en#sales) - [INTEGRATIONS](https://helpdesk.rackbeat.com/knowledge/integrations?hsLang=en#main-content) - [Integration partners](https://helpdesk.rackbeat.com/knowledge/integrations?hsLang=en#integration-partners) - [Shopify](https://helpdesk.rackbeat.com/knowledge/integrations?hsLang=en#shopify) - [Woocommerce](https://helpdesk.rackbeat.com/knowledge/integrations?hsLang=en#woocommerce) - [Shipmondo](https://helpdesk.rackbeat.com/knowledge/integrations?hsLang=en#shipmondo) - [Webshipper](https://helpdesk.rackbeat.com/knowledge/integrations?hsLang=en#webshipper) - [Legacy integrations](https://helpdesk.rackbeat.com/knowledge/integrations?hsLang=en#legacy-integrations) - [The Rackbeat | e-conomic integration](https://helpdesk.rackbeat.com/knowledge/the-rackbeat-e-conomic-integration?hsLang=en#main-content) - [Valuation](https://helpdesk.rackbeat.com/knowledge/the-rackbeat-e-conomic-integration?hsLang=en#valuation) - [FAQ](https://helpdesk.rackbeat.com/knowledge/the-rackbeat-e-conomic-integration?hsLang=en#faq) - [Installation & settings](https://helpdesk.rackbeat.com/knowledge/the-rackbeat-e-conomic-integration?hsLang=en#installation-settings) - [Your Rackbeat agreement](https://helpdesk.rackbeat.com/knowledge/your-rackbeat-agreement?hsLang=en#main-content) - [Billing](https://helpdesk.rackbeat.com/knowledge/your-rackbeat-agreement?hsLang=en#billing) - [Account](https://helpdesk.rackbeat.com/knowledge/your-rackbeat-agreement?hsLang=en#account) - [Other](https://helpdesk.rackbeat.com/knowledge/your-rackbeat-agreement?hsLang=en#other) Rackbeat Helpdesk [Go to rackbeat.com](https://rackbeat.com/en/)         [Contact us](https://helpdesk.rackbeat.com/en/knowledge/kb-tickets/new?hsLang=da)