-
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:
-
MySQL tip: Counting total number of rows even when LIMIT is set
Pagination is a pain in the arse, right? That's one of the lovely things about using an ORM or something to do it for you. But that isn't always possible, so at some point you'll need to use a LIMIT on your select. Now, MySQL has a nice little feature called SQL_CALC_FOUND_ROWS which puts the num …
- On:
-
SQL tip: Most Popular Pages This Week with Piwik
Just a quick update today. I want to make myself a little most popular pages this week for the front page of this site. Now, I am using the lovely Piwik Analytics tool to monitor the site. So I first looked at the Piwik API. That should be the way to do it right? Not quite. The Actions plugin can …
- On: