Share via E-Mail
Share on Twitter
Share on Facebook
E-junkie Blog
E-junkie FaceBook Page
E-junkie @ Twitter

Exporting shipping addresses from your E-junkie Transaction Log

Your E-junkie Transaction Log can be downloaded as a tab-delimited text file, with the Shipping addresses comma-delimited within. Once you download that file, here's how you can extract names and addresses suitable for a mailing list:

  1. Open the log file in a spreadsheet program like Excel, iWork Numbers, LibreOffice Calc, or Gnumeric;
  2. Select the entire column of Shipping addresses (just click on the header letter of the column, e.g. Column R) and Copy;
  3. Open a new plain text file (e.g. using Notepad or TextEdit) and Paste;
  4. Save that file with a name ending in .csv (e.g. 11May2011shipaddr.csv);
  5. Open that CSV file in your spreadsheet program;
  6. Select the first two columns and go to Insert > Column to get two new, blank columns;
  7. Switch back to your original log file spreadsheet;
  8. Select the entire Firstname & Lastname columns and Copy;
  9. Switch back to the CSV file spreadsheet and then Paste the names into the first two columns;
  10. Save that CSV file spreadsheet;
  11. The format of the resulting CSV file should be suitable for most mailing-list import routines.

As another alternative, if you're a programmer or wish to hire one, you can use our custom/3rd-party Integration feature to forward the order data to a custom script that saves the addresses for you in whatever format you wish directly; however, this would not capture address data from past orders, only new orders as they occur. See the Developer Directory link at the top of our site for a list of competent, E-junkie-experienced developers available for hire.

This page added by E-junkieGuru on May 11th, 2011 @ 6:57 pm GMT -7
  • Questions?
    Feel free to contact us if you don't find an answer in our Help pages or our Forums.

    If you just want to enquire about what all E-junkie does, you can check our feature list.
30 Day Money Back Guarantee PayPal Certified Integration 2Checkout Shopping Cart Sell with ClickBank Authorize.Net shipping cart
Slam the Online Scam