Category: E-Commerce

Performance 0

Using Command Query Responsibility Segregation to speed up data-driven web applications

Typical web applications spend most of their time reading data from a data storage (i.e. a database) which is then processed and converted to HTML for the desired frontend visualization. Furthermore, when relying on programming languages such as PHP that are essentially based on the “shared nothing principle” the performance...

Magento Logo 0

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...

Magento Logo 4

Sample SEO Magento robots.txt file

Since I get a lot of requests for a robots.txt file designed for Magento SEO here is a sample to get you started. This Magento robots.txt makes the following assumptions: We don’t differentiate between search engines, hence User-agent: * We allow assets to be crawled i.e. images, CSS and JavaScript files...

Magento Logo 0

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...

Magento Logo 0

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...

Magento Logo 0

Delete orders in Magento using a shell script

In a recent post I’ve shown the steps required to delete orders in Magento using a couple of SQL queries. Since this is a common issue when switching from development to staging and finally to production ennvironments it would be handy to have a shell script that takes care of...

Magento Logo 0

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...

Magento Logo 1

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...

Magento Logo 4

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...

Magento Logo 4

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...

Magento Logo 9

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...