Knowledge Base
Shopping Cart Software Online Manual
Exporting spreadsheets that target specific information
Admin Account Editor Import / Export Center
Location Home > Shopping Cart Software Components > Administration Area > Admin

Exporting spreadsheets that target specific information

The Import/Export Center has been very helpful, however, it does not allow me to export customers based on a specific location, orders that include a particular product, etc.

How do I export spreadsheets that target specific information?

To export spreadsheets for customers, products, orders, etc. based on specific rules, it is recommended to use their corresponding search page (Search Customers, Search Products, Search Orders, etc.). Most search pages will include export options in the bottom action menu, such as:
  • export only SELECTED ('d)
  • export matching search results
  • export ALL

As an example, we will search for orders that were placed within a specific date range using the Search Orders page. Then, using the export options available on the search page, export the orders that match the search results.

1. In the Administration Area, locate [Orders > Search Orders].
2. Search for: Orders that match rules below.
3. For this example, we will be searching for orders between January 1st - December 31st 2012.

The search will consist of orders placed between January and December for the year 2012.
4. Click Search.
5. Once the results have loaded, scroll down to Perform an action on the rows selected above...

In the dropdown menu, there will be 3 different Export Options, but for our current purposes we will want to select export orders matching search results.

6. Click Go.

This same approach can be taken on other search pages to perform a targeted data export.

— Last Edited - 06/4/2013 4:45pm PDT
Rank and add a comment to this article
Only logged in users may leave comments and rank articles. Log in to have your say!
  Knowledge Base Home

  QuickCode™ Tag Glossary

  Modular Homepage

Not Logged in.
Either Log in or create a User Account.

Other articles in this category...

Admin Account Editor

Exporting spreadsheets that target specific information

Import / Export Center

Place an Order Tool

Redirect Manager

Retrieving a copy of your Modular Merchant invoice

Edit My Admin Account

Search Admin Accounts

Admin Attribute Editor

Tax Rule Editor

Search Tax Rules