Import/export product data
Sometimes it is necessary to export/import your product data in bulk. ChannelDock has a handy feature for this. This article describes how you can export product data in bulk, but also how you can import your stock levels in bulk using an excel file.
Exporting product data
Follow these steps to export your product data:
-
Via 'Inventory', go to the 'All products' page.
-
Click on the blue 'Import / Export products' button at the top of the page.
-
Click on 'Export products' in the screen that opens.
-
A .CSV file is then downloaded with all your product data.
Importing product data
To import new product data or update your stock levels using an export from your sales channel, follow these steps:
-
Go to the 'All products' page via 'Inventory'.
-
Click on the light blue 'Import / Export products' button at the top of the page.
-
Click on the upload button (surrounded by a dotted line).
-
In the screen that opens, choose the file you want to upload. Please note that this can only be an .xls or .csv file.
-
Then the upload screen opens. Here you indicate which columns you want to import. Often, the file you want to import has a row with column titles. Does the file you want to upload not have this? Then turn off 'Skip first row of import'.
-
Now select the columns you want to include in the import. It is mandatory to include the 'EAN' column in the import. Furthermore, you need to upload at least one other column.
-
After you have imported at least 2 columns (one of which is the EAN column) , the 'Start import' button appears at the bottom of the screen. It may take a while for the import to be processed; the screen closes automatically. You will then see how many products have been updated.