Follow these steps to export asset data to a spreadsheet:

  1. In a Manage Commerce Assets project, select the assets you want to export. You can select any assets from the Navigation pane or select assets in the current project from the project dialog box.

    If you choose to export assets that you have modified in your project, the property values from the version in your project are exported instead of the values from the main version. For more information, see Asset Versioning.

  2. In the Action menu, click Export.

  3. If you selected more than one type of asset for export, click the Asset Type list and select which type you want to export. You can choose only one.

    If you choose a parent type, any assets of its child types are also exported. To export only assets of a child type, select it from the list instead of the parent type. For more information, see Exporting Different Types of Assets.

  4. In the Properties list, select the properties you want to include in the export. The ID property does not appear because it is always exported. Collection properties appear in brackets.

    Note: If you do not choose any properties, only the ID is exported. You could use this as a starting point for creating a spreadsheet for import. See Importing Assets.

  5. Select the format for the export file (XLS or CSV).

  6. (Optional) To export a collection property with its contents itemized into rows, select the property and click Show Collections in Separate Rows. You can choose only one property. For more information, see Options for Exporting Collection Properties.

  7. (Optional) To preview the exported data, click Preview.

    A sample of the exported data appears showing the first five rows of the spreadsheet. You can modify your Asset Type and Properties selections and click Preview again.

  8. Click Export.

    Once you click the Export button, the operation cannot be cancelled and you cannot work on other Merchandising tasks until the export is complete.

  9. When the export is complete, your browser displays a dialog where you choose to open or save the export file.

    If you click Cancel in this dialog, the export file is not saved and you will need to repeat the export procedure.