Batch Import to Include Purchase Date or EOT?

[bitofgrace]

I'll be doing a batch import of our customer list to pre-fill registrations on a new system
No problem importing user_email, user_login, last_name, first_name
but what i need is to somehow set an EOT date based on their purchase date.

Any way of doing this when I import? (the list we have is thousands deep - so its not an option to update by hand)

Ideal is to preset the EOT in my CSV before import and have it actually work once imported. Am i hoping too much?

-grace

[BlogPiG]

from the UI (EOT is there):

Additional extended information can also be included; even Custom Fields:
"ID","Username","Password","First Name","Last Name","Display Name","Email","Website","Level[0-9]+ or Role ID","Custom Capabilities","Registration Date ( mm/dd/yyyy )","First Payment Date ( mm/dd/yyyy )","Last Payment Date ( mm/dd/yyyy )","Auto-EOT Date ( mm/dd/yyyy )","Custom Value ( starts w/domain )","Paid Subscr. ID","Paid Subscr. Gateway","Custom Field ID #1","Custom Field Value #1","Custom Field ID #2","Custom Field Value #2", ...

Here is a full example with all fields filled in, including extended details; and two Custom Fields:
"","johnsmith22","mY!passwrD","John","Smith","John Smith","john.smith@example.com","http://www.example.com/","2","music,videos","12/31/2000","01/10/2001","12/31/2020","12/31/2021","www.example.com|123.357.125.654","I-2342934SSER243","paypal","interests","fishing,biking,computers","t_shirt_size","xx-large"

[bitofgrace]

Woohooo! that's fantastic ... is their a particular format needed for the "Auto-EOT Date" header? Or is that exactly it already?

[Cristián Lávaque]

You can export a CSV of your users and then just add all the new ones and re-import using that same file so you don't have to worry about the format. The date format is probably best as yyyy-mm-dd. WP Admin -> s2Member -> Import/Export

[bitofgrace]

ohhh perfect. That makes sense thank you!
-grace

[Cristián Lávaque]