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

FilterPossible ConditionsDescription / Example Value
ID
  • equals to any of
  • not equal to any of
Allows you to list specific Product IDs to export, separated by a comma.

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

my-product-handle
Title
  • contains any of
  • equals to any of
  • matches pattern
  • contains none of
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

Part of Title, other title
Title * End of Title
Vendor
  • equals any of
  • not equal to any of
  • contains none of
  • contains any of
Allows you to export Products that have specific Vendors, separated by a comma.

Vendor-1, Vendor Other
Type
  • equals to any of
  • contains any of
Allows you to filter by many Type values, separated by a comma.

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

tag1, tag2, tag3
SKU
  • contains any of
  • not equal to any of
Allows you to export only those Products whose Variants have any or none of the listed SKU or SKU fragments. Separated by a comma.

sku1 fragment, sku2
Price
  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
Allows you to export only those Products whose Variants have this specific price.

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

123111222333, my-collection-handle, My Collection Title
Published Status
  • published
  • unpublished
Allows exporting only Products that are Published or Unpublished.
Inventory Quantity
  • less than
  • greater than
  • equals
Allows you to export only those Products whose Variants have this specific quantity.

5
Barcode
  • equals to any of
  • not equal to any of
Allows exporting products with or without specific Barcode..

12395876123
Created At
  • From
  • To
  • Date range
Allows exporting Products which were created in the Shopify within a specific date range
Updated At
  • From
  • To
  • Date range
Allows exporting Products which were last updated in the Shopify within a specific date range
Published At
  • From
  • To
  • Date range
Allows exporting Products which were published in the Shopify within a specific date range
Body HTML
  • contains
  • does not contain
Allows to export Products which does or does not contain specific string of text in their description.

Part of product description
Weight
  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
Allows you to export only those Products whose Variants have this specific weight.

29.46

Smart Collections and Custom Collections

FilterPossible ConditionsDescription / Example Value
Handle
  • equals to any of
Allows you to export specific collections by their Handles, separated by a comma.

my-collection-handle, other-collection-handle
Products Count
  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
With the “Products Count” filter you can export collections that have a specific amount of Product in it based on your set condition.

5

Customers

FilterPossible ConditionsDescription / Example Value
Date CreatedDate Range:

  • From: YYYY-MM-DD
  • To: YYYY-MM-DD
Allows you to export Customers that have been created within a specific date range.

For today you can leave one of the date fields empty.

Date UpdatedDate Range:

  • From: YYYY-MM-DD
  • To: YYYY-MM-DD
Allows you to export Customers that have been last updated within a specific date range.

For today you can leave one of the date fields empty.

Tags
  • contains any of
  • contains all of
  • contains none off
Allows to export Customers that have all listed tags, any of listed tags or none of the listed tags. Separated by a comma.

tag1, tag2, tag3
E-mail
  • equals to any of
Put the comma-separated list of all the Customer e-mails which you want to filter by.

[email protected], [email protected]

Draft Orders

FilterPossible ConditionsDescription / Example Value
Date RangeDate Range:

  • From: YYYY-MM-DD
  • To: YYYY-MM-DD
Allows you to export Draft Orders that have been created within a specific date range.

For today you can leave one of the date fields empty.

Relative DateLast full:

  • Minutes
  • Hours
  • Days
  • Months
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.

4
Status
  • Open
  • Invoice Sent
  • Completed
Allows exporting all Draft Orders that have a specific status.

Orders

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

FilterPossible ConditionsDescription / Example Value
ID
  • equals to any of
  • not equal to any of
Allows you to list specific Order IDs to export.
Separated by a comma.

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

#1015, #1023
Date RangeDate Range:

  • From: YYYY-MM-DD
  • To: YYYY-MM-DD
Allows you to export Orders that have been created within a specific date range.

For today you can leave one of the date fields empty.

Relative DateLast full:

  • Minutes
  • Hours
  • Days
  • Months
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.

4
Status
  • Open
  • Canceled
  • Archived
Allows you to export all Orders that have a specific status.
Payment Status
  • Unpaid
  • Authorized
  • Pending
  • Partially Paid
  • Paid
  • Partially Refunded
  • Refunded
  • Voided
Allows exporting all Orders with specific Payment Status
Fulfillment Status
  • Unfulfilled
  • Partially Fulfilled
  • Fulfilled
Allows exporting all Orders with specific Fulfillment Status
Product Vendor
  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of
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.

Vendor-1, Vendor Other
Product Handle
  • equals to any of
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.

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

tag1, tag2, tag3
Product SKU
  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of
Allows exporting Orders that have at least one Line Item with specific SKU/s.
Separated by a comma.

MY-SKU-1, Other SKU, SKU123123
Discount Code
  • equals to any of
  • not equal to any of
Allows to export Orders where specific Discount Code has been used.
Separated by a comma.

CODE 123, Summer-Sale
Payment Gateway
  • equals to any of
  • not equal to any of
Allows you to export Orders where specific Payment Gateway has been used.

paypal
Source
  • equals to any of
  • not equal to any of
Allows export Orders that are coming from a specific source.

shopify_draft_order

Payouts

FilterPossible ConditionsDescription / Example Value
Date RangeDate Range:

  • From: YYYY-MM-DD
  • To: YYYY-MM-DD
Allows you to export Shopify Payouts that have been created within a specific date range.

For today you can leave one of the date fields empty.

Relative DateLast full:

  • Minutes
  • Hours
  • Days
  • Months
Allows you to export Shopify Payouts that has been created in the last full amount of time.

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

4

Pages

FilterPossible ConditionsDescription / Example Value
ID
  • equals to any of
  • not equal to any of
Allows you to list specific Page IDs to export or not include in the export, separated by a comma.

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

Part of Title, other title

Blog Posts

FilterPossible ConditionsDescription / Example Value
ID
  • equals to any of
  • not equal to any of
Allows you to list specific Blog Post IDs to export or not include in the export, separated by a comma.

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

Part of Title, other title, different title
Handle
  • equals to any of
  • contains any of
Allows exporting Blog Posts filtering the export by Blog Post Handle, separated by a comma.

my-blog-post-handle, your-blog-post
Blog Handle
  • equals to any of
Allows exporting Blog Posts filtering the export by Blog Handle, separated by a comma.

news, first-blog