Import/Export Collections

The data import/exporter can also import or export Collections on your website
collections2

Export Collections

In this example, we are going to Import/Export our Staff
 
  1. Login to the website as an admin.
     
  2. Go to Content and click on collections
    collections1

     
  3. Click on Edit Staff
    collections3

     
  4. Click on the import/export tab
    collections4
     
  5. This will open the Data Importer/Exporter window and will show the number of Staff that will be exported. Click Export Staff
    collections5

     
  6. Clicking Export staff will give you a file that you can save to your own computer containing your product data. You can then edit it and import it, or you could import it into another system
    image 161
     

Import Collections


In this example, we are going to Import our Staff
 
  1. Login to the website as an admin.
     
  2. Go to Content and click on collections
    collections1

     
  3. Click on Edit Staff
    collections3

     
  4. Click on the import/export tab
    collections4
     
  5. On the import staff area, click on Choose File to choose your spreadsheet and click on Upload
    collections6
     
  6. Once it is finished uploading, it will open the Data Importer page. This will only show the first 2 columns of your spreadsheet  Map the “Insert Column As..” with the Correct Header  and click on Import this data
    collections7

     
  7. Click OK on the warning popup
    collections8
     
  8. This will begin the import. Note that this process can take longer depending on the size of the spreadsheet. click Finish once it's done
    collections9
     
  9. It is best to import a small amount of data first and check the details thoroughly and adjust your spreadsheet accordingly before doing it in bulk to avoid a bad import
     
For more information on cleaning  a bad import click here