Magento 2 Import Validator: Check CSV Before the Run
SKU: IMPORTPREVALIDATOR1
- check required columns, categories and images in advance
- dry run without write access to the catalog
- rule profiles per supplier and file source
- error report with row and column as CSV download
Einmaliger Kauf · inkl. 12 Monate Updates · zzgl. MwSt.
Magento 2 Import Validator: find the errors before the import runs
With the Mironsoft Magento 2 Import Validator you check your CSV file before the standard import processes it. The module reads the file in a dry run, compares every row with your catalog and returns an error report with row number, column and a plain-language message. It writes nothing to the database, needs no maintenance window and can be set up with its own rules for each supplier. The admin screen is simple and needs no developer knowledge.
Check required columns
If sku, attribute_set_code or product_type is missing, the report names the column and the affected rows.
Match categories
Category paths in the file are checked against the tree, unknown paths show up with their row number.
Find images
File names from base_image and additional_images are looked up in the import folder, missing images are reported at once.
Validate values
Prices, quantities, dates and select values are checked for format and allowed options.
Duplicate SKUs and URL keys
Duplicate SKUs in the file and clashes with existing URL keys become visible before the run.
Error report
Result as a table in the admin and as a CSV download, sorted by severity and row.
Why a Magento 2 Import Validator is worth running before every import
The built-in Magento import checks the file only while it runs and stops on some errors with a short message. With files of several thousand rows every failed attempt costs time, and a half-imported file leaves cleanup work in the catalog. Anyone who loads supplier data regularly knows the loop of uploading, waiting, reading the error and fixing the file.
A Magento 2 Import Validator shortens that loop. It runs in seconds, changes no data and lists all problems at once instead of only the first. The import becomes a predictable task that staff without technical training can start with confidence.
Magento 2 Import Validator: check the structure of the CSV file
First the Magento 2 Import Validator checks the format of the file: delimiter, character encoding, header row and column count per row. Then come the required columns per product type. In the admin you define which columns are mandatory for simple, configurable or virtual products. Every deviation appears with its row number, so you find the spot in your spreadsheet straight away.
- Delimiter, encoding and header row are checked
- Required columns per product type, configurable
- Row number and column name for every finding
Match categories, images and attributes before the import
In the second step the Magento 2 Import Validator compares the content with your shop. Category paths must exist in the tree, attribute sets and attribute values must be known, and the image files must be in the import folder. The result separates errors that block the import from notes that only need attention, such as an unknown dropdown value that would be created automatically.
- Category paths against the existing tree
- Attribute sets, option values and image files
- Errors separated from notes
Your own rule profiles for each supplier and each file source
Every supplier delivers different columns. That is why the Magento 2 Import Validator works with profiles: you create rule profiles: expected columns, required fields, allowed value ranges for prices and quantities and the severity of each rule. A profile for the wholesaler checks more strictly than one for your own maintenance file. You pick the profile when uploading, and the report names it in the header.
- One profile per supplier with its own required fields
- Value ranges for price and quantity
- Severity per rule: error, warning or note
Error report, CSV download and permissions for your team
The report appears as a sortable table and can be downloaded as CSV so that your supplier or data editor can apply the corrections directly. Through the ACL of the Magento 2 Import Validator you control who may validate, edit profiles or delete reports. Old reports are removed after a number of days you choose. If you like, the check can also be started with a console command.
- Report in the admin and as a CSV file
- ACL for validating, profiles and deleting
- Retention period of reports is configurable
Where the Magento 2 Import Validator helps in everyday shop work
Typical situations in which a check before the run saves effort.
Supplier catalogs
The wholesaler sends a new file every week. The Magento 2 Import Validator shows in seconds whether categories or images are missing before the import puts load on the shop.
Initial fill of a new shop
At launch thousands of products come from a legacy system. Several validation runs clean the file step by step until it is ready.
Editorial maintenance
Staff edit product texts in spreadsheets. Before uploading they check for themselves whether required columns and values are right, without asking a developer.
Agencies and service providers
Agencies hand the report back to the client, who applies the corrections in the source file and uploads it again.
Magento 2 Import Validator: without and with the module
The difference to the plain standard import.
| Topic | Without the module | With Mironsoft Import Pre Validator |
|---|---|---|
| Time of the check | Only while the import runs | In advance as a dry run |
| Error messages | Short, often only the first error | All findings with row, column and message |
| Database | Partial import possible | No write access |
| Supplier rules | Not available | Rule profiles per supplier |
| Passing it on | Retype the message | CSV report to download |
How we set up the Magento 2 Import Validator for you
The process after your order.
Briefing
You tell us your typical import files, the suppliers and the columns that must be present.
Installation
We install the module, set the permissions and add the Magento 2 Import Validator to the admin menu.
Rule profiles
We create profiles for your suppliers and set the severity of each rule to fit your way of working.
Test runs
We test the Magento 2 Import Validator with sample files full of deliberately built-in errors and check that the report lists every finding.
Handover
Your team gets an introduction to uploading, reading the report and maintaining profiles.
Scope compared with price import and ERP connection
The Mironsoft CSV price import writes prices into the catalog, and the ERP connection via SFTP fetches files automatically. Both change data. This module changes nothing, it only checks and delivers the report. It complements the standard Magento import without replacing it.
All modules can be combined. The admin screen needs no additional library, and the check runs on the server, in the background for large files.
No download, but a personal setup
The Magento 2 Import Validator is not listed here as a finished download file for self-installation. The purchase is a commission: we contact you after the purchase, install the module in your shop and agree profiles, permissions and reports with you.
Frequently asked questions
Everything important about scope of checks, profiles, reports and how the purchase works.
How can I check a CSV file before the import in Magento 2?
How do I find missing images before the import in Magento 2?
Does the Magento 2 Import Validator change my catalog?
Which errors does the module detect?
Can I set different rules for each supplier?
How large may the files be?
Does the Magento 2 Import Validator work with Hyvä?
Can I pass the report on to my supplier?
How does the module differ from the price import?
Can I download and install the module myself?
Recently Viewed Products
Magento 2 Import Validator – Mironsoft Import Pre Validator