> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/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).

# Importing items

There are several ways to **add items** to Robaws, and one of them is the **import of an item list**.  You can also [update existing items in bulk](https://support.robaws.com/en/article/updateby-general-explanation-1et1kir/), for example to adjust prices.  The item import is a little more complex than the import of other modules, because there are a great many options.  

*Navigate quickly to:*
* [Adding items](#2-adding-items)
* [Importing an item list](#2-importing-an-item-list)
* [Filling in the import template correctly](#2-filling-in-the-import-template-correctly)
* [Overview of the additional tabs](#2-overview-of-the-additional-tabs)
* [Need help?](#2-need-help)

||| Be careful when importing, we can only roll back an import in a limited number of cases!  Always test this on staging.robaws.com first!

| Make sure you also read the [general information about data import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) in Robaws.

## Adding items

If you want to add items to Robaws, you can do so by:
1. [importing the items from a webshop](https://support.robaws.com/en/article/importing-items-from-a-webshop-1apt251/) (advantage: the webshop can update the prices daily)
2. [importing the items from an item list](#2-importing-an-item-list) in Excel (this is explained further below)
3. [entering the items manually](/en/article/items-general-rkvihx/) in Robaws, one by one

Before you start an item import, it is important to understand the [options of the item card](/en/article/items-general-rkvihx/) properly.

## Importing an item list

To import items into Robaws, you take the following steps:
1. Collect your items in an Excel file.  You can sometimes get an item list from your supplier to work from.
2. Complete this Excel yourself with, for example, your margin and selling price.  
3. You then copy this data into [the Robaws import template](#2-filling-in-the-import-template-correctly).
4. [Import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) this Robaws template.
 

## Filling in the import template correctly

You find the Robaws import template in settings > import > download template.  
The item import is **always based on the 'articles' tab**. In addition, you can use the **other tabs** to add extra information, depending on how you work.

#### Tab 'articles'

The **'articles'** tab contains the general information of the item.  This tab covers the fields in Robaws that are found under:
* Item data (except stock lines and alternative units)
* Selling price
* Cost price 
Have a look at the [overview of the column titles](https://support.robaws.com/en/article/importing-items-column-titles-1kiqq33/#2-tabblad-articles) and the field that is meant in Robaws, so you can fill in this tab correctly.

#### Filling in the additional tabs correctly

Depending on how you work in Robaws, you can fill in several additional tabs, always in combination with the 'articles' tab.  On every additional tab you have to reference the 'articles' tab to indicate which item this information belongs to. 

1. fill in the 'articles' tab
2. give all your items a unique number in the 'NR' column (without unique numbering you cannot import additional tabs!)
3. fill in the additional tabs starting with 'article' that you want to use correctly (see below)
4. on these additional tabs, reference the unique number from the 'articles' tab.  You do this in the column provided for it, see below.  You can sometimes fill in several lines that reference the same item number (for example entering 3 suppliers for one item)

## Overview of the additional tabs

#### Tab 'article suppliers' (item suppliers)

Item suppliers are used to link a supplier's purchase price to an item. You can have several item suppliers for 1 item. 

**Reference**: add the same value in the ARTICLENR column (tab 'articlesuppliers') as in the NR column (tab 'articles')
Have a look at the [overview of the column titles](https://support.robaws.com/en/article/importing-items-column-titles-1kiqq33/#2-tabblad-articlesuppliers) and the field that is meant in Robaws, so you can fill in this tab correctly.

#### Tab 'articlestocklocation' (stock locations of the item)

This lets you enter the details per [stock location](https://support.robaws.com/en/article/the-difference-between-a-stock-location-and-a-stockplace-16851e1/) for this item.
**Reference**: add the same value in the ARTICLENR column (tab 'articlestocklocation') as in the NR column (tab 'articles')

#### Tab 'articlesalesunits' (alternative sales units)

On this tab you can import [alternative sales units](https://support.robaws.com/en/article/working-with-unit-types-1gs3057/#2-alternatieve-verkoopeenheid) for your item.
**Reference**: add the same value in the ARTICLENR column (tab 'articlesalesunits') as in the NR column (tab 'articles')

#### Tab 'articleadditionallines' (additional line items)

If you want to insert additional line items on an item, you can do so on this tab.  Please note, the additional line items (= items) have to exist in Robaws already!
**Reference**: add the same value in the NR column (tab 'articleadditionallines') as in the NR column (tab 'articles')

#### Tab 'articlecomposites' (composite items)

Please note, this is [only for assembly items](https://support.robaws.com/en/article/composite-items-1goh0xk/)!  **Not to be confused with posts**!
The components (= items) have to exist in Robaws already.

**Reference**: add the same value in the NR column (tab 'articlecomposites') as in the NR column (tab 'articles')
Have a look at the [overview of the column titles](https://support.robaws.com/en/article/importing-items-1gvm4jz/#2-samengestelde-artikelen) and the field that is meant in Robaws, so you can fill in this tab correctly.

##### Tab 'articlemaintenanceschedules' (maintenance template)

For each item, enter straight away which [maintenance template](/en/article/service-and-maintenance-1dkuidy/) applies.  Please note, this only works in combination with item type 'installation'.
**Reference**: add the same value in the ARTICLENR column (tab 'articlemaintenanceschedules') as in the NR column (tab 'articles')

#### Tab 'articletierprices' (tier prices and prices per price group)

Use this tab if you want to set different selling prices for one item, depending on the number of units bought ([tier prices](https://support.robaws.com/en/article/tier-prices-1qiz3c/)) or on the type of customer ([price groups](https://support.robaws.com/en/article/price-groups-1hdocy/)).

**Reference**: add the same value in the ARTICLENR column (tab 'articletierprices') as in the NR column (tab 'articles')
Have a look at the [overview of the column titles](https://support.robaws.com/en/article/importing-items-column-titles-1kiqq33/#2-tabblad-articlestierprices) and the field that is meant in Robaws, so you can fill in this tab correctly.

## Need help?

If you have a question about this explanation, [contact our support colleagues](https://support.robaws.com/en/article/asking-for-help-1ssy1xw/#2-functionele-vragen).

Robaws does not offer support to draw up your item list, complete it and place it in the correct tabs.  If you need help with this, you can call on [an external service provider](https://support.robaws.com/en/article/asking-for-help-1ssy1xw/#2-nood-aan-extra-handen) that we can put you in touch with.

On request, Robaws can carry out an import for you against payment.  Contact us about this via customer@robaws.com.  
Please note: we make **no changes** to the Excel and carry out **no data check**, the data supplied is imported exactly as you have supplied it.