artweek Posted April 21, 2007 Share Posted April 21, 2007 Ok when uploading items, it is done A-Z i want it to be down in a Z-A order please could someone show me thanks. Link to comment Share on other sites More sharing options...
evalguy Posted April 21, 2007 Share Posted April 21, 2007 Where are you talking about "uploading". Some more specifics might help. Link to comment Share on other sites More sharing options...
artweek Posted April 21, 2007 Author Share Posted April 21, 2007 When uploading products into a catagorie. They are in alphabetical order from A ont he first page to z on the last. What i want is z on the first and A on the last thanks. Link to comment Share on other sites More sharing options...
artweek Posted April 21, 2007 Author Share Posted April 21, 2007 anyone need this urgent thanks Link to comment Share on other sites More sharing options...
histcloth Posted April 21, 2007 Share Posted April 21, 2007 I would also be interested in this. We are trying to enter sizes and now matter what sequence we enter the sizes in, they do not come out in the order we want. Â If this is related, I would welcome the reply. Â NJ Sekela Link to comment Share on other sites More sharing options...
♥FWR Media Posted April 21, 2007 Share Posted April 21, 2007 You are not being specific enough so All i can do is suggest you learn up on php array sort fuctions. Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls  KissMT Dynamic SEO Meta & Canonical Header Tags  KissER Error Handling and Debugging  KissIT Image Thumbnailer  Security Pro - Querystring protection against hackers ( a KISS contribution )  If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
artweek Posted April 21, 2007 Author Share Posted April 21, 2007 When adding alot of content to a catagorie say there will be 6 pages of content on the 6th page the z items will be listed and the A items will be on the first i would like to swap the order of items. thanks Link to comment Share on other sites More sharing options...
artweek Posted April 21, 2007 Author Share Posted April 21, 2007 double post* Link to comment Share on other sites More sharing options...
artweek Posted April 21, 2007 Author Share Posted April 21, 2007 woops* Link to comment Share on other sites More sharing options...
evalguy Posted April 21, 2007 Share Posted April 21, 2007 So let me see if I understand this. Under the admin tool, you are browsing all the products in a category. You see the list of products starting from A... towards Z. and you want it in the reverse order, right? Â If so, there are 2 ways I can think of to change this... find the code the selects the rows for this category and after that, use a php sort function to sort it the way you want it. Another way is to change the SQL SELECT statement and let it sort when retrieving those rows. SQL's SELECT statement has a parameter called "ORDER BY <column_name> DESC" which you can use to tell it to sort by that column and DESC tells it to go in reverse order. Â It should not be difficult, but you will need to search through the code to find the correct location for this, then look at the mySql manual to get the correct syntax of the ORDER BY parameter. Of course, backup everything just in case. Â -Neil. Link to comment Share on other sites More sharing options...
♥FWR Media Posted April 21, 2007 Share Posted April 21, 2007 Spot on .. Presuming that it was not DESC to start Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls  KissMT Dynamic SEO Meta & Canonical Header Tags  KissER Error Handling and Debugging  KissIT Image Thumbnailer  Security Pro - Querystring protection against hackers ( a KISS contribution )  If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
artweek Posted April 21, 2007 Author Share Posted April 21, 2007 could use explain ths in a form of step-by-step its just im not to good at sql and things like that so would be really helpfull thankyou. Link to comment Share on other sites More sharing options...
artweek Posted April 22, 2007 Author Share Posted April 22, 2007 bump sorry for bumpin just need help quickly thanks Link to comment Share on other sites More sharing options...
dittones Posted April 22, 2007 Share Posted April 22, 2007 Shane, You can control the order of category and product by a field Sort Order: field in both the categories and product setup. The order relationship is 1 thru ...nnnnn which gives and ascending sequence...Starting with a larger number gives a decending order.... I hope this helps Roman dittone.com Link to comment Share on other sites More sharing options...
evalguy Posted April 23, 2007 Share Posted April 23, 2007 could use explain ths in a form of step-by-step its just im not to good at sql and things like that so would be really helpfull thankyou. Â I've not done this before, so I don't have a step-by-step. But the code you want should be in the file catalog/admin/categories.php . I cannot even test anything here since my site is now live. If you are not familiar with this, I suggest asking one of the better coders on here. Â BTW, since this is an on the admin side, why is it so urgent? Link to comment Share on other sites More sharing options...
artweek Posted April 23, 2007 Author Share Posted April 23, 2007 Link to comment Share on other sites More sharing options...
artweek Posted April 24, 2007 Author Share Posted April 24, 2007 bump again thanks for hte help so far people :) Link to comment Share on other sites More sharing options...
thecandlespastore Posted April 28, 2007 Share Posted April 28, 2007 How about getting the options values in alphabetical order? Always grateful for any help received!! Link to comment Share on other sites More sharing options...
artweek Posted September 24, 2007 Author Share Posted September 24, 2007 gonna give this a bump as i enver got it sorted! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.