Defining Output Format For CSV and XLSX Channels

How to configure the output format of a CSV or Excel feed.

Define the output labels of your attributes manually or by the upload of a CSV template, order of the attribute columns that are listed, which separator to use for multiple values, and whether to include attribute values for product parents, variations, or both.

 

Output Labels

Product listing

Attribute sorting

Attribute fill values

 

💡 Refer to an example feed, if available, of where your channel is being sent to for guidance on how to order columns.

 


Defining the Output Labels of your Attributes


There are two ways to change the output labels of your attributes in order to adapt them to the requirements of the channel you are sending your data to:

  1. Manually Changing the Output Labels in the "Attributes" tab
  2. Uploading a CSV template 

Manually changing the Output Labels


Inside a Channel within the "Attributes" tab you are able to manually change the output labels of your attributes to adapt those to the requirements of the channel you are sending it to. 

Uploading a CSV template to define Output Labels


Many third party channels (Amazon, Wayfair, Home Depot…) have their own set of requirements when it comes to a channel. Usually this information is provided in a spreadsheet template that needs to be filled out.


Within a Channel you are now able to upload a CSV file with column headers to mirror any template for a given channel. By simply matching attributes living in your PIM rather than manually typing in the different output labels required you will save you a lot of time. 


To upload a CSV template, simply head to the "Attributes" tab within your Channel and click on "Upload CSV template". 

 

csv-template-channel

If you have already some attributes selected and choose to upload a CSV file you will have two options:

  1. Add attributes from the CSV template to the channel
  2. Remove all and replace existing attributes

 

Once you have uploaded the CSV template, you can match the required fields for the specific Channel with the attributes living in your PIM. 

 

match-attributes-csv-upload

The attributes that you leave unmatched will still get displayed in the header row of the CSV file but will not display any values. 

 


Product Listing

Define how to format the output of your channel from the "Format" tab of the channel details page.

Here you can decide in which order your products should be listed. Define if you want parents or variations to come first. 

 

channels - format - listing

 


Attribute sorting

The first thing to decide on is how to sort your attribute columns. 

 

Channel - Format - Attribute sorting

 

From the "Attribute sorting" dropdown, you can select from:

  • Manual
  • Alphabetically (A-Z) 
  • Alphabetically (Z-A)

If sorting columns manually, you can drag and drop columns in the order you prefer. If sorting alphabetically, note that they will be sorted alphabetically based on the "output label" defined in the "Attributes" tab of the channel. 

 


Attribute Fill Values

You can also choose if you want to include data only for parent products, product variations, or both on an attribute level. You can also define the value separator for attributes that have more than one value, for example categories. 

 

channels - format - fill value-1

 


What's next? 

 

If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

 

and please let us know 👇