13Jul 2013 by admin No Comments

Update product stock directly from Magento database

Magento

Sometime in some situation development time we need to update products quantity and stock status directly in the magento database. here I describe the most efficient way to do this is to update the products quantity and stock status directly in the database. Product quantity is stored in cataloginventory_stock_item table in qty and stock status in is_in_stock column, also we have to update cataloginventory_stock_status, the columns qty and stock_status with the corresponding Boolean value. So, the SQL query should look something like below query: [sourcecode language="plain"] UPDATE cataloginventory_stock_item item_stock, cataloginventory_stock_status status_stock SET item_stock.qty = '$new_quantity', item_stock.is_in_stock = IF('$new_quantity'>0, 1,0), status_stock.qty = '$new_quantity', status_stock.stock_status = IF('$new_quantity'>0, 1,0) WHERE item_stock.product_id = '$product_id' AND item_stock.product_id = status_stock.product_id [/sourcecode] where $new_quantity contains the product quantity sent by our ERP system and $product_id is the…

25Jun 2013 by admin No Comments

Some Facts about Popularity of Magento Extension and Modules

Magento

Magento has become a popular extension among many sites nowadays. It also has become one of the most functional and powerful platforms for e-commerce sites which offer customization that is rich and full of possibilities with its modules and extensions. This software is built on a model that is full modular and it provides unlimited flexibility and capability to your website or online store. Listed below are some of the facts about Magento and its extensions and modules. Enhance the Functionality of Magento: Aside from the out of the box functionality of Magento, people are still trying to enhance the software's capabilities. Given that its open source, any programmer can sort the software itself to suit to whatever he or she wants out of Magento. The possibilities of enhancement for…

06Jun 2013 by admin No Comments

Improve search result function magento

Magento

Magento default seek capacity is really exceptional, yet in the event that you need to enhance with additional clear and relevant effect then need to taking after progressions. Magento will sort on a rising request. In different statements, the most applicable items will be at the base. We need plunging request, in different statements, the best comes about at the top. We are set to change it by pointing out the diving sort request in the template record. Search for the form.mini.phtml document, and in the event that its not in your topic's template/catalogsearch envelope, include it. [sourcecode language="plain"] <input type="hidden" name="order" value="relevance" /> <input type="hidden" name="dir" value="desc" /> [/sourcecode] This changes the search so that our most relevant results show first. Make a copy of app/code/core/Mage/CatalogSearch/Model/resource/Fulltext.php And place it…

02Jun 2013 by admin No Comments

Magento OnPage SEO for Optimisation

Magento

Magento is exceptionally exceptional ecommerce stage and numerous shopper utilize magento for online shop. There are numerous profits to utilizing Magento for your shopping truck. At the same time there are additionally a few disadvantages to Magento's open source shopping truck platform.one of the aforementioned essential disadvantages is with Seo. Magento isn't the most Seo-accommodating open source programming. In the event that you are needing to do on-page Seo for your site, it could be a touch demanding with Magento. Magento Page Content An additional Magento Seo tip is to determine your Magento class pages and content pages are optimized and could be applicable pursuit terms. Every page title and portrayal ought to be remarkable to diminish copied substance on your site. Content Pages Essentially head off to Cms >…

23May 2013 by admin No Comments

5 Steps that’ll rocket your magento store conversion rate

Magento

What’s the most important part of online retail business? Leads, you would say. Of course leads are important, but what’s the point of having leads which don’t convert. Conversion rate of an e-commerce site speaks about its success. The higher the conversion rate, the more is the number of purchases and the better is the reputation of the store among-st buyers. Are you wondering about the conversion rate of your Magento store and devising ways to improve it? Well, stop thinking and start reading. To convert leads into sales, there are few fundamentals which you must keep in mind and opt for the right Custom Magento development partner. Enlisted below are 5 such fundamentals. Read through and understand how you can optimize the conversion of your site. KISS (Keep it…

18May 2013 by admin No Comments

Increase Image Quality on Magento

Magento

Magento accordingly layers the picture throughout the transfer process to have thumbnail pictures and essential pictures show faster for your clients. Magento expects that you favor speed over picture quality and lessens the span of your picture. The point when picture quality is not strictly outlined for certain sorts of pictures, Magento framework takes the first ever worth, and for some it figures its own particular. All we need to do is to situated the picture quality to the most astounding quality. This could be finished assuming that you open a record: app/code/core/mage/catalog/helper/image.php Discover a strategy __tostring() and simply before attempt condition before all else of the system, embed the accompanying scrap of code: $this->_getmodel()->setquality(99); provided that you need to enhance the nature of item pictures in category see steer…

10Apr 2013 by jullieroslin No Comments

Want to Download some Responsive Magento Themes of 2013?

Magento

RWD (responsive web design) is one such concept that enables your website to convert its look as per the mobile device and web browser. Today, most of the online merchants, who have online store based on Magento, searching for responsive Magento themes to use in their e-stores. In this epoch of mobile technology, each and every customer is accessing any website or internet from his/her smart-phone, tablet or any device. No matter whether it comes to purchase products or visiting any website, most of the people prefer their smart-phone or tablet. Therefore, it is must for every businessman to go hand-in-hand with responsive design, which is one of the most powerful and advanced topic in web designing. By using RWD concept, you will get more business by allowing your customers…

08Apr 2013 by forix No Comments

Revolution of Online Shopping Cart for your Business using Magento Platform

Magento

Searching for an ideal, easy to use, efficient and exclusive e-commerce platform? Your search is sure to end at Magento eCommerce platform known best all over the world for the huge variety of services it delivers. Magento developers aim at providing simplified solutions to the business to get your online business reaction improved. They are sure to revolutionize online shopping cart for your business using the Magento platform. Using this platform has the potential to change the way you handle your online business giving you a better hold of it, keeping you informed and helping in its expansion too. The unique features which are a part of this revolutionary platform are: Easy to use Admin System: The admin system is developed in a way that it can be used by…

25Mar 2013 by admin No Comments

Magento Development Services

Magento

Justwebdevelopment provide all types of magento realted services. If you find affordable magento development service your search end here. Magento Development Magento is an open source web application especially made for ecommerce purpose. It works on Zend framework. After the launching of magneto in 2008, it has been popular day by day as the best ecommerce platform. Magento is PHP based and buffering its data in MySQL.In order to offer the best solution in eCommerce development, magento development proves to be the best platform. Magento provides such a flexibility which helps in business growth. Inquire Now Read More Magento Theme Development It is true that having a stunning website design can leave a good image in the mind of visitor. In the eCommerce market prior to initiate an online shop…

20Mar 2013 by admin No Comments

Display Products With Paging on Magento Home Page

Magento

If you want to display product on home page with pagination it can be done easly in magento backed without writing any custom code in file. Display more products on magento home page so you need to set paging its easily created paging with some XML code in magento. 1. Go to CMS > Manage Pages and click on the Home page. 2. Under the "Design" tab, insert the following code in the "Update Layout XML" field: [sourcecode language="plain"] <reference name="content"> <block type="catalog/product_list" name="product_list" template="catalog/product/list.phtml"> <action method="setCategoryId"><category_id>3</category_id></action> <block type="catalog/product_list_toolbar" name="product_list_toolbar" template="catalog/product/list/toolbar.phtml"> <block type="page/html_pager" name="product_list_toolbar_pager"/> </block> <action method="setToolbarBlockName"><name>product_list_toolbar</name></action> </block> </reference> [/sourcecode] [JWD-Magento-Development]