Introduction
Efficient order management starts with visibility into how your customers choose to pay. When you can accurately filter orders by payment method, you simplify your accounting, speed up fulfillment, and identify potential risks in your sales funnel. Many merchants need this capability to reconcile accounts with third-party providers like Afterpay or to manage manual payment captures for high-risk transactions.
Optimizing this process often involves more than just looking at the order list after a sale is made. Using a tool like install HidePay allows you to control which payment methods are available in the first place, reducing the amount of manual filtering and reconciliation work required later. By setting smart rules at the checkout, you ensure that only the most appropriate payment options are presented to each customer segment.
This guide provides a detailed walkthrough of how to filter your orders within the Shopify admin and how to use advanced reporting for deeper insights. We will also discuss how proactive checkout management can streamline your backend operations. You will learn the specific search syntax needed to find any transaction type and how to save these views for daily use. For a broader introduction to the app and why merchants use it, see our blog post, Introducing HidePay for Shopify.
The Importance of Filtering Orders by Payment Method
Filtering is not just an administrative task; it is a core part of financial health for a Shopify store. Different payment methods carry different fee structures, processing times, and levels of risk. If you cannot isolate these orders, you cannot effectively manage your margins or your cash flow.
Financial Reconciliation
Most payment providers deposit funds in batches. To match your bank statement to your Shopify orders, you must be able to isolate transactions from specific gateways. For example, if you are looking for an Afterpay payout, you need to see exactly which orders were processed through that specific gateway during a specific timeframe.
Fraud and Risk Management
Certain payment methods, such as Cash on Delivery (COD) or specific local bank transfers, may have higher non-payment or chargeback rates. By filtering for these orders, your fulfillment team can perform extra verification steps before shipping expensive inventory. This proactive approach saves time and reduces the cost of lost goods.
Fulfillment Prioritization
Some stores prioritize orders based on how they were paid. Orders paid via "Express" methods like Shop Pay or Apple Pay might be funneled into an expedited fulfillment stream, while orders waiting for manual bank transfer clearance stay in a "Pending" filter until the funds are verified.
How to Filter Orders in the Shopify Admin
The Shopify admin provides a powerful search and filter interface that allows you to isolate orders based on payment gateways and transaction details. While the interface has evolved, the core logic remains focused on the "Orders" section.
Using the Search Bar and Filter Syntax
The most direct way to filter orders is by using specific search terms in the search bar located at the top of the Orders page. Shopify recognizes several keywords that help narrow down results.
To find orders from a specific provider, you can often just type the name of the provider (e.g., "Afterpay" or "PayPal") directly into the search bar. However, for more accuracy, use the following syntax:
-
payment_method:afterpay— Isolates orders where Afterpay was the gateway. -
payment_method:'Shop Pay Installments'— Uses quotes for multi-word payment methods.
Utilizing the "Filter" Button
Next to the search bar, the "Filter" button allows you to select conditions from a dropdown menu. While "Payment Status" (Paid, Authorized, Pending) is a standard option here, filtering by the specific name of the gateway often requires the search bar method mentioned above or the use of custom reports.
Identifying Shop Pay Installments
A common requirement for modern merchants is isolating installment-based orders. In the search bar, you can search for shop_pay_installments to see these specifically. This is particularly useful for stores that see a high volume of BNPL (Buy Now, Pay Later) transactions and need to track the specific impact of these services on their overall conversion rates.
Key Action Steps for Basic Filtering:
- Navigate to your Shopify admin and select "Orders."
- Use the search bar with the
payment_method:[name]syntax. - Check the "Payment Status" filter to ensure you are looking at captured vs. authorized orders.
- Save the search as a "View" to access it with one click in the future.
Hide, sort, and rename Shopify payment methods using powerful conditions. Customize your checkout and control payment options with HidePay.
Managing Manual Payment Captures
If your store is configured for manual payment capture, filtering becomes a daily operational requirement. Manual capture is often used by merchants who need to verify stock levels before taking payment or those who want to perform fraud checks on high-value orders.
Finding Authorized Orders
Orders that have not yet had funds collected will appear with the "Authorized" status. You can filter for these specifically by clicking the "Payment Status" filter and selecting "Authorized." This creates a to-do list for your team to capture funds before the authorization period expires.
Partial Captures and Filtering
In scenarios where you can only fulfill part of an order, you might perform a partial capture. Shopify allows you to filter by status, but tracking partial payments often requires exporting your order data. When you capture a partial amount, the order remains in a state that requires attention, making it vital to monitor these orders so they don't fall through the cracks.
Authorization Windows
Different payment providers have different windows for how long an authorization lasts (often 7 days for Shopify Payments). By filtering for authorized orders and sorting them by "Date (oldest first)," you can ensure that you capture funds before the window closes and you lose the ability to collect payment for that order. For merchants who need to block or validate orders programmatically (for example, to prevent high-risk captures), apps like CartBlock — block or validate orders can add automated checks before fulfillment.
Advanced Reporting and Custom Filters
For merchants on the Advanced Shopify or Shopify Plus plans, custom reports offer a much more granular way to analyze payment data. Standard order lists are great for fulfillment, but reports are better for strategic analysis.
Creating a Custom Payment Method Report
You can create a custom report by navigating to "Analytics" and then "Reports." When you create a custom report based on "Orders," you can add "Payment Method" or "Gateway" as a column. This allows you to see a side-by-side comparison of how different methods are performing.
Reconciling with Transaction IDs
Sometimes, a merchant needs to find a specific order based on a transaction ID provided by a third-party gateway. In the Shopify search bar, you can use the syntax receipt.payment_id:[ID_NUMBER] to locate the exact order. If you also need to match payment method names or debug why a method didn't hide as expected, see the help guide on how to retrieve the correct payment method in HidePay.
Exporting Data for External Analysis
If the native filters aren't sufficient for a complex audit, exporting your orders to a CSV file is the best alternative. The "Payment Method" column in the exported CSV will list the gateway used. You can then use spreadsheet software to create pivot tables that summarize your total sales volume by payment type, which is essential for calculating the true cost of credit card processing fees across your store.
Controlling Payment Options at the Source
While filtering orders after they are placed is necessary, many administrative headaches can be prevented by controlling which payment methods appear at the checkout. If you find yourself constantly filtering out and cancelling orders from a specific region that uses a high-risk payment method, the better solution is to hide that method for those specific customers.
The app we developed, HidePay, gives you the ability to create a payment customization in HidePay that governs your checkout's appearance. Instead of manually filtering "Authorized" COD orders that you know you won't ship to a certain zip code, you can simply hide the COD option for those zip codes. This moves the filtering logic from the back end of your store to the front end, preventing problematic orders from ever being placed.
Sorting for Better Conversions
Order filtering often reveals that customers prefer certain payment methods in specific regions. You can use our tool to sort payment methods so that the most popular or lowest-fee options appear first. If your data shows that customers in Europe prefer local methods over standard credit card entries, you can move those local options to the top. This reduces friction and can improve your conversion rate without changing your actual product offering. See the step-by-step guide to Sort and Rename payment methods for the exact UI actions.
Renaming for Clarity
Sometimes, order reconciliation is difficult because the payment method name in Shopify doesn't match what the customer sees. We allow you to rename payment methods. For example, you might rename "Bank Deposit" to "Direct Wire Transfer (Includes 2% Discount)" to make the instructions clearer for the customer and more descriptive for your fulfillment team when they filter these orders later. If names don't line up, consult the logs and the guide to retrieve the correct payment method in HidePay to ensure you target the right entry.
Using Rules to Streamline Order Management
By using conditional logic at checkout, you can drastically reduce the complexity of your order list. We built the app to handle various merchant scenarios that standard Shopify settings cannot address. For merchants who want to manage both payment and shipping behavior together, learn how the HideSuite — HidePay + HideShip bundle brings both tools into one workflow.
Geography-Based Rules
International shipping carries different risks. If you want to avoid filtering through dozens of unpaid orders from a country where you don't offer certain payment terms, you can set a rule to hide those terms based on the customer's country. Learn how to organize payment methods by country or Shopify Market for step-by-step instructions. This keeps your "Orders" tab clean and focused only on viable transactions.
Cart Total and Product Type Conditions
High-ticket items may require different payment handling than low-cost accessories. You can create rules to:
- Hide "Buy Now, Pay Later" options for orders over a certain dollar amount to limit your risk.
- Show specific B2B payment methods (like "Net 30") only when a customer has a specific tag.
- Disable express checkout buttons for products that require a custom shipping quote.
If you need to hide payments when specific products are present, see the FAQ article on how to hide payment methods for certain products.
Native Performance with Shopify Functions
The app is built on native Shopify Functions. This means the rules you set run within Shopify's own infrastructure. There are no external scripts that slow down your checkout page. For merchants who want to build or migrate custom Functions, consider SupaEasy — codeless Shopify Functions as a complementary tool to generate or migrate functions without coding. Because it is native, it is also more reliable than older methods that relied on theme code edits or fragile workarounds.
Key Takeaway: Effective order management is a two-part process. Use Shopify's internal filters and search syntax for post-purchase reconciliation, and use a tool like our app to manage payment availability pre-purchase. This dual approach minimizes manual labor and protects your margins.
Scenario: Managing Cash on Delivery
Cash on Delivery (COD) is a prime example of why filtering and checkout control are linked. If you offer COD, your order list will often be cluttered with "Pending" orders.
If you ship to a region where COD has a high refusal rate, your team spends hours filtering these orders to call customers and verify their intent. By using HidePay to hide COD for customers with a history of returns (identified by customer tags) or for specific high-risk provinces, you eliminate those "fake" orders from your list entirely. See the tutorial on how to hide Cash on Delivery for foreign customers with HidePay for step-by-step setup. This allows your team to focus on orders that have already been paid, rather than filtering through a backlog of unverified COD transactions.
Reconciling Cross-Border Trade
When selling internationally, you may use various local gateways. Filtering these in the Shopify admin can become complex if you are using multiple currencies.
When you export your orders to filter by payment method, pay close attention to the "Currency" and "Total" columns. A common mistake in reconciliation is totaling the "Amount" column without account for currency conversion. If you use HidePay to show specific gateways only for their native currencies, your exported reports will be much cleaner — see the guide for how to hide payment methods based on cart currency. For example, showing a specific European gateway only when the cart is in Euros ensures that your Euro-denominated payout reports from that gateway match your Shopify filters perfectly.
Optimizing for Mobile Checkout
A significant portion of order filtering issues stems from "Express Checkout" buttons like Apple Pay or PayPal Express. These often bypass certain cart-level validations, leading to orders that lack specific information your fulfillment team needs.
With HidePay, you can block these express buttons based on specific rules. If an order requires a certain customer tag or a specific delivery method that doesn't play well with express buttons, you can hide them. See the help article on how to hide the Express Checkout with HidePay for details. This ensures that every order appearing in your filtered list has gone through the full checkout process and contains all the necessary data for processing.
Conclusion
Mastering the ability to filter orders by payment method is a necessity for any growing Shopify store. Whether you are using the search bar syntax for quick checks or custom reports for deep financial audits, having this data at your fingertips allows for better decision-making.
However, the most successful merchants don't just react to their order data; they shape it. By using HidePay to control which payment methods are available, you can reduce the need for constant manual filtering and prevent problematic orders from ever reaching your queue. When you're ready, try HidePay on Shopify and take control of your checkout today.
- Use
payment_method:[name]in the search bar for instant filtering. - Save custom views for your most frequently used payment types.
- Utilize Shopify Functions for a fast, native checkout experience.
- Control payment availability based on geography, cart value, and customer type.
If you are ready to take control of your checkout and simplify your order management, you can find our app on the Shopify App Store.
FAQ
How do I filter Shopify orders for a specific gateway like PayPal?
You can filter for PayPal orders by going to the "Orders" page in your Shopify admin and typing payment_method:paypal into the search bar. This will isolate all orders processed through the PayPal gateway. You can then save this as a custom view for future access.
Can I filter orders by payment method on the Shopify mobile app?
Yes, you can use the search functionality within the Shopify mobile app to find orders by payment method. While the dedicated "Filter" button has limited options, entering the gateway name in the search bar will pull up the relevant orders. For more complex filtering, the desktop admin is generally preferred.
Is it possible to see which orders used Shop Pay Installments?
To see orders that specifically used Shop Pay Installments, enter shop_pay_installments into the search bar on your Orders page. If you need a more detailed breakdown for accounting, you can create a custom report in the Analytics section (available on Advanced or Plus plans) and add "Payment Method" as a column.
How can I hide a payment method so I don't have to filter it out later?
You can use an app like HidePay to set rules that hide specific payment methods during checkout. For example, if you want to prevent Cash on Delivery orders from certain zip codes, you can create a rule that hides that option for those specific areas. This prevents the orders from being placed, so you don't have to filter or cancel them later.