Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Main Page Categories


marygr

Recommended Posts

Hello!

 

I want to change the categories in the first page, Now at the center of the page is the New products, this I want to change I want of the Best View products of products of my choice. Can somebody help me? I am new at PHP and it's difficult for me to make the changes myself... :rolleyes: :rolleyes: :rolleyes:

 

Thank you!

 

PS. Also I would like to know how can i erase the prices. I have a shop and we don't want to put prices, now it's zero all the prices but i think it's better if that choice will be out.. :blush:

Link to comment
Share on other sites

no answer yet??  >_<      :(

Just go to the Db and change the number of times the product has been viewed and let the product you want to display have the max count.

 

In this solution no need to do any coding

 

 

Satish Mantri

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Hello!

 

I want to change the categories in the first page, Now at the center of the page is the New products, this I want to change I want of the Best View products of products of my choice. Can somebody help me? I am new at PHP and it's difficult for me to make the changes myself...  :rolleyes:  :rolleyes:  :rolleyes:

 

Thank you!

 

PS. Also I would like to know how can i erase the prices. I have a shop and we don't want to put prices, now it's zero all the prices but i think it's better if that choice will be out..  :blush:

 

 

Here is the code solution

 

you have in boxes/best_sellers.php folowing lines on line 14

 

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS

 

 

replace with

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where

 

 

p.products_id = your product id );

 

Satish Mantri

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Here is the code solution

 

you have in boxes/best_sellers.php folowing lines on line 14

 

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS

replace with

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where

p.products_id = your product id );

 

Satish Mantri

 

thank you!! thank you!! thank you!! :D

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...