Press "Enter" to skip to content

Tag: magento

Jobs ahoy!

I know of quite a few companies currently recruiting – so if you are job hunting and think any of the following are of interest to you, please get in contact:

Leicester based
Senior Magento Developer
Senior Digital Designer
WordPress Developer
Account Manager

London based
Account Manager
Big Data Engineer
DevOps Engineer / Big Data SysAdmin
Machine Learning Specialist
Partnership Development Manager?

Guidford based
Sales Executive
DevOps Engineer
Python Software Developer
Systems Administrator

Brighton based
Java Developer
Head of User Experience and Design (UI / UX)
Senior Designer/UI Developer
Accountant
Senior Accountant
Trainee Account Manager (Finance Industry)
Outbound Sales Advisor

UK (contract/remote work)
WordPress Developer (up to £30/per hour)
Senior WordPress Developer (up to £45/per hour)
Symfony Developer

Magento: Class Zend_log not found in GoMage Lightcheckout Help file

Do you receive an error message such as:

Fatal error: Class 'Zend_Log' not found in /.../app/code/local/GoMage/Checkout/Block/Adminhtml/System/Config/Fieldset/Help.php on line 48

when running the GoMage Lightcheckout v3.1 plugin for Magento? If so, it’s a quick fix: just open up that file and remove the section:

protected function _getFieldsetCss()
{
$configCss = (string)$this->getGroup()->fieldset_css;
return 'config collapseable'.($configCss ? ' ' . $configCss : '');
}

and your Magento ecommerce shop should start working! (Basically, in a recent version of Magento CE – version 1.7.0.2 or before – that method was set as “protected” in Mage_Adminhtml_Block_System_Config_Form_Fieldset and so the child class GoMage_Checkout_Block_Adminhtml_System_Config_Fieldset_Help was not able to redeclare it).

Magento: Associating customer accounts

If you run a Magento e-commerce store, you may occasionally find existing customers placing orders without being logged into their account. This isn’t a problem usually, unless the customer is one of those vary rare ones which actually logs into the customer frontend to track/check their order(s). If they weren’t logged in, they won’t see the ecommerce order.

So how do you fix this? Well, there is a Magneto module available to do this, but (as is increasingly common in the Magento world) it costs $99. Or there is my way which is free and requests two SQL statements:

UPDATE sales_flat_order, customer_entity
SET sales_flat_order.customer_id=customer_entity.entity_id
WHERE
sales_flat_order.customer_email=customer_entity.email

UPDATE sales_flat_order_grid,sales_flat_order
SET sales_flat_order_grid.customer_id=sales_flat_order.customer_id
WHERE
sales_flat_order_grid.increment_id=sales_flat_order.increment_id

Done.

PHP: Magento – current stock value

If you run the Magento ecommerce shopping cart software and you want to find out how much your stock is worth, how many product lines you have stocked and how many individual items you have, you may find the following MySQL query handy.

I’m assuming that you’ve created an attribute with the attribute code “supplier_price” as a decimal, that you’ve kept this field up to date and your stock levels are accurate 😀 If it isn’t called “supplier_price” change the appropriate part in the query.

SELECT
COUNT(sku) AS 'products_stocked',
SUM(qty) AS 'items_in_stock',
SUM(stockvalue) AS 'stock_value'
FROM (

SELECT
catalog_product_entity.sku,
cataloginventory_stock_item.qty,
catalog_product_entity_decimal.value,
(cataloginventory_stock_item.qty * catalog_product_entity_decimal.value) AS stockvalue
FROM
cataloginventory_stock_item,
catalog_product_entity,
eav_attribute,
catalog_product_entity_decimal
WHERE
catalog_product_entity.type_id='simple' AND
cataloginventory_stock_item.product_id=catalog_product_entity.entity_id AND
catalog_product_entity_decimal.entity_id=catalog_product_entity.entity_id AND
eav_attribute.attribute_id=catalog_product_entity_decimal.attribute_id AND
eav_attribute.attribute_code='supplier_price' AND
cataloginventory_stock_item.qty > 0
ORDER BY sku ASC) AS b

Book Review: php|architect’s Guide to E-commerce Programming with Magento

I’ve decided to switch the back end of my side-line e-commerce dance wear and leisure wear clothing site from ClickCartPro to Magento. Why? Well, Magento is cheaper (moot point as I’ve already brought the licence for ClickCartPro), Open Source (so’s ClickCartPro), is more flexible (so it seems), has more options and it’s another shopping cart system for me to learn and have experience with (plus it does seem to be growing in popularity quite a bit).

However, the switch has come with a price: it’s quite a complex bit of kit! So, since Waterstones had an offer on and I needed to buy some other books I purchased php|architect’s Guide To E-Commerce Programming with Magento from them (Waterstones’ price is £19.99 and Amazon’s is £18.99: both with free shipping. It’s also available as a PDF for $29.99 from the publisher’s site). Why did I buy this book? Well, it was the only Magento book Waterstones (or Amazon) had!