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!