Thread: Retrieve Customer's Email Address?

I wanted to know if there was a way to String a customer's email address if they are logged in? I need to retrieve this email address for various uses. . .

I would also like to retrieve other fields, such as their first name, last name, address, city, state, zip, et cetera. . . for sending custom emails to Customer Service for service requests.

We are on v8.0.1.2.

Thank you,

~D

To grab just that info?

Code:

if (ThisCustomer.IsRegistered)
{

FirstName.Text = ThisCustomer.FirstName;
LastName.Text = ThisCustomer.LastName;
EMail.Text = ThisCustomer.EMail.ToLowerInvariant().Trim();
Phone.Text = ThisCustomer.Phone;
}

This will get you going. Checks if they are registered then uses ThisCustomer to populate the strings.

Thank you. I actually just found this in the namespace and in the account.aspx page. . . I'll give this a shot.

Thanks again!

Originally Posted by ZachJ85

To grab just that info?

Code:

if (ThisCustomer.IsRegistered)
{

FirstName.Text = ThisCustomer.FirstName;
LastName.Text = ThisCustomer.LastName;
EMail.Text = ThisCustomer.EMail.ToLowerInvariant().Trim();
Phone.Text = ThisCustomer.Phone;
}

This will get you going. Checks if they are registered then uses ThisCustomer to populate the strings.

What about grabbing their address?

Surely that only gets information of registered customers and NOT logged in customers. For logged in you'd have to look at the CustomerSession table and join that to the Customer table and then determine if they were registered, otherwise they are an anonymous customer.

Originally Posted by esedirect

Surely that only gets information of registered customers and NOT logged in customers. For logged in you'd have to look at the CustomerSession table and join that to the Customer table and then determine if they were registered, otherwise they are an anonymous customer.

That's what what I want. . . I want to get that information from a registered customer.

Thank you.

select * from customer
where customerid in (select customerid from customersession)
and isregistered=1

Not an exact science, since the customer may have disappeared from the session. You could check the [lastactivity] field in [customersession] to see if it's within the last hour.

The you'd want to join to the [address] table to get their address on either the [billingaddressid] or [shippingaddressid]

So, there's no easy way of just stringing out their address - like their first name, last name, et cetera. . . ?

Where/when do you want to do it?

From within the admin application? Or using SQL Server Management Studio? Or from another application?

Originally Posted by esedirect

select * from customer
where customerid in (select customerid from customersession)
and isregistered=1

Not an exact science, since the customer may have disappeared from the session. You could check the [lastactivity] field in [customersession] to see if it's within the last hour.

The you'd want to join to the [address] table to get their address on either the [billingaddressid] or [shippingaddressid]

He wants info for ONLY registered users.

Wouldn't ThisCustomer.IsRegistered handle the same thing as your query? If they are registered then ThisCustomer.Whatever will grab the data he needs. If they aren't registered or not logged in it won't grab that data.

In his original post he says 'logged in'. But he doesn't say what application he wants to use as his client.

Originally Posted by esedirect

In his original post he says 'logged in'. But he doesn't say what application he wants to use as his client.

I'm not sure what you mean by which application. I want logged-in registered users. I'm all set now though. . . I used the fields from the PrimaryShippingAddress object.