Mar 2024
3 / 3
Sep 2024
Sep 2024
E-junkie_GuruWebmaster & Support Guru
Mar '24

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

  • created

    Mar '24

  • last reply

    Sep '24
  • 2

    replies

  • 405

    views

  • 2

    users

  • 2

    links

6 months later
anthonyk
Sep '24

Would it be possible to also get a field for "updated email address" in case the buyer's email was updated by me using the "View/Edit Mail List" feature?

In the download log, all I see is "Payer E-mail" and I think this is the address that matches the payment. However, some customers need their digital products sent to an alternate address because they purchased with a PayPal account they can no longer access or from a business account that blocks downloads. (I know, weird, but it happens all the time.) Having an accurate email address in the transaction log download would be useful in these situations.

E-junkie_GuruWebmaster & Support Guru
Sep '24

The Transaction Log is meant to be a permanent record of the order data we processed at the time of the original sale, so that data cannot be edited/updated.

If you need to resend a buyer's link, you can use the Reactivate Link button in your log, but instead of using the option to "Resend thank-you email(s) to original buyer", just use the Copy Link button and paste that into a personal message to the recipient.

Or you can use Manage Buyers > Send free download link/code to generate a replacement link. Note that we had to disable the email-sending function of this feature, as spammers were abusing that to send masses of spam, which caused a major outbound-email outage for us back in January. However, you can still use this feature to generate free links, then just copy the link generated there and paste that into a personal message to the recipient. Note you can simply right-click on that link URL (or on a Mac, hold the Control key when you click) and then select Copy Link, rather than having to drag-select the URL manually to copy it.