Joomla Templates Club 406,261 posts

[apan66 Friend apan66Join date: July 2010Posts: 27Downloads:0Uploads:0 Thanks: 8]

#157778

Hello,

On the frontpage, my products appear randomly, in the “What’s new here” and “Featured products” module.

How can I place them in my own order and keep them that way?

Thank you in advance.

[Phan Gam Friend Phan GamJoin date: June 2008Posts: 216Downloads:0Uploads:2 Thanks: 4 Thanked: 39 times in 38 posts]

#368281

#1. “What’s new here” modules is mod_ja_vmproductslide module, In this products is ordering by “product_name”.

If you want to change order field, i think you can make code modification as follows.

1. Open application.php file in modulesmod_ja_vmproductslideja_vmproductslide folder.
2. Finding code section

$query .= ($this->_typeproduct) ? (($this->_typeproduct == 1 ) ? ' AND p.product_special ="Y" ORDER BY p.product_name DESC ' : 'ORDER BY p.cdate DESC ') : 'ORDER BY p.product_name DESC ';
about line 75
3. Change ORDER BY field as you want
#2. You can do the same with module “Featured products”
Open file mod_virtuemart_featureprod.php in modulesmod_virtuemart_featureprod folder.
And change sql Order by for get products query.
Hope that helps

[apan66 Friend apan66Join date: July 2010Posts: 27Downloads:0Uploads:0 Thanks: 8]

#368474

Thank you.

But I’ve never done this, I really don’t know what to write instead of that code?

Thank you very much for your effort.

[Phan Gam Friend Phan GamJoin date: June 2008Posts: 216Downloads:0Uploads:2 Thanks: 4 Thanked: 39 times in 38 posts]

#368699

Hi apan66,
You can open website doc root (where locate your website codes) and make to change as my suggestions.
Regard

[Author]

Posts