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
 ccategory in edit product does not work
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

37 Posts

Posted - October 22 2007 :  23:13:02  Show Profile  Visit Season's Homepage  Reply with Quote
In Product Update Doing a Search by Ccategory, it does not work. there is also a Categories List Drop down but it does not seem to do any thing either. Version 6.09

If you wanted to see a list of everything in a specific Category how would it be done.


Starting Member

29 Posts

Posted - October 23 2007 :  01:21:59  Show Profile  Visit yudevan's Homepage  Reply with Quote

Actually it wouldn't occurs as long as the category you entered is exist, it probably you are enter inactive category or you have specified two criteria for search rule

for example:

ccategory is equal 2
but at the category tipe you select dining(3)

it wouldn't display anything
please make sure the category is exist

Hope this helpful

Just Gimme a Byte of Micro!
Go to Top of Page

Starting Member

37 Posts

Posted - October 23 2007 :  18:05:24  Show Profile  Visit Season's Homepage  Reply with Quote
How would you display in Edit or Bulk editor a list of items from one category.

Please be detailed.

Go to Top of Page

Senior Member

United Kingdom
1898 Posts

Posted - October 23 2007 :  18:09:38  Show Profile  Visit devshb's Homepage  Reply with Quote
if you were doing it from sql, the actual query that you'd do would be like:
select * from products where exists (select 1 from prodcategories where intcatalogid=catalogid and intcategoryid=100)

(where 100 is the categoryid that you're looking for)
it can't be a straight-forward where clause; it needs to be an exists clause, because you can have a product in multiple categories so it needs to check the matrix table.

also you'd need to ensure that you don't have gaps within the branches in the matrix (ie for a given bottom-level category, all the categories going up that branch must be selected in the edit-product page) - it might be that you have missing gaps in the data.

doing the query above in your vpasp admin advanced query screen could give you a few pointers in that direction if you try it out for different category ids going up the branches.

if you've got loads of products, and manually filling in those gaps in the data would take ages, then you could use our prod/cat check/fix tool which would check/fill the gaps for you:

Simon Barnaby
[email protected]
Web Design, Online Marketing and VPASP addons

Edited by - devshb on October 23 2007 18:14:51
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000