To create a support ticket, start a search

Extracting email addresses from customers who ordered a particular product


Store Commander allows you to export a list of your customers' email addresses who previously ordered a specific product.

The interest lies in the possibility of sending targeted follow-ups in order to offer a promotional code or a complimentary product to these customers for instance, and thereby encouraging customer loyalty and visit on your store.

Store Commander gives you two solutions:

 From its Orders interface

 From its Customers panel in the Properties column

The difference lies in the type of additional information you would like to export.

 

From Store Commander Orders interface

In the Orders interface, display the 'Picking' view'
 

picking_view.PNG



Using the filtering option in the 'Name' column, enter the name of the specific product.
At this point, only orders of this product are displayed in the grid.

 

Filter_name.PNG


 

You can right-click in the column headers to choose which columns to export, including of course the 'email' column.

You can also choose to re-order the column display by a simple drag/drop.

Once your display preferences are decided, simply click on the Quick Export icon  on the toolbar.

When the new window pops up, select the data using CTRL+C or Apple+C if you are working on a Mac.

In your spreadsheet application (Excel, OpenOffice or other), paste the data using CTRL+C or Apple+C if you are working on a Mac.

This is it. In just a few steps, you now have all email addresses of customers who ordered flip flops.

 
 

 From Store Commander's Customers grid in the Properties panel

In the Products central column, select the specific product.

Display the 'Customers' grid from the right hand-side column

Straight away, names and email addresses of customers who ordered the previously selected product are displayed

 

Customer_prod.PNG


 

Now click on the Quick Export icon  on the toolbar

When the new window pops up, select the data using CTRL+C or Apple+C if you are working on a Mac.

In your spreadsheet application (Excel, OpenOffice or other), paste the data using CTRL+C or Apple+C if you are working on a Mac.

 

Quick_export02.PNG


 

There you are, after a few clicks, you now have the email addresses of all customers who ordered the Satin Trousers. You can now contact them to offer a promotional code on a complimentary product such as a belt for instance. This would encourage them to come back to your site to order more products!

Please note that you can select multiple products in the central column, allowing you to export a complete list of customers who ordered any of the products within the same category for instance.

 

Customer_cat.PNG


Download our dedicated Guides to learn how to manage your shop at lightning speed with Store Commander.