All Products

[warrenerjm]

Hi

 

OK. I followed the instructions, ignoring the part about 2 database queries & the file catelog/includes/languages/english/vssver.scc because I couldn't get an answer about them & they weren't mentioned in the install instructions?

 

All now works well. I have a All products page & it shows up in my Dynamic site map.

 

My problem is, it doesn't show a link in the categories box. I have checked all the files. This is the instruction (part 3 only)

 

3. Place Links to the new page as you want. Look this:

 

<?php

echo '<a href="' . tep_href_link(FILENAME_ALL_PRODUCTS) . '">' . ALL_PRODUCTS_LINK . '</a>';

?>

 

3.1 Make a link in the categoriesbox:

open catalog/includes/boxes/categories.php:

 

find around line 66:

 

$info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES);

 

change to:

 

$info_box_contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_ALL_PRODUCTS) . '" class="headerNavigation">' . BOX_HEADING_CATEGORIES . '</a><br>' );

 

I have done 3.1 but not 3. One because I don't know where to put it, & two because I am reading that to mean if I want to put the link else where?

 

Can anyone please tell me why I am not getting a link showing in the categories box?

 

I do have category box enhancement contrib, which I hope to change to New DHTML category menu soon.

 

Thank you

 

Julie

 

Thank you.

[choosealogin]

The code you posted would make the category box heading a link to your all products page. Are you sure it didn't work?

[warrenerjm]

The code you posted would make the category box heading a link to your all products page. Are you sure it didn't work?

I'm stupid! :-"

 

Yes it does work, but I guess that means it's not designed for customers to see? How do I get a title "All Products" to show up as the link in the Categories box. ie like it was a category? Please :D

I assumed, because I'd seen others with this type of link, that was what the contribution would do.

 

Thank you

Julie

[warrenerjm]

Another point I have just noticed, is that the categories on the All Products page doen't seem to be in any particular order. They are definately not alphabetical, so if the customer could see it, they might get a little confused. Is there a fix for this too please?

 

Thanks

 

Julie

[choosealogin]

I don't have this contribution installed, and I'm not really familiar with it. Your first question was easier ;)

 

But I found this text in the readme for an older version (2.3).

 

 

find (in catalog/includes/boxes/categories), near the bottom:

 

new infoBox($info_box_contents);

 

and replace with:

 

 $info_box_contents[] = array('align' => 'center',
						   'text'  => '<font size=-2><a href="' . tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL') . '">' . BOX_INFORMATION_ALLPRODS . '</a></font>');

 new infoBox($info_box_contents);

 

Hopefully, that will make it work the way you want it to. I think hiding the link was considered an 'upgrade' because some sites will have an overwhelming list that they don't really want the customer to view.

 

I'm not sure about your other question, about the order. Hopefully more help will arrive.

 

 

I'm stupid! :-"

 

Yes it does work, but I guess that means it's not designed for customers to see? How do I get a title "All Products" to show up as the link in the Categories box. ie like it was a category? Please :D

I assumed, because I'd seen others with this type of link, that was what the contribution would do.

 

Thank you

Julie

[warrenerjm]

I don't have this contribution installed, and I'm not really familiar with it. Your first question was easier ;)

 

But I found this text in the readme for an older version (2.3).

find (in catalog/includes/boxes/categories), near the bottom:

 

new infoBox($info_box_contents);

 

and replace with:

 

 $info_box_contents[] = array('align' => 'center',
						   'text'  => '<font size=-2><a href="' . tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL') . '">' . BOX_INFORMATION_ALLPRODS . '</a></font>');

 new infoBox($info_box_contents);

 

Hopefully, that will make it work the way you want it to. I think hiding the link was considered an 'upgrade' because some sites will have an overwhelming list that they don't really want the customer to view.

 

I'm not sure about your other question, about the order. Hopefully more help will arrive.

 

Thank you Mark

 

I will try that.

 

Will this page still help with rankings, as the link isn't obvious to the customers in the heading, or won't the spiders realise that? Without the products & categories being in order, it is probably better to leave in the header for the time being. I will obviously take note of your instructions & see whether anyone else can solve the second part.

 

Thanks for checking this out for me.

Julie

[marok]

Hi there

 

I think I managed to solve the second part!

 

The categories in All Products are ordered by category_id (which is the order you first added them).

 

If you want the categories ordered alphabetically, change this line in /all_products.php (around line 95)

 

$products_query = tep_db_query("SELECT p.products_id, pd.products_name, pc.categories_id FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc WHERE p.products_id = pd.products_id AND p.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = FLOOR($languages_id) ORDER BY pc.categories_id, pd.products_name");

 

to

 

$products_query = tep_db_query("SELECT p.products_id, pd.products_name, pc.categories_id, cd.categories_name FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE pc.categories_id = cd.categories_id AND p.products_id = pd.products_id AND p.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = FLOOR($languages_id) ORDER BY cd.categories_name, pd.products_name");

 

Now I'm no PHP expert but ... well, it worked for me :)

Edited May 31, 2006 by marok

[warrenerjm]

Hi there

 

I think I managed to solve the second part!

 

The categories in All Products are ordered by category_id (which is the order you first added them).

 

If you want the categories ordered alphabetically, change this line in /all_products.php (around line 95)

 

$products_query = tep_db_query("SELECT p.products_id, pd.products_name, pc.categories_id FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc WHERE p.products_id = pd.products_id AND p.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = FLOOR($languages_id) ORDER BY pc.categories_id, pd.products_name");

 

to

 

$products_query = tep_db_query("SELECT p.products_id, pd.products_name, pc.categories_id, cd.categories_name FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE pc.categories_id = cd.categories_id AND p.products_id = pd.products_id AND p.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = FLOOR($languages_id) ORDER BY cd.categories_name, pd.products_name");

 

Now I'm no PHP expert but ... well, it worked for me :)

Hi Gareth

 

Thank you for replying. I changed my mind & installed the "all products with pictures" instead. It is much better & alphabetical with price, pictures etc. A good point with this one is it has only so many products per page instead of a long list.

 

Julie