Community Documentation

Searching for sales

Last updated August 16, 2007. Created by sime on October 20, 2006.
Edited by add1sun. Log in to edit this page.

While there is a transaction history at administer » store » transactions, you may want to do a deep search of your transactions. This can be done on the search page: administer » store » search.

Basic search

To perform a simple search, you can type some text into the first text box and click Search. The search examines all of your product titles and descriptions, and then returns all transactions that contain these products.

Advanced search

Below the basic search are your advanced search options (you may click on Advanced search to reveal it). Please note that the Basic search textbox is a part of the Advanced search. Here is a description of the other search options.

Label Description
Transaction ID This is the unique ID assigned to every sale of 1 or more products.
Product expiration For products which have recurring scedules, enter a date of expiry (or a range like 1/1/2006-31/1/2006).
Username or ID This is the user name or user ID of the purchasing customer's Drupal account.
Date created When the transaction was created. enter a date of expiry (or a range like 1/1/2006-31/1/2006).
Product ID This is the unique ID assigned to every product. If the following node was a product, www.example.com/node/99, it's product ID would be 99.
Total cost This is the gross cost of the invoice which includes shipping. You can enter a range, eg: 10-100 would be all transactions between $10 and $100.
Payment status Search on payment status. Limit to one or more of: pending, payment received, completed, failed, denied, refunded, canceled.
Workflow Search on payment status. Limit to one or more of: transaction received, invoiced, shipped, awaiting customer response, canceled, completed
Payment method Search based on the payment method. The options will be based on those payment methods enabled on your site.
Product type Search based on the product type. The options will be based on those product types enabled on your site.
Recurring status This is a checkbox that allows you to limit to products which are recurring.

Once you submit your search, the search terms that you've used should display on the results page.

About this page

Drupal version
Drupal 4.7.x

Site Building Guide

Drupal’s online documentation is © 2000-2012 by the individual contributors and can be used in accordance with the Creative Commons License, Attribution-ShareAlike 2.0. PHP code is distributed under the GNU General Public License.
nobody click here