Magento Guide → Import Magento Products

How to import Magento products

Key takeaways

• Magento product imports use a CSV file that matches Magento’s data structure.
• The import tool is under System > Data Transfer > Import.
• Add/Update, Replace, and Delete control how Magento handles product data.
• Clean data, validation, image prep, and post-import checks help prevent issues.

Magento product imports can save hours of manual work. Whether you’re launching a new store, adding hundreds of SKUs, or migrating from another platform, the import process lets you upload product data in bulk using a simple CSV file.

Let’s walk through how to prep your file, upload it through the admin, avoid common errors, and automate the whole thing if needed.

Why import products in Magento?

Importing products helps Magento merchants manage catalogs faster. Instead of adding items one by one, you can upload thousands of SKUs in one go.

This is especially useful when setting up a new store with an existing catalog, migrating products from another ecommerce platform, syncing Magento with inventory or ERP systems, making bulk edits to pricing or stock, or updating seasonal product lines.

Magento supports various product types, including simple, configurable, bundle, grouped, downloadable, and virtual, all of which can be imported using the same system.

How to import Magento products: quick steps

The built-in Magento import tool handles product imports through the admin panel. The basic process is to prepare a CSV, select Products as the entity type, upload and validate the file, run the import, then check the storefront.

1. Go to System > Data Transfer > Import
2. Select Products from the Entity Type dropdown
3. Click Download Sample File
4. Choose the import behavior
5. Upload your CSV
6. Click Check Data before importing

Before you import Magento products

A product import starts before the upload. Make sure you have admin access, a clean product CSV, category paths, attribute sets, image files, and a backup or staging environment if available. Large imports can change hundreds or thousands of products at once. Test a small file first so you can catch formatting, category, attribute, or image issues before importing the full catalog.

Prepare your Magento product CSV file

Before uploading anything, you’ll need a properly formatted CSV file. Magento offers a downloadable sample that includes all the required columns and formatting rules.

To get the sample file:

1. Go to System > Data Transfer > Import
2. Select Products from the Entity Type dropdown
3. Click Download Sample File

Open the file in a spreadsheet program like Excel, LibreOffice, or Google Sheets. Don’t use apps that might auto-format your data, such as turning SKUs into scientific notation.

Check the core product fields before importing. At minimum, each product needs a SKU, name, attribute set code, product type, and price. You may also need fields for categories, quantity, status, visibility, descriptions, and images depending on the products you import.

Use the correct attribute set code from your Magento admin. For categories, use the full category path. For images, make sure the file names in the CSV match the image files you plan to upload.

When finished, export the file as a comma-delimited CSV and save it with UTF-8 encoding to reduce character issues during import.

Choose the right import behavior

1. Go to System > Data Transfer > Import
2. Set Entity Type to Products

Magento gives you three main import behavior options. Add/Update adds new products and updates existing products by SKU. Replace deletes existing product data and replaces it with the CSV data. Delete removes products listed in your file.

Add/Update is usually the safest choice for adding new products or updating existing ones. Use Replace or Delete carefully, especially on a live store, because they can make major catalog changes.

Configure validation settings

Validation settings control how Magento handles errors in your CSV. Stop on Error is the safer option when you are testing because Magento stops when it finds an issue. Skip error entries lets Magento continue importing valid rows while skipping rows with errors.

Set the Allowed Errors Count if you use skip mode. Review any errors, correct the CSV, and rerun validation before importing the full file.

Upload and validate your CSV

From the same Import screen, click Choose File and upload your prepared CSV.

If you include image references, make sure the image files are in the correct location before validating. Then click Check Data to validate the file.

Magento will scan for format issues, missing fields, and incompatible values. If Magento finds errors, fix them in the CSV and upload the file again. Once validation passes, move to the import step.

Import Magento product images

Product images are one of the most common import issues. Magento usually needs image files to be available on the server before import, unless your CSV uses full external image URLs.

Images must be placed in pub/media/import before you run the import.

The CSV image columns should reference the correct file names or paths. Common columns include image, small_image, and thumbnail. Make sure file names match exactly, including capitalization and extensions.

Import configurable products

Configurable products need more care than simple products because they connect a parent product to simple child products.

For parent products, Magento commonly uses fields such as configurable_variations and associated_skus to connect variations, depending on the import format and setup. Simple child products should appear before the configurable parent product in the CSV so Magento can connect the variations correctly.

Attribute values like size, color, or material must match the attributes and accepted values in Magento. If those values don’t match, validation may fail or the configurable product may not connect correctly.

Run the import

Once validation passes, click Import. Magento will process the CSV and show a success message when the import is complete.

Large files can take longer, especially when the import includes images, category changes, inventory updates, or configurable products. Avoid interrupting the import while it runs.

Refresh cache and reindex after import

After importing products, refresh invalid caches under System > Tools > Cache Management so storefront changes appear correctly.

Magento doesn’t always reindex immediately. You may need to do it manually:

php bin/magento indexer:reindex

Also flush the cache to make sure changes appear:

php bin/magento cache:flush

Reindexing can help product data, categories, prices, and search results update correctly after larger catalog changes.

Check imported products on the storefront

A successful import message doesn’t guarantee every product looks right on the storefront. After the import, check product visibility, images, category placement, prices, stock status, configurable variations, search results, and URLs.

Review a few products from each product type or category you imported. If you updated a large catalog, spot-check both the admin and storefront before assuming the full import worked as expected.

Common Magento product import errors

Magento’s import system is strict, and even small formatting issues can stop the process.

Large imports and automation

Large product imports may hit upload limits, memory limits, or browser timeouts. If your file is large, split it into smaller batches or use the command line for faster, more reliable performance. Large imports can also affect database load, indexing, cache, and hosting resources.

Magento’s built-in import tool works well for many product uploads, but some stores need more advanced import workflows. This may include recurring supplier feeds, Google Sheets imports, FTP/SFTP file drops, API connections, attribute mapping, stock updates, or larger catalogs that need more control than the admin import tool provides.

Improved Import & Export by Firebear Studio can support advanced product imports from file types and sources like CSV, XML, XLSX, Google Sheets, FTP/SFTP, Dropbox, and direct URLs. It can be useful for stores that need scheduled imports, attribute mapping, product image imports, or external data sources.

Xtento Product Import Module can help with automated product and stock updates from third-party systems. It may be useful for developers or store teams syncing Magento with suppliers, inventory tools, ERPs, or other external platforms.

Magmi Import Tool may still be used by technical teams for high-volume or legacy import workflows, but it is better suited for experienced developers who understand command-line imports and Magento-specific data handling.

For recurring imports, automation works best when source data is reliable, the process is logged, and errors are reviewed regularly.

How to import Magento products FAQs

Getting started with how to import Magento products

Importing Magento products starts with clean CSV data, the right import behavior, validation, image preparation, cache refreshes, reindexing, and post-import checks.

Start by downloading the Magento sample file and testing a small import. Confirm products, images, prices, categories, visibility, and variations before importing the full catalog.

Large product imports can put pressure on hosting, indexing, cache, and database resources. Liquid Web Magento hosting gives stores the performance, support, and reliability needed to manage growing catalogs with confidence. Explore Liquid Web Magento hosting to find the right fit for your store.