Magento - Magmi Import: skipped 1 record

Magento - Magmi Import: skipped 1 record

July 31, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Magmi Import: skipped 1 record

Magmi Import: Solving the “Skipped 1 Record” Issue

Understanding the Magmi Import Process

Magmi is a powerful tool for Magento that allows you to import large amounts of data quickly and efficiently. However, when encountering issues like “skipped 1 record,” it can be frustrating to troubleshoot.

Analyzing the Provided CSV

The given CSV file contains one product with basic attributes: sku, name, price, qty, is_in_stock, visibility, image, weight, and two additional columns for categories and tax_class_id.

"sku";"name";"price";"qty";"is_in_stock";"visibility";"image";"weight";"categories";"tax_class_id"
12333444;"T-Shirt White Small.";2.95;1;1;4;;"0.3";"shirts";2

Troubleshooting the Import

Step 1: Remove Unnecessary Columns

The first step is to simplify the CSV file by removing columns that aren’t required for a basic product import.

  • The categories column can be removed as it’s not needed for this single product.
  • Similarly, the tax_class_id column can also be eliminated if you don’t have any custom tax rules.

The revised CSV should look like this:

"sku";"name";"price";"qty";"is_in_stock";"visibility";"image";"weight"
12333444;"T-Shirt White Small.";2.95;1;1;4;;"0.3";

Step 2: Use the Latest Magmi Version

Ensure you’re using the most recent version of Magmi to avoid compatibility issues with your Magento installation.

Step 3: Utilize “Create New Items” Mode

When running the import, choose the “create new items…” mode instead of any update or merge options. This helps prevent conflicts during the initial setup.

Resolving Persistent Import Issues

Even after these adjustments, you might still encounter the “skipped 1 record” error. In such cases, add a few additional columns to your CSV file:

  • store: Set this value to admin, which is the default store view.
  • attribute_set: Search for an existing attribute set in your Magento admin panel and include its ID here.
  • type: For simple products, set this column to simple.

The final CSV should look like this:

"sku";"name";"price";"qty";"is_in_stock";"visibility";"image";"weight";"store";"attribute_set";"type"
12333444;"T-Shirt White Small.";2.95;1;1;4;;"0.3";admin;<your_attribute_set_id>;simple

Conclusion

When dealing with Magmi import issues, remember to:

  • Simplify your CSV by removing unnecessary columns.
  • Use the latest version of Magmi for compatibility.
  • Choose “create new items” mode during initial product imports.

In most cases, adding the required store, attribute set, and type information will resolve persistent import problems. For more advanced troubleshooting or Magento-related tips, consider visiting Laravel Company, where we provide in-depth guides on Magento development and optimization strategies.

Catalog Pricing Import/Export Errors

Our network