E-junkie Tip

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 (Windows) or TextEdit (Mac, in plain text mode);
  4. Paste the shipping addresses into that file;
  5. Save that file with a name ending in .csv (e.g. 11May2011shipaddr.csv);
  6. Open that CSV file in your spreadsheet program;
  7. Select the first two columns and go to Insert > Column to get two new, blank columns;
  8. Switch back to your original log file spreadsheet;
  9. Select the entire Firstname & Lastname columns and Copy;
  10. Switch back to the CSV file spreadsheet and then Paste the names into the first two columns;
  11. Save that CSV file spreadsheet;
  12. 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.

Start 1 Week Free Trial

  • Just $5 per month
  • No setup fee
  • No transaction fee
  • No transaction limit
  • No bandwidth limit
This page added by E-junkieGuru on May 11th, 2011 @ 6:57 pm GMT -7
Updated by E-junkieGuru on August 31st, 2015 @ 5:58 pm GMT -7