Category: Magento

Fixing Magento 1 newsletter queue bug due to missing encoding in grid renderer class

In a recent Magento 1.9.3.2 project we experienced a strange behavior related to the built-in newsletter module in admin grid. When trying to add a newsletter template to the queue using the action dropdown in the admin grid the following JavaScript error showed up: Uncaught SyntaxError: Unexpected end of JSON input     at JSON.parse […]

Magento acquires RJMetrics to add Magento Analytics to portfolio

Magento recently acquired RJMetrics, a powerful cloud-based analytics solution for e-commerce merchants. RJMetrics will be added to the Magento product suite as a brand new solution called Magento Analytics. The idea behind Magento Analytics according to Magento is that it will allow non-technical business users to quickly and easily integrate with enterprise-grade data sets across a broad […]

Magento Newsletter Unsubscribe Form

One of the most missed functions in Magento 1 is a newsletter unsubscribe form. Although, by default you can generate newsletter unsubscribe links to be used for instance in newsletters sent out to subscribers there’s no nice out-of-the-box way to integrate a newsletter unsubscribe form in Magento 1. Which is why there already exist some extensions […]

Updating Magento tax rules causes code already exists error

When trying to update tax rules in Magento that have been imported by extensions such as firegento magesetup you might run into problems related to duplicate tax rule codes, e.g. “20% VAT” for both customers and retailers. By default, Magento happily accepts duplicate tax rule codes when importing them trough setup scripts. But when trying […]

New table column not updating in Magento

So you’ve added a custom column for a table, e.g. admin_user or through your custom extension’s model table. The only problem is your values are not being stored by your underlying model classes, i.e. abstractions of Mage_Core_Model_Abstract. But why you ask since Magento is supposed to automatically infer database table to model relations through Zend_Db and magic getters […]

Please agree to all the terms and conditions before placing the order redirect issue in Paypal Express Checkout and Magento

So your customers are not able to complete orders when using Paypal Express Checkout in Magento one page checkout due to “misbehaving” sales agreement checkboxes. Please agree to all the terms and conditions before placing the order. The scenario at hand is as follows: Customers select PayPal Express Checkout as checkout method (yes, it’s not a […]

Customize surcharge price logic for Phoenix Cash on Delivery Magento extension

A recent customer had the requirement to calculate cash on delivery surcharges in relation to the shipping costs. For instance, let’s say that shipping to Germany costs EUR 8 whereas customers from Austria are charged only EUR 5, unless the total order reaches a certain amount resulting in free shipping. Now the requirement in this case […]

Delete orders in Magento

When developing and testing your Magento store you will potentially create a lot of test orders. In addition, when creating/testing extensions you might need to reset order-related entries, e.g. when experiencing SQL integrity constraint violations such as SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’, query was: INSERT INTO `sales_order_tax` (`order_id`, `code`, `title`, `percent`, […]

Fix Anaraky Google Dynamic Remarkting Tag extension

By default, Anaraky Google Dynamic Remarkting Tag (“Anaraky GDRT”) does not set correct page type “other“, as described in Google’s Dynamic Remarketing guidelines. Instead, it uses “siteview“. To overcome this behavior there are only 2 simple modifications required. Required modifications for Anaraky Gdrt extension First, in app/code/community/Anaraky/Gdrt/Block/Script.php on line 51 replace siteview by other: becomes Second, in the same file […]

Set tier prices for product variants of configurable products in Magento

So you want to set tier prices for product variants of configurable products in Magento. To achieve this you create a configurable product and associate your simple product variants based on your pre-defined attributes. At this point you start setting tier prices for your associated product variants, i.e. your simple products thinking that Magento will use these values on […]

Solve “Unable to find a sitemap to generate” in Magento

In case you receive the error message Unable to find a sitemap to generate when trying to generate a Google Sitemap for an existing entry in Magento make sure to check that the sitemap ID generated is set correctly, i.e. not equal to 0 (zero). In this particular Magento 1.9.1.0 setup the ID for the first sitemap […]

Run Magento Data Flow Profile from shell

Running Magento data flow profiles for importing/exporting data is quite resource intensive and can take a while to execute for larger junks of data. Although there exist alternative ways to import/export data in Magento sometimes existing data flow profiles can’t be replaced just yet. Below you find a shell script to run Magento data flow profiles from […]