Get Excelify now
Get Excelify now

More filters for Shopify Products export

Shopify Products export filter excel csv

Recently we have received a lot of requests for various export filters, so here is a new batch of amazing filters for your Product exports and changes for existing filters.

Look up more info about Excelify exported Products.

New Product filters

Barcode

It provides the ability to filter Products by Barcode. If at least one Variant matches the given condition, then the whole product will be included in the export.

Possible conditions:

  • equals to any of
  • not equal to any of

Created At, Updated At and Published At

It allows you to filter your exported products by a specific date range.

Created At – the date when the Product was created in the Shopify.
Updated At – the date when the Product was last updated in the Shopify.
Published At – the date when the Product was published in the Online Store sales channel.

Possible conditions:

  • from – starting from specific date till today
  • to – from beginning of time till a specified date
  • date range – between two specific dates

Body HTML

It gives the ability to export only Products that contain or does not contain specific text in their descriptions.

Possible conditions:

  • contains
  • does not contain

Weight

Filters the exported Products file by Variant Weight field. Returning only Products that have at least one variant with matching Variant Weight.

Possible conditions:

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

Updates for existing filters

ID

Added condition “not equal to any of” providing the ability to export Products that do not have specific IDs.

Title

Added conditions:

  • Matches pattern – use wildcards when filtering Products by Title.
    * – asterisk symbol will represent none or any amount of any characters
    ? – question mark will represent any single character
    Example – if you have Product names “A Title1”, “B Title2”, “Title3”, “Title 99” you can apply filter “*Title?”. The app will export all Products where the product name starts with any amount of any characters or no characters before the word “Title” and have 1 character after the word “Title”. So the product “Title 99″ will not get exported as there are 3 characters after it – ” 99″.
  • contains none of – Allows exporting all Products that do not have a specific string of text in the Title

Type

Added condition “contains any of”. Allows exporting Products that contain specific fragments in their Type field.

Vendor

Added condition “contains any of“. Allows to export Products that contain specific fragments in their Vendor field.

Collections

Added condition “not equal to any of“. Allows to export Products that are not in specific Collections.

Price

Added condition “between“. Allows exporting Products where at least one Variant Price field value is between two specific numbers.