Overview

When you receive a new data feed from a supplier, the column names often don’t match your system’s fields. Instead of manually matching “Product_SKU” to “Code” or “Retail_Price” to “Price”, you can use the smart mapping assistant to handle the heavy lifting.

The assistant analyzes your file and suggests the best matches for every column, saving you from tedious manual configuration.

How to auto-map a new feed

Follow these steps to upload your file and let the assistant suggest a mapping.

1. Open [navigate:/products/import|Import|upload] in the product catalog.
2. Select the **Create template and import** tab.
3. Upload your supplier's file (CSV, Excel, or XML) or provide a direct URL to the feed.
4. Click the **Confirm** button.
5. Wait a few seconds while the assistant analyzes the file structure and suggests matches.
6. Review the suggested mappings in the **Import Mapper**.
7. Click **Import** to start the data ingestion.

The Review Step [badge:Mandatory|warning]

**Review is mandatory:** Always verify the suggested matches before clicking Import. While the assistant is highly accurate, it may occasionally misinterpret ambiguous column names (e.g., matching "Weight" to "Shipping Weight" instead of "Product Weight").

In the Import Mapper, you will see a table showing:

• Source Column: The name found in your supplier’s file.
• Target Field: The field in your system where the data will be stored.

If a suggestion is incorrect, you can click the target field to select a different one from the dropdown, or use the chat to ask for a correction (e.g., “Use the ‘MSRP’ column for the ‘Price’ field”).

**Tip:** Want to know why the assistant matched a specific column? Look for the **AI Explanation** block in the mapper to see the reasoning behind the suggestion. [navigate:/user-flows/ai-explanations|Learn more|bot]

Example Mapping

Here is how a typical supplier feed is transformed into your system’s format:

{
  "columns": {
    "SKU_ID": "code",
    "PRODUCT_NAME_EN": "name",
    "PRICE_VAT_EXCL": "price",
    "STOCK_LEVEL": "stock"
  },
  "matchBy": "code"
}

Refining the results

If the initial mapping isn’t perfect, you don’t have to start over. You can talk to the assistant to refine the logic:

card: Change specific fields
icon: edit
Ask the assistant to swap columns or use a different field for specific data.

card: Handle complex data
icon: workflow
If your file has nested data or requires simple transformations, describe what you need in plain English.

card: Save as template
icon: save
Once you are happy with the mapping, you can save it as a template for future updates from the same supplier.

[try:/products/import|Start a new import|upload]