Assign a private key

When you activate the Import Connector, the first step is to assign a private key. After that, you can configure how the connector should behave when it imports data into Sales Layer.

Overwrite when importing

Use this option when you want the data in Sales Layer to be overwritten with the content from the CSV file. With this setup, the CSV file acts as the source of truth and replaces the content inserted in the PIM.

If this option is not enabled, Sales Layer will only import the changes detected in the CSV file. Any change made in a field that was previously imported by the connector will remain unchanged if the value in the CSV does not contain changes.

If you only need to overwrite all content once, refresh the connector manually instead of changing the regular connector configuration.

Only import existing items

This option prevents the connector from creating new records.

When this option is enabled, Sales Layer will only update items where the reference in the CSV file matches an existing reference in the PIM. This is useful when you want to update existing products, variants, or categories without adding new ones by mistake.

Select the tables to import

In the next step of the connector setup, you can choose which tables the connector should update.

The available tables may include:

• Categories
• Products
• Variants
• Points of Sale
• Any table created in Custom Entities

Each table includes its corresponding fields. You can disable the tables you do not want to synchronize and keep only the ones you need.

The mandatory field used to link the imported data with an item in Sales Layer is the item reference. This reference allows the connector to identify whether each row should update an existing item.

Map the CSV fields

When mapping fields, take into account that the names are case-sensitive. The value entered in Name on Import must match the column name in the CSV file.

For example, if your CSV column is called Product Description, the field name configured in the connector must use that exact same name.

If the names do not match, the connector will not be able to import that column correctly.

Apply formulas during import

You can apply formulas when importing or updating items through the Import Connector.

For example, formulas can be used to:

• Change a product status when certain conditions are met
• Change the category assigned to a product
• Add or update labels
• Transform values from the CSV before importing them

Keep in mind that formulas can increase synchronization time, especially if they are complex or applied to many fields.

Import multi-language content

To import multi-language content, map the corresponding field in the connector and include the language in the CSV column name.

Use a colon followed by the language ISO code.

Example:

Product name:en Product name:de Product name:fr

Create one column per language in the CSV file.

The connector will import values in the languages configured in the Parameters tab of the channel. The field is mapped only once in the Output Data tab, and the import will be performed according to the values inserted in the CSV under each language column.

Use one CSV column in more than one field

If you need to import the same CSV column into two different Sales Layer fields, use the GET_COLUMN_VALUE formula.

This allows you to reuse the value from one imported column in more than one destination field.

Link the import file

The last setup step is to link the file for each table you want to synchronize.

You can do this by entering:

• A direct URL
• An FTP path
• An empty value, when the import will be performed through API

If you type ftp:, the connector will ask for the FTP username, password, and port.

FTP connections must use a certificate signed by a certification authority. Self-signed certificates are not accepted.

Server access requirements

The remote server must allow Sales Layer to access the CSV file.

If the server uses a firewall, the following Sales Layer IPs should be added to the whitelist:

• 52.16.19.36 and 34.252.100.48 for cloud.saleslayer.com
• 52.16.206.155 for api.saleslayer.com
• 52.16.132.188 for back process servers

Set the synchronization frequency

After selecting the file and the tables to synchronize, choose how often the connector should run.

For example, you can schedule the connector to run hourly, daily, or at another available frequency.

At the selected time, the file is added to the import queue. The import does not start immediately. It begins when the process reaches its turn in the queue.

CSV file requirements

Before linking your CSV file, review these requirements:

• The column names in the CSV must match the names configured in Name on Import.
• Column names are case-sensitive.
• The file name should not contain special characters, spaces, commas, quotes, or periods.
• If the CSV contains the same reference on more than one row, the connector imports only the first row and ignores the following rows with the same reference.
• API 1.18 supports large CSV files through both manual import and automated import via connectors.

Best practices

Before activating the Import Connector, test the CSV structure and confirm that references, column names, and field mappings are correct. Keep formulas as simple as possible, especially for large files. When importing multi-language content, use consistent ISO language suffixes in the CSV column names.