Start Free Trial
Start Free Trial

Use filters to export only specific items from your Shopify Store.

Save time by filtering your Shopify exports

In the Matrixify app, you can apply filters to Export only specific items from your Shopify Store.
You can find the Shopify export filter icon in the Matrixify app when creating new export, select what you wish to export, and under that entity click on the “Filters” button.
Select the filter of your choice for your items and press “Set” to apply the filter to your next export.

Shopify export filters within the 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.

Filters location

Available Filters

Products

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

Possible Conditions

  • equals to any of
  • not equal to any of

Example

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

Possible Conditions

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

Example

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

Possible Conditions

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

Example

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.

Possible Conditions

  • contains
  • does not contain

Example

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

Possible Conditions

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

Example

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

Possible Conditions

  • equals to any of
  • contains any of

Example

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.

Possible Conditions

  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of
  • starts with any of
  • matches pattern

Example

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.

Possible Conditions

  • 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.

Possible Conditions

  • on or after
  • on or before
  • date range
  • relative date
Status Allows filtering Products export by the Products status in Shopify.

You can select multiple conditions in this filter. Selecting all would be the same as not applying the filter.

Possible Conditions

  • Active
  • Draft
  • Archived
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.

Possible Conditions

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

  • 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.

Possible Conditions

  • equals to any of
  • not equal to any of

Example

123111222333, my-collection-handle, My Collection Title
Variant 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.

Possible Conditions

  • equals to any of
  • contains any of
  • not equal to any of
  • starts with any of

Example

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

Possible Conditions

  • equals to any of
  • not equal to any of

Example

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

Possible Conditions

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

Example

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

Possible Conditions

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

Example

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

Possible Conditions

  • less than
  • greater than
  • equals

Example

5
Metafield Filters the Orders export by Product level Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value

Possible Conditions for Text value:

  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty

Possible Conditions for Number value:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

Smart Collections and Custom Collections

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

Possible Conditions

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

Example

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

Possible Conditions

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

Example

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.

Possible Conditions

  • 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.

Possible Conditions

  • 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.

Possible Conditions

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

Example

5
Metafield Filters the Orders export by Collections Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value

Possible Conditions for Text value:

  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty

Possible Conditions for Number value:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

Customers

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

Possible Conditions

  • equals to any of

Example

[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.

Possible Conditions

  • 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.

Possible Conditions

  • 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.

Possible Conditions

  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of
  • starts with any of
  • matches pattern

Example

tag1, tag2, tag3
Address Country Code Filters Customers that have addressed with specific country codes.
This allows exporting customers from specific countries.You can list multiple two-digit country codes, separated by a comma.
You can see list of all Shopify approved Countries and their codes in Matrixify Countries and Provinces documentation.Possible Conditions

  • equals to any of
  • not equal to any of

Example

US, FR, LV
Accepts Marketing Filters Customers that have or have not subscribed to marketing emails.

Possible Conditions

  • Yes
  • No
Email Marketing: Status Filters Customers that have or have not subscribed to marketing emails.

Possible Conditions

  • Subscribed
  • Not Subscribed
Metafield Filters the Orders export by Customers Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value

Possible Conditions for Text value:

  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty

Possible Conditions for Number value:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

Discounts

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

Possible Conditions

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

Example

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.

Possible Conditions

  • 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.

Possible Conditions

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

Draft Orders

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

Possible Conditions

  • equals to any of
  • not equal to any of

Example

12311123423,2342342342
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.

Possible Conditions

  • 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.

Possible Conditions

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

You can select multiple conditions in this filter. Selecting all would be the same as not applying the filter.

Possible Conditions

  • Open
  • Invoice Sent
  • Completed
Tags Allows to export Customers that have all listed tags, any of listed tags, or none of the listed tags. Separated by a comma.

Possible Conditions

  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of
  • starts with any of
  • matches pattern

Example

tag1, tag2, tag3
Metafield Filters the Orders export by Draft Order Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value

Possible Conditions for Text value:

  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty

Possible Conditions for Number value:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

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.Possible Conditions

  • equals to any of
  • not equal to any of

Example

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

  • equals to any of
  • starts with any of

Example

#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.

Possible Conditions

  • 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.

Possible Conditions

  • 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.

Possible Conditions

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

    • contains any of
    • contains all of
    • contains none of
    • equals to any of
    • equals to all of
    • not equal to any of
    • starts with any of
    • matches pattern

Example

tag1, tag2, tag3
Status It allows you to export all Orders that have a specific status.

You can select multiple conditions in this filter. Selecting all would be the same as not applying the filter.

Possible Conditions

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

You can select multiple conditions in this filter. Selecting all would be the same as not applying the filter.

Possible Conditions

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

You can select multiple conditions in this filter. Selecting all would be the same as not applying the filter.

Possible Conditions

  • Unfulfilled
  • Partially Fulfilled
  • Fulfilled
Discount Code Allows to export Orders where specific Discount Code has been used.
Separated by a comma.Possible Conditions

  • equals to any of
  • not equal to any of
  • contains any of
  • starts with any of

Example

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

Possible Conditions

  • equals to any of
  • not equal to any of

Example

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

Possible Conditions

  • equals to any of
  • not equal to any of

Example

shopify_draft_order
Billing: Country Code Filters Orders that have billing address with specific country code.

You can list multiple two-digit country codes, separated by a comma.
You can see a list of all Shopify approved Countries and their codes in Matrixify Countries and Provinces documentation.

Possible Conditions

  • equals to any of
  • not equal to any of

Example

US, FR, LV
Shipping: Country Code Filters Orders that have shipping address with specific country code.

You can list multiple two-digit country codes, separated by a comma.
You can see a list of all Shopify approved Countries and their codes in Matrixify Countries and Provinces documentation.

Possible Conditions

  • equals to any of
  • not equal to any of

Example

US, FR, LV
Line: 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.

Possible Conditions

  • equals to any of

Example

my-product-handle, other-product-handle
Line: 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.

Possible Conditions

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

Example

Vendor-1, Vendor Other
Line: SKU Allows exporting Orders that have at least one Line Item with specific SKU/s.
Separated by a comma.Possible Conditions

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

Example

MY-SKU-1, Other SKU, SKU123123
Line: Variant Inventory Qty Filters the Orders export by Line Items linked Product Variant current total Inventory Quantity.

Possible Conditions

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

Example

99
Metafield Filters the Orders export by Order level Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value

Possible Conditions for Text value:

  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty

Possible Conditions for Number value:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

Payouts

Filter Description
Date Allows exporting Payouts from a specific date range.

Relative 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.

Possible Conditions

  • 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.

Possible Conditions

  • equals to any of
  • not equal to any of

Example

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

Possible Conditions

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

Example

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.

Possible Conditions

  • 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.

Possible Conditions

  • 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.

Possible Conditions

  • on or after
  • on or before
  • date range
  • relative date
Metafield Filters the Orders export by Page Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value

Possible Conditions for Text value:

  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty

Possible Conditions for Number value:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

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.

Possible Conditions

  • equals to any of
  • not equal to any of

Example

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

Possible Conditions

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

Example

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.

Possible Conditions

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

Example

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.

Possible Conditions

  • 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.

Possible Conditions

  • 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.

Possible Conditions

  • 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.

Possible Conditions

  • equals to any of

Example

news, first-blog
Metafield Filters the Orders export by Blog Post Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value

Possible Conditions for Text value:

  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty

Possible Conditions for Number value:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

Activity

Filter Description
Subject Type 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.

Possible Conditions

  • Article
  • Blog
  • Collection
  • Comment
  • Order
  • Page
  • PriceRule
  • Product
  • ApiPermission
Verb Allows you to list activity event verbs separated by a comma to export events that have a specific verb.

See the Shopify API Resources section for a list of possible verbs.

Possible Conditions

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

Example

create
Created At Allows exporting Activity events which were created in the Shopify within a specific date range.

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

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

Possible Conditions

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

Files

Filter Description
File Name
Comma-separated list of text. App will return only FIles where File Name contains at least one of the listed texts.

Possible Conditions

  • contains any of

Example

green, image, my-file, .jpg
Created At Allows exporting which were created in the Shopify within a specific date range.

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

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

Possible Conditions

  • on or after
  • on or before
  • date range
  • relative date
Type Allows selecting to export only Images or generic Files.

Possible Conditions

  • Image
  • File
Size MB Filters the Files by their file size in MB.

Depending of how Shopify CDN stores and optimizes files, size can be different than what you see in Shopify Admin -> Settings -> Files section.

This will also make filtering by Size MB be a bit approximate, because filtering happens by the original file size, but the admin shows the eventually processed CDN file size.

Possible Conditions

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

Example

100
Status Status of the file creation in Shopify:

  • Failed – File processing has failed
  • Uploaded – File has been uploaded but the processing hasn’t started yet
  • Processing – File is being processed by Shopify
  • Ready – File is ready to be displayed

Possible Conditions

  • Failed
  • Uploaded
  • Processing
  • Ready