Magento: Remove all categories from a store

This is just the Sql commands that I just discovered today in order to to remove all categories. For more information, please check here. Please also notice that you may have to change the prefix of database tables, enjoy 🙂

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;
INSERT INTO `catalog_category_entity`
(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`POSITION`,`level`,`children_count`)
VALUES
(1,3,0,0,‘0000-00-00 00:00:00’,‘2009-02-20 00:25:34’,‘1’,1,0,1),
(2,3,3,0,‘2009-02-20 00:25:34’,‘2009-02-20 00:25:34’,‘1/2’,1,1,0);
INSERT INTO `catalog_category_entity_int`
(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`)
VALUES
(1,3,32,0,2,1),
(2,3,32,1,2,1);
INSERT INTO `catalog_category_entity_varchar`
(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`)
VALUES
(1,3,31,0,1,‘Root Catalog’),
(2,3,33,0,1,‘root-catalog’),
(3,3,31,0,2,‘Default Category’),
(4,3,39,0,2,‘PRODUCTS’),
(5,3,33,0,2,‘default-category’);
SET FOREIGN_KEY_CHECKS = 1;

Building a Magento Admin Module

Have you ever wanted to build a custom module for the Magento admin panel? Today I am going to share this information hoping you will find this post useful!

Creating the Module Folder Structure

Lets start by creating the following folders:

app/code/community/Toto/ImportXml/etc
app/code/community/Toto/ImportXml/controllers
app/code/community/Toto/ImportXml/Helper

Building the Module

Within the ‘etc’ folder create a file called config.xml and paste in the following code:

configxml

Next create a file called adminhtml.xml within the ‘etc’ folder and paste in the following:

adminhtml

We need to tell Magento to load our module and to do this we need to create a file within /app/etc/modules. I called my file Toto_ImportXml.xml and it contained the below XML code:

xml

Now if you refresh your Magento admin panel, you should notice a new tab called ‘Tofu & Tomato Commerce’. However, if you click on it you will be given a PHP error saying that Magento can’t find a helper class. This is because within adminhtml.xml we told Magento that the tab is associated with the module ‘importxml’ and by default Magento looks for a helper file called Data.php.

module=”importxml”

In the config file we also declared the helper class within the global node.

globalhelper

To fix this problem we need to create a file called Data.php with the Helper folder (/app/code/community/ Toto/ImportXml/ Helper/Data.php). This will be an empty class for the time being but it will fix the warning we are currently getting. Paste the following into Data.php:

helper

Note: The class name needs to be file path structure to Helper/Data.php.

The final stage is to add the controller. This will route the user to the method specified within adminhtml.xml. For example lets take the following:

<action>greenmodule/index/index</action>

Magento will look in the module ‘Greenmodule’ for an index controller with the method called indexAction. So lets create a php file called ‘IndexController.php’ within the controllers folder (/app/code/community/Toto/ImportXml/controllers/ IndexController.php). Paste in the below PHP code:

controller

The above method simply creates a block with a the heading ‘Tofu & Tomato Commerce’ by using Magento factory methods. Refresh your browser and you click on the custom menu tab – you should now see a brand new page with the h1 tag.

Note: You may have to clear your magento cache or log out and log back in for the new page to show. This has caught me out many times.

tofu&tomato-commerce

Enjoy!

Magento: How can I format / shorten a price to two decimal

I was having trouble displaying some prices on my Magento store in currency format (2 decimal places). Instead the values were being displayed at 4 decimal places. Bellow is a snippet. (for example: from +0.8500 to +0.85)

$numberformatted = number_format($number, 2, '.', '');

More information: http://php.net/manual/en/function.number-format.php

magento-format-shorten-price-2-two-decimals

Magento: Get Bundled Items name / title by bundled product Id

This post is jut a small snippets that will help you to get all bundle items’ title.

Of course, I’m not sure how useful can it be as is, so if you need optimized version of it, you will need to play with it for a while. I tried to find it on google few days ago and I had no luck, so if anybody has better solution, please comment.

Here we go:

bundle products

Bundled Products, Magento will not recalculate the Price – Bundle.reloadPrice()

Hello, I’m Tofu, nice to see you again.

My client gave me a purchased Magento template and asked me to install and configure a new Magento store for him. The template was very clean and professional. However, there was an weird issue since it did not support the latest Magento version 1.9.

I created serveral bundle products just for testing purpose then I added or subjected items to the cart, the price did not change. I got js errors:

Uncaught ReferenceError: taxCalcMethod is not defined 
Uncaught TypeError: Cannot call method ‘reloadPrice’ of undefined

Finally, I figured out the problem. We will need to copy the following javascript snippets from BASE theme to our activated theme in
/app/design/frontend/default/YOUR_TEMPLATE/template/
/bundle/catalog
/product/view/type/bundle.phtml

bundle-magento-products

Enjoy!