The Order / Coupon / Subscription Import Export Plugin for WooCommerce lets you filter the rows in your import file before they are processed. Using filters such as order ID, order date, order status, customer, and ordered items, you can import or update only the orders that match your criteria instead of processing every row in the file.
This is useful when your import file holds a large set of orders but you only need to add or update a specific subset.
Steps to Filter Import Rows
Navigate to WebToffee Import Export (Pro) > Import.
- Select the post type as Order.
- Choose Advanced import as the import method and upload the import file.
- In Step 3 – Map import columns, map the required fields.
- In Step 4 – Filter import rows, configure the required filters.
- Click Step 5: Advanced options/Batch import/Scheduling, configure the remaining options, and complete the import.
Refer to Import WooCommerce Orders to know more about the overall import process.
Filter options are available only with the Advanced import method. If you leave the filter section empty, every row in the import file is imported.
How Import Filters Work
Each filter consists of three fields:
- Element – The order field to filter on.
- Condition – The condition to apply. The available conditions depend on the selected element.
- Value – The value the rows are matched against.
Click + Add new filter to add another filter, or use the delete icon to remove one.
Available Order Import Filters
The following elements are available on the Filter import rows screen:
| Element | Description |
|---|---|
| Order | Imports rows matching the specified order IDs or order numbers. |
| Order Date | Imports orders based on the order date. |
| Order Status | Imports orders with the selected statuses. |
| Customer | Imports orders placed by the specified customers. |
| Item ordered | Imports orders containing the specified products. |
Click + Add new filter and select from the Element dropdown to filter on additional fields.
1. Filter by Order ID or Number
Use the Order filter to target a specific set of orders in the import file.
- Select Order under Element.
- Select Include as the condition.
- Enter the required order IDs or order numbers.
Only the rows matching the entered IDs or numbers are imported. The remaining rows in the file are skipped.
Example: A migration file holds 10,000 orders, but only a handful failed in the previous run. Add an Order → Include filter with those order numbers to retry just those rows.
2. Filter by Order Date
Use the Order Date filter to restrict the import by when the orders were placed.
- Select Order Date under Element.
- Select the required condition.
- Select the date to filter against.
Conditions available for the Order Date filter
| Condition | Description |
|---|---|
| Greater than | Imports orders placed after the selected date. |
| Less than | Imports orders placed before the selected date. |
| Equals | Imports orders placed on the selected date. |
| Not equals | Imports orders placed on any date other than the selected one. |
| In between | Imports orders placed within the selected date range. |
Example: Use Order Date → Greater than with a specific date to process only orders placed after that date, instead of processing the entire file.
3. Filter by Order Status, Customer, or Item Ordered
The remaining filters let you narrow the import by the order’s own attributes:
- Select the required element — Order Status, Customer, or Item ordered.
- Select the required condition.
- Select or search for the required value.
Example: Use Item ordered → Include → Black Hoodie to import only the orders in the file that contain that product.
Using Multiple Import Filters
You can combine multiple filters to narrow the import further. Click + Add new filter to add another condition.
When multiple filters are configured, a row must match all the conditions to be imported. For example:
- Order Status → Include → Processing
- Order Date → Greater than → 01-01-2026
- Item ordered → Include → Hoodie with Logo
Only rows that satisfy all three conditions are imported.
Filtering import rows lets you reuse a single large file across multiple targeted imports, rather than editing the file down each time.
