How to Export Simple Product CSV from Magento 2 Programmatically

How to Export Simple Product CSV Programmatically using custom Scripts.

Create one custom.php File into the root folder.

and put the below code into a file and run it into the browser.

You can find this CSV inside the root directory

Copy to Clipboard

<?php

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
ini_set('memory_limit', '5G');
error_reporting(E_ALL);

use Magento\Framework\App\Bootstrap;
require realpath(__DIR__) . '/app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();
$state = $objectManager->get('Magento\Framework\App\State');
$state->setAreaCode('frontend');
$registry = $objectManager->get('Magento\Framework\Registry');
$registry->register('isSecureArea', true);
//Store id of exported products, This is useful when we have multiple stores.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

/** @var MagentoCatalogModelResourceModelProductCollection $productCollection */
$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection');
$collection = $productCollection->addAttributeToSelect('*')->load();

$fp = fopen('exports.csv', 'w');
$csvHeader = array("name","sku");
$i = 0;

fputcsv( $fp, $csvHeader,",");
foreach ($collection as $product){
    $data = array(); 
    $data[] = $product->getName(); 
    $data[] = $product->getSku();
    fputcsv($fp, $data);	
}

fclose($fp);
echo 'export all product';
?>

Published On: December 25th, 2020 / Categories: Magento, Magento 2 / By Kalpesh Chavada /

Let’s Make Things Happen

Transforming your ideas into reality is our expertise. Share your vision without hesitation, and let our skilled team bring it to life.

“Akshar Group Technologies did such a great job at resolving the initial problem that the partnership expanded to include further development and is still ongoing. Diligent and committed, the team goes above and beyond to deliver their work promptly. They have an extensive knowledge base.”

Justin Delp

Digital Engage, US

By submitting my data I agree to be contacted

How to Export Simple Product CSV from Magento 2 Programmatically

About the Author: Kalpesh Chavada

Let’s Make Things Happen

Converting your Ideas into Reality

Useful Links

Resources

Address

Ahmedabad

Dubai

United Kingdom

How to Export Simple Product CSV from Magento 2 Programmatically

About the Author: Kalpesh Chavada

Related Posts

How to Update Magento 2 to the Latest Version?

Magento 2.3 Support ends from Adobe

Remove Qty Decimal from Product Grid Magento 2

Update Magento 2 Using Command

Let’s Make Things Happen

Converting your Ideas into Reality

Useful Links

Resources

Address

Ahmedabad

Dubai

United Kingdom