Configuring CSV file export

Comma-separated values (.csv) files are a great way to migrate data between systems. Ergonode allows you to create a .csv file with ease and export them either manually or automatically.

You have two options for exporting data from Ergonode. The first option is to export all your data in several .csv files. The second option is to only export changes made from the previous export.

To create a .csv file with your data, go to “Channels” in the “Data Exchange” tab within the Side Menu, click “New Channel”, and select Ergonode ZIP under Channel Type (you can also create an export channel for Shopware 6, more on that here) and give it a unique name in the space provided.

This window gives you the option to select language channels you wish to export (this is based on the languages you selected in your language tree) as well as choose from one of the export types mentioned previously – full export to export all data present, or incremental, to only export changes made from the last export you made. You can additionally choose to export a segment. If you wish to do that, you need to select a segment from the appropriate dropdown, provided you have segments set up in the system already. If no segments exist, the selection will remain blank.

If you wish to read about creating segments, you can do it here.

Once this is completed to your satisfaction, press “Export Now” to create the export file.

To preview ongoing export go to the history tab. As this job can take some time, you will have an option to see the current status here. Export details can be found by clicking on the eye icon.

To see any changes in status you will need to manually refresh this page. Please keep in mind that especially with full export and lots of products, this can take up to a couple of hours to be done.

When export is done (status: ENDED), you need to download the file manually. To do so click on the eye icon in the history tab near your export job, and then on DOWNLOAD FILE.

The download will get you a zip file, with all the exported items in separate CSV files. Importing CSV files into Ergonode PIM lets you choose with files you wish to import, so you do not need to import everything at once.

If you wish to automate your export ex: for backup purposes, we got you covered. You may use a built-in Scheduler.

You can set this up by deciding on the start date of the scheduled exports and the time interval between them.

Please note, that any custom units you create in your Ergonode environment will not be exported and must be re-created manually in the environment your data will be imported into for the attributes using these custom units to be imported properly.