We have 5 main (root) categories in our store (many sub categories). The most popular items purchased are from 2 categories.

I want to create a featured product page to show only flagged items from one root category at a time.

We have a featured product page, and we need it’s functions to stay as they are… any item flagged will be displayed on that page.

The page I’m trying to tweak I got from the below link.
“Move the default ProductCart home page (mainIndex.asp) to your root folder. http://www.earlyimpact.com/productcart/support/code_samples/index.zip - Download this special version of mainIndex.asp - renamed http://www.earlyimpact.com/productcart/support/code_samples/index.zip - index.asp - which has been modified to work in your root folder.”

I’m wondering…. is there any easy solution?  

many thanks
n0thing

I've not tried this, but I would think you could use the file from the Developer's Corner submitted by Dan Tang that allows you to display N featured products anywhere...and then modify the SQL statement to only call items from your category. Easiest would be to create a file for each of the categories you are wanting to feature.

Currently, that file uses this SQL statement at line 28:

'select products that are flagged as featured items for the homepage
mySQL="SELECT sku,idProduct, description, serviceSpec, details, price, smallImageUrl FROM products WHERE showInHome=-1 AND active=-1"

You could modify it to this, which would select all products from your given category regardless of whether or not they are marked to be displayed on the home page (they just have to be marked as "Featured":

'select products that are featured items from a specific category
'be sure to replace X with your category number
mySQL="SELECT products.sku, products.idProduct, products.description, products.serviceSpec, products.details, products.price, products.smallImageUrl
FROM products INNER JOIN categories_products ON products.idProduct = categories_products.idProduct
WHERE categories_products.idCategory=X AND products.active=-1"

Of course, there are other ways to do this like modifying it to check and for the category in the incoming link and then querying based on that.

I hope that at least sets you on the right path!

hi rightmind
thanks so much for your idea and code. i've been afk for awhile.
i got about as far as the 'INNER JOIN' statement and ran into knowledge issues.

I got your suggested code working (thanks!) and as far as i can tell, your code displays items from sub categories only - and does not list any items from any categories below it... (hope that made sense)

As mentioned, i have 5 main categories, (tools, wi-fi, hardware, software, prints).
Under TOOLS, i have 7 sub categories. All our products under tools are locted in the 7 sub sections only. Using your code, i'm able to list 'featured products' in one of the sub sections, but not in the main root catagory.

i'll continue to bang my head on this sql statement.

thanks for your help
nothing