# Profiles

## How to start

To start drag'n'drop an XLS or XLSX file, or click to browse for it.

<figure><img src="/files/w77eY4AlhTez9Ie0HvuJ" alt=""><figcaption></figcaption></figure>

Wait for a file to be fully uploaded.

<figure><img src="/files/44jcqTCB9g8sCp6TbeVt" alt=""><figcaption></figcaption></figure>

In case of an error, you will be notified about it.

<figure><img src="/files/jFnRSxKtxyWtych7iJyp" alt=""><figcaption></figcaption></figure>

Then click on the *Configure import* button (if the pop-up/modal window does not automatically appear.

<figure><img src="/files/bTdvdgtfGsiSjHpvlxMh" alt=""><figcaption></figcaption></figure>

## Configuration

Select the row with column titles (multiple sheets are supported, but import can only be done from one per profile). If an empty or incompatible row is selected, it will be colored red, and a small error icon will appear on the right side of the window.

<figure><img src="/files/IPIFfWltQq3R4hIBkgDW" alt=""><figcaption></figcaption></figure>

Multiple columns with the same name are not supported. If you see that message, you need to quit the process, make changes in the source file,  and start all over again.

<figure><img src="/files/2SUmDO8hFbyLpw5roZfc" alt=""><figcaption></figcaption></figure>

&#x20;Columns without names will not be imported.

<figure><img src="/files/tqGys88SCRdWWSSgduNz" alt=""><figcaption></figcaption></figure>

Click on the Next step button to proceed.

<figure><img src="/files/eluE4qAsJ7oYoUYq1caX" alt=""><figcaption></figcaption></figure>

From the left panel, choose options that are right for you (some will be only visible if applicable).&#x20;

<figure><img src="/files/fLeZuME9tu7gUXy4SpPb" alt=""><figcaption></figcaption></figure>

* **Language** - choose the language to insert data into (only one language in the profile is supported)
* **Error processing** - decide how the system should behave when errors occur
* **Template for new products** (only shows up when the "Update only existing product option" is not chosen ) - choose the template that is used for new products
* **Import products** - choose the system behavior for a product import

## [Auto-SKU](/system/settings/sku.md)

**How should newly created products behave when importing products with a custom attribute identifier (e.g., EAN attribute)?**

{% hint style="info" %}
**Occurs in the configuration:** Add new & update existing and Add only new products.
{% endhint %}

<table data-header-hidden="false" data-header-sticky><thead><tr><th>Auto-SKU feature</th><th>System SKU</th><th>Effect for new products</th></tr></thead><tbody><tr><td>✅ Enabled</td><td>❌ Is not mapped</td><td>New products will be imported with SKUs generated by the system</td></tr><tr><td>✅ Enabled</td><td>✅ Is mapped</td><td>New products will be imported with SKU numbers assigned from the imported file</td></tr><tr><td>❌ Disabled</td><td>❌ Is not mapped</td><td>New products will not be created (SKU is required)</td></tr><tr><td>❌ Disabled</td><td>✅ Is mapped</td><td>New products will be imported with SKU numbers assigned from the imported file</td></tr></tbody></table>

**How should the system behave during import with a custom attribute (e.g., EAN) specified as an identifier, when SKU has also been mapped?**

{% hint style="info" %}
**Occurs in the configuration:** Update only existing products.
{% endhint %}

| System SKU      | Effect for updated products                                                                                                                                                                              |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ❌ Is not mapped | Product updates proceed as usual.                                                                                                                                                                        |
| ✅ Is mapped     | The system must additionally verify whether the value of the specified Identifier (e.g. EAN) in the product, matches the value of the mapped SKU (the imported SKU must be the same as the product SKU). |

## Mapping

Now, map the columns from the file to entities in Ergonode. Depending on the type of entity, some extra options may appear.

{% hint style="info" %}
Depending on the settings, products, categories, and attribute options can be set to create them if they are missing in Ergonode.
{% endhint %}

| Option                                     | Description                                                                                                                                                                                                                                                       |
| ------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Map to codes                               | Tries to match value from the file to attribute code, if the "Create new if... " option is on, creating a new one if not matched                                                                                                                                  |
| Map to translation                         | Tries to match value from the file to attribute translation, if the "Create new if... " option is on, creating a new one if not matched                                                                                                                           |
| Create a new if it cannot be mapped to ... | If on, creates a new value/option/category when not matched                                                                                                                                                                                                       |
| Identify product by this column            | It's possible to identify the product not only by SKU but also by other values, this option defines it (only some attribute types are supported, if the attribute type is not supported this option will not appear)                                              |
| Folder path                                | Appears when an attribute type is file, gallery, or image. If a typed path does not exist it will be created. It's possible to use variables here. Please remember that all system type attribute begins with "esa" Ex: System attribute SKU has a code #esa\_sku |

<figure><img src="/files/i0vBiW4AR7r9YnVU15eY" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/01EEl2pWdKRZj9200aZK" alt=""><figcaption></figcaption></figure>

If an attribute has a name, it will be displayed by default. To see the attribute code, hover the mouse over it.

{% hint style="info" %}
The Globe icon indicates that this attribute is of the global type.
{% endhint %}

<figure><img src="/files/8y1mwkreEM3g0duiJonj" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You may use the *Map automatically* option to ask the system to map columns with entities that have the same name.&#x20;
{% endhint %}

<figure><img src="/files/IMvgK2t8MYPuTPoBbg73" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/49nRJOWz7rwulHISJD7h" alt=""><figcaption></figcaption></figure>

Mapping progress is indicated by the progress status. Not all columns need to be mapped.&#x20;

<figure><img src="/files/0FOl2iVDfBjUbGM9YdaX" alt=""><figcaption></figcaption></figure>

It's possible to ignore a column from the import; to do so, click on the slider to deactivate.

{% hint style="warning" %}
If a column is deactivated, it will be automatically removed from the import profile upon saving or importing.&#x20;
{% endhint %}

<figure><img src="/files/fmjua9xuwtKlRNLD0fUo" alt=""><figcaption></figcaption></figure>

## Saving  the profile

If your import profile is complete, you may save it for later use. To do so, click on *Save profile,* type the profile name, and click *Save profile.*

<figure><img src="/files/lKUGQpHM8KjgNQTnckhk" alt=""><figcaption></figcaption></figure>

Success will be indicated with a message.

<figure><img src="/files/9cgPlrX9YaXEyWmxMuTR" alt=""><figcaption></figcaption></figure>

In case of a situation where not all attributes are mapped (and are not set as disabled), you will be displayed a confirmation message.

<figure><img src="/files/C7BPsDHPMM0ZGGmcyavT" alt=""><figcaption></figcaption></figure>

Clicking *Ignore columns and continue* to save it anywa&#x79;*.* Clicking *Cancel* will abort the process and highlight unmapped columns.

<figure><img src="/files/WtLxzFshJ2RZDTugoOK0" alt=""><figcaption></figcaption></figure>

## Importing the data

When configuration and mapping are set and done, it's time to start importing the data. To do so, click on the *Import now* button in the upper right-hand corner, and confirm the intent.&#x20;

&#x20;

<figure><img src="/files/IKLAkjS348CpIq5le0r3" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/fNRxz5oQbo2gs1drOiVi" alt=""><figcaption></figcaption></figure>

&#x20;  If succeed you will see a confirmation message.

<figure><img src="/files/niTjCoxxikEdZDtDZzY1" alt=""><figcaption></figcaption></figure>

In the case when not all columns are mapped, a proper notification will be displayed.

<figure><img src="/files/NoBw8pQn0svTfQTi6zC1" alt=""><figcaption></figcaption></figure>

&#x20;Click *Ignore and continue* to start the import process anyway, or *Cancel* to abort. If aborted unmapped columns will be highlighted.

<figure><img src="/files/GeVBBYYrt5xvc5iU7dbE" alt=""><figcaption></figcaption></figure>

## Editing the profile

Saved profiles can be edited. To do so, click on the 3 dots menu and choose *Edit profile*.

<figure><img src="/files/CjKzj3bBggfCnuLexZW3" alt=""><figcaption></figcaption></figure>

Now you will be presented with three tabs: [General](https://app.gitbook.com/o/-MYEHeJzjM7kDdfKkmLk/s/M9BbYBbDPiJapb75xJ2k/~/changes/261/data-exchange/product-importer/profiles#general), [File setup](https://app.gitbook.com/o/-MYEHeJzjM7kDdfKkmLk/s/M9BbYBbDPiJapb75xJ2k/~/changes/261/data-exchange/product-importer/profiles#file-setup), and Mapper.

### General

Used to change the name of the profile.

<figure><img src="/files/fBz1nXicCnYkz1AWlHst" alt=""><figcaption></figcaption></figure>

### File setup

This tab allows for changing selected sheets and the row where column titles are.

<figure><img src="/files/sEmmc353ljK4KUJzM7oJ" alt=""><figcaption></figcaption></figure>

### Mapper

This tab brings you back to the mapper.&#x20;

<figure><img src="/files/6Y7P0jxaEOndajmen9dc" alt=""><figcaption></figcaption></figure>

To delete a column in a saved profile, click on the *bin icon*.

<figure><img src="/files/y5ndEJIWkOHFbc1NtwU6" alt=""><figcaption></figcaption></figure>

Then confirm your intent.

<figure><img src="/files/VKk4C4nkQ7owy61V5CrL" alt=""><figcaption></figcaption></figure>

If succeded a proper message will be displayed.

<figure><img src="/files/rX7ctP8FCGswb01uwj6G" alt=""><figcaption></figcaption></figure>

## Upload a new file to the saved import profile

This can be done from two different places. The first one is straight from the *Saved profiles* list.&#x20;

<figure><img src="/files/8hhZ0WfdLdRC66EUznYa" alt=""><figcaption></figcaption></figure>

Or from the edit profile screen.

<figure><img src="/files/1BquJPPQmMlizpq6BYuH" alt=""><figcaption></figcaption></figure>

When clicked, a new window will show up. Drag and drop a file to it, or click to browse.

<figure><img src="/files/34WRZvuBPLDJBr9LpMWR" alt=""><figcaption></figcaption></figure>

The file uploading process will be indicated by the progress bar.

<figure><img src="/files/pxRSjpgGAkPXYSKLubuE" alt=""><figcaption></figcaption></figure>

When done, click on *Import now* to start the import or *Cancel* to abort.

<figure><img src="/files/1KMg9Nd8qwNejC7nYQRJ" alt=""><figcaption></figcaption></figure>

Successfully started import will be indicated with a proper message.

<figure><img src="/files/7MNknUM4D41NfJBMU0tT" alt=""><figcaption></figcaption></figure>

## Delete the saved profile

On the *Saved profile* list, click on the *three dots menu* and select the *Delete profile* option.

<figure><img src="/files/EROwx4042cJOuq3kCzVl" alt=""><figcaption></figcaption></figure>

This can also be done when in profile edition mode.

<figure><img src="/files/IxUN1CY2bn65caUgHZ6f" alt=""><figcaption></figcaption></figure>

Confirm your choice.

<figure><img src="/files/6FiwZ7m0WpDj7bKuqTzm" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://usermanual.ergonode.com/data-exchange/product-importer/profiles.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.