Array ( [0] => GDPR Cookie Consent [1] => CCPA [2] => Getting Started [3] => Changelog [4] => GDPR [5] => Add and Categorise Cookies [8] => Auto-block cookies with Script Blocker [13] => Create Privacy Policy Page [15] => Customize Cookie Notice [18] => Customize Settings Pop up [19] => Change Toggle button color [21] => Display Cookie List [22] => FAQ [23] => Getting Started [24] => Multilingual Support [25] => Overview [26] => Import Export Suite for WooCommerce [28] => Order / Coupon / Subscription Export Import Plugin for WooCommerce [29] => PayPal Express Checkout Payment Gateway for WooCommerce [30] => Changelog [31] => Getting Started [32] => Issue Refund [34] => Video Tutorial [35] => Print Invoice, Packing Slip, Delivery Note & Label for WooCommerce [36] => Address Label [39] => Changelog [41] => Credit Note [43] => Delivery Note [45] => Dispatch Label [47] => FAQ [48] => Invoice [49] => Adding meta data [50] => Customizations [51] => Email PDF Invoice [52] => FAQ [53] => Getting Started [54] => Invoice Number [55] => Multilingual Support [56] => Overview [57] => Packing Slip [58] => Customizations [59] => Getting Started [60] => Pick List [62] => Proforma Invoice [65] => Shipping Label [68] => Product Import Export Plugin for WooCommerce [69] => Smart Coupons for WooCommerce [70] => Abandoned Cart Discount [71] => Advanced Coupon Options [72] => Bulk Generate [73] => Changelog [76] => Getting Started [78] => Import Coupon [80] => Sales Countdown Timer [81] => SignUp Coupon [82] => Store Credit [84] => Volume/Quantity based coupon [85] => Stripe Payment Gateway for WooCommerce [86] => Alipay [87] => Apple Pay [88] => Changelog [89] => Compatibility with Subscription [90] => Getting Started [93] => SCA Ready [94] => Stripe Checkout [95] => Stripe Overview [96] => Stripe via Credit Card [97] => Troubleshoot [98] => Video Tutorial [99] => Subscriptions for WooCommerce [100] => Changelog [101] => Email Notifications [102] => FAQ [103] => Getting Started [104] => Manually Add or Modify Subscriptions [105] => Subscriptions Payment Gateway Guide [106] => URL Coupons for WooCommerce [107] => Changelog [108] => FAQ [109] => Getting Started [110] => Import URL Coupons [111] => QR Code Coupon [112] => WordPress Users & WooCommerce Customers Import Export )

Documentation/Order / Coupon / Subscription Export Import Plugin for WooCommerce/How to filter WooCommerce order export by ordered products

How to filter WooCommerce order export by ordered products

Order/Coupon/Subscription Import Export for WooCommerce plugin enables import and export of orders, subscriptions, and coupons in CSV/XML format. The plugin is capable of providing add-on filter options while bulk import or export.

You can filter orders by order statuses, coupons used, products ordered, etc. Here, we will detail how the orders can be filtered by specific products while export.

  1. Install and activate the order import export plugin in the usual manner. Navigate to WooCommerce > Order Im-Ex
  2. In order to export the orders, select Export from beneath the Order tab. The plugin comes with various options to incorporate the order export for exporting orders in different manners as shown below:

    WooCommerce Order Export

    WooCommerce Order Export

  3. The order export window consists of following fields
    • Order Statuses:  Select order statuses for which you want to export orders from the list.
    • Products: To export orders of only specific products, select required products from this field. For example, if you want to export orders containing products Hoodie with pocket and Tshirt only, then select those products from the product list as shown below:

      Export orders by products

      Export orders by products

    • Coupons: Enter coupon codes separated with commas to export those orders to which the specified coupon codes are applied.
    • Offset: Enter the order row number at which you wish to start the export.
    • Limit: Enter the maximum number of orders that you wish to export.
    • Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
    • End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
    • Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
    • Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.
    • Exclude already exported: Check this to avoid duplication while exporting.
    • Export line items into separate columns: In order to export line items in a separate column, tick this checkbox.
    • Include hidden metadata: If you want to include custom metadata of the order in the export, especially from third-party plugins, then tick this checkbox. 
    • Click Export Orders (CSV) or Export Orders (XML), the CSV/XML file gets auto-downloaded to your computer.

Refer to how to Import and Export WooCommerce Orders by using Order /Coupon / Subscription Export Import plugin for WooCommerce. Please refer to the product page to know more about the plugin features.

  • Was this article helpful ?
  • YesNo