Product Display Problem

[napogee]

My Question Is:

 

How can I display the items NON-ALPHABETICALLY.

 

THe only way I figured to this is by inserting a Sort Number. But I have 400 items + so I have to edit them all ?

 

Thanks,

Jess

[peterr]

Hi,

 

My Question Is:

 

How can I display the items NON-ALPHABETICALLY.

 

THe only way I figured to this is by inserting a Sort Number. But I have 400 items + so I have to edit  them all ?

 

Thanks,

Jess

<{POST_SNAPBACK}>

 

Where do you want to sort the products 'non-alphabetically' ? Are you using the 'all products' contribution, or you simply want the products ordered by (for example) product ID, when a category is selected ?

 

Peter

[napogee]

Hi,

Where do you want to sort the products 'non-alphabetically' ? Are you using the 'all products' contribution, or you simply want the products ordered by (for example) product ID, when a category is selected ?

 

Peter

<{POST_SNAPBACK}>

 

I guess I would like them sorted in a way I can Graphically select ITEM #xxx to #1 where it shows.

 

Or if there is no graphical way, a fast way to insert the sort numbers ?

 

~ Jess

[peterr]

Hi,

 

I guess I would like them sorted in a way I can Graphically select ITEM #xxx to #1 where it shows.

 

Or if there is no graphical way, a fast way to insert the sort numbers ?

<{POST_SNAPBACK}>

 

1. Where do you want to display the products in 'non-alpha' order ?

 

(i) When the main page is displayed (index.php), to show in 'new products', specials or .. ??

 

(ii) When the category is slected, and the products belonging to the cateogry are displayed ?

 

(iii) Are you using the 'all products' contribution, and you want to make the change there ?

 

 

2. What exact order do you want the products to display in, product ID, model number, description ??

 

3. Adding the sort order field will mean you will have to continually update the sort order for new products,etc,etc.

 

Peter

[napogee]

Hi,

1. Where do you want to display the products in 'non-alpha' order ?

 

(i) When the main page is displayed (index.php), to show in 'new products', specials or ..  ??

 

(ii) When the category is slected, and the products belonging to the cateogry are displayed ?

 

(iii) Are you using the 'all products' contribution, and you want to make the change there ?

2. What exact order do you want the products to display in, product ID, model number, description ??

 

3. Adding the sort order field will mean you will have to continually update the sort order for new products,etc,etc.

 

Peter

<{POST_SNAPBACK}>

 

 

When the category is slected, and the products belonging to the cateogry are displayed. I have the contribution 3 products in a row selected. I want select what items will show up first.

[peterr]

Hi,

 

I guess I would like them sorted in a way I can Graphically select ITEM #xxx to #1 where it shows.

<{POST_SNAPBACK}>

 

Please advise if you want it sorted by "product model" or by "product ID#" ?

 

Peter

[napogee]

 

Please advise if you want it sorted by "product model" or by "product ID#" ?

 

Peter

<{POST_SNAPBACK}>

 

Hi Peter,

I Guess by Private ID#

[peterr]

Hi,

 

I Guess by Private ID#

<{POST_SNAPBACK}>

 

I assume you mean product ID#.

 

As you stated earlier ........

 

When the category is slected, and the products belonging to the cateogry are displayed. I have the contribution 3 products in a row selected. I want select what items will show up first.

<{POST_SNAPBACK}>

 

then the file that is used for those product displays is index.php

 

Around line 195 of /index.php is this .......

 

$listing_sql .= " order by pd.products_name";

 

modify that line to ......

 

$listing_sql .= " order by pd.products_id";

 

You may also have to modify some of the lines following 195, for example line 205 is:

 

$listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

 

Obviously replace 'pd.products.name' with 'pd.products_id', BUT only do it where you see lines with the $sort_order variable, there are some without it.

 

Modify 195 first, and if that only gives the products in product ID order under some situations, then also modify the other lines I mentioned.

 

Peter