This topic is a bit technical, not sure if there is anyone from the tech department of eBay has a chance to help take a look.
Recently I am developing a tool to help generate address labels from the downloaded orders report file from the seller hub, but it was found there are a few very obvious encoding issues with the downloaded CSV file, especially when there are double quotes (") in some data columns (for example, Post To Address, Item Title, etc).
For example, when there are double quotes in thePost To Address 1, like,
"DURRAMCOURT", 123 ABC HIGHWAY
the double quotes shall be escaped and the column shall be,
"""DURRAMCOURT"", 123 ABC HIGHWAY"
but in the downloaded CSV file, the double quotes were not escaped at all, and the column was put incorrect as,
""DURRAMCOURT", 123 ABC HIGHWAY"
The consequence of this issue is that the downloaded csv file is hard to be decoded by some automated tool, sometimes even the Excel can not parse that order row properly.
According to the standard Common Format and MIME Type for Comma-Separated Values (CSV) Files ,
7. If double-quotes are used to enclose fields, then a double-quote
appearing inside a field must be escaped by preceding it with
another double quote. For example:
"aaa","b""bb","ccc"
Not sure if this problem could be corrected by eBay or not?
