Overview
Import settings control how WISEPIM processes incoming product data. By configuring these defaults, you ensure every import behaves consistently — whether run by you or a team member.
These settings apply project-wide as defaults. You can still override individual options when performing a specific import.
Import Filters
Import filters let you control which products get imported from a file. Without any filters, all rows in your import file are processed.
Adding Filters
Click Add Filter to open the advanced filter modal. Each filter condition consists of:
- Field — The product field to evaluate (e.g., Product Name, SKU, Price, Stock Quantity).
- Operator — The comparison logic (e.g., equals, contains, is empty, greater than).
- Value — The value to compare against (not required for operators like “is empty” or “has value”).
Filter Logic
You can combine multiple conditions using:
- AND — All conditions must match for a product to be imported.
- OR — Any single condition matching is enough to import the product.
Use import filters to exclude test products, products below a certain price threshold, or products without essential fields like SKU or EAN.
Conflict Resolution
When an imported product already exists in WISEPIM (matched by SKU or another identifier), the conflict resolution setting determines what happens.
| Option | Behavior |
|---|
| Merge | Combines existing and imported data, keeping the most complete version of each field. |
| Overwrite | Replaces all existing data with the imported data for matched products. |
| Skip | Keeps existing data unchanged and ignores imported duplicates. |
The Overwrite option replaces all fields on the existing product. Make sure your import file contains complete data before using this mode.
Empty Field Handling
This setting controls what happens when a field in your import file is blank.
| Option | Behavior |
|---|
| Skip empty fields | Leaves the existing value in WISEPIM unchanged. |
| Clear field | Removes the existing value, making the field empty. |
| Use default value | Fills the field with the attribute’s configured default value. |
“Skip empty fields” is the safest default. It prevents accidental data loss when your import file only contains partial product information.
Validation
Validation determines how strictly WISEPIM checks your imported data.
| Mode | Behavior |
|---|
| Strict | Rejects any row with missing required fields or invalid data formats. No partial imports. |
| Standard | Imports valid rows and skips rows that contain errors. You receive a report of skipped rows. |
| Lenient | Imports everything possible and auto-fixes minor issues (e.g., trimming whitespace, normalizing formats). |
Standard mode is the recommended default. It balances data integrity with flexibility, and provides clear feedback about any rows that could not be imported.
Saving Changes
When you modify any setting on this page, a save bar appears at the bottom:
- Save — Persists your import settings to the project.
- Undo — Reverts all changes to the last saved state.
