How to update items with import function

Admin portal version 1.31 or higher

Quick navigation: Admin > Administration > Export/Import

Sometimes it's necessary to update data in bulk. Since the data might be different for each item the Mass edit function will not be suitable. For tasks like this, you can use Export and Import to update items or other Data at the Admin portal.

This guide will go through these three parts:

• Export
• Edit
• Import

Export

Go to Administration > Export and select the data you want to export. In this example, we will use the Item data. Select Items and make sure all checkboxes are selected for each data selection.

When you click on Proceed the Export file will be created, click on Download to download the file to your computer.

Edit

Note! It's very important that you have all fields selected for the export or else the import will not work!

Find the field you want to alter. In this case, we want to update the price so we go to Q - "Price per piece".

Import

Go to Administration > Import, select Items, and click Proceed.

Click Import File and select the file you exported and edited. Click Import.

An overview of how many values will be updated and which will be skipped will be shown. Click Proceed to finalize the import.

If something didn't go as planned the system will inform you that there are some business errors. Click the red message box at the upper right corner or double click the latest row in the list.

In our example, there were two issues with products missing some mandatory data. Download the error file to view the reason for the failed upload. You do this by clicking the Download Invalid Rows button.

Note! The other 41 rows that did not have errors were uploaded and updated in the system successfully.