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
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.
- 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.
- from – starting from specific date till today
- to – from beginning of time till a specified date
- date range – between two specific dates
It gives the ability to export only Products that contain or does not contain specific text in their descriptions.
- does not contain
Filters the exported Products file by Variant Weight field. Returning only Products that have at least one variant with matching Variant Weight.
- less than
- less than or equal to
- greater than
- greater than or equal to
Updates for existing filters
Added condition “not equal to any of” providing the ability to export Products that do not have specific IDs.
- 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
Added condition “contains any of”. Allows exporting Products that contain specific fragments in their Type field.
Added condition “contains any of“. Allows to export Products that contain specific fragments in their Vendor field.
Added condition “not equal to any of“. Allows to export Products that are not in specific Collections.
Added condition “between“. Allows exporting Products where at least one Variant Price field value is between two specific numbers.