VirtueMart Forum

VirtueMart Dev/Coding Central: VM1 (old version) => Virtuemart 1.1 Development (Archiv) => Quality & Testing VirtueMart 1.1.x => Topic started by: jjk on June 19, 2008, 19:42:14 PM

Title: Sorting items doesn't work
Post by: jjk on June 19, 2008, 19:42:14 PM
If I click on "item information", the item list on my system is loaded initially without the sort arrows and sort input fields. They only show up after selecting a category, but neither the arrows nor using the sort input fields with numbers reorders the list.

Just tried to find a workaround playing with the sample product "Ladder", but with no success. Actually, I was looking for the possibility to reorder items displayed in the frontend - items sort order in the backend is less important to me - having both would be nice.

Best Regards

Joerg


VM 1.1 nightly 1422
PHP Built on:       Windows NT RED 5.0 build 2195
Database Version:    5.0.51a
Database Collation:    latin1_swedish_ci
PHP Version:    5.2.5
Web Server:    Apache/2.2.8 (Win32) DAV/2 mod_ssl/2.2.8 OpenSSL/0.9.8g mod_autoindex_color PHP/5.2.5
Web Server to PHP interface:    apache2handler
Joomla! Version:    Joomla! 1.5.3 Production/Stable [ Vahi ] 22-April-2008 22:00 GMT
User Agent:    Mozilla/5.0 (Windows; U; Windows NT 5.0; de; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
Title: Re: Sorting items doesn't work
Post by: aussieute on June 22, 2008, 06:24:46 AM
I'm with you

In the product list the products are in the correct order
Product ID's are correct .. I have them going up in price
In the public section view they are incorrect.

Most disconcerting

Title: Re: Sorting items doesn't work
Post by: cassidyb on July 09, 2008, 02:35:25 AM
I am getting this same issue.  I can not sort the items at all.

VM 1.1.1 Joomla 1.5.2
Title: Re: Sorting items doesn't work
Post by: aravot on July 09, 2008, 20:29:55 PM
@jjk, can you try build 1460, tired it, worked for me.
Title: Re: Sorting items doesn't work
Post by: jjk on July 09, 2008, 23:04:59 PM
Peter,

just had a look at this with build 1456. Problem didn't disappar with this one (my original post was using build 1422).

You seem to be a little ahead  ;)- the lastest build I can find is still 1456 from VirtueMart.net - Developer Developer Portal - Nightly Builds.

Where do I get 1460? Just downloaded the files from the SourceForge SVN Trunk (haven't done so the last 6 months or more) and that one tells me it is build 1041! - so I suppose the files at SourceForge are outdated.

Title: Re: Sorting items doesn't work
Post by: aravot on July 09, 2008, 23:11:38 PM
SVN access info http://dev.virtuemart.net/cb/wiki/1363
Title: Re: Sorting items doesn't work
Post by: jjk on July 10, 2008, 14:56:13 PM
Updated to build 1465, but no change concerning sorting an item list.

Just to make shure we are talking about the same thing - sorting the product list within a category works fine. What doesn't work is sorting the Item List after clicking on "Item Information" of  a product.
BTW - in this build VM doesn't tell me anymore when I'm looking at an Item List while in simple layout. Instead it just says Product List, which might be confusing for the user. See screenshots below.

The reason I stumbled about this sorting problem is that I would like to sort the items according to  price in the "Add to Cart" container after adding another item.

Additional question:
After adding new products, the sort order field always shows a default value of 1 for all new products. Is this "by design" or is it a bug?

Joerg

[attachment cleanup by admin]
Title: Re: Sorting items doesn't work
Post by: aravot on July 10, 2008, 18:44:51 PM
Now I get it "Item Information" = "Child product", sort ordering is only for main category, for now decide how you want child products to show on frontend and enter it in that order.
Title: Re: Sorting items doesn't work
Post by: jjk on July 10, 2008, 18:57:11 PM
Sorry - my fault. I should have written "sorting Child Products (Items)" to be clear.  :-[
Title: Re: Sorting items doesn't work
Post by: amie on July 12, 2008, 07:03:38 AM
Im having same trouble with the arrows for custom ordering of products not working. On creation of new product no order value is set.  You can type in the order numbers and hit save but if you then later hit one of the arrows it screws up the whole list order you just manually typed in.  Will there be a fix for the ordering arrows not working?

Oh - I have Joomla 1.5, VirtueMart 1.1.1 (nightly build from 11 June)
Title: Re: Sorting items doesn't work
Post by: jjk on July 12, 2008, 10:45:06 AM
Quote from: amie on July 12, 2008, 07:03:38 AM
  Will there be a fix for the ordering arrows not working?

I suppose there will, but probably this does not have a high priority tag - so I assume we will have to wait for a while to see a fix.  :D
Title: Re: Sorting items doesn't work
Post by: RolandD on October 06, 2008, 07:31:19 AM
I know why it happens. VM assumes there is an entry for each product in the #__vm_product_category_xref table. When saving it does an update of the record. However, there is no record available so the update is simply ignored by the database. Thus leaving your order not set.

I could not find this bug reported in the bug tracker, so I have done so: http://dev.virtuemart.net/cb/issue/2395
Title: Re: Sorting items doesn't work
Post by: buddyq on June 28, 2010, 18:55:51 PM
Hey let's put a bump on this topic. This is still a huge issue. Is VM even being updated anymore?
Title: Re: Sorting items doesn't work
Post by: lrawling on June 28, 2010, 23:54:12 PM
Hi buddyq,

In your Site Configuration (Admin | Configuration, Site tab), select Default from the Default product sort order field. Now your selected sort order for your products should be recognised in the front end. It seems the default is set to Product Name which will over-write your Item Order. This is my understanding anyway and always happy to be corrected!

Cheers,

Title: Re: Sorting items doesn't work
Post by: dick.read on September 05, 2010, 22:00:36 PM
Having same problem here, using up/down arrows does not work. Entering a numbered order in the boxes and saving does not work. The display order seeems to be related to the Item ID as some product - items do display in the required order in the frontend. Has anyone found and answer to this yet??