You can export supported collection properties, such as lists, sets, and maps, in either of the following formats:
Flat: all collection items are listed in one cell and separated by commas
Itemized: each collection item is listed in a separate row
For instructions, see Exporting Asset Data.
Items in map collections contain key/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:
ID | displayNameDefault | childSKUs |
---|---|---|
xprod1068 | Wool waist tie top | xsku1448, xsku1449 |
xprod2525 | Metallic silk blend tank top | xsku2525_1, xsku2525_2 |
Note: If collection items contain only numbers, or contain a comma in a value, 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:
ID | childSKUs |
---|---|
xprod1068 | xsku1448 |
xprod1068 | xsku1449 |
xprod2525 | xsku2525_1 |
xprod2525 | xsku2525_2 |