Sorting the Customer Table (Admin in osCommerce)

By | August 25, 2008

If your shop is like mine, you have lots of customers, which is a good thing. However, the customers screen in the admin could be better. So what I have come up with is a new way to sort the customers table…in fact it’s an old way, but using 2008 technology instead of hard coded links…

Have a look at this video of it in action (in my testshop, not my real shop!):

Pretty sweet. I added an extra column in my customers table called ID as I find it useful to know the ID’s of my customers. That’s the only difference to most other osCommerce Stores. I can sort ascendingly or descendingly on ID, First Name, Last Name or Date Account Created – which is going to make my admin tasks much easier.

Years back, I made the same thing but using hard coded links to refresh the page (thereby pulling in the data needed), that contribution is still available as far as I know. This new way of sorting does the same but without a page refresh!

So, just how is it done?

Easy answer – using javascript. I took jQuery and the TableSorter plugin – then I recoded a portion of the customers.php page to add the necessary variable to make it all work.

Leave a Reply

Your email address will not be published. Required fields are marked *