AI Smart Import

Get up to speed with Emporix by using AI Smart Import to transfer the data to the system.

The AI Smart Import feature simplifies the process of uploading and integrating test data, allowing you to import information related to brands, categories, catalogs, products, prices, product media, availability, tax and product category assignment. Leveraging AI capabilities, it automatically maps the data from uploaded files to the data structure used in the Emporix system.

AI Smart Import is designed for importing sample data or test data. It is not intended for large-scale production data imports. Large-scale data imports should be handled during project implementation as part of the initial setup.

AI Smart Import

You can upload data in both JSON and CSV formats, with JSON serving as the source object format. Our Generate Mapping functionality activates the AI to transform and align all object data from the file format to the schemas required by Emporix, ensuring a seamless and accurate data import process. The feature also supports mixins for enhanced flexibility.

If you want to use sample data import, you should do so before configuring your tenant. This is because sample data requires a basic tenant configuration, including the main site, en language, and a standard tax class. This configuration is applied automatically during the sample data upload, so if you configure your tenant first, your settings may be overwritten during the data upload.

Use case examples

Overall sample data upload

As a customer, you want to explore sample data for your tenant configuration to see how your own data could be organized in the Management Dashboard.

1

Start AI Smart Import

Go to the AI Smart Import and choose Sample data import. This action adds sample data to your tenant for brands, categories, catalogs, products, prices, product media, availability, tax and product category assignment.

2

Review sample data

Check the respective nodes in your Management Dashboard and view the sample data that was uploaded.

When the sample data upload is finished, you see the Last import date column updated. Mapping is not applied as it relates to single data uploads and no import logs are kept. You can view the results of the sample data upload by going to relevant nodes in Management Dashboard.

Single data uploads

As a customer, you want to upload only the categories data to the Management Dashboard.

1

Choose data to import

In the AI Smart Import, you can see different objects that can be imported. To import categories data, choose the Go to arrow and open the Categories import view.

Data to Import

2

Upload data from a file

Choose Upload file and select your file containing the categories data you want to import. Check the examples of the files that can be uploaded for the AI:

CSV format

3KB

AISmartImportCategories.csv

Open

JSON format

3

Review source objects

When you upload the file, all the objects from the file are visible as the Source Objects. In this case the file held object data for 9 categories. Using the arrows in the Source Object field you can switch between different object categories.

Category Upload

4

Match objects

Choose Generate Mapping, this starts the transformation of the objects to match the object data schema used at Emporix.

5

Review transformations

In the Transformations field you can check which fields were changed.

For example: supercategoryId from the file data was transformed to parentId to match object schemas. You can check the transformations for all the uploaded categories. You can review the generated object mapping.

Category Mapping

6

Save the mappings

To keep your object mapping choose Save. If you don't want to import the categories now, you can get back to the configuration at a later point and finish the process with the current mapping saved.

When you get back later to the mapping, the source object, the transformed object data and the logs are no longer visible, but the mapping is still valid.

7

Import data

To import the categories as they are mapped, choose Import file. This creates the categories structure in the Emporix system.

8

Review logs

When the process is complete, you can also check the logs in the Import Logs tab.

Files samples to upload

With the AI import, you can upload data separately for products, catalogs, brands, categories, prices and availability. See the files in the table for the correct upload file format with mapping examples:

Import type: products with media

CSV format

15KB

AISmartImportProduct.csv

Open

JSON format

Mapping

Import type: catalogs

CSV format

3KB

AISmartImportCatalog.csv

Open

JSON format

Mapping

Import type: brands

CSV format

1KB

AISmartImportBrands.csv

Open

JSON format

Mapping

Import type: categories

CSV format

3KB

AISmartImportCategories.csv

Open

JSON format

Mapping

Import type: prices

CSV format

1KB

AISmartImportPrice.csv

Open

JSON format

Mapping

Import type: availability

CSV format

650B

AISmartImportAvailability.csv

Open

JSON format

Mapping

Troubleshooting

If an error occurs during the import process, you can prompt the AI to correct the mapping, with up to five attempts allowed. If the issue persists, select Generate Mapping again to restart the mapping process.

To adjust object parameters, you can ask the AI to make specific changes using prompts such as:

• Map the code field to the ID field.

• Add the FR language to every product if it's missing.

• Correct the mapping for the Snacks category.

This allows for precise customization and ensures accurate data handling.