Category: Frameworks

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 […]

Setting up Varnish caching server for pd-admin with Apache and php-fcgi

Deploying Varnish caching server can significantly speed up web-based applications, as well as simple websites. Varnish supports different back-end systems, ranging from the popular Apache web server to the more efficient nginx. Especially when it comes to handling high traffic sites Varnish can bring a considerable uplift to the responsiveness by e.g. caching entire pages […]

How to solve “550 sorry, user unknown” problem when using pd-admin

Recently, a client reported problems when trying to send mail to certain domains hosted on their own web server. The web server in question was running pd-admin as administration tool set. Mail hosting was done on a separate dedicated mail server. The error message reported by the client was the infamous 550 sorry, user unknown Checking […]

Remote deployment script for Magento extensions using modman and rsync

In order to have an efficient way of deploying Magento extensions to (remote) Magento setups I’ve created a simple deployment script based on modman and rsync. How it works This script copies your Magento extension to the .modman directory of your destination Magento project and deploys it there using modman. In addition, it exludes files and […]

WordPress Simple Latest Posts Shortcode Plugin

Although there exist numerous WordPress plugins for integrating the latest posts into pages this new Simple Latest Posts Shortcode Plugin was created to specifically serve those people who just want to have a single line of shortcode in order to display the latest posts in their blog. Nothing more, nothing less. And yes, there also will […]

Install PHP intl extension using Homebrew on XAMPP

Recently, when trying to install the PHP intl extension for a Symfony2 based web project using Homebrew to following error message kept showing up: /usr/local/bin/brew: /usr/local/Library/brew.rb: /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby: bad interpreter: No such file or directory /usr/local/bin/brew: line 23: /usr/local/Library/brew.rb: Undefined error: 0 This post steps explains what is needed to install PHP intl extension using Homebrew on […]