Suppose, you have ID of some products and you want to load them at once in Magento, then here is a solution:- Suppose, you have 5 products ID: 5, 22, 45, 75, 88 You can store them in one array: $productIds = array(5, 22, 45, 75, 88); Then, you can use MySQL’s IN() clause for … Read more
Here is a step-by-step guide on moving Magento site from one server to another. This can be from localhost to server or from server to localhost or from one server to another. Step 1: Enable maintenance mode This is to be done so that no users could place any order while you are backing up … Read more
I recently transferred a Magento website from one webhost to another. Frontend part is working fine. I am able to view products and cms pages. I am also able to view the admin login page. However, when try logging to admin, I get error page showing the following SQL query: SELECT `e`.*, SUM((e.base_subtotal-IFNULL(e.base_subtotal_refunded,0)-IFNULL(e.base_subtotal_canceled,0)-IFNULL(e.base_discount_amount,0)+IFNULL(e.base_discount_refunded,0))*e.base_to_global_rate) AS `revenue`, … Read more
Magento has the feature to verify the authenticity of newly registered customers before activating their account. When a user registers to your Magento shop, then he/she will get a confirmation email with a confirmation link. The customer’s account will be activated only after he/she clicks that confirmation link. By default this feature is not activated … Read more
Problem: I am having the following error when I browse Layered Navigation on Magento. You cannot define a correlation name ‘attribute_idx’ more than once Cause: This is because a block has been duplicated. You have to check your layout xml files to check if you have included same block at same place twice. Solution: To … Read more
You might get this error when you go to Magento Connect Manager (System -> Magento Connect -> Magento Connect Manager) of your Magento installation. This means that Magento Connect is unable to write files to your server. Warning: Your Magento folder does not have sufficient write permissions. The solution to this problem is to set … Read more
Problem: I had added a new product attribute. Suppose the attribute code is ‘test’. I have been trying to fetch/select that newly added product attribute. Here is my Magento collection code:- $collection = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect('test') ->addAttributeToFilter('url_key', 'SOME_URL_KEY') ->getFirstItem(); I don’t see the attribute ‘test’ when I print the collection data. echo "<pre>"; print_r($collection->getData()); echo … Read more
Let’s suppose that you have a custom Magento module named ‘YourModule’. You have a custom database table for the module. There is a date field in the table. Now, your requirement is that your module should be able to display and edit the date field from admin section. This article shows how you can display … Read more
Suppose, you have a custom Magento module and you wanted to add a custom tab to “Customer My Account” section, i.e. the frontend part displayed after customer login. Here is the solution:- Let’s suppose, your module’s name is Yourmodule. 1) Add these xml code in app/design/frontend/your_package/your_theme/layout/yourmodule.xml Note:- In default Magento settings, your_package = default & … Read more