View All Products

Is there a way to have a customer click a link to "view all products" either in a specific category, or of the entire store cart?

For instance I have a product category called "Toys & Learning" with 7 pages deep of product, rather then click through all 7 pages, click "view all products" to see all the products in that category.

I also have been working with pagination for my page drop downs.
see link:
http://forum.opencart.com/index.php/topic,2022.0.html

This might be a thread you'd be interested in:
http://forum.opencart.com/index.php/topic,2116.0.html

I actually coded it on one of my dev sites but I think I wiped it since then.. but bruce's post with the sql might be good to get you started.

I did bruce's idea, create a new category "All Products" assign all products this extra category then it works. However now I get 23 pages to click through. Is there a way with pagination to click "view all" to include this together? Am I going overboard with all these small ideas???

http://www.ecobabygear.com/store/category/path/52

*Also, today I was fixing the admin "people online 3600 sec bug", and as I was doing the changes to report_online.php file I saw I had a customer online and was following them and saw that they had 2 items in their cart, and then seeing the last page they were on keep changing to  finally see the checkout-confirm url, then before my eyes the new order appeared! Cool

nextgenxx wrote: I did bruce's idea

And the earth didn't explode?! That was risky! shweew..   :P

nextgenxx wrote: However now I get 23 pages to click through. Is there a way with pagination to click "view all" to include this together?

Yes.
Something like this:

CHANGE:
$results = $database->getRows($database->splitQuery("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join product_to_category p2c on (p.product_id = p2c.product_id) left join image i on (p.image_id = i.image_id) where status = '1' and language_id = '" . (int)$language->getId() . "' and p2c.category_id = '" . (int)end(explode('_', $request->gethtml('path'))) . "' and p.date_available has('path') ? $session->get('category.' . $request->gethtml('path') . '.page') : $session->get('category.page')), $config->get('config_max_rows')));

TO:
$results = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join product_to_category p2c on (p.product_id = p2c.product_id) left join image i on (p.image_id = i.image_id) where status = '1' and language_id = '" . (int)$language->getId() . "' and p2c.category_id = '" . (int)end(explode('_', $request->gethtml('path'))) . "' and p.date_available < now() and p.status = '1' order by p.sort_order, pd.name");

(NOT TESTED)

nextgenxx wrote: Am I going overboard with all these small ideas???

Yes 

nextgenxx wrote: finally see the checkout-confirm url, then before my eyes the new order appeared! Cool

Very cool! Lets share the profits with the devs!