How to import user defined CSV files

Create a new CSV Mapping

Go to Channels and then to CSV Formats
Click Create to create a new CSV mapping
In the General Info tab, fill out some general information about the mapping.
Enter an ID and a name.
Select which type of data you want to import (typically products).
Upload an example file – this can be a smaller version of your original file with only a few rows.
Go to the File Preview tab.
Adjust the settings so that the preview below matches your CSV file.
Make sure all columns are displayed correctly, the header is recognized (if present), and the encoding is correctly set.
You may need to select CSV File Type = Custom to fine-tune the settings.
Now go to the Mapping tab and map the columns from your file to the PIM data model.
Select a column and click Map next to the field you want to map it to.
For attributes, prices, etc., you first need to create a new object by clicking the plus (+).
For some columns, you might want to add transformations, like converting a currency to uppercase letters.
Click Save to save the mapping.

Go to Channels and under the IMPORT section click on Manage
Click Create to create a new Channel
In the General Info tab, fill out the basic information.
Make sure to select the same Import Object, e.g., products.
Go to the Communication tab.
For manual imports, set Communication to Interactive.
Go to the Import Format tab.
Select Format: CSV, and under the Mapping System section choose CSV/Flat File Mapping.
Then select the CSV mapping you created earlier.
Click Save to save the channel.

Go to Channels and under the IMPORT section click on Execute
Select the channel you just created.
Upload the file you want to import by selecting it or dragging it into the upload section.
Optionally, configure what data to overwrite, what to use as defaults, and set the execution time or job name.
Click Run to execute the import.