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 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 via Excel is to inform feed® of which column in Excel contains the "Product number". This is required in Excel to identify the correct product in feed® for updating. If there are duplicate products with the same product number in feed®, the update will fail 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.
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 have a template that covers the columns you are using, 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".
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.
- 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. - 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.