This article helps to clean data from tables which are not necessary for the website and also clean files from the directory which are not useful. Cleaning log from database reduce the database size and also the improvement in the site performance.
Category: Magento
Magento is an open source based ecommerce web application that was launched on March 31, 2008. It was developed by Varien (now Magento Inc) with help from the programmers within the open source community but is owned solely by Magento Inc.. Magento was built using the Zend Framework. It uses the Entity-attribute-value (EAV) database model to store data.
Varien, the company owning Magento, formerly worked with osCommerce. They originally planned to fork osCommerce but later decided to rewrite it as Magento. Magento officially started development in early 2007. Seven months later, on August 31, 2007, the first public beta version was released.
Magento: Display multi-select field in form and grid
The multi-select field is very useful in many features like assigning an item to multiple categories. I am writing code here to implement multi-select in form page and then display multi-selected values in grid page.
Magento: Email alert for customers
Adding users is faster and more efficient for eCommerce website. This is particularly helpful for companies who add large volumes of users on an ongoing basis. Sending email using a cron has numerous benefits for growing customers in the website. Many of our customers purchased product, but some customers are not logged in the website from long time or some customers are even not logged in the website. So i am writing this post which helps to send mail to not logged in customers.
Magento: How to change admin password
Admin login is one of the issue due to forgot password therefore i am getting to change or reset password of admin.
Magento: Call block and template
In Magento each view page contains template(html) and its own block (PHP) so that understanding about template, block is beginning of Magento web application.
Magento: Web store backup guideline
A system can fail no matter but how fast we can up the system and same applies to the Web store. Thus for preparation it is vital to have a good backup of all those files and database of the solution. For the reason this section describes the resources of different components of backups required for Magento, PHP, and Database. There are three sections which will help webshop to ensure what need to be backup regular basis and keep it safe for the situation of failure.
Magento: fatal-error on product detail
Fatal error: Call to a member function loadPriceData() on a non-object in Magento. This error displays when edit product or view of product list page.
Magento: How to solve blank page error
The error has been fixed by changing content of core function getRowUrl in app\code\core\Mage\Adminhtml\Block\Widget\Grid.php
Magento: Display additional attributes in layered navigation
This is the simple way to display additional attributes of products in layered navigation which helps to filter product easily.
Magento: Fetch data from custom table
Fetching data from custom table in magento is quite difficult because its data store in entity attribute value (EAV) model therefore most of the table structure are in EAV model. So joining one table with other tables is different from other database system. Here is a query example of sample table which helps you to use join, select, group, filter data from custom table .