Archive for January, 2010
Mass update stock levels in Magento – FAST
Jan
31st
This isn’t ground-breaking code, but rather just using some core code in a rather stripped out manner. As we’re not big fans of Magento data flow here, we perform most of our stock and catalogue updates using external scripts to Mage::app. We have been trickling elements of these out to the wider world so you [...]
FAQs
Jan
27th
What is the maximum email attachment size?
The maximum attachment size is currently 10MB.
What are the name servers to use for theclientarea.info DNS?
Please see http://www.sonassi.com/knowledge-base/sonassi-name-server-access/
How can I create a subdomain?
Simply create a new folder in the relevant directory.
/domains/example.com/subdomains/mynewsubdomain
Free Magento and Wordpress integration …
Jan
27th
This offer has now expired.
… for our SonassiHosting customers
As a gesture of goodwill – for the first 10 customers to drop us an email, we are willing to install our Magento Wordpress extension FREE OF CHARGE.
We’ll even theme it a little where neccessary.
We are going to try and continue the trend by offering exciting free [...]
Display Attributes on Invoice or Packing Slip in Magento
Jan
22nd
Add this to Mage/Sales/Model/Order/Pdf/Items/Invoice/Default.php, replace ATTRNAME as appropriate.
public function draw()
{
...
$product = Mage::getModel('catalog/product')->loadByAttribute('sku', $this->getSku($item), array('ATTRNAME'));
if ($product) {
$lines[0][] = array(
[...]
Wordpress and Magento integration extension
Jan
22nd
This extension has now been replaced by the far superior deluxe edition. It is still available for download, but we recommend using the deluxe edition.
We’re not trying to re-invent the wheel here, nor are we going into any depth of connecting the authentication modules. From a front-end standpoint, the two “elements” wordpress and magento are [...]
Cleanly delete all categories in Magento
Jan
22nd
If you have been working on a demo store – or yours is still in the early stages of construction, you will probably find it necessary to remove all the categories to start fresh at some point.
Thanks to CasualCommerce, there is a pretty straightforward MySQL “script” to clear out the tables and start fresh.
[...]
Service Interrupted: 21st January 2010 14:53 > 15:28
Jan
21st
At 14:53 a thread locked on our main front-end node, this rendered all servers behind it inaccessible.
After the system was deemed non-responsive, the system was immediately power cycled (restarted) – upon bringing the system back on line, as a matter of course, we felt it necessary to perform a file system check to verify [...]
Fast bulk product status change with Magento
Jan
18th
If you have a large catalogue, using some standard features are simply impractical to use. Recently, we needed to disable an entire range of products based on its SKU – via the backend, bulk status changing 5000 products will take hours, but fortunately SQL is a spot more lightweight.
In the code below (to be run [...]
Speed up Magento, product import, export and general via the database
Jan
18th
If your Magento product imports and exports certainly aren’t as speedy as they used to be, it could be that the database table is just filling up with old records. There are a few to look at.
dataflow_batch_import
dataflow_batch_export
log_url
log_url_info
log_visitor
log_visitor_info
The dataflow records can be quickly emptied:
truncate table dataflow_batch_import;
truncate table dataflow_batch_export;
For your logs – I would suggest you correctly [...]
Would you like some Twitter with your Google results sir?
Jan
13th
Whilst its not breaking news – its the beginning of results starting to affect our day to day running and blog-worthy!
From the Google blog:
“
Given this new type of information and its value to search, we are very excited to announce that we have reached an agreement with Twitter to include their updates in our search [...]