Community > Ideas
45 views
Community Review

Add a way to export a list of customers (both guest and registered) from Live Store Front

Add a way to export a list of customers (both guest and registered) from Live Store Front? I would like to be able to send marketing materials to customers possibly with email campaigns. 

Pete Christiansen Pete Christiansen
published 04/23/2020 13:13

endorsed by
  • Tammy Ensor
  • Keston Pollard
Add Comment
Mandeep Singh
replied 04/23/2020 20:33

It looks like it would help if we add Store > Customers option with a grid (search/export). Keeping this open for community to review.

Pete Christiansen
replied 04/23/2020 14:48

I need a gridview with an csv export button for this SQL script.

SELECT DISTINCT LSF_Address.Firstname, LSF_Address.Lastname,LSF_Address.Email, LSF_Address.Phone, LSF_Address.Address1, LSF_Address.Address2, LSF_Address.City, LSF_CountryRegion.Name,LSF_Country.Name
FROM LSF_Address
INNER JOIN LSF_CountryRegion ON LSF_CountryRegion.CountryRegionID = LSF_Address.CountryRegionID
INNER JOIN LSF_Country ON LSF_Country.CountryID = LSF_Address.CountryID

Mandeep Singh
replied 04/23/2020 20:32

You could always execute that script from SQL Console; it has an export to CSV option as well. 

Pete Christiansen
replied 04/24/2020 14:24

Thank you for the suggestion! I have never used the sql console. 

Last Activity 04/24/2020 14:24