Guest Posted September 20, 2005 Share Posted September 20, 2005 Take a look at: http://www.klassiekegeuren.nl and click one of my categories. The products in the subcategories are not alphabetical sorted? Who can help me please? Greetings, Hugo ( sorry for my bad english ! ) Quote Link to comment Share on other sites More sharing options...
Guest Posted September 20, 2005 Share Posted September 20, 2005 Unless the German alphabet uses some strange order that I'm not aware of, they are in alphabetical order. :on2long: Quote Link to comment Share on other sites More sharing options...
Guest Posted September 20, 2005 Share Posted September 20, 2005 I`m sorry, i mean http://www.klassiekegeuren.nl/parfums/ please can somebody help me out? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 20, 2005 Share Posted September 20, 2005 Right now they're simply in the order they were inserted into the database. You'll have to specify the sort order if you want them listed differently. Quote Link to comment Share on other sites More sharing options...
Guest Posted September 20, 2005 Share Posted September 20, 2005 Is it not possible to, let the computer do his work, and sort it out for me? Quote Link to comment Share on other sites More sharing options...
Guest chrismaber Posted October 12, 2005 Share Posted October 12, 2005 Is it not possible to, let the computer do his work, and sort it out for me? I have the same problem. How do I sort the SubCategories in to Alaphabetical order? I am guessing it is in the viewCat.inc.php page but am unsure where and what to script to insert. The table I believe needed to be queried is CubeCart_inventory and the field name is productCode. I guess I have to insert something like "ORDER BY productCode ASC" but do not know where to insert. Could somebody please help. :w00t: Quote Link to comment Share on other sites More sharing options...
Guest Ija Posted October 12, 2005 Share Posted October 12, 2005 Hmm this is quite an easy fix Open /includes/contents/viewCat.inc.php Find somewhere @ line 158 $productListQuery = "SELECT ".$glob['dbprefix']."CubeCart_cats_idx.cat_id, ".$glob['dbprefix']."CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM ".$glob['dbprefix']."CubeCart_cats_idx INNER JOIN ".$glob['dbprefix']."CubeCart_inventory ON ".$glob['dbprefix']."CubeCart_cats_idx.productId = ".$glob['dbprefix']."CubeCart_inventory.productId WHERE ".$glob['dbprefix']."CubeCart_cats_idx.cat_id = ".$db->mySQLSafe($_GET['catId']); Replace it with $productListQuery = "SELECT ".$glob['dbprefix']."CubeCart_cats_idx.cat_id, ".$glob['dbprefix']."CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM ".$glob['dbprefix']."CubeCart_cats_idx INNER JOIN ".$glob['dbprefix']."CubeCart_inventory ON ".$glob['dbprefix']."CubeCart_cats_idx.productId = ".$glob['dbprefix']."CubeCart_inventory.productId WHERE ".$glob['dbprefix']."CubeCart_cats_idx.cat_id = ".$db->mySQLSafe($_GET['catId'])." ORDER BY name ASC"; :w00t: Quote Link to comment Share on other sites More sharing options...
Guest chrismaber Posted October 12, 2005 Share Posted October 12, 2005 Great, Thanks very much that worked. Really aprreciated. Chris :D Quote Link to comment Share on other sites More sharing options...
Guest vrakas Posted November 11, 2005 Share Posted November 11, 2005 It worked for me also :P Quote Link to comment Share on other sites More sharing options...
Guest Posted April 16, 2006 Share Posted April 16, 2006 :) Whew... Glad I found this little fix. Now my product listings are looking much better sorted! Quote Link to comment Share on other sites More sharing options...
Guest Posted April 18, 2006 Share Posted April 18, 2006 As a side note, many people asked for this mod in the previous versions of CC...Why dont they just include this (among other "really asked for" mods) in the default version? I recall using the CC ver 2.x.x and they were asking for this left and right. Quote Link to comment Share on other sites More sharing options...
Guest steve_ Posted April 19, 2006 Share Posted April 19, 2006 because then they can't sell it to you if they give it away Quote Link to comment Share on other sites More sharing options...
Guest mitrenga Posted April 19, 2006 Share Posted April 19, 2006 Thanks, work just great! ;) Quote Link to comment Share on other sites More sharing options...
Guest groovejuice Posted April 19, 2006 Share Posted April 19, 2006 That's a bitter and cynical comment @_steve; not to mention just plain wrong. In actuality there are many free mods and fixes available. The vast majority of people who sell mods for CubeCart offer excellent products for a very reasonable price and typically provide support as well. These very same people are the ones who voluntarily (for no remuneration whatsoever) spend hours assisting users on this forum, many of whom don't bother to hunt in the archives or use the search function. Quote Link to comment Share on other sites More sharing options...
Guest ilsesthings Posted May 30, 2006 Share Posted May 30, 2006 Right now they're simply in the order they were inserted into the database. You'll have to specify the sort order if you want them listed differently. Sir William, Fate reunites us, I see! I'd love to specify the order of the subcategories, and not necessarily by alphabetical order. Where would I do this and how? Thanks so much! ilse www.ilsesthings.com Quote Link to comment Share on other sites More sharing options...
Guest illusen Posted May 30, 2006 Share Posted May 30, 2006 Right now they're simply in the order they were inserted into the database. You'll have to specify the sort order if you want them listed differently. Sir William, Fate reunites us, I see! I'd love to specify the order of the subcategories, and not necessarily by alphabetical order. Where would I do this and how? Thanks so much! ilse www.ilsesthings.com I also want to sort them but not in alpha order. is it a case of adding the sub cats in order that I want them? If so it's a bit of a long way round as I'll be adding more sub cats later.... Anyone know of any mods for this? Many thanks! Quote Link to comment Share on other sites More sharing options...
Guest mediajunk Posted November 8, 2006 Share Posted November 8, 2006 Thanks Ija, works great! Quote Link to comment Share on other sites More sharing options...
Guest Posted November 12, 2006 Share Posted November 12, 2006 many thanks - just next to figure out how to get rid of the sub-cat numbers ie "subcat (0)" - the qty bit......searching to be done i suppose */* Quote Link to comment Share on other sites More sharing options...
Guest Hermitcrab Posted November 21, 2006 Share Posted November 21, 2006 I'd also like to be able to manually sort subcategories. Can this be done? Quote Link to comment Share on other sites More sharing options...
Guest jamez Posted November 26, 2006 Share Posted November 26, 2006 I'd also like to be able to manually sort subcategories. Can this be done? Yes i have done this in my site. What i did was put spaces at the front of the category names. The more spaces infront the higher up the page your category will apprear (and the spaces dont show up in your shopping cart). Hope this helps. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 20, 2007 Share Posted August 20, 2007 Can the products be sorted in price order? (cheapest first?) Quote Link to comment Share on other sites More sharing options...
Guest livvving Posted August 21, 2008 Share Posted August 21, 2008 PERFECT! Many thanks for this easy fix. Quote Link to comment Share on other sites More sharing options...
Guest speckled Posted November 29, 2009 Share Posted November 29, 2009 is it possible to create a list for your subcategories instead of a folder icon, as it was for the categories? I have that info saved, and I can't find where to create a list for your subcategories. Thanks, Nancie Quote Link to comment Share on other sites More sharing options...
Guest speckled Posted November 29, 2009 Share Posted November 29, 2009 finally got it figured out Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.