Custom product query + category layout

[sandomatyas]

I want to create a custom product list with my special requests (like products in stock and added in the last week and cheaper than a limit and not featured and have a specific custom field value, etc). The query is okay, I can fetch the records from the database.
But what do you suggest to display them like VM displays products of a category? Basically I need using the products sublayout and a proper pagination. Building a custom component with an own pagination and use VM sublayouts?
Or any better idea?

[StefanSTS]

As much as possible I would try to operate with categories.

Depend if you can set a category for these products you could just create a "below this price"-category and so on and use a custom products.php like products_belowprice.php.

If that does not work, the new products_something.php could also hold higher level categories and you filter in the loop for the prices you need.

Stefan

[GJC Web Design]

Code Select Expand

use a custom products.php

agree with stefan - it is very easy actually to create a complete "other" VM "view"  by just duplicating and renaming the model, view folder  etc etc and then as suggested adapt the products_myname.php to what u need

have also done different views by duplicating the products.php model, renaming and the class and calling it in your view by

$productModel = VmModel::getModel('Productmy');

then use all the normal functions

[sandomatyas]

Nice one thanks. My only fear that with this idea I miss a lot of new features and bugfixes mostly in the model. Maybe extend the new model from the old one and override only a few methods could help to maintain the code integrity when I update VirtueMart

[Studio 42]

Of course use product model as parent if you use most same function or vmmodel if not.