Magento 2 import CSV programmatically

The CSV Magento 2 expects

Start from a known-good export: System → Data Transfer → Export, choose Products, and use that file as the template. The minimum useful columns are:

Option 1: automate the built-in importer

The built-in importer is the Magento\ImportExport\Model\Import class. A custom CLI command keeps the same validation, behavior modes and error reporting as the admin screen. The exact command name varies by Magento version; check bin/magento list for import commands, or add your own command.

<?php
use Magento\ImportExport\Model\Import;
use Magento\ImportExport\Model\ImportFactory;

final class SupplierImport
{
    public function __construct(
        private ImportFactory $importFactory,
        private \Magento\Framework\Filesystem $filesystem
    ) {}

    public function run(string $file, string $behavior = Import::BEHAVIOR_APPEND): array
    {
        $import = $this->importFactory->create();
        $import->setData([
            'entity' => 'catalog_product',
            'behavior' => $behavior,
            'import_images_file_dir' => 'pub/media/import',
            'import_field_mapping' => [],
        ]);

        $source = $import->getImportSource()->setData([
            'file_path' => $file,
        ]);

        $result = $import->validateSource($source->getSource());
        if (!$result) {
            return $import->getErrorAggregator()->getAllErrors();
        }

        $import->importSource();
        $import->invalidateIndex();

        return $import->getErrorAggregator()->getAllErrors();
    }
}

Run it from a cron job or a custom bin/magento command. Keep the file in var/import/ or another writable path, and log the error aggregator so a failed row is visible instead of silent.

Option 2: REST API and bulk endpoints

If your source system can send JSON, skip CSV entirely. The product API accepts one product per call, and Magento 2.4 adds asynchronous bulk endpoints for larger batches:

# single product
POST /rest/V1/products
Content-Type: application/json

# asynchronous bulk
POST /rest/async/bulk/V1/products
Content-Type: application/json

[{"product":{"sku":"SKU-1","name":"Chair","price":49.9,"attribute_set_id":4,"status":1,"visibility":4}}]

Bulk endpoints return a batch ID; poll the bulk status endpoint, then reindex. This is a good fit for a PIM or ERP that already emits JSON. For supplier XML feeds, FeedPup handles the mapping and sends the products to Magento without writing a custom importer.

What about Magento Dataflow import?

Dataflow was the Magento 1 import framework: profiles, adapters and a browser-run data flow. Magento 2 replaced it with the ImportExport module and the System → Data Transfer → Import screen. If a guide mentions Dataflow profiles, it is for Magento 1 and will not work on Magento 2. The modern equivalents are the ImportExport model, the admin import and the REST bulk API.

Common Magento CSV import errors

When supplier feeds make the CSV manual

A CSV import assumes you already have the right file. A supplier feed is usually XML, changes without notice and uses different field names. Converting it to Magento CSV by hand defeats the point of automation. FeedPup reads XML or CSV, suggests field mappings, lets you review sample values, and can create a small set of disabled draft products before a larger run. It also handles the supplier-specific parts: variants, images and scheduled price/stock checks.

See the Magento 2 supplier XML guide for the end-to-end connection and a verified Magento Open Source 2.4.8 walkthrough.

Magento 2 CSV import FAQ