Working with tier prices programmatically in Magento is somewhat tricky. I found a couple of annoying bugs or behaviors that really got me stuck. I’ll speak about that at the end of this post. Update: Our colleague Josh found how to solve this issue by rewriting a core module. Take a look at that solution in […]
Some things are easy, some things are not. This one is easy-peasy. If you want to get the product list that a customer has been subscribed to (price or stock alert), you need to use the productalert model. Product stock alert list Product price alert list
Here are a few tips to take into account if you want to start developing with Magento.
I was looking for a code in order to create category attributes in Magento and found a post from Mukesh Chapagain where he explains in a really easy way how to do so. But it didn’t work for me. I’m supposing that the problem is the way how we call the installer in the mysql […]
Last days I developed a extension for Magento that basically lets a customer change their session and log in as another customer. It’s not really very complicated, what this extension does is the following: Creates a new customer field where shop administrators have to add the ID of those customers that the particular customer is […]
I’ve upgraded a couple of Magento CE (1.4) to Magento EE (1.11) using the traditional (and effective) way. But I found that there was an important issue when reindexing prices that prevented Magento from doing it.
Reading this post on Magento Boards I found that the problem (in my case) was related to an error with the catalog_product_entity_tier_price table where some of the entries were related to products that didn’t exist anymore. This was the actual error and when trying to reindex product prices, Magento would throw this message:
The current project I’m working on has something special: each client has its own price, but this price is not in Magento but in an Oracle DB. Every client on the website has a client id related to the Oracle DB, and in the Oracle DB there is a discount that is different for each […]
Upgrading Magento is a tricky task. Even though the process is somewhat easy, when you find errors that they are not always easy to solve. One of these errors is the 1025 mysql error. This error is related to foreign keys checks. There is no easy way to solve it. You can try modifying the […]
If you prefer to use an extension to add a «Delete» option on the orders list, see the Seamless Delete Order extension. But if you want to do it by your own using the Magento functions, it’s quite easy. Just use something like this (this function would delete all orders, so don’t apply it directly!):