Help CenterContact support
All Columna: Order Export & Sheets articles

How do I filter orders before I export them?

Updated

On this page
  1. How filters work
  2. Steps
  3. Verify it worked
  4. Sort and page through the list
  5. Pickup or delivery date
  6. Good to know
  7. Troubleshooting

Use the filters on the Orders page to choose which orders go into your file: by date, status, fraud risk, tag, payment method, discount code, POS location, shipping country, shipping method, product type, SKU, vendor or sales channel.

How filters work

The filters above the order list decide two things: which orders the list shows, and which orders the app exports when you choose All orders that match your filters in the Export orders window. Orders you tick are exported as they are, without these filters.

Steps

  1. In the app, open Orders.
  2. Pick a view in the view menu: All, Unfulfilled, Unpaid or Paid. When you set the statuses yourself, the menu shows Custom.
  3. Type in Search by order number, customer or email to find orders by order number, customer or email.
  4. Click the date filter (it shows Last 30 days when you open the page). Choose Last 7 days, Last 30 days, Last 90 days or Last 12 months, or enter dates in Created from and Created to.
  5. Click Status and tick the values you want. Tick several to export orders with any of them; tick none to leave the filter off:
    • Payment status: Paid, Pending, Authorized, Partially refunded or Refunded.
    • Fulfillment status: Unfulfilled, Partially fulfilled or Fulfilled.
    • Sales channel: Online Store, Point of Sale or Draft orders.
    • Fraud risk: High, Medium, Low, None or Not checked yet.
  6. Click More filters. Each filter takes several values: type a value and click Add (or press Enter), click a suggested value under the field, or pick one from the list. Click the x next to a value to remove it.
    • Tagged with: only orders with any of these tags.
    • Not tagged with: leave out orders with any of these tags.
    • Payment method: for example shopify_payments or manual. The app suggests the methods of your recent orders.
    • Discount code: matches the first discount code used on the order.
    • POS location: shown when your recent orders include Point of Sale orders.
    • Shipping country: the country of the shipping address.
    • Shipping method: the shipping method name the customer chose, for example “Standard”.
    • Product type: orders with at least one item of these product types.
    • Line item filter: choose SKU, Vendor or Product title and enter a Value. Only matching line items are exported and orders without a match are skipped.
  7. Click Export.

Verify it worked

  • The list shows only the matching orders. With no match you see “No orders found” and “Try a different filter or search.”
  • In the Export orders window you see how many orders match, for example “All 42 orders that match your filters”.
  • The History page lists the filters of each export, such as “Tag: wholesale” or “Payment method: manual, paypal”.

Sort and page through the list

Click the Order, Date, Customer or Total column header to sort the list. Use Items per page (25, 50 or 100) and the arrows under the list to move between pages. Sorting and paging change only the list, not the export.

Pickup or delivery date

Shops that sell for a pickup or delivery day can also filter by Pickup or delivery date. With that filter set, a Location filter appears for pickup locations. See “How do I plan production by pickup or delivery date?”.

Good to know

  • Shipping country, Shipping method and Product type are applied to the exported file only. The order list and the order count in the Export orders window do not use them, so the window does not show a count while one of them is set. The other filters narrow the list, the count and the file.

  • Each filter holds up to 20 values of up to 255 characters.

  • Order dates use your store’s time zone from Settings › General in Shopify admin.

  • The search text is not saved in History, so an export made with a search cannot be run again from there.

Troubleshooting

You see “The start date must be before the end date.” Change Created from or Created to so the start comes first.

You see “Enter a date as YYYY-MM-DD, for example 2026-10-16.” Type the date in that form, or pick it from the calendar.

You see “Orders older than 60 days are not accessible yet.” The app can read only the last 60 days of orders until Shopify grants it access to all orders. Choose a date range within the last 60 days.

You see “No orders yet”. Your store has no orders. Orders show up here once customers place them.

Built and supported by StoreFleet, Shopify app developers since 2021.