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

Add Date field with Datepicker in Magento

Magento
Here I want to show you how to add date field with date picker in any of your form like contact, gift message etc in magento frontend design. Magento has a built in library for calendar functionality but its available only on admin so here I show you how to se date field with date picker in magento frontend. Add below css and javascript for calender in your current theme page.xml file. This will include all the calendar library functions frontend on your theme. [sourcecode language="plain"] <action method="addItem"><type>js_css</type><name>calendar/calendar-win2k-1.css</name><params></params></action> <action method="addItem"><type>js</type><name>calendar/calendar.js</name></action> <action method="addItem"><type>js</type><name>calendar/calendar-setup.js</name></action> <block type="core/html_calendar" name="head.calendar" as="calendar" template="page/js/calendar.phtml"></block> [/sourcecode] Now add below code in which form where you want to add date field like contact, gift message etc... [php] <div class="field"> <label for="dob"><?php echo Mage::helper('contacts')->__('DOB') ?></label> <div class="input-box"> <input name="dob" id="_dob"…
Read More

Multi Select Drag and Drop Jquery

JQuery
When data is very large and selection using multiselect is difficult so you can use this option multi select drag and drop with jquery. The first holds the options that are available, and the second holds the options that have been selected. Usually, the two boxes are separated by add and remove buttons. You can select an item from the first box, click the add button, and add it to the second box. Likewise, you can select an item from the second box, click the remove button, and it goes back into the unselected box. [sourcecode language="plain"] <table> <tr> <td> <label>All Value</label><br/> <select name="multi_list1" id="select1" multiple="multiple"> <option value="name1">Name 1</option> <option value="name2">Name 2</option> <option value="name3">Name 3</option> <option value="name4">Name 4</option> </select> </td> <td> <a href="#" id="add">&gt;&gt;</a> <br/><br/> <a href="#" id="remove">&lt;&lt;</a> </td> <td>…
Read More

Import And Export Mysql Heavy Database

MySql
Exporting and Importing database through PhpMyadmin is only good if you have small database. But you want to import and export big database then it is not possible. Here I show you script which is easily import and export heavy mysql database. Import big mysql database [php] &amp;lt;?php $mysqlDatabaseName ='MyDBName'; $mysqlUserName ='username'; $mysqlPassword ='yourPassword'; $mysqlHostName ='localhost'; $mysqlImportFilename ='db.sql'; $command='mysql -h' .$mysqlHostName .' -u' .$mysqlUserName .' -p' .$mysqlPassword .' ' .$mysqlDatabaseName .' &amp;lt; ' .$mysqlImportFilename; exec($command,$output=array(),$worked); switch($worked){ case 0: echo 'Import file &amp;lt;b&amp;gt;' .$mysqlImportFilename .'&amp;lt;/b&amp;gt; successfully imported to database &amp;lt;b&amp;gt;' .$mysqlDatabaseName .'&amp;lt;/b&amp;gt;'; break; case 1: echo 'Error during import. Please make sure the import file is saved in the same folder as this script and check your mysql details like username, password, host and database name.'; break; } ?&amp;gt; [/php] Export…
Read More

Magento get items in order

Magento
Here, I can show you how you can get information about all items in your magento shopping cart based on order id. How to get product details from order id or sometimes need to get product it, product sku, product name , category id, category name. So its easy to get product from order item based on order number. [php] <?php require 'app/Mage.php'; Mage::app(); $orderNumber = 100004544; $order = Mage::getModel('sales/order')->loadByIncrementId($orderNumber); // get order total value $orderValue = number_format ($order->getGrandTotal(), 2, '.' , $thousands_sep = ''); // get order item collection $orderItems = $order->getItemsCollection(); foreach ($orderItems as $item){ $product_id = $item->product_id; $product_sku = $item->sku; $product_name = $item->getName(); $_product = Mage::getModel('catalog/product')->load($product_id); $cats = $_product->getCategoryIds(); $category_id = $cats[0]; // just grab the first id $category = Mage::getModel('catalog/category')->load($category_id); $category_name = $category->getName(); echo "orderNumber=".$orderNumber."<br/>"; echo…
Read More

Magento category product count

Magento
Many times we need to show product count per category in magento. So here I am showing to how many products (Product count) in that categories. First of all I get all categories based on category position with ascending order and then get product count for that category. It shows like below example: Laptops (4) Hard Drives (4) Root Catalog (5) Monitors (4) Shirts (19) Shoes (46) Get category and product count in magento [php] <?php $categories = Mage::getModel('catalog/category')->getCollection() ->addAttributeToSelect('name') ->addAttributeToSelect('url_key') ->addAttributeToSelect('my_attribute') ->addAttributeToSelect('position') ->addAttributeToSort('position', 'ASC') ->setLoadProductCount(true) ->addAttributeToFilter('is_active',array('eq'=>true)) ->load(); ?> <?php foreach($categories as $key=>$category): ?> <?php if($category->getName() != ''):?> <?php $prodCollection = Mage::getResourceModel('catalog/product_collection')->addCategoryFilter($category); // Magento product collection ?> <a href="<?php echo $category->getUrl() ?>"><?php echo $category->getName() ?></a> (<?php echo $prodCollection->count() ?>)<br/> <?php endif;?> <?php endforeach; ?> [/php] [JWD-Magento-Development]
Read More