close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Need help with Categories and Sub Categories

Thread began 3/30/2009 12:37 pm by wrigleydon259291 | Last modified 5/24/2010 2:06 pm by anonymous | 1630 views | 6 replies |

wrigleydon259291

Need help with Categories and Sub Categories

Hi, I am very new to PHP and ecart. I am constructing the database stucture within phpmyadmin.

I am currently trying to add subcategories to exisitng product categories and I'm completely confussed about the best and most simple way to do this ie:

Category - subcategory - further subcategory - list of products

I have my 'itemcategory' table setup on my database which has my main category ID and Names listed. I just really need to know the direction to go for adding the subcategories. Would I need to create a new table for these subcats? or would I create a new field within the 'itemcategory' table?

I would be most grateful if someone could help me solve this or point me in the right direction. Many thanks.

Sign in to reply to this post

Ray BorduinWebAssist

You could do either. You could use a parentCategoryId or a separate table. It really depends on the final requirements of the solution you are creating... just one level of subcategories? or do you want to support:


Category - subcategory - further subcategory - further subcategory - further subcategory - list of products

Really there isn't a right way or a wrong way. Each would have pros and cons.

Sign in to reply to this post

wrigd

Hi Ray, thanks for your response. I would definately prefer to have the : Category - subcategory - further subcategory - further subcategory - further subcategory - list of products, solution. What would you recommend as the best way to set this up. Many thanks.

Sign in to reply to this post

Ray BorduinWebAssist

Add a categoryParent field to the category table. Set it to zero for main level categories, and set the categoryID to subCategories.... then you need to ask yourself do all subcategories exist in only one category?

That would of course also effect your database structure... but you don't want to make things so complex that you go over your head, so consider carefully.

If you did want subcategories to exist within different subcategories, or products to exist within different subcategories.. these decisions would go into how you would structure your database.

For instance if products could exist in more than one category, then you wouldn't have a categoryID as part of the product, instead you would have a productCategories table that included the categoryID and the productID so that one product could be listed in more than one category.

Similarly if you had more than one parent category for a subcategory, then you would not add the parentID to the category table and instead you would create a parentCategory table with the parentCategoryID and childCategoryID so that those too could exist in more than one structure. But of course these things will all complicate the creation of the administrative section to update the necessary information properly and easily.

Sign in to reply to this post

KJT

I am also very new to PHP and I bought Powerstore. I would like to admend everything - database, admin and store to allow for the following:

Category - subcategory - list of products

So I would eventually like to have four main product catergories, then within these subcategories and then list of products:
Eg. Automotive - Air Flow Meter - Honda Air Flow Meter for Model4858
- Jaguar Air Flow Meter for Model5749
Marine -Motor Boat Engines - Model blah
- Model blahblah

I tried adding a subcategory name to the productcategories database in phpmyadmin but I don't know if I did it correctly or how to admend the template/information in powerstore to allow for the change in the database. Now I end up with errors when you try to add a category name and subcatgory on the admin productcategories insert page, so I have def done something wrong!

This is how my database looks since I changed it:

CategoryID int(11) No auto_increment
CategoryName varchar(50) latin1_german2_ci No
SubCategoryName varchar(50) latin1_german2_ci No

This is all new to me and hence the reason I bought Powerstore but I really need the subcategory feature due to the amount of very different product lines we hold. I hope that you can help me in this matter.

I can give you a link to my site so far if that helps?

Sign in to reply to this post

anonymous

Need Categories to display down side of page

Hi I'm hoping you can help with this - im trying to dsplay categories down the right side of the page, and i see from another user that webassist could provide some code to enable this - this site has been able to receive code for this www.glitz.co.nz/
I would like to do the same thing, and im a newbie. Would you be able to provide code to olist catagories down the side bar for me

Sign in to reply to this post

anonymous

Catagories listed in Sidebar

--------------------------------------------------------------------------------

Hi I'm hoping you can help with this - im trying to dsplay categories down the right side of the page, and i see from another user that webassist could provide some code to enable this - this site has been able to receive code for this www.glitz.co.nz/
I would like to do the same thing, and im a newbie. Would you be able to provide code to olist catagories down the side bar for me

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...