Excel import av produktdata

Importing Excel Files

Importing and mass-updating products via Excel is an efficient way to create and maintain product data, and something many people are accustomed to working with. However, blindly importing all data from an Excel sheet when uploading it also carries a high risk of errors and unintended overwriting of information.

Therefore, in feed®, we have created an product import function where you can upload your Excel document, link only the columns with data you want to import to desired fields in feed®. Choose whether you want to create, update, or both, and see a simple analysis of the import before starting the job. This is to reduce the risk of importing something incorrectly, overwriting data, or creating products that were not planned.

When uploading an Excel file, you can either use "drag & drop" and drop the desired file into the large "upload area" (1.), or you can click the upload icon in that box to open a file explorer, navigate to, and select the desired Excel file.

If you have saved any templates for mapping Excel files, you will see them in a list (3.) below the upload area. Here, you can update names or delete old templates.


Mapping of data from Excel to feed® fields.


The first step to be able to import an Excel file via feed is to inform feed® of which column in Excel contains the "Product number". This is required in feed to identify a match on product number for updates or creation of new products. That is why you only get product number as the first mapping option. 

The active Excel column for mapping is identified by a orange chain icon . If the first column isn't the product number click on the chain icon for the correct product identification to color activate that column and click on "Product number *" on the right side of the screen to map this value. 


PS: If there are duplicate products with the same product number in feed®, the update will fail on those products as there is no unique way to identify which product needs to be updated.

If the product number in the Excel file is not found, the product will be created if the option for create has been set at the import analysis.


After mapping the product number you will get more tabs from feed to choose from:

  • Product
  • Text
  • Attribute
  • ETIM Class (if activated in feed)
  • ETIM feature (if activated in feed)

Each of these will give you options to choose from the available fields that is in feed. 

Most of these tabs will be dropdown selections.

Important: It is possible to type/search in these dropdown fields to narrow the options shown.

There is a limit to 50 shown datafields in the dropdown, so if you cannot find it by scrolling in the list you have to start typing the name of the field to find/filter the value you need.  


If the same Excel import is to be executed on a regular basis with the same template you can speed up the import mapping process by saving the mapping as an template by pressing this icon in the top right corner. 

You will be prompted with the option to create a new template, or update an existing one. 


If you already have a saved template from this Excel import that covers all the columns mapping click on this icon in the top right corner.

You will be prompted with a list or search option for the template. Select it and press "apply template", and the mapping will be completed.


This icon lets you choose/override if the import document should use 1 or 2 header rows in the import. 

If you have exported a product report from feed it will by default have 2 header rows, and the document will have a embedded property stating it is a feed_excel_format. This embedded property is read on import and sets the number of header rows to 2 automatically. 

If you use a external Excel document without this embedded property only 1 header row is expected, and set automatically as number of header rows. 


If you delete the second row before importing the file you have worked on, you can use this icon to manually change the number of header rows to be read to 1.


Why do feed use two header rows:

The first row contains the column names and the second row contains information about what language code the text columns are extracted from in feed.

You will see "code" on some columns that requires you to import values using the import code (and not the name value) in that datafield.


Important:

If you see a Column with Code and language code in the export file, always use the code column on import.

You should remove the other column from the feed file before you import. Otherwise you will get the same column name listed twize in the import, and you will get error messages on the column that contains the name and not the codes. 


Dataregisters or header data with list options need Code on import. The advantage with this comes when you have several languages. The code is the same on a spesific value, while the name may differ based on the language.    

 


Once the mapping is complete, you can click on the icon in the bottom right corner.

This will take you to a small import analysis where you can choose the import mode and verify that the number of products for creation and/or update matches the expected values.

  1. Select import mode
    Here you can choose if you want to:
    A: Create new and update existing products.
    B: Only create new product numbers. Assuming that product numbers do not exist,
    C: Only update existing ones. Assuming that it finds a unique match on the product numbers.

  2. Select action
    If you have finished data mapping and have chosen the import mode, you can press "Start import"
    Alternatively, you can cancel and go back to mapping.


After the import is done you will get a result list. 

Any warnings or Errors will be listed with line number and Product numer.

Clicking on these will give you more information on the problems. 


Some errors might originate from the same error source. For example import code missing, or mapping to a field that expects numbers, but get text from the import. 

Clicking on the rows can be useful to identify issues if there are just a few warnings or errors, but a better overview is available via: Integrations - Jobs. 

Here you will find a list imports. The Excel type import should be in that list. 

Click on that type to enter the list of Excel imports


Click on the import you want to investigate:


The error and warnings should be presented with rows that shows details on what should be correced for the import lines to update feed correctly. 

From here you can: 

  1. Click on the icon to go directly to the product (and perhaps correct the issue manually. If the product number is missing or you have duplicates on product number this will not be possible. 
  2. Click on icon to initiate a download the list to Excel.
    1. You will get a notification when it is done
    2. Click on the bell and then click on "Job details excel export finnished" to download the report. The same report is also available via Integrations - Excel export - Job details. 

The second option will let you filter issues in Excel so you can identify warnings or errors that are the same on several products. 
This will potentially help you to change a few values that can import a lot of products with warnings correctly. 
For example, one wrong import key could results in several hundred product warnings. Correct that and all of them will be imported correctly  

  • No labels