cancel
Showing results for 
Search instead for 
Did you mean: 

REST API Import Data JSON or CSV

REST API Import Data JSON or CSV

Hi, I'm new to Magento 2. I'm trying to import multiple products via the API. The documentation shows an example of importing multiple products via JSON or CSV. But when I generate the request to the repo, it tells me the path doesn't exist. Here's the documentation link: https://developer.adobe.com/commerce/webapi/rest/modules/import

Is it possible I need to integrate an Adobe module into Magento 2 so I can import multiple products?

1 REPLY 1

Re: REST API Import Data JSON or CSV

Hi @mcabezaope0766 ,

 

That /import/ API (from the Adobe documentation you linked) is only available for Adobe Commerce (the paid Enterprise/Cloud version). Magento Open Source does not include that bulk import API.

Options for Magento 2 Open Source:

1) Magento Admin: System > Import

If you're okay using the Admin Panel, this is the easiest way.

  • Go to: Admin > System > Data Transfer > Import

  • Choose Entity Type: Products.

  • Upload your CSV file.

Magento will handle bulk product imports for you this way - no need for code or API.

 

2) Standard REST API - One Product at a Time

Magento Open Source allows you to create products via the REST API, but only one at a time.

Endpoint: POST /rest/V1/products

Example JSON Payload:

{
"product": {
"sku": "test-sku-123",
"name": "Test Product",
"price": 99.99,
"status": 1,
"type_id": "simple",
"attribute_set_id": 4
}
}

 

You'd need to loop over your product data and send one HTTP request per product.
This is fine for small batches, but slow for large catalogs.

 

3) Programmatic Import (PHP Script)

For larger imports, you can write a PHP script using Magento's core classes - which is much faster than sending individual REST calls.

Example approach:

$product = $this->productFactory->create();
$product->setSku('test-sku-123');
$product->setName('Test Product');
$product->setPrice(99.99);
$product->setTypeId('simple');
$product->setAttributeSetId(4);
$product->setStatus(1);
$product->setWeight(1);
$this->productRepository->save($product);

You can loop over a CSV file and create thousands of products this way in bulk.

 

4) Third-Party Extensions

There are a lot of community modules for bulk product import/export for Magento Open Source, some even extend the REST API to allow bulk importing in one call.

Examples:

Firebear Improved Import & Export - advanced CSV / XML / JSON import/export.

Xtento Product Import Module - automate bulk imports from files or feeds.

 

Problem Solved? Accept as Solution!

 

Hope it helps!

 

Thanks

Ankit Jasani