Import Data Using Import Maps

Suppliers send product and catalog data to retailers and manufacturers in their native format, usually as spreadsheets or xml file format. They typically use standard industry formats, such as BMECat, eClass, or others.

Retailers need to onboard or upload the data provided by suppliers into Product Hub. To import this data, they can use import maps.

The following privileges are required to upload data using the import map template:

Manage Item Batch (EGI_MANAGE_ITEM_BATCH)
Generate Access Token (EGI_GENERATE_ACCESS_TOKEN_PRIV)
Manage Item Import Map (EGI_MANAGE_ITEM_IMPORT_MAP_PRIV_OBI)

To import the data using import maps:

In the Product Information Management work area, navigate to the Manage Item Batches task.
Search and select a batch or create a batch.
Make sure that the appropriate batch options are set for the batch. To do this, from Actions, select Edit Item Batch Options.
From Actions, select Add Items to Batch.
In the Upload from File dialog box, review the batch number, batch name, and source system information.
Select or create an import map.
Review the map and submit, which loads the data file into the interface tables, and closes the dialog box. The Manage Item Batches page is displayed.
Click Submit. The data will be imported and the items along with their child entities will be created.

Correct Errors

To correct import errors:

Click Manage Item Batches task in the Product Information Management work area.
Search for the batch for which the Item Import process was run.
Click the batch name to navigate to batch details.
Review the errors for each item.
Select the item rows that are in error and click Manage in Spreadsheet to export Item data to spreadsheet.
Once all the rows are corrected, resubmit the process by clicking Upload and then submit the Item Import process.
Repeat the submit and error correction steps in this section until all rows are imported successfully and the items along with their child entities are created.