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';
?>

About Author:

Kalpesh Chavada

Kalpesh Chavada is Our Founder & CEO of Akshar Group Technologies. He is serving with 11+ years of experience in different technologies like Magento, WordPress, Laravel, jQuery, Shopify, Branding, and Digital Marketing. He is very good with creative logic and always ready to take on challenges.

Yaani Dipali

Akshar Group Technologies is one of the best company with very supportive team & mentor to guide employees, Company is very cultural friendly with a career growth too. Working here is a journey full of learning, facing challenges and achieving constant growth in career. Most recommended company for both fresher and experienced. Glad to be part of Akshar Team.

Chris Taylor

I've worked with this company for 10 years and highly recommend them. High quality work for an affordable price and excellent service.

Gurdeet Bansal

Amazing work. From start to finish, they have been on top of all the changes that need to be made and fixed and was done to a very high standard. Will be using again 100% and recommend highly!

Anant Tomar

Best Quality and Versatile Work.

Ayd Ser

Excellent job and great communication, we Sr every happy with the service and definetly recommend Kalpesh and the team. Many thanks LOTIW

chirag sagpariya

Best software developer company.Team is young and enthusiastic.Our ecommerce website developed by Akshar group technologies.www.sparron.in Now response is very good from customer.

Javin Goyal

It was a pleasure to work with Kalpesh at Akshar Group Technologies. He is so good at what he does that he used to take care of half my needs while we were on the call discussing them! He was always available and ready to put in the effort to get the job done. He made the arduous task of launching a website seem like the easiest thing in the world. I really appreciate the effort he put in and could not have asked for anything better.

Mahant Creative

Have been working as a trainee since last 3 months. Company is amazing for newbies and it has great learning scope for them. AGT team who work here are supportive, helpful and friendly.

Laura McCranor

Kalpesh was very professional and all of his work was very timely and of high quality.

How to Export Simple Product CSV from Magento 2 Programmatically

About Author:

Kalpesh Chavada

We’re Waiting To Help You

Converting your Ideas into Reality

Quick links

Quick links

Services

Services

Get in touch

Get in touch