How to Filter, Remove, or Exclude Products using Rules on any Field
Product Filters (Rules on any Field)
Product filters are analogous to email filters, and allow you to exclude items from the data feed. Your feed can also be configured to include only the items matching the filters. You can set up filters from the "Manage Feed > Product Filters" page.
You can add a filter on any field For example, you can add a filter to exclude items where 'price' < 1.00, 'title' contains "gift certificate", or 'qty' = 0.
Using your Store's Catalog to Filter
Rather than configuring filters in our system, it may be more convenient for you to control which items are excluded and included directly from your store catalog. To set that up, follow these steps:
- Add a custom field to your store catalog, like 'exclude-from-nextag' with values 'y' and 'n'.
- Add a catalog field to your feed for this custom field from the "Manage Feed > Define Fields" page, and mark it disabled.
- Create a filter like 'exclude-from-nextag = "y"'.
Use the Manage Feed > Analyze Source Data tool to see the values in the raw data for your boolean field. Use those values to set up the filters accordingly. For example, a 'false' may be represented by a blank value, and 'true' may be represented by a 't'.
Viewing Filtered and Unfiltered Items
After making your changes, look in the "Product List" to review the filtered and unfiltered items. Filtered items will appear with strike-through. Then, run a Submit task from "Submit a Task" to send your updated feed to its destination.
Although we do not recommend this, you can also manually remove items. Download your data feed file from the "Data Feed File" page, remove the items using a spreadsheet program, and then upload it manually. This is not recommended because you would have to repeat the manual clean-up every time.
Regular Expression Filters
Filters can be added using regular expressions. Regular expression syntax is essentially an extremely terse programming language. So they are very powerful, but also very hard to learn how to write. You can use this MySQL Regular Expressions Documentation for reference, or contact us for free setup of regular expression filters.