Skip to main content

Search & Filter Payments

Every plugin in the Ottu Dashboard has a Transactions table. This page shows how to see which transactions are paid and which are not, how to find one transaction, and how to list the payment links created by one user or processed through one connector. Administrators can also choose the filters and search fields that every transactions table offers.

Who can do it: any dashboard user. You only see the transactions you are allowed to see: if some are missing, see Why can't I see all the transactions?

How can I see which transactions are paid and which are not?​

  1. In the Ottu Dashboard sidebar, open the plugin, for example Payment Request, and click Transactions.

    The dashboard sidebar with Payment Request open and Transactions selected
  2. Click Filter at the top right of the table.

    The Filter button above the transactions table
  3. In State, choose:

    • Paid to see the paid transactions;
    • All Unpaid to see every transaction that is not paid. It covers the states Created, Pending, Attempted, Failed, Expired and Unavailable.
    The State filter open, with Paid in the list
  4. Click Search.

    The Search button at the bottom of the Filter panel

The table now shows only those transactions. To see everything again, click Filter and then Reset.

State takes one value at a time. You can also choose a single state, such as Expired or Canceled. Canceled transactions are not part of All Unpaid. See Transaction States for what each state means.

If there is no State filter, an administrator has removed it: ask them to add it back.

How do I filter the unpaid transactions and export them?​

  1. Open the plugin's Transactions table and click Filter.

    The Filter button above the transactions table
  2. In State, choose All Unpaid, then click Search.

    The State filter open, with All Unpaid at the end of the list
  3. Click Export Transactions above the table.

    The Export Transactions button above the transactions table
  4. Under Select file type, choose CSV or XLSX, then click Export.

    The export options with Select file type: CSV or XLSX
  5. The Generated Reports page opens. When your export shows a download icon, click it to get the file.

    The Generated Reports table with the Download column

The file contains only the transactions the table was showing. See Export Transactions for more, including what to do when an export is slow.

How do I find one transaction?​

Use the search above the table. It searches one field at a time.

  1. Open the plugin's Transactions table.

    The dashboard sidebar with Payment Request open and Transactions selected
  2. In Select field, choose what you know about the payment, for example the customer's email.

    The search above the transactions table: Select field, the Search box and the Search button
  3. Type the value in the Search box. Part of the value is enough, and capital letters do not matter: shop finds shopify.

    The search above the transactions table: Select field, the Search box and the Search button
  4. Click the Search button.

    The search above the transactions table: Select field, the Search box and the Search button

I only have the customer's name​

Look in Select field for the customer's name fields, such as First Name or Last Name:

  • If they are listed, choose one, type the name and click Search.
  • If they are not listed, the search cannot use the name yet. Ask your account administrator to add the name fields as search fields. An administrator chooses which fields the search offers, and none are set up by default.

Two other ways to find the payment:

  • If your sidebar has Express Search, open it. It can search by order number, session ID, customer email, customer first name, customer last name and customer phone.
  • Narrow the table with Filter, for example by the date the payment was created or by its State, and look through the shorter list.

Step-by-Step Instructions​

Step 1 of 4
Step 1 of 4

Access the Transactions Section

From the Ottu Dashboard, open the Payment Request plugin and go to the Transactions subsection. All transactions performed via the Payment Request plugin are listed here.

Video Demonstration​

A tutorial video is available to provide a visual walkthrough of the filtering process:

Watch the video tutorial

Choose the Filters and Search Fields​

An administrator chooses which filters and search fields the transaction tables offer, in Administration Panel > Search > Search Config.

Filters​

Each row under Filter Fields adds one filter to every transactions table:

SettingWhat it does
FieldThe transaction field to filter on. Most transaction fields can be used, plus Seen, Email Seen and Application (the application that created the payment).
Label and Label (Arabic)Optional. When Label is empty, the field's own name is shown. When only Label (Arabic) is empty, the dashboard in Arabic shows Label.
Filter TypeDropdown, Boolean, Date, Date Time or Amount Range. When empty, Ottu picks the type that fits the field.
Minimum Amount and Maximum AmountThe range of the slider of an Amount Range filter.
OrderThe position of the filter.
Is active?Clear it to hide the filter without deleting it.

By default there are filters for the created, modified and state-changed dates, the state, gateway, currency and initiator, and the Seen and Email Seen flags. A dropdown lists the values its field can have, for example your gateways, your users, or the applications found on your payments.

Search Fields​

Choose what the search box can search on:

  • Internal Fields: select any of Internal ID, Customer Email and Application.
  • Search Fields: add fields of your plugins, including custom fields.

A search matches part of the value and ignores case, so shop finds shopify. A plugin with its own entry in Administration Panel > Search > Plugin Search Configs uses that entry's search fields instead.


What's Next?​