additional product category

[turk361661]

I have product that has the following parameters:
It must belong to 1 of 5 categories either ABCD or E.
It may also belong to a sub category of F or G or none.

I'm using DataAssist Wizard to create the Admin pages. When the user clicks on Insert product page I want them to be able to Insert a new product, select a category (ABCD or E) and then select a subcategory (F or G or none).

Should I create an additional table in the ecommerce database similar to "productcategories" and call it productSUBcategories?
Or would the "productoptions" table be better at handling this structure/releationship.
Can you please advise or offer any insight? If you have any tutorials/examples using the ecommerce database that might be helpful too.

Thanks,
Danielle

[Jason Byrnes]

yes, you would want to create a new sub categories table to associate the product to subcategories.

[turk361661]

Hi Jason,

Thanks for the advice. I created my additional subcategory table.

Out of pure curiosity can you explain or give me an example of when the "productoptions" table would be useful.

Thanks again for the advice.

[turk361661]

If you can point me to a tutorial which discusses using the productoption table, that would also be great. I see a couple on the forums mention the tutorial but I could not find the link.

Thanks again for the help,
Danielle

[Jason Byrnes]

On the eCart support page is the link to the product options tutorial:
http://www.webassist.com/support/ecart/how-tos/product_options.php