# Imports

Importing is currently only available on certain tables (eg. *Products* ).

![image.png](https://how-to-erp.dewesoft.com/uploads/images/gallery/2024-04/scaled-1680-/CHMimage.png)

**1**. On pressing the **"Import"** button, a form is shown, in the "**Upload** **file**" step, that expects file, of type excel or csv, with the required data, sorted into columns.

![image.png](https://how-to-erp.dewesoft.com/uploads/images/gallery/2024-04/scaled-1680-/VN7image.png)

**2**. After uploading a suitable file, the form moves to the "**Prepare Import**" step and displays all rows from the file.

![image.png](https://how-to-erp.dewesoft.com/uploads/images/gallery/2024-04/scaled-1680-/vPmimage.png)

Here, we can map every column in the file to a column in the ERP table. All required columns are marked with a red asterisk (<span style="color: rgb(224, 62, 45);">\*</span>). The checkboxes on the left allow us to only select some rows or remove certain rows, that we do not want to import.

**3**. Once you are done, click **"Import"** and the selected rows will be imported into the table. After successful import, you can review changes and close the form.

#### Product import:

Required fields:

product\_type\_id

short\_name

name

sku (if empty, SKU generator will fill up the data)

weight (must be present, can be 0)

example: https://docs.google.com/spreadsheets/d/1DhJW2IgTCOQIxHO15t\_zv0e6YHdAMoJ0e7mdVeIj1Pw/edit?gid=0#gid=0