How to export a Column List to Excel

Create a new Column List

1. Go to Products and to Column Lists.

2. Click on Create to create a new Column List.

3. Fill out the mapping.
   Enter an ID and a description.
   Select basic product fields, attribute values or prices to be included in the mapping.

4. Customize the columns if needed.
   On the right you can rearrange the order, change the column header or the width.

5. Save the Column List.

Configure an Export Channel

1. Go to Channels and under the EXPORT section click on Manage.

2. Click on Create to create a new Channel.

3. Fill out ID, Description and Group.
   You can also select a Logo, e.g. the Excel Logo.

4. Go to the Export Format tab.
   Add a description.
   Select the Excel format and then select Column List as the Mapping system.
   Now select the Column List you just created.

5. Go to the Communication tab.
   Select File and select a directory and enter a file name.
   You can also configure to add a timestamp to the file name or compress it into a ZIP file.

6. Save the Channel.

Run the Export

1. Go to Channels and under the EXPORT section click on Execute.

2. Select a Stored Query or Worklist with products you want to export.

3. Select the Channel created in the previous steps.

4. Optionally, change the execution time or the job name.

5. Click Run to execute the export.