Items Import from Excel

We recommend you to practice importing with our sample file before you import your own file. This will help you to understand what the import is like and feel confident when uploading your own file.

1. In the Kladana workspace, select Inventory → Products and Services.
2. Click Import and in the drop-down list, select Import from Excel.
3. In the opened window, click Excel-file sample.
4. When a sample file downloads to your computer, drag-and-drop it to the upload area.
5. Ensure that the header columns match the required fields to import the file correctly.
6. Select the company and warehouse to store your products.
7. Click Start Import.

You can check the import results in the Products and Services section.

Prepare your file for import

The importing process is sensitive to certain data columns in the table. To import data correctly, your file should comply with the following conditions:

• Contain the required column Name, without it nothing will be imported. If some of the product names in your table are not unique, your file should contain the SKU column. Otherwise, importing products with duplicate names will be incorrect.
• If you keep services among products, your file should contain the Type column. It defines whether an item is a product or a service.
• If you keep product variants, your file should contain the SKU column. It defines whether an item is a unique variant. Also your file should contain columns Feature: <Option> for each attribute your products have. It’s responsible for the correct importing of product variants.
• If you sell several products as packs, your file should contain UOM and Packaging:<UOM> columns. They are responsible for the measurement of your packing unit and the number of items in it.
• If you want to import product groups, your file should contain the Folders column. If your groups also have subgroups, write them in one string and split using forward slashes. For example, ″Branding/Accessorise″, where ″Branding″ is a parent folder and ″Accessories″ is a subfolder.
• If you want to upload images, your file should contain the Image column with direct links to these images. You can use any Image Hosting you like.
  If you want to add multiple images for a product or a variant, separate links to images with a semicolon.

If there is something unclear in the list of conditions, you can simply use the image below as the reference to properly prepare your data for import.

Import your file

Only when you’ve prepared your file the right way, you are ready to import it to Kladana. If your file is greater than 10 MB, split it into two parts and upload them in turn.

1. In the Kladana workspace, select Inventory → Products and Services.
2. Click Import and in the drop-down list, select Import from Excel.
3. Choose the file in the XLS or CSV format or drag-and-drop it to the upload area.
4. Ensure that data in the uploaded columns match the data type in the drop-down lists above them.
5. If you don’t want any column to import, in the drop-down list above this column, select Do not upload.
6. Select the company and warehouse to store your products.
7. Click Start Import.

The time required to complete import depends on the number of items in the products list. When the import finishes, you’ll get a notification.