VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Subcats missing in dropdown in ADMIN section
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

37 Posts

Posted - January 25 2011 :  07:37:09  Show Profile  Reply with Quote
Hello, we went in to edit some products in a subcategory and the dropdown only shows parent cats. How can we show all categories? THe products are there if you choose ccategory and type in the number but my client is not a programmer and it's insane to think he'll have to do this every time he needs to edit a product in a subcategory. please let us know how to display all categories in the admin category dropdown. many thanks in advance.

VP-ASP Expert

United Kingdom
948 Posts

Posted - January 25 2011 :  09:29:03  Show Profile  Reply with Quote

I didn't like this restriction either so I changed it. If you feel confident to change code in a file then open shopa_editdisplay.asp in a text or html editor and save a copy as backup

Find the sub routine Sub Addcategories (approx. line 840)
Find this line:
catSQL="Select * from categories where highercategoryid=0 order by catdescription"

Comment out the where clause so it should look like this:
catSQL="Select * from categories" 'where highercategoryid=0 order by catdescription

Save and try it. You should now get a dropdown list of all your categories in the order they appear in the categories table.
I'm still on v6.50 but I think the routine will be the same in v7.0

Hope this helps,

Go to Top of Page

Starting Member

37 Posts

Posted - January 25 2011 :  19:40:21  Show Profile  Reply with Quote
That's great, Carrol, I'm confident working in the code so I'll give it a try and let you know. Many thanks again!
Go to Top of Page

VP-ASP Super User

282 Posts

Posted - January 26 2011 :  13:28:43  Show Profile  Visit chrisredco's Homepage  Reply with Quote
What a beautiful thing! Helps so much when editing in Admin. Thanks for the tip.

Go to Top of Page

Starting Member

37 Posts

Posted - January 27 2011 :  18:48:30  Show Profile  Reply with Quote
absolutely works great for me, thank you very much!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000