Archive for December, 2009
Quick script to batch create Magento categories
Dec
18th
A site we administer with a reasonable amount of SKUs (far in excess of 100,000), needed some quick category manipulation for a series of new data to be dropped in. The new information had a desired category tree that had to be built up quick, but with over 600 categories to be created, human effort [...]
[slightly] Lifesaving online tools for a web developer
Dec
17th
Everyone needs some help to make their life easier and here are some of the on-line tools we use on a regular basis. We’ll keep the list updated whenever we find (or remember) another service that could come in handy for others!
Free Uptime Monitoring
This is one of the many (external) resources we rely [...]
Export Excel CSVs with double quotes
Dec
17th
This is a necessary evil for anyone who is working with CSV files manipulating them for data import to Magento (when XML is not suitable). Add the following function (sub routine) to Excel and hit the Macro button to run it. You’ll have no more failed Magento imports with this handy function.
Sub subExportCSV()
On Error GoTo [...]
Quick script to export Magento categories with IDs
Dec
17th
If you are after a quick method to get all the category ID’s for your categories for some Excel lookups (for new data imports), then this quick PHP script should help you out:
<?php
define('MAGENTO', realpath(dirname(__FILE__)));
require_once MAGENTO . '/app/Mage.php';
Mage::app();
$category = Mage::getModel ( 'catalog/category' );
$tree = $category->getTreeModel ();
$tree->load ();
$ids = $tree->getCollection ()->getAllIds ();
if ($ids) {
$file = "var/import/catwithid.csv";
file_put_contents($file,"catId, catName\n");
foreach [...]
The #sonassi_network is tracked via Twitter
Dec
16th
After the disaster suffered at the London Internet Exchange, there has become a necessity to track network complications externally.
We have always tracked any network complications internally via www.theclientarea.info, however, we have expanded on that functionality by extending our #sonassi_network status to twitter.
So now you can track the our network easily by a few of the [...]
Speeding up the Magento admin
Dec
13th
I’ve noticed a few people discussing this issue on the Magento Commerce forum, so it might be worthwhile for us to offer a level of assistance (other than the fast Magento hosting we provide already from sonassi hosting).
Downloading the following file, SlowManageCategories.zip patch.
Extract the zip file and copy Sonassi_All.xml to your ./app/etc/modules/ directory.
Copy the SlowManageCategories [...]
We are worthy of sitelinks
Dec
11th
Given the nature of Google site links, there are several assumed criteria amongst the SEO world as to how to ascertain site links.
Well, today, Sonassi was finally worthy. Although, its hardly something to boast about, it has been a long awaited feature in our office, its made our Friday!
Update: 1 day has ticked by and [...]
Resolved: Routing complications at LINX
Dec
11th
Following from our post on the routing complications at the London Internet Exchange.
Whilst we haven’t had official word from LINX, our tests have shown correct routing to our data centre with no issues.
Once the issue is confirmed, we will update this thread.
UPDATE
More information from LINX, they diagnosed a faulty port on a core switch.
Daily LINX [...]
TradesmenQuoter
Dec
9th
Tradesmenquoter.co.uk will allow you to compare over 100,000 tradesmen to find the best and most cost effective tradesmen for your job requirements across each and every UK Town and City. We can compare the market for you within minutes and enable you to get the best local tradesmen at the best possible prices.
Sonassi modernised the [...]
Routing complications at LINX
Dec
9th
This issue should be resolved and updates are being tracked on our LINX routing post.
It seems that the London Internet Exchange (LINX) are currently experiencing problems. Our connections to LINX are no longer carrying traffic and this is having an impact on some clients who would normally cross LINX to reach us. We do not [...]