|
awenzel
Starting Member
4 Posts |
 Posted - September 13 2006 : 10:51:24
|
I have started adding products into multiple categories. However, when I add a product to a second category, suddenly it no longer appears in the first category in the admin (it appears properly in both categories in the store.) What I mean, is when I select a category as my filter in the admin Products page, the SQL that's generated is "SELECT * from products Where ccategory=47", which clearly won't select products that are in multiple categories. When I put a product in multiple categories, the "ccategory" field for that product is set to the maximum category ID of all the categories that the product is in. That means that in the admin, that product will only show up in that one category.
An example is that I put a single item in the "toys" and "sale items" categories, yet in the admin, it only appears under "sale items" and no longer under "toys".
Does anyone know if the VPASP admin is supposed to work this way?
This also affects coupons, where if you set the "couponcategories" field on the coupon, that coupon only applies to the specified categories. The same issue listed above is causing the coupon to not be applied to all products in a listed category. In my example, even though the "toys" category is valid for the coupon, products that are in both "toys" and "sale items" are not getting the coupon.
I'm using VP-ASP 5.50.
Thanks.
|
|
All Forums
Products in multiple categories don''t appear
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
