You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi there,
I have been reading and getting useful info from everyone, thanks.
I cannot find a clear solution for my problem. Perhaps I missed it.
When a user clicks a main category, they see all the related subcategories. Below the categories, it shows items there, but I don't want any products. I only want subcategories to show.
There are no products directed to display in my main categories, only in subcategories. I cannot seem to find any switch to turn this off. The strange thing is some items from the related subcategories are diplayed, but not all.
Any help is appreciated
Offline
bump..
Has anyone else run into this problem? I know I can change the way products display on the splash and other pages. But on a main category page, I only want subcategories to show. I assume there is a way around this, right?
It makes my site look cluttered
Offline
I haven't been in CCP6 for months, but don't you have in your categories setup screen these options:
Main Category (true/false)
Subdispnum (number of sub cats to display)
Subdisptype (display format)
Proddispnum (number of prods to display per row) ****
Proddisptype (display format)
In looking in the Lotus Approach database I was setting up for CCP6 categories, I see my main cats had these settings respective to the above list:
1, 4, default, (blank), default
My sub cats are set:
0, (blank), default, 4, default
Offline
Thanks slydog. I will give that a go and see how it works.
Offline
I just did the changes via excel and successfully uploaded the ccp0_cat file.
It does not remove the products in the main categories. I also tried removing the default on Proddisptype (display format) to blank and same thing.
I did not adjust the subcategories as I don't think it affects these main categories that I am concerned about.
Any other methods to try to achieve this?
Offline
Are you sure that the category that the items are displaying in are not calling the items directly, or that the items aren't set to display in those categories? What is your site address so we can look at it?
John
Offline
I just checked my old development site (still live). If I click a main category in my left menu all I get is subcategories. I don't recall doing anything special for that, so it must be a setting somewhere -- but, again, I haven't played with CCP6 for quite awhile.
Offline
Go to Home > ClickCartPro > Catalog: Categories, Products and Options > Manage Online Store Products and check the Product Display Areas entry’s these control where the individual product is displayed.
Mike Simpson
wwwdjshopper.net
Offline
Thanks everyone for the replies to my problem. I have all the category and product display settings the same, and correct for what I want to show. The fact that only some main categories had items displayed under the sub-categories was strange.
What I did was clone one category that did not have this issue, and renamed it to the main category with the problem (I deleted the problematic main category first). It actually worked and the clones from the good main categories are fine now.
Initially, when setting up 6.0, I took my database from 5.1 in excel and just copied the columns' content that I wanted into an export of a 6.0 categories db file. I wouldn't think this would have any affect since I did not use any 5.1-6.0 importing tools.
I don't know if anyone else will run into this strange issue, but if you do, just clone a main category that doesn't show items under the sub-categories.
Last edited by bobbyd (05-03-2007 00:27:21)
Offline
Hi,
I have the same issue - there are Items being displayed in the sub-cat listings - even though they are not being called from either the category or the product fields.
I am guessing that this was due to the import process (from ccp5.1 to ccp6).
I have a lot of sub-cats - in excess of 100 - so cloning is not really an option.
Nick or suport team is there a better option? Is there sometjing I can do via MySQL?
Neil
Offline
Bump - really need some advice on this please.
Anyone had the same issue?
Thanks.
Offline
I still have the same issue actually. I managed to fix it by cloning directories and it seemed to fix it. However, I made some adjustments to my site and soon there after, the same thing again. Still only in some categories,not all. This proves to me it is not any optional settings within the catalog display.
I also would like to know to cause of this. When I tried my previous method of cloning the directories under different names again, then back to the original name (after deleting the renamed clone), they still appear. It makes my site look silly as they only show 1 item per line, and I REALLY cannot have any items shown in category/subcategory pages until the user navigates to the category in which the product is intended to display.
A reason for this would be appreciated, and a fix or means to resolve it necessary for me to continue using the product.
Offline
You will run into this issue in two cases:
(1) You have referenced the main category as a related category for the product under Manage Products.
(2) You have used a similar name for your main and sub categories. The system does a 'LIKE' style search on category names to determine relationships. Example: You create a product and relate it to the sub-category 'XXX'. The sub-category 'XXX' is related to the main category 'XXXYYY'. Because the string 'XXX' appears in both names, the product will appear in both categories. I would recommend renaming your main categories so they don't use similar strings as what your sub categories use. Ie: Change main category to 'ZZZYYY'.
Offline
Nick you have to be kidding me!!
The reason is most definetly (2) - but relates to the reference string as opposed to the display name.
Because CCP doesn't offer a logical way to select/group subcategories and products (at least in my view) - I tried a logical naming approach.
My reasoning was pretty simple. If I have one category and 3 levels of subcategory - then by including the main category name in the sub-cat - I could easily identify and include the subcats.
Now you tell me they have to be unique!
I'll be starting from scratch :-(
This is what I currently have - for both the reference string and in some cases the display name.
Main Cat: mymain
Sub Cat level 1: mymain_sc1
Sub Cat level 2: mymain_sc1_sc2
Product is ONLY associated with category mymain_sc1_sc2 - but is also appearing in mymain_sc1!
Why is it doing a LIKE search?
We are required to explicitly enter the related category for a product - shouldn't it just look for that category?
Is there another solution. I have 400 products and probably in excess of 250 subcategories.
I would have to renter the subcats in order to create new reference strings - unless you have some funky SQL query?
Hope you can help - this is urgent!
Neil
Offline
Why is it doing a LIKE search?
We are required to explicitly enter the related category for a product - shouldn't it just look for that category?
It does a LIKE type search to allow you to assign items to multiple categories as well as to allow you to have over 1,000,000 items in 1,000,000 categories without increasing server load or requiring more resources.
Is there another solution. I have 400 products and probably in excess of 250 subcategories.
I would have to renter the subcats in order to create new reference strings - unless you have some funky SQL query?
You only need to adjust the categories table - not the products as you'll only have to rename the main categories and change the relationship info for them in the subcategories. The easiest way to do this is to export a CSV version of the ccp0_cat table (using Raw DB Admin), making those changes using a program like Excel that can edit CSVs, then importing it back into the software. Right before the import (the second step), execute this raw statement:
DELETE FROM ccp0_cat
To remove all the old categories. It should only take you a few minutes to update all of them if this is the way you go about it. Instead of calling that example cat 'mymain', call it 'mainmy' and that will be enough of a difference.
Offline
Thanks Nick - that worked great and only took a short time.
Another question I have (which is probably answered by your server load column) but is it possible, where there are multiple levels of subcats - for CCP to ONLY show subcats which have products? Would a custom mod be possible or would it be overly complex?
So my main cats would all have a similar subcat level 1 and level 2 - for consistency.
However not every subcast2 would have an associated product.
Rather than have the user browse to an empty cat - I'd prefer to not show the subcats.
You would typically see this in business directory listing software.
Thanks again for quick response.
Neil
Offline
This can be done, but should only be done for stores that have a relatively small number of products. This would require a lookup on the products table first, getting all items with inventory - then working backwards to figure out categories. Very memory intensive and load intensive.
Offline
Hi Nick,
Whats your definition of relatively small number of products - I would think there will probably be a max of 500 - currently around 200.
I also noticed something odd with breadcrumbs in location.
If I "browse" using the breadcrumbs - go up a cat and back down to an different item - then back again.
The breadcrumb doesn't show the "current" path - instead it shows the path I just took.
I assume its not meant to work like that ... but maybe it is :-)
Neil
Last edited by ndoherty (05-29-2007 16:18:35)
Offline
Nick,
I PM's you last week on this. I think I have the same issue again - products showing up in categories because of the %like% search.
Can you check and confirm this is the case please - its urgent.
Basically I have the following category definitions - note I'm using category identifiers and not names.
MAIN mymain
CAT Level 2 mymain_SC1
CAT Level 3 mymain_SC1_A
CAT Level 3 mymain_SC1_B
CAT Level 2 mymain_SC2
CAT Level 3 mymain_SC2_A
CAT Level 3 mymain_SC2_B
If I add a Product and define the Related Categories as: mymain_SC2_A
The product is also showing in the:
mymain_SC2
category
Is this because of the naming and the "like" search?
Can I force search to be more strict?
Last edited by ndoherty (07-02-2007 18:26:55)
Offline
Yes, you are experiencing this issue due to your category naming. Instead of:
CAT Level 2 suspension_SCANIA
Do:
CAT Level 2 suspension_SCANIA_MAIN
All others are fine.
Offline
I had the same issue in regards to the category and "like" search.
I found the best way around it was to use a hyphen instead of an underscore. Therefore and alternate solution would be suspension-SCANIA.
You can quickly change all the underscores by exporting your category to a csv and do a find/replace in excel and import the new category listing.
Offline
Hi Nick,
This issue seems to be occuring again - but only for products which have a large amount of related categories.
So i just wanted to check something with you.
I have the following category definitions
FIRST ONE
CAT Level 1 firstonemain
CAT Level 2 firstone_SC1_main
CAT Level 3 firstone_SC1_A
CAT Level 3 firstone_SC1_B
SECOND ONE
CAT Level 1 secondonemain
CAT Level 2 secondone_SC2_main
CAT Level 3 secondone_SC2_A
CAT Level 3 secondone_SC2_B
I have added a product which appears in lots of subcats e.g.
secondone_SC2_A,secondone_SC2_B,secondone_SC2_C,secondone_SC2_D,secondone_SC2_E etc..
The problem is that the product is now appearing in firstone_SC1_A,firstone_SC1_B etc..
So is this back to the %LIKE% search ... because I though this only affected the main (upper level categories)?
Why does this only appear to happen with products with many related categories - and not products which only have one or two categories defined?
Hope you can help ... and I don't have to rename again!
Thanks
Offline
Ndoherty,
What is the exact names of the categories? When I had this , with the help of Dave, we noticed the underscore is acting as a "wildcard" and any term in between the underscores would be picked up in other categories with the same sequence (ie SC2).
As mentioned above, I think the best way to assure everything works the way you want is to rename the categories with a hyphen in place of the underscores. I had roughly 100 categories and it took me a minute to make the change in excel and upload them too CCP.
Offline