1. Using Oracle Commerce Agent Console
  2. Search for Customers and Orders
  3. Search for orders

Search for orders

On the top right side of the page, click the order search icon.

On the Order Search page, you can use the following criteria to search for all types of orders in your system:

  • Customer first and last name, email address, and phone number. Note that anonymous orders do not contain profile information. Refer below to searching for anonymous orders using profile criteria.
  • Order number.
  • SKU, product name, order states, order status, and orders submitted previously in days.
  • For those companies that have implemented a multiple site environment, the agent can also search for orders by site.
  • Account (available if account-based commerce functionality has been enabled for your environment; this column is populated for shoppers with accounts only).
  • Approver (available if account-based commerce functionality has been enabled for your environment; this column is populated for shoppers with accounts only).

    Approvers have the ability to approve or reject orders. If the order is approved, the order is placed. If the order is rejected, the order is not placed and its status is changed to Rejected.

Click the Show Advanced Search link to show expanded criteria fields, including specific start and end dates, and customer order-level shipping or billing addresses. Click the Hide Advanced Search link to display only the standard search criteria fields.

The search criterion is based on Starting With, either letters or numbers. For example, typing a K in the First Name search field could produce results of Kara, Kim, and Kyle. Typing Ki would limit the search to Kim as a related result.

Search for anonymous orders using profile criteria

You can use a standard order search for anonymous orders, which includes searching for an order ID, order state or status, and the criteria listed earlier. However, you can search for anonymous orders using profile criteria by searching for the first and/or last name that is used on a shipping and billing address. Use the Advanced Search page to search for either the First Name or Last Name of the Shipping/Billing Details section.

You can also search for anonymous orders by using a shopper's email ID. However, this requires using the Agent API to retrieve the orders. For example, you could issue a REST call similar to the following:
/ccagent/v1/orders?q=shippingGroups.email sw ""&&queryFormat=SCIM

For additional information, refer to the Agent API documentation.