-
Tip: find which payment method was used for Magento orders with SQL
Today we wanted to work out which payment type had been used for a range of orders on the Ethical Shop. The quickest way I could think of was to dive into MariaDB/MySQL and issue a quesry on the sales_flat_order and sales_flat_order_payments tables for a range of orders. You can use the increment_ …
- On:
-
Magento tip: Number of products in category, subcategories of a store
I had need today of counting the total number of products in a category and all its subcategories in one of the magento stores that New Internationalist runs. It took a little while to write the code so I am putting it out there in case anyone else has the same problem. Most probably my future self. …
- On:
-
Magento tip: Set number of new products shown in CMS block
I am currently doing a redesign of the New Internationalist ethical shop’s home page. I just spent about 20 minutes trying to work out how to set the number of products that are displayed in the new products block when it is called from within a CMS page in Magento.If you’re in the …
- On:
-
Magento tip: Working on success page without having to place an order
The other day I needed to make a trivial change in the checkout page in the New iNternationalist ethical shop. I always want to visually test a page before rolling it out live. I know how easy it is to mess up the position of an angle bracket or something! Normally you can only see the checkout s …
- On:
-
Magento tip: How many and which products are in abandoned carts
I wanted to get an abandoned carts report in Magento the other day. What I wanted to see was what SKUs were in carts and how many of each SKU. A long search turned up nothing of use, so I went straight to the database and started typing SQL. In the end this is what I got and it seems reasonably c …
- On:
-
Magento Tip: Remove Breadcrumbs from Homepage
A very quick tip to add to the interwebs because my Google Fu failed to find it the other day when I needed. I wanted to remove the breadcrumbs from a single CMS page — in my case the home page (aka the front page) — in Magento. It’s rather easy to do as it turns out, but I had …
- On:
-
Tip: Upgrade Magento 1.5 from the commandline
One of the roles that I have at work is maintaining the Magento software that runs our ethical gift shop. I recently upgraded one of our Magento installs from 1.5.0.1 to 1.5.1 using the newly introduced mage commandline tool. As regular readers will know I am a bit of a CLI freak, and was happily …
- On: