Exporting Customer and Order Information Using Saved Exports

Written by Kate Ngo Updated over a week ago

With the Saved Exports tool, you can create custom SQL queries to export information from your store's database.

In our example below, we'll export the total number of orders for each customer as well as the total number of customers who have placed orders. We'll export this data to a CSV file which can be imported into a standard spreadsheet program such as Microsoft Excel.

Accessing Saved Exports

You can follow these steps to access and create a saved export within your store's Admin Area:

In your Admin Area, go to Inventory > Import/Export.

Click on the Saved Exports tab.

Click Add New Query.

Configure your custom query and save your changes when finished.

See the table below for an example query that will export the order information as described at the beginning of the article.

Use this example as a starting point for more complex queries that you can save and use with your site.