Set up a set of rules based on the fields you have mapped. You can filter in two ways, either by including rows through rules, or by excluding rows through rules.
When you go to the step “Filtering”, you will see the two options:
- “Add rules to remove rows”
- “Add rules to include rows”
This is where you decide if the rows should be either included or excluded. Below, you can see “+ Add filter”, where you can click to set up the filter. When you click it, on top you will see that you can put a title on the filter and sort the order.
Afterwards, you can click to choose which of the fields you mapped you can filter.
You can always add another filter and if you have more than one filter, you can choose to include all of the filters by clicking the blue switch “AND”. Or, you can click the blue switch “OR” and choose which specific filter should be applied, from all of the ones you have set up.
Also, you can edit or remove a filter with the buttons shown at the bottom of the page. You can have as many and as complex rules as you like. For example, you can filter out products that are no longer sold but still in the inventory.
However, in 99 out of 100 cases, it is recommended that you do not want to set up rules in import filtering, but in export filtering.
For instance, if you might use the data for one location but not another, you should not filter it out on importing but in exporting.