Import from File

Overview

Import from File brings products into MicroPIM from a spreadsheet or data file you already have. Upload the file, let AI suggest how each column maps to a MicroPIM field, review the mapping, and start the import. Every run is tracked with per-row error reporting.

This is the best method when your product data lives in a supplier spreadsheet, an export from another platform, or a custom data file.

Navigation

Sidebar: Import → Import (dialog) → Import from File tab URL: /admin/import

Supported formats

Format	Extensions
CSV	.csv
Excel	.xlsx, .xls
JSON	.json
XML	.xml

How to import products from a file

To import from a file, upload a CSV, XLSX, JSON, or XML file, review the AI-suggested field mapping, then start the import.

1. Open the Import dialog and select the Import from File tab.
2. Upload your file. You can choose Upload and Preview to inspect rows first, or Upload and Import to proceed.
3. MicroPIM parses the file and uses AI field mapping to suggest a source-column → MicroPIM-field mapping, with a confidence score per field.
4. Select the rows to import, then review and adjust the mapping. You can set multi-value separators, map custom attributes, and choose a conflict strategy.
5. Save the mapping as a reusable Import Profile if you’ll import similar files again.
6. Start the import. Progress and row-level errors appear in History Import.

Field mapping

• AI proposes a mapping automatically and highlights lower-confidence matches for review.
• sku and name are required — every import must map these two fields.
• You can map custom product attributes and define separators for fields that hold multiple values.
• Save any mapping as an Import Profile to reuse it on future files.

Conflict strategies

When an imported product matches an existing one, choose how to resolve it:

Strategy	Behavior
Skip (default)	Leave the existing product unchanged
Update	Overwrite the existing product with imported values
Create new	Add the imported row as a new product

Limits & rules

• Maximum file size: 50 MB.
• Rate limit: up to 10 imports per hour per user.
• Files are validated on upload; unsupported types are rejected.

Actions

• Upload and Preview — inspect parsed rows before importing
• Upload and Import — parse and proceed to mapping
• Map Fields — review and adjust the column mapping
• Save Profile — store the current mapping for reuse
• Start Import — begin processing the selected rows
• Download Errors — export a CSV of rows that failed

API

API Available

Endpoint: GET /api/import — list import jobs Endpoint: POST /api/import — start a new file import

Related

• Import Products — compare all import methods
• History Import — track progress, retry, and download error reports
• Files — manage uploaded source files
• Import from Feed — for recurring feed files, use a scheduled feed source
• Import from Link — import specific product URLs instead of a file
• Import Bulk — expand a category or listing URL into many products