Create a page under CMS > Pages and call it Newsletter. Then add the code below:

{{block type="newsletter/subscribe" template="newsletter/subscribe.phtml"}}

The code below can be used in the template/page .phtml files:

Example below was used in 2column-left.phtml file:

<?php $category = Mage::getModel('catalog/layer')->getCurrentCategory();?>
<?php if($category->getId()==24): ?>
<?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('block-for-cat24')->toHtml() ?>
<?php elseif($category->getId()==23): ?>
<?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('block-for-cat23')->toHtml() ?>
<?php else: ?>
<?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('block-for-everything-else')->toHtml() ?>
<?php endif; ?>

Use the CSV below to setup VAT in Magento

WebShopApps Shipping
WebShopApps Invoice
OneStepCheckout
Simple Google Shopping

To Retrieve URL path in STATIC BLOCK

To get SKIN URL

{{skin url=’images/sampleimage.jpg ‘}}

To get Media URL

{{media url=’/sampleimage.jpg’}}

To get Store URL

{{store url=’mypage.html’}}

To get Base URL

{{base url=’yourstore/mypage.html’}}

To Retrieve URL path in PHTML
Note: In editing PHTML don’t forget to enclode the following code with PHP tag

Not secure Skin URL

getSkinUrl(‘images/sampleimage.jpg’) ?>

Secure Skin URL

getSkinUrl(‘images/ sampleimage.gif’, array(‘_secure’=>true)) ?>

Get Current URL

$current_url = Mage::helper(‘core/url’)->getCurrentUrl();

Get Home URL

$home_url = Mage::helper(‘core/url’)->getHomeUrl();

Importing products to Magento using a CSV