uc_catalog needs products ordered by nid.

Posts: 163
Joined: 08/07/2007
Uber DonorBug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.Not Kulvik

We have a number of herbs that come in separate forms. They come in cut, chopped and powdered form. since they have the same title, they sort inline but the various forms of the herb show up in random order. This is no big deal unless the herb also falls on a pager boundary. We have that case, OF COURSE!!! Smiling

Anyway, the fix we use is to change the line 894 of uc_catalog so it looks like this:

<?php


if (empty($_REQUEST))) {
  
$order = 'p.ordering, n.title, n.nid';
...
etc. ...
?>

The addition of n.nid forces the products with same title to always sort in the same order and therefore always appear in the same place as you traverse the pager boundary.

Steve

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Hah, interesting issue... I'm glad we're open source. We'd never find this stuff. Laughing out loud

Anyways, bookmarking this and will nail it when we're back in the office on Monday.

Posts: 5367
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Committed the fix.