Export WooCommerce Orders with Payment Method – Paypal

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

How to export orders from WooCommerce by Payment method

In our comprehensive WooCommerce Reporting Plugin, one of the most powerful dashboard report is the Export Order Details report.

The most powerful filter of all is the meta data filter.

Using this filter you can query and export every aspect of your woocommerce order information.

For e.g Let say you need to Export all orders with a particular payment type. In this example we will try to filter only those orders that are paid via Paypal.

  1. Open the WooCommerce Reporting Interface

How to use Meta Filter

2. Click on the “Export Order Details

On the left hand side you will see the meta data filter as below

Switch the Filter option to “Include”. When you select “Ignore” then all meta data selections will be ignored. Include will match your selected condtions and Exclude will filter out your selected values and show you only that don’t match.

How to use Payment Filter

In our case we want to know all the orders in a particular period that contain “Paypal” as payment method.

So we select “Include” and then from the “Select Meta Field” we pick “_payment_method”

This drop down shows all the possible meta fields in your WooCommerce system. It will also list any additional Order level meta fields that may come from custom plugins.

Once you select “_payment_method”, the drop down below will dynamically filter and show you the valid values for that filter.

In this case we pick “Paypal” and the main table grid will display all WooCommerce orders containing Paypal as payment type.

Similarly, you can

  • Find all WooCommerce Orders paid by Stripe (select only stripe in the meta field value)
  • Find all WooCommerce Orders that are paid by Stripe and Paypal ( select Stripe first, press Ctrl key and then select Paypal)

How to select multiple values

  • Find all WooCommerce Orders paid by Check (just select the payment method type)
  • Find all WooCommerce orders paid by deposit using the deposit filter on the left hand side
  • Find all Orders that are not paid via Paypal
  • Find all Orders that are originated from a particular country (select _billing_country from meta field filter)
  • Find all Orders that ship to any particular country (select _shipping_country)
  • Find all Woo Orders that contains shipping state as “Pennsylvania” and “New York” (use Ctrl Key and then select the first state and the next state)
  • Find all WooCommerce Order Details by particular order currency (You can select a range or currencies by simple drag selecting all or multiple values)

We are constantly updating and adding new features to this reporting plugin. It is super fast as it does not use any of the WooCommerce or WordPress tables for reporting purpose. We also provide “Non Cached” version that are slow but report on top of the wordpress tables but we do not recommend them.

So what are you waiting for?

Go get the most advanced WooCommerce reporting plugin .

We are actually selling at a steep discount!

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH