Magento How to Export/Import all products from all store in a single fetch/dump?

Magento How to Export/Import all products from all store in a single fetch/dump?

October 6, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento How to Export/Import all products from all store in a single fetch/dump?

Efficient Magento Product Export/Import Across Multiple Stores

Managing products across multiple Magento stores can be complex, especially when it comes to bulk import and export operations. This guide will walk you through the process of exporting all products from all your stores in a single fetch/dump and importing them back in one go.

Why Use Single-Fetch/Import for Multi-Store?

Having the ability to handle product data across multiple stores with minimal manual intervention is crucial for maintaining consistency, saving time, and reducing human error. This approach allows you to:

  1. Update prices or attributes uniformly.
  2. Sync new products across all domains.
  3. Troubleshoot issues more efficiently.

Magento Built-In Limitations

Magento’s native interface does not support single-fetch/import functionality for multiple stores out of the box. The default setup requires you to export and import data separately for each store.

However, with some custom coding or by utilizing third-party extensions, we can achieve this efficiently.

Extension Option: Multi Export Import

One popular extension that provides this functionality is the “Multi Export / Import” developed by Amasty. This extension allows you to:

  • Select multiple stores for export/import operations.
  • Save time and resources when dealing with large datasets.

You can find more information about this extension here.

Custom Coding Solution

If you prefer a custom coding solution, I would recommend using Magento’s API along with some PHP scripting. Here’s a high-level overview:

  1. Use the Magento API to fetch products: Magento provides an API endpoint (rest/V1/products) that returns all product data.

  2. Merge and format data: Write a script to merge the product data from different stores into a single CSV or JSON file. Ensure you handle store-specific attributes appropriately.

  3. Import the merged data: Use the same Magento API (or import/export functionality) to upload the merged data back into all three stores simultaneously.

  4. Automate with cron jobs: Schedule these scripts as cron jobs for automated periodic syncing.

Code Example: Fetch Products via API

Here’s a simple example of fetching products from a single store using cURL:

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://www.store1.example.com/rest/V1/products');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
if(curl_errno($ch)) {
    echo 'Error:' . curl_error($ch);
}
curl_close ($ch);

$products = json_decode($response, true);

// Now $products contains all the products from store1

Conclusion

In summary, while Magento’s built-in features do not support single-fetch/import across multiple stores, extensions like Amasty’s Multi Export / Import provide a robust solution. Alternatively, a custom coding approach using the Magento API can also be implemented for more advanced scenarios.

Remember to test thoroughly before implementing in a production environment and always backup your data prior to any import operations.

For further reading on Magento API and data manipulation techniques, I recommend checking out our Magento Development Guide.

Catalog Extensions Pricing Import/Export

Our network