Our Devs have rolled out an improvement to how Billing and Shipping Addresses are reported in the TAB-delimited export file we generate when you download a copy of your E-junkie Transaction Log data.
Previously, these addresses were only provided in a single column each for Billing Info and Shipping Info, with the address components (street, city, state, etc.) combined and provided therein as comma-separated values (CSV). However, since some buyers may use commas when entering their address details, this sometimes posed a challenge for sellers who need to re-separate the combined address details back out into separate fields -- e.g. for their shipping fulfillment system, shipping label printer, or a private database.
Luckily, our system has always stored those address components in separate database fields, and only combined them into CSV format programmatically when generating log views and downloads.
Our Devs have now added some extra columns to the end of each row in our log-export downloads to report those address-component fields separately, in addition to the original, combined Billing Info and Shipping Info columns which remain as they were before. The new columns we added for this are labeled as follows:
Billing information:
Payer Business, Payer Street, Payer City, Payer State, Payer Zip, Payer Country
Shipping information:
Shipping Business, Shipping Name, Shipping Street, Shipping City, Shipping State, Shipping Zip, Shipping Country, Shipping Phone