Adobe Target Product Recommendaiton: categoryID in Feed File

[instant_pomelo]

We have been getting ready to upload product data into Target for Product Recommendation using the csv approach.

According to documentation, we need to populate entity.categoryId as a comma separated value. But this is confusing because csv is comma separated, and the comma separated values get pushed into the next column. So, the second categoryId would get pushed into the next column which in our case is imagelink and so on.

What is the recommended approach to updating the entity.categoryID field when using csv file?  For other custom attributes with multiple values, we are using arrays with [], should we do this here too?

[instant_pomelo · Accepted solution]

Figured it out. The answer is to quote the fields.

We quoted all the text and numeric fields, and they seem to be working fine.

Hope this help if any one has any doubts about this