Technology GupShup- All about Technology, Software , Databases, Web Development and Computers

Sometimes you need to delete all products from magento store. You can do it from admin panel however if you have large number of products (more than 5000) delete will time out and you will have to delete like 200 products at a time. To save time you can go to phmyadmin and run following query to delete all products easily. Make sure you have backed up your database before this. This worked well on Magento 1.9 and did not cause any side effects.  SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `catalog_product_bundle_option`; TRUNCATE TABLE `catalog_product_bundle_option_value`; TRUNCATE TABLE `catalog_product_bundle_selection`; TRUNCATE TABLE `catalog_product_entity_datetime`; TRUNCATE TABLE `catalog_product_entity_decimal`; TRUNCATE TABLE `catalog_product_entity_gallery`; TRUNCATE TABLE `catalog_product_entity_int`; TRUNCATE TABLE `catalog_product_entity_media_gallery`; TRUNCATE TABLE `catalog_product_entity_media_gallery_value`; TRUNCATE TABLE `catalog_product_entity_text`; TR...

Are you looking to setup an online store? You can setup your store and you can start selling in a week. There are many platforms available to use but Shopify is easiest, reliable and SEO friendly.   Not familiar with Shopify ? It is a great way to sell tour products, without worrying about managing a server, payment gateways, etc. as for a small monthly fee everything is included.  Click here to create a free trial store and start exploring. 

E commerce is great way to reach more customers and significantly increase profits. Global eCommerce sales have increase to a $1.25 trillion in 2013. So how can you get your share out of this market? Building a ecommerce website requires skilled software engineers to manage orders, payments and reports. Good designers are required to make site more appealing and easy to use. But good news is you do not need to hire these professional to start selling online.  There are many pre-built platforms that let you create online shop in hours or even minutes. These plateforms allow you to - List products with categories, images, descriptions and customization. Almost everything that you can thing of. - manage order and payment process and notify you whenever new order arrives - manage inventory and shipping costs - Have support for Search Engine Optimization(SEO) and  Social sharing and marketing. There are tens of such platforms but most popular ones are Woocommerce ...

Favicon is the small icon that appears on left of the title bar  when your website is opened in browser. Figure below show favicons of gmail and blogger. This is a very good way to brand your site. To add a favicon to your wordpress follow these steps. Create favicon favicon is a 16 x 16 pixel image so you have to either shrink your logo to this size or create a new image for your favicon. You can save image in either gif, png, jpg or ico.  Adding favicon Once you have the image ready install " All in One favicon ".  Then in your website admin dashboard goto            Plugins-> All installed Plugins and under All in one favicon select settings. This will open this interface Now you can select a favicon in whatever format you have(only one) and save.  Reload your site and favicon should be there.  In case you have any problems leave a comment here.

Sitemap is one of the important pages of every website and very helpful for the user when she is lost. With large number of pages and posts it can be hard to create a Sitemap page manually. Luckily Wordpress has many plugins for that and out of those WP Sitemap Page  is my favourite. To add sitemap on a page just install this plugin and add    [wp_sitemap_page]   shortcode to your page. It can display all pages , posts and categories but you can choose what to show. If you have any questions write it in comments.