display featured PRODUCT on main page

[mimran]

you could be right but i beg to differ.
Do you know what is the master Category for featured products?
If i can find out the category number that will resolve the problem.

[fairestcape]

I don't think Featured products are placed in a "category". The function is controlled by a database "switch" that enables several php files to perform call functions off the data in the database.

If the database "switches" are turned ON via admin panel (eg, the featured product sidebox, coupled with all the products that have been designated "featured"), then the relevant php files kick into life and do their work.

These will (amongst others), involve:-

includes\modules\featured_products.php
includes\modules\sideboxes\featured.php
includes\templates\template_default\templates\tpl_featured_products_default.php
includes\templates\template_default\templates\sideboxes\tpl_featured.php

...Suggest you open up each of these to see their php structure, and this may help you develop some custom code to put into other php files that render the index page.

[mimran]

already have done that
and just to simply put it
when you say start main at category = 0 (top category) that is essentially exactly what i am saying
if you looked through all databases you won't find this hence this is
master category with category_id = 0
on the same principle i believe there is one for this too.
and to support my arugument database table category_configuration_id does represent group category id for FEATUREd to be #22 but for some strange reason this logic is not working
or i am on lines in opposite directions

[fairestcape]

database table category_configuration_id does represent group category id for FEATUREd to be #22

I just looked in a database (via phpMyAdmin) on a shop I manage, that has severalfeatured products.

There is no ID for a category called "Featured" in my dbase.

I can see ALL categories I have manually created in Admin Panel, but no category for featured products.

As I said, a catgegory is not created for featured products - the data is dynamically called off existing tables and cobbled together according to settings and relevant php code.

[mimran]

Yes seems you are right!

[fairestcape]

Here's a possible work-around...

1. You create a category called "Featured".
2. Set up all your "featured" products using the catalog>>>featured products facility.
3. Go to the cateogries where your featured products reside.
4. LINK COPY these featured products to your manually created "Featured" category
5. In Maximum Values>>>Random Featured products for Sidebox, set to display the same number as your total number of featured products.
6. In Configuration>>>Layout Settings>>>Categories Box - show featured products link (set to false) ... you have a main category now, called "featured".
7. in Layout Settings>>>Main Page - opens with category (set to the ID of your "featured" category)

[mimran]

if not too much of a hassle i have sent you a private message

[mimran]

i can see what you are saying but the main essence of a featured product is the time so i can leave something for five days and then expire it automatically which by doing as you suggested is not achieveable

[mimran]

hi every one

this is my second general public plea if someone can assist with this issue PHALEASE

[mimran]

well well well! good news is i sat down on code and after a bit of manipulation have figured two ways of doing it, just have to implement them properly as have to figure out all the different places where it requires changes but Yes doable. but if anyone comes across this post and knows an easier way please do let me know, i have taken the longest way possible.