Kryptronic Software Support Forum

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.

#1 04-28-2007 18:28:18

bobbyd
Member
Registered: 04-13-2007
Posts: 10

Help removing "items" in main categories

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

 

#2 05-01-2007 11:54:44

bobbyd
Member
Registered: 04-13-2007
Posts: 10

Re: Help removing "items" in main categories

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

 

#3 05-01-2007 12:23:24

slydog
Member
Registered: 05-21-2006
Posts: 694

Re: Help removing "items" in main categories

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

 

#4 05-01-2007 20:54:54

bobbyd
Member
Registered: 04-13-2007
Posts: 10

Re: Help removing "items" in main categories

Thanks slydog.  I will give that a go and see how it works.

Offline

 

#5 05-01-2007 21:17:08

bobbyd
Member
Registered: 04-13-2007
Posts: 10

Re: Help removing "items" in main categories

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

 

#6 05-01-2007 22:16:02

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Help removing "items" in main categories

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

 

#7 05-01-2007 22:26:24

slydog
Member
Registered: 05-21-2006
Posts: 694

Re: Help removing "items" in main categories

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

 

#8 05-01-2007 22:54:22

Litemaster
Member
From: Plymouth, Devon, UK
Registered: 12-03-2005
Posts: 147
Website

Re: Help removing "items" in main categories

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

 

#9 05-03-2007 00:24:53

bobbyd
Member
Registered: 04-13-2007
Posts: 10

Re: Help removing "items" in main categories

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

 

#10 05-21-2007 09:28:16

ndoherty
Member
Registered: 06-13-2006
Posts: 95

Re: Help removing "items" in main categories

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

 

#11 05-21-2007 18:57:22

ndoherty
Member
Registered: 06-13-2006
Posts: 95

Re: Help removing "items" in main categories

Bump - really need some advice on this please.

Anyone had the same issue?

Thanks.

Offline

 

#12 05-22-2007 09:24:22

bobbyd
Member
Registered: 04-13-2007
Posts: 10

Re: Help removing "items" in main categories

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

 

#13 05-22-2007 10:05:15

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19970
Website

Re: Help removing "items" in main categories

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'.


Nick Hendler

Offline

 

#14 05-22-2007 12:34:57

ndoherty
Member
Registered: 06-13-2006
Posts: 95

Re: Help removing "items" in main categories

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

 

#15 05-22-2007 13:07:13

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19970
Website

Re: Help removing "items" in main categories

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.


Nick Hendler

Offline

 

#16 05-22-2007 19:05:20

ndoherty
Member
Registered: 06-13-2006
Posts: 95

Re: Help removing "items" in main categories

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

 

#17 05-23-2007 08:35:53

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19970
Website

Re: Help removing "items" in main categories

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.


Nick Hendler

Offline

 

#18 05-24-2007 13:37:09

ndoherty
Member
Registered: 06-13-2006
Posts: 95

Re: Help removing "items" in main categories

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

 

#19 05-25-2007 11:32:17

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19970
Website

Re: Help removing "items" in main categories

First, by relatively small I mean around 200 or less.

Second, breadcrumbs are supposed to show the path you took.  Remember Hansel and Gretel?


Nick Hendler

Offline

 

#20 07-02-2007 09:30:50

ndoherty
Member
Registered: 06-13-2006
Posts: 95

Re: Help removing "items" in main categories

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

 

#21 07-02-2007 09:34:02

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19970
Website

Re: Help removing "items" in main categories

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.


Nick Hendler

Offline

 

#22 07-02-2007 12:30:25

sppars
Member
Registered: 01-25-2006
Posts: 301

Re: Help removing "items" in main categories

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

 

#23 07-19-2007 09:58:54

ndoherty
Member
Registered: 06-13-2006
Posts: 95

Re: Help removing "items" in main categories

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

 

#24 07-19-2007 15:15:28

sppars
Member
Registered: 01-25-2006
Posts: 301

Re: Help removing "items" in main categories

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

 

Board footer