Problem: The "table" method of displaying subproducts of inventory is the only one that shows stock levels with [cstock]. How can I show those same levels when using the small, more convenient, "drop down" method?
Solution: The 'shopproductinventory.asp' page controls the entire construction of the inventory section on the product display pages (shopdisplayproducts, shopexd.asp) as long as you've not excluded that functionality (in a customer template perhaps). To get the inventory to show up before the "cname" of the item in the drop down, follow these directions.
***REMEMBER to save an archive copy of the original shopproductinventory.asp in case something doesn't work right! ***
1. Find the line dim hideprice
in the "GenerateSubProductName" sub of shopproductinventory.asp
2. Change it to dim hideprice, cstock
3. Find the line tempoption=rs("cname")
in the same sub
4. Change it to tempoption="(" & rs("cstock") & ") " & rs("cname")
5. Save and upload the new version of the page. Now any product which has inventory subproducts (child products) associated with it, and displayed as a dropdown, shall show the stock levels in paren's before the name of the subproduct in that drop down.
***REMEMBER to save an archive copy of the original shopproductinventory.asp in case something doesn't work right! ***
To see it working, visit this URL:
http://www.roseandcrowne.com/shop/shopexd.asp?id=536