Skip to main content
WISEPIM integrations catalog for Shopify, Amazon, WooCommerce and more WISEPIM integrations catalog for Shopify, Amazon, WooCommerce and more Your product data lives somewhere already: in Shopify, Magento, WooCommerce, a spreadsheet, a supplier feed, or all of the above. Importing brings it into WISEPIM so you can start improving it.
Bringing in a catalog for the very first time? Follow the step-by-step guide: Import your catalog safely.
On your first platform import, WISEPIM automatically pulls in your categories and attributes alongside your products. No manual setup required. Your catalog structure is ready from the start.

Import sources

Click Import on the Products page to open Import Products. The list builds itself: every connected integration that supports import appears as an option, next to the built-in sources. Sources you used before move to the top with a Last used chip. The Import Products dialog with connected shops, CSV Import, Excel Import, XML Import, EAN Scanner, From a website or URL and Demo Data The Import Products dialog with connected shops, CSV Import, Excel Import, XML Import, EAN Scanner, From a website or URL and Demo Data
If you don’t see a platform in the list, it isn’t connected for import yet. Set up the integration on the Integrations page and it appears automatically.
Pasting a webshop URL into WISEPIM so a server crawls it is retired. The browser extension is the only way to import from a website now.

Connect your platform first

Before importing from an e-commerce platform, you need to set up the integration. Each platform has its own way of generating API credentials. Follow the guide for your platform:

Shopify

Generate a custom app and API key

WooCommerce

Create REST API keys

Magento

Set up an integration token

Lightspeed

Connect your Lightspeed account

Kaufland

Get your Kaufland API credentials

WebshopImporter

Configure WebshopImporter
Once your credentials are ready:
  1. Go to the Integrations page
  2. Select your platform and enter your API credentials
  3. Test the connection
  4. Save
The import modal only shows platforms that have been successfully connected. If your platform doesn’t appear, head to Integrations and set it up first.

Running a platform import

1

Go to the Products page

Click the Import button in the toolbar.
2

Pick your source

Select the platform you want to import from. Only connected integrations are shown.
3

Choose a store (if you have more than one)

If a platform has several stores connected, WISEPIM asks which one to import from under Select Store. With a single store, it skips this and goes straight to the import.
4

Narrow the scope, if you want

Under One-time import scope you can limit this run instead of pulling the whole store: Only products modified since or Only products created since a date (with Last 24 hours, Last 7 days and Last 30 days presets), Maximum products to import, Only these SKUs or Exclude these SKUs (paste a list or a spreadsheet column, up to 5,000), and Only these categories already in your project (up to 500). Some platforms add their own parameters, such as status, vendor, product type or tag. Which options appear depends on what the platform’s API can filter on.
5

Let WISEPIM do the work

WISEPIM connects to your platform, discovers your products, and pulls everything in, including categories, attributes, and product relationships.
6

Review your catalog

Once the import completes, spot-check a few products to make sure everything came through correctly.
Imports run in the background. You can keep working in WISEPIM while your products are being pulled in. You’ll get a notification when it’s done.

Import a file

Choose CSV Import to open Import your products. Drop your file on Drop your CSV or Excel file here. WISEPIM reads it, matches the columns to your fields and shows Here’s what we found before anything is imported. Most files go from upload to import on this one screen.
1

Drop your file

The importer checks for three things: one row per product, a column with each product’s SKU, and column names in the first row. Download an example file gives you a template that works.
2

Answer any open questions

If WISEPIM can’t tell how to read the file, it asks first under A few choices before importing. See Choices before importing.
3

Check what WISEPIM found

The review shows the row and column count, how products are matched, which columns go where, and any rows that can’t be imported. Click Not right? Change it to change the separator or header row, or Use another file to start over.
4

Import

The button tells you what happens: Import 240 products, Update 240 products or Import 240 new products, depending on what this import does. The import runs in the background.

Files the importer reads

Files can be up to 300 MB and up to 10,000 columns. Files over 10 MB are inspected in full before you continue (“Inspecting the complete file. You can continue when inspection finishes.”), and large uploads go up in parts.
The importer is forgiving. It reads UTF-8 (including files with stray Windows-1252 characters), Windows-1252 and UTF-16, honours Excel’s sep=; line, skips title or supplier rows above the header, handles non-English headers, and cleans numbers written as € 1.299,00, 899,-, (12.50) or 1,299.00. Placeholders such as UNKNOWN stay empty instead of turning into 0. Barcodes typed as =8718164601441 or in scientific notation are recovered, and an invalid check digit is a warning, not a failed row. Values that older exports protected with a leading apostrophe, such as '-123, import cleanly. Excel workbooks import the stored value of each cell, not its display formatting. Leading zeros come back from the cell’s number format, and formulas use their last saved result. A formula that was never calculated imports empty with a warning on that row: open and save the workbook in Excel, then upload it again. WISEPIM picks the worksheet that holds the products and tells you when it picked another sheet than the first one. Some files are refused with a clear reason, for example a blank file, an Excel file renamed to .csv, or a row with a quote that is never closed.

Choices before importing

When a file is ambiguous, A few choices before importing appears before the review. You can’t import until each question has an answer. The choices are saved with your import profile, so the next file from the same source skips them. WISEPIM also repairs common file problems on its own and tells you what it did, for example “Quote escaping repaired. Rows adjusted: 12.” or “Selected the product worksheet automatically.”

What WISEPIM shows in the review

Columns are matched in two passes. Known names match first, then AI picks a field for the rest from the column name and its values. Every AI pick is marked, so you can change it. Rows that can’t be imported are listed with the reason, for example “12 rows can’t be imported” or “3 rows repeat a SKU” (only the first row with each SKU imports). Download these rows gives you a file of them to fix. Row numbers match your spreadsheet, where row 1 holds the column names.
On a large file the review covers the first rows only, for example “This review covers the first 5,000 rows. The import reads the whole file.” The rest is checked during the import.

What this import does

Under Matching existing products, choose What this import does:
  • Add new products and update existing ones (default)
  • Only update existing products: rows that match no product are left out. Skipped rows don’t count toward your plan’s product limit.
  • Only add new products: products already in WISEPIM stay as they are.
And choose how existing products are found under Find existing products by:
  • SKU, then EAN/GTIN: match on SKU, and when the SKU is new, match a product with the same EAN. That product keeps its own SKU.
  • EAN/GTIN, then SKU
  • SKU only
Rows without a SKU are no longer skipped. When a row has an EAN but no SKU, WISEPIM looks up the EAN first. A file without a SKU column can import as long as an EAN column is mapped. A row with no SKU and an EAN no product has can’t be added. Before you start, WISEPIM counts how many products are new and how many already exist, for example “We match products on the SKU in “Article”: 120 new, 880 already in WISEPIM.” Empty cells never erase what’s already in WISEPIM.
Running a supplier stock or price update? Choose Only update existing products so the file can’t add products you don’t sell.

Language of each column

Columns that go into a translatable field, such as the name or description, get a Language of choice for that column. Columns named like name_sv get their language automatically. Importing one language never removes the translations you already have in other languages.

Prices and dates

  • Compare-at price: map an “old price”, “was price” or “compare at price” column to Compare-at price. When it’s higher than the price, WISEPIM stores it as the regular price and your price as the special price. When it isn’t higher, it is ignored.
  • Dates are read in ISO format, day-first European format and as Excel date numbers. Text that isn’t a date is kept in a text attribute named after the column, or reported as invalid. One bad cell no longer fails the rest of the batch.

Multiple images

Images can arrive in one column or in several:
  • One column with several URLs: WISEPIM splits them on the separator. The first URL becomes the main image, the rest go into the gallery. You set the separator under Multi-Value Field Settings in More import options. The default is the pipe (|).
  • Numbered image columns: columns such as “Image 1”, “Afbeelding 1” or “Bild 1” become the main image, and “Image 2” to “Image 10” fill gallery positions 2 to 10. “Extra image 1” or “Additional image 1” count after the main image. Amazon’s other_image_url1 to other_image_url8 work the same way. Columns beyond 10, or extra image columns without a number, go into the gallery as a list.
Image URLs without a file extension are recognized too. A cell that isn’t an http or https link is reported and not linked.

Category paths

Your file can carry a whole category tree in one cell. WISEPIM detects the level separator, such as >, /, |, \ or »:
That creates Home, then Kitchen under it, then Knives under that, and puts the product in the deepest one. Several paths in one cell are split on ;, , or |. Levels spread over several columns, such as “Category 1”, “Category 2” and “Category 3”, are joined into one path, up to 10 levels. Click Change format on the Categories card when the detection is wrong. Existing categories are reused, so importing the same paths again does not create duplicates.

Remembered choices and import profiles

Import a file with the same columns again and WISEPIM reuses your choices: “We reused your choices from the last file with these columns.” Click Forget them to start fresh. To use the same choices for files with other names, choose Advanced > Save these choices and give the import profile a Profile Name. Pick it next time from Advanced. When you apply a profile to a file from the same supplier, WISEPIM checks the file’s structure and warns you when the supplier’s columns changed. A profile tied to a supplier keeps values you edited or verified by hand, and the other languages of a product, when the supplier sends a new file.

Advanced

Click Advanced on the review for the full four-step importer: The Advanced import options step with duplicate handling, project defaults for unmapped fields and the detected source platform The Advanced import options step with duplicate handling, project defaults for unmapped fields and the detected source platform

Combine or reshape data

Under File and settings, Combine or reshape data handles files with a different row or column layout. Most files don’t need it.
  • Turn columns into rows: turn option columns such as Small and Medium into rows with an option and a value. Set Columns to expand, Option column name and Value column name.
  • Append files with matching columns: put files with the same columns underneath each other, for example January and February.
  • Join files using a shared column: add information from another file, for example stock quantities by SKU. The Shared unique column needs unique values in every file.
Preview result shows the new layout without importing. Use original layout undoes it. For a ZIP, choose Advanced: combine files from this archive.

Feed record layout

For JSON, JSON Lines, XML and fixed-width files, Feed record layout tells WISEPIM where each product is:
  • Product record path (JSON): leave it empty for a top-level list, or use a path such as /catalog/products.
  • Product record tag (XML): the tag that holds each product.
  • Fixed-width columns: add each column with a Column name, First character (1-based) and Last character (inclusive).

Map your columns by hand

The mapping editor has three views. Switch between them whenever you like; they all edit the same mapping. Auto-map unmatched finds matches for your unmapped columns. Known names are checked first, then AI suggests the rest. The suggestions land in Review auto-map suggestions, each with a score: Model probability for an AI match, Local match score for a name match. The scores rank suggestions; they aren’t verified accuracy. Uncheck the ones you don’t want, change a target where needed, then apply the rest. The issue queue counts what still needs a decision (“3 issues need attention”) and steps you through them; press ⌘J to jump to the next one. Import readiness lists the blockers before you can start: unresolved columns, required fields still missing, mapping conflicts and duplicate headers. The Mapping tools panel has three tabs:
  • Recipes: save the current mapping as a recipe and apply it to the next file from the same source. Recipes are stored on this device for the active project.
  • Rules: a Bulk mapping rule for files with many similar columns. Match columns by Starts with, Ends with, Contains or Has tokens, then map, ignore or mark them not applicable in one go.
  • Warnings: sample values that may not fit the type of the field they are mapped to.
Import transformations trim whitespace, change text case and set the source date and number formats. They are applied to mapped fields before the import is validated. When you apply a saved profile to a file whose headers differ, the Profile compatibility check shows which mappings fit, which saved columns are missing and which columns are new. Apply compatible mappings applies only the matches. WISEPIM CSV import column mapping, matching spreadsheet columns to product fields WISEPIM CSV import column mapping, matching spreadsheet columns to product fields

More import options

  • When duplicates are found: Update existing products, Skip duplicates, or Create as new (the new product gets a numbered SKU, for example ABC-2). Switch on Don’t add new products to only update products you already have. This per-import choice is independent of the project-wide conflict resolution setting for platform imports.
  • Map values: decide per source value which option it becomes, or Add as new option. Add new options from attribute columns (off by default) adds new options for attribute name and value pairs. Your choices are saved with the profile.
  • Nested Data: turn rows into parent products and variants. When the file suggests variants, a Variants detected chip appears. Pick a Variant mode: no variants, parent and child linked by an identifier column, or grouped by a shared attribute. WISEPIM can also group rows whose SKUs share a stem, such as TB/1809/119 and TB/1809/120. A row with a blank child SKU feeds the parent instead of becoming a variant.
Closed the tab halfway through? The importer keeps a draft of your mapping and settings. Come back and it offers Resume your import setup: re-upload the same file, or one with the same columns, and your setup is restored. Only the setup is kept, never the file contents.

Mapping as JSON

Mapping as JSON shows the whole mapping as JSON. Copy or Download it to reuse for another file, or paste one in, Load file and Apply mapping. Applying it replaces the current mapping and import settings. The JSON must be smaller than 2 MB.

Resolve held rows

When the advanced importer holds rows back, Resolve held rows opens: “Your original file is kept. Correct these rows, or import valid rows and keep these for later.”
  • Edit a held row in place, then click Validate corrected rows.
  • Click Import 950 valid rows to bring in the rest now and fix the held ones later.
  • Click Check all rows before import to check the whole file first.
The first 50 held rows are shown. Corrected rows import without replaying the whole file.

Template defaults fill the rest

Your file rarely has every field. Product template defaults close that gap: any field your file doesn’t map gets the default value you set in Import settings, so new products land complete instead of half empty. Defaults can cover status, type, visibility, brand, supplier, price, cost, stock, shipping, units, country of origin, and product family. Text fields can also use pattern defaults with {{variable}} placeholders, so a value like {{brand}} {{name}} is built per product.
Template defaults are on by default and you can turn them off for a single import with Use project defaults for unmapped fields. They only apply when a product is created. Updates to products you already have are never touched, so a re-import can’t overwrite real data with a default.
A re-import never turns a missing value into a zero either. When the source leaves out a price or a stock quantity, WISEPIM keeps the value you already have. A real 0 in the source is still stored as 0. A row without a name keeps the existing name.

The Excel Import option

Excel files go through CSV Import like any other file, up to 300 MB, with a Worksheet choice. The separate Excel Import option in the import modal is the older converter. It accepts .xlsx workbooks up to 10 MB, with a Sheet selector and the same mapping editor. Use CSV Import for .xls files and large workbooks.

Demo data

Want to explore WISEPIM before importing your own catalog? Choose Demo Data, pick your industry under Choose Your Industry, and WISEPIM loads 25 sample products with categories, attributes and families already set up. You can clear them out later when your real products are ready.

How long does it take?

Import speed depends on catalog size and your platform’s API rate limits. Each platform throttles requests differently, so times can vary.
File imports are fast because there’s no API rate limiting involved. Platform imports depend on how quickly the source platform serves requests. Shopify, Magento, and WooCommerce all have different rate limits.
Start with a small test batch to verify everything works before importing your full catalog.

After the import

When a file import finishes, WISEPIM shows what happened: how many products were created and updated, and Next steps such as filling in missing fields, writing descriptions with AI for products without one, reviewing new categories and checking new fields. Stored values checked compares what was saved with your file: “Checked 1,000 rows. 0 rows have changed or omitted values; 0 rows could not be fully verified.” Quality scores are calculated shortly after each batch. Until then a product shows “Quality score not calculated yet” and doesn’t appear in quality score filters.

Post-import completeness scan

WISEPIM post-import cleanup wizard triaging missing weight, images and prices by impact WISEPIM post-import cleanup wizard triaging missing weight, images and prices by impact Once a file import finishes, WISEPIM scans the imported products for missing critical fields, like a main image, weight, and price. If any gaps are found, Import cleanup opens and walks you through each gap one step at a time:
  • Missing images: WISEPIM checks whether an unmapped column in your original file might hold the image URLs. If so, it suggests re-running the import with that column mapped. You can also paste a placeholder URL to fill all products at once.
  • Missing weight or price: AI reads each product’s existing title and description and extracts the value where it finds one. For products where it can’t, you can set a single value for all of them.
  • Other field gaps: similar step-by-step fix options, including AI enrichment for text fields.
You can skip any step and come back later. Skipped gaps stay visible on the Products page as a banner until all critical fields are filled.

What to do next

  1. Work through Import cleanup: if critical fields are missing, fix them before you publish
  2. Spot-check your data: open a few products and verify the information came through correctly
  3. Review your categories: make sure the imported structure looks right
  4. Check your attributes: they’re already there, ready to use
  5. Enrich with AI: select products and let the AI improve your content

Undo an import

Imported the wrong file, or the wrong store? Open the import in the Process Tracker and choose Rollback. It removes what that import brought in, so you can fix your file and run it again from a clean starting point.
Rollback is only available on import tasks. Do it before you start enriching, so you don’t throw away work you did on top of the imported products.

Where each product came from

Every product remembers the source it first arrived from: a platform, a file, the browser extension, or a feed. WISEPIM records this once, on the first import, and never changes it afterwards, so it stays a reliable record of origin. You can filter your catalog by import source on the Products page. That makes it easy to answer questions like “show me everything that came from this supplier’s file” before a bulk edit, an enrichment run, or a cleanup.

Troubleshooting

Import not starting

  • Check that your integration is connected and tested on the Integrations page
  • Verify your API credentials haven’t expired
  • Make sure your API user has the right permissions

No products found

  • Confirm your store actually has published products
  • Check API user permissions, as some platforms restrict product visibility
  • Try re-testing the integration connection

File issues

  • Answer every question under A few choices before importing. The import can’t start until you do
  • Check the skipped rows on the review and use Download these rows to fix them
  • Make sure a SKU or EAN column is mapped, so products can be matched
  • If your plan’s product limit is reached, new products stop being created. Updates still go through

Slow import

Large catalogs take time, and platform API rate limits can slow things down. If an import seems stuck, check the Process Tracker for status updates.

Import Settings

Configure the defaults every import runs with.

Web Scraping Import

Import product pages with the browser extension.

EAN Scanner

Scan a barcode to find a product or add it.

Process Tracker

Follow long-running imports and see exactly what changed.

Exporting Products

Send your enriched catalog back out to your channels.

Import your catalog safely

A guided first import, from source file to a catalog you can work with.