There was a problem with reindexing process magento

Magento
When I try to reindex from magento admin I show error "There was a problem with reindexing process". I found many post in google but not get excat fixed. After many hours I fixed that issue and I show you how you can also fix this issue and working good all reindex.   1) Export all catalog_product_flat _1 tables with data and structure with 'Disable foreign key checks' enabled. 2) Truncate all catalog_product_flat _1 tables. 3) Ensure that whether products categories are all visible in Frontend. 4) Login to Magento Admin Panel. 5) Then go to 'System' menu and click on 'Index Management' submenu. 6) At last click "Reindex Data" next to "Product Flat Data" index. To figure out the reindexing issue for Category Products do the following actions: 1)…
Read More

WordPress gallery add rel lightbox

Wordpress
Everyone to like lightbox or prettyphoto to show images in nicely in popup. In wordpress are many plugins to set popup for your images but need to insert or set rel to every images or gallery. But if you added all the images then you can decide to open image in popup that time very difficult to rework to set or edit rel in every images or gallery. If you want to set automatically rel in every images or add all gallery images rel=lightbox or something like that then this post is very useful to you and save lot of time. If you want to set all images url rel=lightbox or rel=prettyphoto then add this below function to your theme function.php file. [php] <!--?php <br ?-->// Custom functions add_filter('the_content', 'my_addlightboxrel');…
Read More

Display product image in invoice + Magento

Magento
Here I show you how to Display product image in magento PDF invoice or Display product image in shipping invoice. The product line display occurs in specific PHP classes within the app/code/core/Mage/sales/Model/order/pdf folder. There is one folder for shipment, one for invoice, and one for credit. The product display occurs in the deault file where the Mage_Sales_Model_Order_Pdf_Items_Abstract is defined. Product object using the id from order / items, and get the image file using the following code in the draw function. [php] /* Display Image Start */ $id = Mage::getModel('catalog/product')->getIdBySku($this->getSku($item)); $product= Mage::getModel('catalog/product')->load($id); $imageUrl = $product->getSmallImageUrl(); $imageFile= str_replace(Mage::getBaseUrl('media'),"media/",$imageUrl); $imageWidth = 100; $imageHeight = 50; $image = Zend_Pdf_Image::imageWithPath($imageFile,$imageWidth,$imageHeight); $y=$pdf->y – $imageHeight /3; $page->drawImage($image, 35,$y, 35+ $imageWidth / 2, $y + $imageHeight/2); // If you want to display custom image then use this…
Read More

Enable GZip Compression

PHP
Gzip is the most popular and effective compression method currently available and generally reduces the response size by about 70%. Approximately 90% of today's Internet traffic through browsers that claim to support gzip. Gzip is a server process that essentially compresses your files on the fly before transmission to the user. It is primarily used to compress text files such as HTML, CSS, and JavaScript with impressive results. GZip method was used in earlier version of apache (before apache 1.3). But after that apache introduced deflate method which is not much effective as Gzip (But still it is very good). But GZip is no more supported after apache 1.3. So in now a days you must have Apache greater than 1.3 and if not you must upgrade to latest version.…
Read More

Fatal error: Call to a member function getTable() on a non-object in magento

Magento
Sometime you can see on your magento store "Fatal error: Call to a member function getTable() on a non-object in magento" when you try to get Configurable product in frontend or when you try to add Configurable product in backend in magento. Its error occurred because of not found some function or file. When I moved my magnto store from my local server to online and try to add Configurable product from backend I see this error   Error: Fatal error: Call to a member function getTable() on a non-object in /var/www/magento/app/code/core/Mage/Core/Model/Mysql4/Collection/Abstract.php on line 456   Sometime extract zip file or move files from local to online some files change name like Attribute.php0000644. In our case when I trace or after some R & D I found the solution. Please…
Read More

Call a Widget in pages content from admin

Wordpress
Here its an idea how you call your widget in pages content using admin panel. If you want to call your wideget not on every page or just call or shows on single page in content area so this is very help to show you how to Call a widget with a shortcode. First creating a custom function for the functions.php file which would output any widget by name. After that Now in Post/Page content, you can use that widget just by referencing it by name. [php] function widget($atts) { global $wp_widget_factory; extract(shortcode_atts(array( 'widget_name' => FALSE ), $atts)); $widget_name = wp_specialchars($widget_name); if (!is_a($wp_widget_factory->widgets[$widget_name], 'WP_Widget')): $wp_class = 'WP_Widget_'.ucwords(strtolower($class)); if (!is_a($wp_widget_factory->widgets[$wp_class], 'WP_Widget')): return '<p>'.sprintf(__("%s: Widget class not found. Make sure this widget exists and the class name is correct"),'<strong>'.$class.'</strong>').'</p>'; else: $class =…
Read More

Removed shipping address and shipping method from onepage checkout in magento

Magento
Here I can show you how to remove shipping address from onepage checkout and remove shipping method from onepage checkout in magento. Based on different shop and requirement we need to magento customize onepage checkout method. When site give user only product information or accept only quote request based on product then no need to show shipping address and shipping method tab from onepage checkout in magento. If you are managing logistics for heavy equipment, consider using specialized services for tasks like https://www.shiply.com/de/fahrzeugtransport/traktortransport.php to ensure safe and efficient handling. If you want to removed shipping address and shipping method from onepage checkout in magento then foloe below step. Step 1: GO to /public_html/app/code/core/Mage/Checkout/Block/Onepage/abstract.php Replace this code [php] &amp;lt;?php protected function _getStepCodes() { return array('login', 'billing', 'shipping', 'shipping_method', 'payment', 'review'); } ?&amp;gt;…
Read More

Cannot initialize the indexer process

Magento
When I upgrade magento all is work fine but when I try to reindex then it show me error like "Cannot initialize the indexer process". I spend lot time and finally I got the solution for this. I found many solution for fixed this issue but not work for me but when I repair my magento database using database repair tool developed by Magento core then its fixed me. How to repair the magento database: 1. Download repair tool from Magento and unzip the package. 2. Upload magento-db-repair-tool-1.1.php to your server 3. Backup your current database (call it 'magentoDB1'). Export this database and then import it into a new database (let's call it 'magentoDB2'). 4. Install a fresh Magento using 'magentoDB2'. 5. Now open the the URL in browser: http://www.youdomain.com/magento-db-repair-tool-1.0.php.…
Read More

WordPress Plugins for eCommerce

Wordpress
WP e-Commerce WP e-Commerce shopping cart plugin for WordPress is an elegant easy to use fully featured shopping cart application suitable for selling your products, services, fees online and connects you with your potential customers in a seamless manner. WP e-Commerce works well sites of all shapes and sizes. You can use it so sell actual physical products, digital downloads, or even memberships. WP e-Commerce Plugins Features Import/Export Payment Gateways Integration Search Engine Optimization Internationalization Support(Like multiple currencies) Shipping Checkout Managing Orders Catalog Mangement Link: http://wordpress.org/extend/plugins/wp-e-commerce/ [JWD-Wordpress-Development] eShop eShop is a another good option to make shopping cart in wordpress. The eShop plugin is easy to use and offers a solid all-around e-commerce solution for WordPress sites. You can apply discounts to products to help enhance sales, and there are…
Read More

Magento addAttributeToFilter SQL Conditionals

Magento
If you want to customize query or product collection data you can easily to do that with addAttributeToFilter funcation in magento. In short you can easily customize product collection select query based on your requirement in magento development. [php] <?php $collection = Mage::getModel('catalog/product')->getCollection(); ?> [/php] If you want get all fields then use below condition select [php] <?php $collection->addAttributeToSelect('*'); ?> [/php] If you want to get limited fields then use below condition [php] <?php $collection->addAttributeToSelect(array('name', 'product_url', 'small_image')); ?> [/php] [php] <?php $collection = Mage::getModel('catalog/product')->getCollection() ->addAttributeToSelect(array('name', 'product_url', 'small_image')) ->addAttributeToFilter('sku', array('like' => 'test-product%')) ->load(); ?> [/php] The above code would get a product collection which contain only products that have an SKU starting with "test-product". addAttributeToFilter Conditionals [php] <?php // Is Equal To (eq) $collection->addAttributeToFilter('status', array('eq' => 1)); // Is Not Equal…
Read More