chrometweaks.org

Do you like iPage.com for registering a domain name?

Click Here To View All Answers...


Got a question... Do you like iPage.com for registering a domain name? Hoping for any answer or 2. My other question... I am working with a client right now who would like products in categories to show up in a specific order. I have experimented with the Sort Order option and various ways of inputting products but no matter what I try, OSC orders the products the way it wants to. This is making me very mad. Is there a way around all this so products will STAY in the order in which I input them?..

Comments (68)

I'm stumped. I'm not so sure what is the right answer to your question. I'll do some investigation and get back to you if I find an anything. You should email the people at iPage as they probably could answer your iPage question..

Comment #1

After you click a link in the categories infobox, the products that are displayed there are in the wrong order..

I entered them into the catalog the way I wanted them but now they're even wrong in the catalog admin...

Comment #2

Most of the osc is setup to alphabetic descending..

Comment #3

There's no way to break that and order them manually? Damn.....

Comment #4

I was just buying myself some time with a snipet of info.

Backup your catalog/index.php then in the catalog/index.php locate this code.

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from "TABLE_CATEGORIES" c, "TABLE_CATEGORIES_DESCRIPTION" cd where c.parent_id = '"(int)$category_links[$i]"' and c.categories_id = cd.categories_id and cd.language_id = '"(int)$languages_id"' order by sort_order, cd.categories_name");.

Break; // we've found the deepest category the customer is in.

}.

}.

} else {.

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from "TABLE_CATEGORIES" c, "TABLE_CATEGORIES_DESCRIPTION" cd where c.parent_id = '"(int)$current_category_id"' and c.categories_id = cd.categories_id and cd.language_id = '"(int)$languages_id"' order by sort_order, cd.categories_name");.

And change it to this.

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from "TABLE_CATEGORIES" c, "TABLE_CATEGORIES_DESCRIPTION" cd where c.parent_id = '"(int)$category_links[$i]"' and c.categories_id = cd.categories_id and cd.language_id = '"(int)$languages_id"' order by sort_order, cd.categories_id");.

Break; // we've found the deepest category the customer is in.

}.

}.

} else {.

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from "TABLE_CATEGORIES" c, "TABLE_CATEGORIES_DESCRIPTION" cd where c.parent_id = '"(int)$current_category_id"' and c.categories_id = cd.categories_id and cd.language_id = '"(int)$languages_id"' order by sort_order, cd.categories_id");.

I am not sure if this will give the result you want however there are other combinations the bit to look at is the bit of code that says order by sort_order, cd.categories_name which I changed to end _id you can change this part to alter the order.

A similar thing can be done to the admin.

This post has been edited by.

241.

: 01 March 2004, 18:51..

Comment #5

You might always be able to use a sorting contribution like this one:.

Http://www.oscommerc...ntributions,911..

Comment #6

I am working with a client right now who would like products in categories to show up in a specific order. I have experimented with the Sort Order option and various ways of inputting products but no matter what I try, OSC orders the products the way it wants to. This is making me very mad. Is there a way around all this so products will STAY in the order in which I input them?..

Comment #7

I need to narrow down the issue.

Is it the order within the categories info box or product info page.

Is it when you click on a link in the categories infobox and the page loads up.

There are sections of the code which state order by (then the type product id category id options names , then desc descending and asc ascending etc.)..

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.