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