It is not always necessary to add all existing products to the feed file. You may need to only export the products of some specific category, brand, size, color, or even based on several conditions at the same time. The “Filter Configuration” section in the FeedPro extension specifically serves this purpose. You may add as many filtering conditions as you need.
You can filter the products by all conditions together or by any of them separately.
Select the Attribute you wish to filter and then select the Condition and Value to be applied.
Screenshot: Products Filter Configuration
- not equal
- greater than
- less than
- greater than or equal to
- less than or equal to
- like: use this option if you want to search and add the products with the specified parameters to the feed file. Use the "%" sign for like and not like options (see example below);
- not like: use this option if you want to search and exclude the products with the specified parameters from the feed file (see example below).
Enter filter value.
Example for "like" ("not like") option:
Use A123% - then SKU's that only begin with A123 will be added to the feed file.
Use %A123 and SKU's that only end with A123 will be added to the feed file.
Use %A123% and SKU's that only contain A123 in any place will be added to the feed file.
You can delete rows using the "Remove" button.
Add Filter Row
You can add new rows using the "Add Filter Row" button.
Please pay attention to the following filter conditions as example.
If a product attribute is not equal to the filter condition value, e.g., 'Price is not equal to 200', then all products that have price not equal to 200 will be added to the feed file.
If you want to export the products with the price equal to 200, you should configure the filtering condition in the following way: 'Price is equal to 200', then all products that have price equal to 200 will be added to the feed file.
Special Price Option
This option gives an opportunity to export the products that have a Special price on the current day. You need to choose the following settings in the Filter configuration tab:
Special Price From Date - equal - today
Special Price To Date - equal – today
Null Filter Condition
There are some cases when you need to configure the following filter condition: "Attribute!= 0 or Attribute = 0".
Screenshot: “Null Condition”
Sometimes this condition cannot be applied because Magento® system doesn’t consider “0” as a numeric value, but as “null”. So, we advise you to change the condition using Condition field without using “0”.
You can use the following condition: "Attribute >= 1 or = Attribute =< 1"
Screenshot: “Correct Condition”
There will not be any problems with filtering on this condition.