ATG Merchandising User Guide

You can export supported collection properties—lists, sets, and maps—in one of two formats:

For instructions, see Exporting Asset Data.

Items in map collections contain key and value pairs that map one thing to another. To represent these items, the key and the value are separated by an equals sign, for example, Alabama=AL,Alaska=AK.

Flat Format

In flat format, each row of the spreadsheet represents a single asset with all of its exported properties. This format allows you to export multiple properties for each asset. Individual values in a collection are separated by a comma, for example, blue,green,red, or a comma and a space if they are repository items, for example, cat110006, cat11008, cat11009.

The following table shows how the childSKUs collection property appears in flat format:

Note: If collection items contain only numbers, or contain a comma in a value, then the items are enclosed in double quotation marks, for example, "123","124". This prevents Microsoft Excel from interpreting the list of numbers as a single number. If a value contains a comma, the double quotation mark indicates that the comma does not begin a new item. For example, a keyword collection could be exported as: winter accessories,"hats, scarves, and gloves",knitted gifts. The quotation marks are removed if you re-import the spreadsheet.

Itemized Format

In itemized format, collection items are separated into individual rows, so one asset might span several rows in the spreadsheet. If you choose to itemize a collection property, you can only select that one property for export.

The following table shows the products from the previous example with the childSKUs property in itemized format: