All Products

[dm18k]

All Products Enchanced

 

http://www.oscommerce.com/community/contributions,1785

 

I just installed this contribution. Very easy to install also.

 

It lists all my products. It lists them from lowest price to highest price. Is there a way to change this? Like to A-Z?

[Belzibut]

All Products Enchanced

 

http://www.oscommerce.com/community/contributions,1785

 

I just installed this contribution. Very easy to install also.

 

It lists all my products. It lists them from lowest price to highest price. Is there a way to change this? Like to A-Z?

 

I'm also looking for that contrib. Here is an example:

 

http://www.consoleplus.co.uk/index.php?man...sort=3a&sort=4a

 

The sort products listing dropdown box.

 

Thanks all,

 

David

[Guest]

All Products Enchanced

 

http://www.oscommerce.com/community/contributions,1785

 

I just installed this contribution. Very easy to install also.

 

It lists all my products. It lists them from lowest price to highest price. Is there a way to change this? Like to A-Z?

 

you mean like: http://www.h2opoolproducts.com/allprods.php

[Curly]

you mean like: http://www.h2opoolproducts.com/allprods.php

 

I am also looking for something like this, where you can list all your products in a nice and clean way. Does anyone know a contribution that can do this?

[Guest]

I am also looking for something like this, where you can list all your products in a nice and clean way. Does anyone know a contribution that can do this?

 

We took allprods.php and modified it a tad for better SEO

 

1) we limitted the amount of items per page by alpha as Google doesn't like long link lists

2) we add images with links so google knows that there is a link to an image, not just textual links

3) we added a modifier that shows a subset of all items as a table list, and includes the text from the description (first 250 characters) of the item This modifier can be set from 0-N and allows us to "shorten" the pages display as google limits what they will index on the page. The balance in a tabled link list of product names only

4) Between the first and second table we display one of five random text blocks that contains site appropriate text and keywords. These text blocks can contain links (for instance, one can list some of the more popular manufacturers and link to the manufacturer listing page).

 

Between these techniques the allprods.php page becomes more than a page for listing all the products, but it becomes a part of the SEO (there are a few more things we did, but those four basic ones will help with SEO).

 

below is the alpha header

 

<tr><td class=main align=center>
<a href=allprods.php?alpha=a>A</a> |
<a href=allprods.php?alpha=b>B</a> |
<a href=allprods.php?alpha=c>C</a> |
<a href=allprods.php?alpha=d>D</a> |
<a href=allprods.php?alpha=e>E</a> |
<a href=allprods.php?alpha=f>F</a> |
<a href=allprods.php?alpha=g>G</a> |
<a href=allprods.php?alpha=h>H</a> |
<a href=allprods.php?alpha=i>I</a> |
<a href=allprods.php?alpha=j>J</a> |
<a href=allprods.php?alpha=k>K</a> |
<a href=allprods.php?alpha=l>L</a> |
<a href=allprods.php?alpha=m>M</a> |
<a href=allprods.php?alpha=n>N</a> |
<a href=allprods.php?alpha=o>O</a> |
<a href=allprods.php?alpha=p>P</a> |
<a href=allprods.php?alpha=q>Q</a> |
<a href=allprods.php?alpha=r>R</a> |
<a href=allprods.php?alpha=s>S</a> |
<a href=allprods.php?alpha=t>T</a> |
<a href=allprods.php?alpha=u>U</a> |
<a href=allprods.php?alpha=v>V</a> |
<a href=allprods.php?alpha=w>W</a> |
<a href=allprods.php?alpha=x>X</a> |
<a href=allprods.php?alpha=y>Y</a> |
<a href=allprods.php?alpha=z>Z</a> <br> 
<a href=allprods.php?alpha=1>1</a> |
<a href=allprods.php?alpha=2>2</a> |
<a href=allprods.php?alpha=3>3</a> |
<a href=allprods.php?alpha=4>4</a> |
<a href=allprods.php?alpha=5>5</a> |
<a href=allprods.php?alpha=6>6</a> |
<a href=allprods.php?alpha=7>7</a> |
<a href=allprods.php?alpha=8>8</a> |
<a href=allprods.php?alpha=9>9</a> |
<a href=allprods.php?alpha=0>0</a> |
<a href=allprods.php>LIST ALL PRODUCTS</a> 
</td></tr>

 

Below is the alpha query mods

 

// added alpha page selections to query
   if (!is_null($_GET['alpha'])) $addregex = "pd.products_name REGEXP '^[".s
trtoupper($_GET['alpha'])."!".strtolower($_GET['alpha'])."].*$' and ";

// added alpha page selections to query as well as picking up the descriptions 
// and not showing hidden categories items
   $products_query = tep_db_query("select p.products_id, p.products_model ,p
d.products_name, pd.products_description, p.products_image, p.products_price, p.
products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABL
E_PRODUCTS . " p , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES 
. " p2c left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufa
cturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd
.products_id and pd.language_id = '" . (int)$languages_id . "' left join " . TAB
LE_SPECIALS . " s on p.products_id = s.products_id where ".$addregex." p.product
s_id = p2c.products_id and c.categories_id = p2c.categories_id and c.cshow > '0'
and products_status = '1' order by pd.products_name");

 

(yes, we have instituted a simple hidden categories capability and c.cshow > '0' which you can just drop out if you don't want to use the feature. This allows us to use a mod we created called "specials in cart" that allows us to craete specials and put them in the hidden category, and when someone orders something that we have attached to the special, it adds a notice in the shopping cart letting tem know that they can add the special item to the cart, but they can't get to the items in that category via any other method than when it is presented to them in their cart... for instance, a store doesn't sell gift baskets, but when you order from the "soap" category and your total order is over $50.00 you are offered a free gift basket... that sort of thing. Anyway, just remove that and the balance of te query should on most stores).