Get Excelify now
Get Excelify now

Export filters

Summary

In Excelify app, you can apply filters to Export only specific items from your Shopify Store.
You can find the filter icon in the Excelify app in the Export section. Select the filter of your choice for your items and press “Set” to apply the filter to your next export.

Filters within item category (e.g. Products, Orders, etc.) can be combined.

Note: total displayed item count and estimated time won’t be affected by the filters applied.

Products

Filter Description
ID Allows you to list specific Product IDs to export, separated by a comma.

  • equals to any of
  • not equal to any of

12311123423,2342342342
Handle Allows you to export specific product by its Handle.

  • equals to any of
  • contains any of
  • contains none of

my-product-handle
Title Allows you to export Products whose Title contains specific text.

“Matches pattern” condition allows entering wildcard symbols.
* – asterisk symbol will represent any amount of any characters
? – question mark will represent any one character

  • contains any of
  • equals to any of
  • matches pattern
  • contains none of

Part of Title, other title
Title * End of Title
Body HTML Allows to export Products which does or does not contain specific string of text in their description.

  • contains
  • does not contain

Part of product description
Vendor Allows you to export Products that have specific Vendors, separated by a comma.

  • equals any of
  • not equal to any of
  • contains none of
  • contains any of

Vendor-1, Vendor Other
Type Allows you to filter by many Type values, separated by a comma.

  • equals to any of
  • contains any of

Type-1, Type-2
Tags Allows to export Products that have all listed tags, any of listed tags or none of the listed tags. Separated by a comma.

  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of

tag1, tag2, tag3
Created At Allows exporting Products which were created in the Shopify within a specific date range.Relative date condition allows you to export Products that have been created in the last full amount of time.

For example – Last 1 Days, would export Products from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Products which were last updated in the Shopify within a specific date range.Relative date condition allows you to export Products that have been updated in the last full amount of time.

For example – Last 1 Days, would export Products from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Published At Allows exporting Products which were published in the Shopify within a specific date range.Relative date condition allows you to export Products that have been published in the last full amount of time.

For example – Last 1 Days, would export Products from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Published Status Allows exporting only Products that are Published or Unpublished.

  • published
  • unpublished
Collection Allows to export Products who are in any of the collections with matching collection IDs, Handles or Titles. Separated by a comma.

  • equals to any of
  • not equal to any of

123111222333, my-collection-handle, My Collection Title
SKU Allows you to export only those Products whose Variants have any or none of the listed SKU or SKU fragments. Separated by a comma.

  • contains any of
  • not equal to any of

sku1 fragment, sku2
Barcode Allows exporting products with or without specific Barcode.

  • equals to any of
  • not equal to any of

12395876123
Weight Allows you to export only those Products whose Variants have this specific weight.

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between

29.46
Price Allows you to export only those Products whose Variants have this specific price.

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between

5.99
Inventory Quantity Allows you to export only those Products whose Variants have this specific quantity.

  • less than
  • greater than
  • equals

5

Smart Collections and Custom Collections

Filter Description
Handle Allows you to export specific collections by their Handles, separated by a comma.

  • equals to any of
  • contains any of
  • contains none of

my-collection-handle, other-collection-handle
Title Allows you to export Products whose Title contains specific text.

“Matches pattern” condition allows entering wildcard symbols.
* – asterisk symbol will represent any amount of any characters
? – question mark will represent any one character

  • contains any of
  • equals to any of
  • matches pattern
  • contains none of

Part of Title, other title
Title * End of Title
Updated At Allows exporting Collections which were last updated in the Shopify within a specific date range.Relative date condition allows you to export Collections that have been updated in the last full amount of time.

For example – Last 1 Days, would export Collections from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Published At Allows exporting Collections which were published in the Shopify within a specific date range.Relative date condition allows you to export Collections that have been published in the last full amount of time.

For example – Last 1 Days, would export Collections from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Products Count With the “Products Count” filter you can export collections that have a specific amount of Product in it based on your set condition.

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to

5

Customers

Filter Description
E-mail Put the comma-separated list of all the Customer e-mails which you want to filter by.

  • equals to any of

[email protected], [email protected]
Created At Allows exporting Customers which were created in the Shopify within a specific date range.Relative date condition allows you to export Customers that have been created in the last full amount of time.

For example – Last 1 Days, would export Customers from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Customers which were last updated in the Shopify within a specific date .Relative date condition allows you to export Customers that have been updated in the last full amount of time.

For example – Last 1 Days, would export Customers from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Tags Allows to export Customers that have all listed tags, any of listed tags or none of the listed tags. Separated by a comma.

  • contains any of
  • contains all of
  • contains none off

tag1, tag2, tag3

Discounts

Filter Description
Title Put the comma-separated list of all the Discount Title which you want to filter by.

  • equals to any of
  • contains any of
  • contains none of

X-Mas2019, Black Friday Discount
Created At Allows exporting Discounts which were created in the Shopify within a specific date range.Relative date condition allows you to export Discounts that have been created in the last full amount of time.

For example – Last 1 Days, would export Discounts from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Discounts which were last updated in the Shopify within a specific date range.Relative date condition allows you to export Discounts that have been updated in the last full amount of time.

For example – Last 1 Days, would export Discounts from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date

Draft Orders

Filter Description
Created At Allows exporting Draft Orders which were created in the Shopify within a specific date range.

Relative date condition allows you to export Draft Orders that have been created in the last full amount of time.

For example – Last 1 Days, would export Draft Orders from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Draft Orders which were last updated in the Shopify within a specific date rangeRelative date condition allows you to export Draft Orders that have been updated in the last full amount of time.

For example – Last 1 Days, would export Draft Orders from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Status Allows exporting all Draft Orders that have a specific status.

  • Open
  • Invoice Sent
  • Completed

Orders

You can apply multiple Orders filters for single export, to get only the orders that you need.

Filter Description
ID Allows you to list specific Order IDs to export.
Separated by a comma.

  • equals to any of
  • not equal to any of

12311123423,2342342342
Name Allows to export Orders that starts with any of the text.
Separated by a comma.

  • equals to any of
  • starts with any of

#1015, #1023
Created At Allows exporting Orders which were created in the Shopify within a specific date range.

Relative date condition allows you to export Orders that have been created in the last full amount of time.

For example – Last 1 Days, would export Orders from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Orders which were last updated in the Shopify within a specific date rangeRelative date condition allows you to export Orders that have been updated in the last full amount of time.

For example – Last 1 Days, would export Orders from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Processed At Allows exporting Orders which were processed in the Shopify within a specific date rangeRelative date condition allows you to export Orders that have been updated in the last full amount of time.

For example – Last 1 Days, would export Orders from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Status It allows you to export all Orders that have a specific status.

  • Open
  • Canceled
  • Archived
Payment Status Allows exporting all Orders with specific Payment Status

  • Unpaid
  • Authorized
  • Pending
  • Partially Paid
  • Paid
  • Partially Refunded
  • Refunded
  • Voided
Fulfillment Status Allows exporting all Orders with specific Fulfillment Status

  • Unfulfilled
  • Partially Fulfilled
  • Fulfilled
Product Vendor Comma-separated list of the product Vendor name fragments. Will look through all the Line Items and if any of them will contain this product Vendor, then the whole Order will get included in the export.

  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of

Vendor-1, Vendor Other
Product Handle A comma-separated list of the product Handle fragments. Will look through all the Line Items and if any of them will contain this Handle, then the whole Order will get included in the export.

  • equals to any of

my-product-handle, other-product-handle
Tags Allows to export Orders that have all listed tags, any of listed tags or none of the listed tags.
Separated by a comma.

  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of

tag1, tag2, tag3
Product SKU Allows exporting Orders that have at least one Line Item with specific SKU/s.
Separated by a comma.

  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of

MY-SKU-1, Other SKU, SKU123123
Discount Code Allows to export Orders where specific Discount Code has been used.
Separated by a comma.

  • equals to any of
  • not equal to any of

CODE 123, Summer-Sale
Payment Gateway Allows you to export Orders where specific Payment Gateway has been used.

  • equals to any of
  • not equal to any of

paypal
Source Allows export Orders that are coming from a specific source.

  • equals to any of
  • not equal to any of

shopify_draft_order

Payouts

Filter Description
Date Allows exporting Payoutsfrom specific date rangeRelative date condition allows you to export Payouts from the last full amount of time.

For example – Last 1 Days, would export Payouts from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date

Pages

Filter Description
ID Allows you to list specific Page IDs to export or not include in the export, separated by a comma.

  • equals to any of
  • not equal to any of

12311123423,2342342342
Title Allows you to export Pages whose Title contains or does not contain specific text, separated by a comma.

“Matches pattern” condition allows entering wildcard symbols.
* – asterisk symbol will represent any amount of any characters
? – question mark will represent any one character

  • contains any of
  • equals to any of
  • matches pattern
  • contains none of

Part of Title, other title
Title * End of Title
Created At Allows exporting Pages which were created in the Shopify within a specific date range.

Relative date condition allows you to export Pages that have been created in the last full amount of time.

For example – Last 1 Days, would export Pages from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Pages which were last updated in the Shopify within a specific date range.

Relative date condition allows you to export Pages that have been updated in the last full amount of time.

For example – Last 1 Days, would export Pages from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Published At Allows exporting Pages which were published in the Shopify within a specific date range.

Relative date condition allows you to export Pages that have been published in the last full amount of time.

For example – Last 1 Days, would export Pages from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date

Blog Posts

Filter Description
ID Allows you to list specific Blog Post IDs to export or not include in the export, separated by a comma.

  • equals to any of
  • not equal to any of

12743246124,2346584351
Title Allows you to export Blog Posts whose Title contains or does not contain specific text, separated by a comma.

“Matches pattern” condition allows entering wildcard symbols.
* – asterisk symbol will represent any amount of any characters
? – question mark will represent any one character

  • contains any of
  • equals any of
  • matches pattern
  • contains none of

Part of Title, other title, different title
Title * End of Title
Handle Allows exporting Blog Posts filtering the export by Blog Post Handle, separated by a comma.

  • equals to any of
  • contains any of
  • contains none of

my-blog-post-handle, your-blog-post
Created At Allows exporting Blog Posts which were created in the Shopify within a specific date range.

Relative date condition allows you to export Blog Posts that have been created in the last full amount of time.

For example – Last 1 Days, would export Blog Posts from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Blog Posts which were last updated in the Shopify within a specific date range.

Relative date condition allows you to export Blog Posts that have been updated in the last full amount of time.

For example – Last 1 Days, would export Blog Posts from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Published At Allows exporting Blog Posts which were published in the Shopify within a specific date range.

Relative date condition allows you to export Blog Posts that have been published in the last full amount of time.

For example – Last 1 Days, would export Blog Posts from last full day, so yesterday.

  • on or after
  • on or before
  • date range
  • relative date
Blog Handle Allows exporting Blog Posts filtering the export by Blog Handle, separated by a comma.

  • equals to any of

news, first-blog