1. 
   calicosun2
   New Member

   Hi

   Is there anyone out there that can tell me how to do this? Please. I really need help with this. It is imperative that the categories and products are ordered in a specific way. I have tried changing the order from name to id in the category.functions.php file but this doesn't seem to be working. I have tried changing the order in phpMYAdmin but don't really know what I am doing there and what I have tried didn't work.

   Please can someone help me? I have been trying to get this site live for months. I am desperate.

   Posted 5 months ago #
2. 
   calicosun2
   New Member

   Is anyone able to help me? Please? I am prepared to pay for help with this if someone who knows what they are doing is able to assist.

   Posted 5 months ago #
3. 
   calicosun2
   New Member

   This topic is resolved. When I get a chance I will post the answers (again - did but they disappeared). If you do a search you will probably find them elsewhere.

   Posted 5 months ago #
4. 

   Trusted

   leewillis77
   Resident Expert

   Marked as resolved:

   Edit widgets/category_widget.28.php and find this line:

   $category_settings['order_by'] = array("column" => 'name', "direction"
   =>'asc');

   Change it to:

   $category_settings['order_by'] = array("column" => 'order', "direction"
   =>'asc');

   That should sort it I think - the categories will be ordered by whatever
   you put in the "order" field in the database.

   Posted 5 months ago #
5. 
   nexialys
   New Member

   hey, i was to post that same question...

   and i refuse the answer... sorry Lee... rofl

   there is a "order" field in the database, but no input in the categories manager to edit this setting... what is the problem here?... that would be so simple to add a new entry in the categories editor to be able to put the number here, what would it take?

   people do not have to edit their database or edit codes to make this happen, sorry.

   Posted 5 months ago #
6. 

   Trusted

   leewillis77
   Resident Expert

   calicosun2's issue is resolved. If you have a separate one (Sounds like you're looking for a feature enhancement), then feel free to open a new topic - or perhaps contact one of the many consultants to discuss your requirements:

   http://getshopped.org/resources/wp-consultants/

   Thanks

   Posted 5 months ago #
7. 
   upcycleexchange
   New Member

   Thanks...got this fixed a few versions back, but with an upgrade it was changed back I guess. I didn't edit the database files, just used the change above by lee willis. Instead of order, I changed name to id and it now lists them in the order they were created which is fine with me at this point. Thanks Lee!

   Posted 4 months ago #
8. 
   tyankee
   New Member

   i can not find the file mentioned above - widgets/category_widget.28.php - i can only find the file widgets/category_widget.php but can not find the line mentioned.. can someone please help me.. it seemed like i could reorder the products by just clicking and dragging - as it let me do this - but once i republished the order went back to the original..

   Custom Templates for WHMCS, Wordpress, LayeredPanel, Zen Cart, and more.

   Posted 3 months ago #
9. 
   upcycleexchange
   New Member

   it is in wp-content/plugins/wp-e-commerce/widgets.

   Also, this will reset with each wp ecommerce upgrade, so be sure to save the file to upload again, save this thread, or memorize the fix. Just had to redo it again after upgrading to 3.7.6.3

   Posted 3 months ago #
10. 
    GolfBravo
    New Member

    That just doesn't seem to work for me.

    I have tried both order and id tags (in $category_settings['order_by'] = array("column" => 'id', "direction" =>'asc');), but the category sort order remains the same (I have the categories numbered in the database). No idea why it doesn't work (E-commerce version 3.7.6.7, Wordpress v3.0, iBlog pro template).

    Is there another solution to the category sorting order?

    Posted 1 month ago #
11. 
    gerrywarner
    New Member

    Me neither, any help gratefully received ...

    Posted 1 month ago #

RSS feed for this topic

Reply

You must log in to post.