Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Choosing Products for the main Page


cjx

Recommended Posts

Hello friends

 

I am totally new and i am trying oscommerce offline on my computer. I already installed and its working. What i want to learn is

Is it possible to choose the products that i want for the main page. Or is there any other way changing the products every refresh at the main page (random Products) Please let me know how can i do this.

 

Thank you very much

 

Best Regards :blush:

Link to comment
Share on other sites

Thanks to Burt

I have found how to show random products so i write here again if someone needs help

 

So what Burt says is ;

 

open up /includes/modules/new_products.php

 

and change from this:

 

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

 

to this:

 

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS);

 

So this will make your products random at the main page

 

Now just one more thing to learn how to choose the products we want for the main page. When i found it i will write here as well.

 

Thank you

Link to comment
Share on other sites

Now just one more thing to learn how to choose the products we want for the main page. When i found it i will write here as well.

 

I'm looking for the answer to this as well... or at least how to restrict it to one category (for frontpage items)....

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...