Product Sequencing - How to get it to Work?

[Rich]

We have a marketplace site that pulls all of our products from our Commerce
Server 2007 Enterprise Edition catalog.

Problem is that no matter how we sequence the products in the catalog, it
doesn't translate to the site.

We have looked at the code and stored procs and there is nothing
specifically telling the products how to sequence/sort. Right now they are
being sequenced/show in in the web site by the product ID in the catalog
(lowest to highest), although it's not really using the product ID, it's
simply going off the next line/row entered into the database table.

So my question is, is there a configuration in Commerce Server 2007 that we
have to turn on to tell it to sort the products out in the site by using the
sequence column? I would think it would sort using the sequence column by
default, but we don't see anything that's doing that.

Or, do we have to change our stored procs to specifically tell it to sort
using that sequence column? I wouldn't think you would have to do that given
the sequencing is built into commerce server. I would think there would be
some default way it would order by

Thanks much!

[Muhammad Usman]

I am facing the same issue. I have sequenced the categories but they are not
appearing on web page as are expected. I am using runtime mode of
programming. Could anybody help me, how could this sequencing feature be used
in runtime mode