If you Have Product Name and get product details for import product csv use this. Create php file and put code
php
<?php
require_once '../app/Mage.php';
Mage::app();
$row = 1;
echo '
‘; if (($handle = fopen(Yourcsvname.csv', r')) !== FALSE)
{ while (($data = fgetcsv($handle, 1000, ,')) !== FALSE) { $num = count($data);
//echo ' $num fields in line $row: n'; $row++; for ($c=0; $c < $num; $c++)
{ echo '; echo ‘'; $product_collection = Mage::getResourceModel(‘catalog/product_collection')
->addAttributeToSelect(‘*') ->addAttributeToFilter(‘name',$data[$c]) ->load();
foreach ($product_collection as $product) { echo ‘'; //exit; } echo '; } } fclose($handle); } echo ‘
‘.$data[$c]. ‘.$product->getSku() .
‘; ?>
After this same location put your CSV File. In csv File your product Name must be compulsory and save this. You Get your csv product all Details.Share this playbook