Import Filters let you import only the rows of a CSV that match conditions you set. Every other row in the file is skipped, so you do not have to cut a supplier file down by hand before uploading it. Leave the filters empty and every row in the file is imported, exactly as before.
Import Filters are available on every CSV import in 3Dsellers, in both the Listings Manager and the Products Catalog.
In this article:
Where do I find Import Filters?
Open any CSV import in 3Dsellers and upload your file. Import Filters sits just above the mapping table, under Mapping Presets, with the note "Only CSV rows that match the conditions will be imported."
It is available on imports that create records and on imports that update them. The only import without Import Filters is the bulk image upload, which takes a ZIP of images rather than rows.
How do I add a filter?
There are two ways in, and both build the same thing.
From the Add Filter link
Click Add Filter next to "Where", above the mapping table, and pick the field yourself from the full list. Fields you have not mapped are still offered, marked (not mapped).
From a mapping row
Click the funnel button at the end of any mapping row. This opens the same popover with that row's CSV column already selected, so it reads for example "Only rows where SKU (sku)...".
Either way, choose an operator, type a value where the operator needs one, then press Add Filter. The condition appears as a chip in the Import Filters strip, and the funnel button on that row lights up so you can see at a glance which fields are filtered.
Reopening the funnel on a row that already has a condition shows it in edit mode, with Done and Remove. Saving from there replaces the condition rather than adding a second one.
Which operators can I use?
Import Filters offer ten operators: equals, does not equal, contains, does not contain, starts with, ends with, is empty, is not empty, greater than, and less than.
"is empty" and "is not empty" take no value. The rest compare against what you type.
How do I combine conditions?
Conditions inside a group are joined by and or or, and you switch between them with the control between the conditions.
Pressing Add Filter next to "Where" always starts a new group. Groups are joined by their own and / or control.
So "condition A and condition B" belongs in one group, while "either this set or that set" needs two groups.
Saving filters with a preset or a schedule
Import Filters are saved with a Mapping Preset, so a preset carries its conditions the next time you select it.
They are carried by a scheduled import too, so a recurring supplier feed keeps applying the same conditions on every run.
If you apply a preset to a file whose headers differ from the original, a condition may point at a column that is not in the new file. 3Dsellers warns you about unknown columns before importing.
Examples
A supplier sends one file for the whole catalogue and you only stock one brand. Filter Brand equals your brand.
You want to skip rows with no price yet. Filter Price is not empty.
You only want new-condition items above a price point. One group with Condition equals New and Price greater than 100, joined by and.
You want two product lines from one file. Two groups, SKU starts with AB and SKU starts with CD, joined by or.
Limits
Import Filters match the raw text in the CSV, as written in the file, before any conversion the import does.
They filter the CSV row, not your existing listings or products. A row is applied only if its own values match.
They are not available on the bulk image upload, which has no rows to filter.
They do not change what a matching row does. Mapping still decides which column feeds which field.
⚠️ On an import from a URL, the file is not read in your browser, so there are no column headers to pick from. You type the column name yourself and there is no unknown-column warning, so check the spelling carefully. A typo means no rows match and nothing is imported.
Troubleshooting
Nothing was imported and the run says no rows matched
A condition is excluding everything. Check the spelling of any typed column name, check that the value matches the file exactly, and remember that Import Filters compare the raw text in the CSV rather than a converted value.
I have a condition I did not mean to add, such as "Price equals 0"
If you open the filter popover, pick a field and click away without pressing Add Filter, you can be left with a default condition. Nothing matches it, so the import reports that no rows matched rather than changing anything. Remove the chip from the Import Filters strip and add the condition again.
I am warned that a column is not in this file
This usually happens when you apply a Mapping Preset saved against a different file. Either rename the column in your CSV to match, or edit the condition to point at a column this file actually has.
More rows were imported than I expected
Check how your conditions are grouped. Conditions joined by or, or split across two groups joined by or, match a row if either side is true. Put conditions that must all be true in one group joined by and.
FAQ
What happens if I leave Import Filters empty?
Every row in the file is imported, exactly as it was before Import Filters existed. Filters are optional on every import.
Can I filter on a column I have not mapped?
Yes, you can. Unmapped fields appear in the field list marked (not mapped), so you can use a column to decide which rows to import even when you are not importing that column's value.
Do Import Filters filter my existing listings or products?
No, Import Filters only filter the rows of the CSV you are uploading. A row is applied if its own values match the conditions, regardless of what your existing listings look like.
Are my filters saved when I save a Mapping Preset?
Yes, the conditions are stored with the preset and come back when you select it again. Scheduled imports keep their filters too.
Can I use Import Filters when creating new listings or products?
Yes, Import Filters work on create imports as well as update imports. Because they match the CSV row rather than an existing record, there is nothing to match against beforehand.
Can I filter on more than one column?
Yes, add as many conditions as you need. Conditions in the same group are combined with and or or, and you can add further groups for alternatives.