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

Popular posts from this blog

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...

Import Customers by csv file in Magento

Import Customers by csv file in Magento here i developed script to import customers in magento by csv file. csv file have following columns ########customerid (unique key) accesskey (customer type) emailaddress password firstname lastname companyname billingaddress1 city state postalcode country phonenumber faxnumber ########### here i didn't use any magento's core file. code is given below,i hope it will help you :) set_time_limit(36000); error_reporting(0); /** * @Use Script to import customer's data in Magento Database * @createDate Mar 2010 * @author Manoj Ninave (manojninave@gmail.com) **/ define("DB_HOST","localhost",TRUE); // database server name define("DB_USER","root",TRUE); // database user define("DB_PASS","",TRUE); // database user's password define("DB_NAME","dbname",TRUE); // database name require_once('db.class.php'); if( !isset($db_obj) ) {...

Magento Tables required to Import Products.

Data inserted in following tables while importing products. 1)adminnotification_inbox 2)catalogindex_eav 3)catalogindex_price 4)cataloginventory_stock_item 5)cataloginventory_stock_status 6)catalogsearch_fulltext 7)catalog_category_product 8)catalog_category_product_index 9)catalog_product_enabled_index 10)catalog_product_entity 11)catalog_product_entity_datetime 12)catalog_product_entity_decimal 13)catalog_product_entity_int 14)catalog_product_entity_media_gallery 15)catalog_product_entity_media_gallery_value 16)catalog_product_entity_text 17)catalog_product_entity_varchar 18)catalog_product_link 19)catalog_product_link_attribute_int 20)catalog_product_website 21)core_url_rewrite Regard Manoj Ninave