0

Standalone Magento Scripts

Read more
 

Every now and again its useful to create a small standalone magento scripts, I have used them in the past to quickly update settings, or for creating small export scripts etc. These can be setup anywhere on the server and ran either in the browser or via the command line. Scripts would need to be [...]

 

0

Drop Magento Database in One Query

The code below does as the title suggests. If anyone has been trying to remove the Magento database for whatever reason you’ll find that with all of the key constraints that come with Magento droping every table at once requires a special bit of code. Below is from a 1.7.0.2 store, different version of Magento [...]

 

0

Magento Zend Database Read Queries

Read more
 

As a platform Magento is built on the Zend Framework, therefore we can utilise the Zend Framework Database Class for reading from and writing to the Magento database. These actions would normally be used in a custom magento module or standalone script that you have running on your site. Direct database actions should be handled [...]

 

 

0

Magento Robots.txt File

Read more
 

The robots.txt file on your website can help you say what gets indexed, crawled and used by the search engines. It is a vital part of your website which is often overlooked. Full details on the robots.txt file can be found on the wiki page @ http://en.wikipedia.org/wiki/Robots_exclusion_standard however below I have listed the most helpful [...]

 

2

Get Customer Group from Session

Using the customer group is a good way to restrict and change parts of your Magento store when a customer is logged in. A good example of this is if you are wanting to put restrictions in or show alternative banners based on a Wholesaler customer login. To get the customer group id from the [...]

 

0

Call a template from a Static Block

Read more
 

Recently I was searching for how to do this and all I could find was how to put a static block into your template file, however here is how to go the other way and pull a .phtml template file into a static block: [crayon] {{block type=”core/template” block_id=”demo.block” template=”your/template/path.phtml”}} [/crayon] Simply replace the block type, [...]

 

0

Adding Custom Category Attributes

Read more
 

Through some recent work in the office we were required to add custom attributes to allow extra data entry via the category manager in the Magento admin area. We achived this by adding attributes in the SQL setup file from a custom module. Some examples of how to add these category attributes are shown below: [...]

 

0

Get table name with prefix

When writing database queries in modules for Magento it is often helpful to wrap the table names in a core function called “getTableName” this function will then prefix the table name if the install is using prefixes in the database. To do this: [crayon] Mage::getSingleton(‘core/resource’)->getTableName(‘table_name_here’); [/crayon]

 

0

Delete All Test Orders via MySQL

Hey all, many of you have asked how to quickly truncate the correct Magento database tables to remove test orders or old website orders. The following SQL code has been tested on Magento 1.4 and above. Please be aware that this code, when ran, will permanently delete all the orders and quotes in your Magento [...]