Import product data from a spreadsheet in the Vendor portal

Use import in the VendorConnect Vendor portal to create or update product data from a spreadsheet.

What you can import depends on your permissions. Depending on your access, you can create new Entities, update existing Entities, or link Entity types by using data from a spreadsheet.

Before you import

Prepare a spreadsheet with the data you want to import.

Your spreadsheet must include a column that identifies each Entity. This is typically a part number or another unique value.

The import process

The import process has the following steps:

1. Select the import file
2. Configure the imported Entities
3. Map the spreadsheet columns to Fields
4. Start the import

a) Select the import file

In the VendorConnect Vendor portal,
do the following:

1. In the header, click the New Entity menu.
   The menu opens.
    
2. Click Import data.
   The import wizard opens.
   
    
3. In the import wizard, drag the spreadsheet into the import area, or click the import area to select the file from your computer.
   The file is added to the import wizard.
    
4. Click Next.
   The configuration step opens.

b) Configure imported Entities

Use the configuration step to define how VendorConnect should handle the data in the spreadsheet.

In the import wizard,
do the following:

1. If available, select whether the import should create new Entities or update existing Entities.
   
    
2. Drag the Entity types included in the import file into the drop area on the right.
    
3. For each Entity type, select the identifier column from your spreadsheet.
   The identifier column is used to match spreadsheet rows to the correct Entity.
    
4. If you want to link one Entity type to another, select a Link type and add an identifier column that contains the Entity ID of the Entity you want to link.
    
5. Click Next.
   The column mapping step opens.

c) Map spreadsheet columns to Fields

The import wizard automatically tries to map spreadsheet column names to the Inriver Fields you have access to. Manually map any remaining columns that you want to import.

In the import wizard,
do the following:

1. Review the automatically mapped columns.
    
2. Map any remaining spreadsheet columns to the correct Inriver Fields.
   
    
3. If a column should be mapped to multiple Fields or languages, click the plus button next to the Entity Field and add another mapping.
    
4. Confirm that every Field used as an identifier column has at least one Inriver Field assigned for each Entity.
    
5. Click Next.
   The validation and import step opens.

d) Start the import

In the import wizard,
do the following:

1. Review the import setup.
   
    
2. Click Start Import.
   The import starts.
    
3. Monitor the import status in the dialog.
   Errors and warnings are listed in the Job Log.

VendorConnect automatically creates submissions for each Entity in the import that contains changes.

Monitor import progress after closing the dialog

If you close the import dialog, you can continue monitoring the import from the VendorConnect Jobs list on the right side of the header.

• Click the status icon at the top right of the job card to reopen the dialog and view more details.
• Hover over the status symbol above the delete button in the VendorConnect Jobs list to view error messages.

Further reading

Import images in bulk with image URLs in the VendorConnect Vendor portal

Export product data from the VendorConnect Vendor portal

Track your submissions and messages in the Vendor portal

How to find products and enrich their data in the Vendor portal