Forums / Templates, Stylesheets, Page Layout / Remove gift certificates from bestsellers list?

Remove gift certificates from bestsellers list?

Locked

Started by essentialparadox on 3 Oct 2009, 5:07 AM · Views: 769

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
3 Oct 2009, 5:07 AM
#1
essentialparadox avatar

essentialparadox

Zen Follower

Join Date:
May 2005
Posts:
89
Plugin Contributions:
0

Remove gift certificates from bestsellers list?

Is there an easy way to remove gift certificates from the bestsellers list?

4 Oct 2009, 11:59 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Remove gift certificates from bestsellers list?

If all of your Gift Certificates use the same master_categories_id you could use that to filter out products ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

5 Oct 2009, 12:11 AM
#3
essentialparadox avatar

essentialparadox

Zen Follower

Join Date:
May 2005
Posts:
89
Plugin Contributions:
0

Re: Remove gift certificates from bestsellers list?

Hmm… Thank you. Can you give me a bit more direction on how to do this filtering?

If it's complicated and involves any coding, I will probably just prefer to ignore it!

5 Oct 2009, 2:23 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Remove gift certificates from bestsellers list?

To do this you would need to customize the SQL statements Best Sellers sidebox using your templates and overrides ...

The original files are in:
/includes/modules/sideboxes/best_sellers.php
/includes/templates/templates_default/sideboxes/tpl_best_sellers.php

and copy them to your templates and overrides directory:
/includes/modules/sideboxes/your_template_dir/best_sellers.php
/includes/templates/your_template_dir/sideboxes/tpl_best_sellers.php

then change your file:
/includes/modules/sideboxes/your_template_dir/best_sellers.php

to include the extra code on the SELECT statements in the WHERE clause for:
p.master_categories_id != XX

where the XX would be the categories_id for the Master Category that the Gift Certificates belong to ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 Oct 2009, 5:34 AM
#5
essentialparadox avatar

essentialparadox

Zen Follower

Join Date:
May 2005
Posts:
89
Plugin Contributions:
0

Re: Remove gift certificates from bestsellers list?

Thank you! :)