Page 1 of 1

Changing order of files on downloads page

Posted: Mon Sep 27, 2010 9:14 am
by cartcreative
Hi all

I'm using v 1.4.9.1.

I'm setting up a music downloads store for a client. Each of their products has around 10 downloadable files. I've named each of these as follows:

01-trackname
02-trackname
03-trackname

etc.

I would have expected them to appear in this order on the account's downloads page, but this isn't the case! They don't appear in any logical order at all - track 3 might appear first, then track 10, then track 1....

To make matters worse, if you purchase multiple products, then go to the downloads page, the files for each product are all jumbled up together. Its very confusing, and the customer wouldn't necessarily know which track belonged to which product, particularly as the product name doesn't get displayed with the file.

Is there a way to organise the files on the download page, so they are clearly separated into individual products, and sorted by file name? A way to display the product name with the file would be a definite bonus!

If anyone can help with this, I'd really appreciate it. :)

Thanks!

Re: Changing order of files on downloads page

Posted: Mon Sep 27, 2010 12:19 pm
by cartcreative
It seems like OC orders the downloads on the page by date added, which may make sense for some stores, but not the one I'm working on.

I've managed to change it so it orders first by order ID, then by filename. So the latest orders will appear first, and then all the tracks will get listed in numerical order.

If anyone is interested in doing the same, open catalog/model/download.php and change this:

ORDER BY o.date_added DESC LIMIT

to this:

ORDER BY o.order_id DESC, od.filename ASC LIMIT

I still haven't figured out how to group the downloads by product, or at least to display the product name with each download file. So if anyone knows how to do this, I'd love to hear from you!