Monthly Archives: September 2008

Magento: Add Static Block to CMS Page

Posted on September 30, 2008 by Josh Pratt

There is definitely nothing complicated about doing this. Static blocks are a great way to divide up different types of data blocks to make updating content easier. There are just two simple steps to adding a static block to a … Continue reading →

Posted in Magento | 17 Comments

Magento: Add Custom Module For Custom Admin Config Options

Posted on September 29, 2008 by Josh Pratt

In my previous post, I showed you how to add instructions to the Short Description on the product add/edit form. While this is useful, if you ever wanted to change the instructions, you would have to open the template file … Continue reading →

Posted in Magento | 11 Comments

Magento: Add Instructions to Form Field in Admin Product Add/Edit

Posted on September 26, 2008 by Josh Pratt

I made some custom functionality that can happen with a product’s Short Description. Depending on what is put in that textarea, icons and special product-specific links can be displayed on that product’s view page. It requires a specific format though … Continue reading →

Posted in Magento, PHP | 3 Comments

Magento: No Tax for Wholesale Customers

Posted on September 25, 2008 by Josh Pratt

We ran into the need today to not charge tax for wholesale customers. The good news is that no code modifications are needed to accomplish this. All the functionality is already built right into Magento. Here’s a step-by-step process on … Continue reading →

Posted in Magento | 3 Comments

Magento: Easily and Quickly Delete All Products

Posted on September 25, 2008 by Josh Pratt

If you have ever tried to delete a large amount of products out of Magento, you’ll realize that it takes forever, and in many cases, you have to do it in small quantities at a time otherwise it will freeze … Continue reading →

Posted in Magento, MySQL | 16 Comments

PHP: One Line If Statement (Ternary Operator)

Posted on September 24, 2008 by Josh Pratt

I decided to see if there was a better way to write a simple if statement today, and of course, there was. It uses the Ternary Operator (?:). My if statement today was rather simple. I needed to find out … Continue reading →

Posted in PHP | Leave a comment

Mysqli and Object-Oriented PHP

Posted on September 22, 2008 by Josh Pratt

Sometimes it is easy for me to get stuck doing things the way I know how to do it, rather than finding a better, more up-to-date method. I just had a recent post about making multiple connections to mysql, but … Continue reading →

Posted in MySQL, PHP | Leave a comment

Magento: Accessing Customer Session

Posted on September 17, 2008 by Josh Pratt

I needed to create some custom shipping functionality within Magento today which would charge wholesale customers $5.00 flat rate, and all other customers got free shipping. This required having to access the customer group number. Wholesale customers are have a … Continue reading →

Posted in Magento | 3 Comments

Turn Off Word Wrap in Leopard Terminal

Posted on September 16, 2008 by Josh Pratt

As I said in the post prior to this, I have really been enjoying using Terminal for accessing MySQL databases. I found a problem with it though. If you have a table with a lot of columns, or a column … Continue reading →

Posted in Mac OS X, MySQL | 1 Comment

Using MySQL Through The Command Line