Skip to main content

Import images into Magento database without using Magento core files.

here code is to import images into magento databse without using any core files.
this is for product's images. you can modify it for gallery images also.
here all the images took from media/import and copied to that perticular directory.

you can find here,how images created there directory structure.

if images name is example.gif,then will create directory structure like e/x/example.gif.
that is means this images will copy to media/catalog/product/e/x/example.gif
and the value /e/x/example.gif will insert into table catalog_product_entity_varchar.you can see this image at fronend to that perticular product.Actaully i did script to imaport product with catagory,attribute,images,description.... etc
it is nothing but a cron job.i took only import images part from my script.

$LargeProductImageURL=$LargeImageURL!=""?basename($allData[$key]->LargeImageURL):"";

$first_2_letter = substr("$LargeProductImageURL", 0,2);
$first_letter = substr("$first_2_letter", 0,1);
$second_letter = substr("$first_2_letter", -1);
$product_image ="/".$first_letter."/".$second_letter."/".$LargeProductImageURL;

$product_path=$media_path."".$slash."catalog\product";
$import_images=$media_path."".$slash."import".$slash."".$LargeProductImageURL;
$mypath1=$product_path."".$slash."".$first_letter;
if(!is_dir($mypath1))
{
mkdir($mypath1,0777,TRUE);
}
$mypath2=$product_path."".$slash."".$first_letter."".$slash."".$second_letter;
if(!is_dir($mypath2))
{
mkdir($mypath2,0777,TRUE);
}
//copy ( string $source , string $dest [, resource $context ] )
$Image_dest=$mypath2."".$slash."".$LargeProductImageURL;
@copy($import_images,$Image_dest);

#####check Is images are ready for copy or not
if (file_exists($import_images)) {
$product_image = $product_image;
}
else {
$product_image="no_selection";
}
#######
$UrlKey = strtolower(str_replace(" ","-",$PName));
$URL_path= $PName.".html";

/*if(empty($LargeProductImageURL))
{$product_image="no_selection";}*/

$db_obj->query("INSERT INTO catalog_product_entity_varchar(entity_type_id, attribute_id,store_id,entity_id,value) VALUES
('".$catalog_product."','56','0','".$entity_id."','".$PName."'),
('".$catalog_product."','82','0','".$entity_id."','".$UrlKey."'),
('".$catalog_product."','469','0','".$entity_id."','2'),
('".$catalog_product."','67','0','".$entity_id."','".$PName."'),
('".$catalog_product."','69','0','".$entity_id."','".$PName."'),
('".$catalog_product."','70','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','71','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','72','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','86','0','".$entity_id."',''),
('".$catalog_product."','90','0','".$entity_id."',''),
('".$catalog_product."','92','0','".$entity_id."','container2'),
('".$catalog_product."','95','0','".$entity_id."',''),
('".$catalog_product."','96','0','".$entity_id."',''),
('".$catalog_product."','97','0','".$entity_id."',''),
('".$catalog_product."','83','0','".$entity_id."','".$URL_path."')", $db_conect);

regard
Manoj Ninave

Comments

Post a Comment

Popular posts from this blog

How to Unzip/Extract zip file into one directory.

ini_set(’memory_limit’,'800M’); set_time_limit(36000); /** * @Module to Extract folder in one directory * @package general * @Author: Mr. Manoj M.Ninave **/ //create media/import directory in root dir $dir = $_SERVER['DOCUMENT_ROOT'].”/media/import”; $filename = $dir.”/ABC.zip”;//destination $zip_file = “http://www.yourssite.com/ABC.zip”;//source $contents = file_get_contents($zip_file); //echo $contents; $handle = fopen($filename, “w+”); fwrite($handle,$contents); fclose($handle); $zip = zip_open($filename); if ($zip) { while ($zip_entry = zip_read($zip)) { $zipEntry = zip_entry_name($zip_entry); $zipEntryFile = substr($zipEntry,strrpos($zipEntry,”/”)+1); $dirFile = $zipEntryFile;//unzipped directory $dirPath = $dir.”/”.$dirFile; $fp = fopen($dirPath, “w+”); if (!$fp) continue; if(zip_entry_open($zip,$zip_entry, “r”)) { $buf = zip_entry_read($zip_entry, zip_entry_filesize($zip_entry)); fwrite($fp,$buf); zip_entry_close($zip_entry); fclose($...
3 comments
Read more

How to get detail information about facebook user

Solution to get Detailed information about facebook user. 1) First you need to log in to the Facebook Developer application: Go to the Facebook Developer AppAfter following the link, click “Allow” to let the Developer application access your profile. 2) Begin setting up a new application. Go to the Developer application and click “Set Up New Application”. Give your application a name, check to accept the Terms of Service, then click Submit. You’ll see some basic information about your application, including: but for that you will need PHP client library you can download “PHP client library” after clicking the above link. for detail information see get started * Your API key: this key identifies your application to Facebook. You pass it with all your API calls. * Your application secret: Facebook uses this key to authenticate the requests you make. As you can tell by its name, you should never share this key with anyone. code: require_once ‘facebook.php’; $appapikey = ‘Your API Key’; $a...
2 comments
Read more

Loading web pages problem in Firefox and Crome browser?

I faced problem to load some web page in Firefox and Crome browser so i passed some code in .htaccess files. code is given as follow: php_value output_handler ob_gzhandler simply copy and paste it to .htaccess file. Also see that following lines are passed are not: php_flag allow_call_time_pass_reference on php_flag magic_quotes_runtime off php_flag register_globals off php_flag magic_quotes_gpc On php_flag register_argc_argv on php_value register_long_arrays on php_value display_errors on php_value allow_url_include on to compress your files for faster loading “php_value output_handler ob_gzhandler” is very useful. Regard Manoj Ninave
1 comment
Read more