Skip to main content

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

Comments

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

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

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