Error can not add product wrong product type

[cshart]

I have setup the database added lots of products, edited can move between folders, but can not add new product.

The error comes up in pink after you click new product and says "The pecified product type cannot be added to this category. The category in question can take products _ general and that is what it is setup for. But no matter what and I have tried to fixed the tables. I can not add a new product.

What to do to be able to add product to the category???


Thanks,
C

[DrByte]

1. Admin->Catalog->Product Types ... which product types are listed?
Have you made any changes to these settings anywhere? If so, what?
Have you deleted any of the defaults?

2. Admin->Catalog->Categories/Products ... edit the category you're getting the error with. Which categories does it show as restricted to (at bottom of category edit details)?

[Ajeh]

Could you check your product_types table via phpMyAdmin and post the settings that you have in there?

[cshart]

Could you check your product_types table via phpMyAdmin and post the settings that you have in there?

Product_types
Product-General product
Product-Music product_music
Document-General document_general
Document-Product document_product
Product-Free Shippping product_free_shipping

Attached find Product Type to Category which is making no sense at all to me. What is this suppose to have in it. This looks like it might be the problem.

Thanks,

C

[DrByte]

What is the structure of your product_types_to_category table ?

Is there an auto-increment on one of the fields? In this case, there should not be...

[Ajeh]

If I go to phpMyAdmin and browse the product_types table I see the following:

type_id type_name type_handler type_master_type allow_add_to_cart default_image date_added last_modified
1 Product - General product 1 Y 2006-09-20 22:32:57 2006-09-20 22:32:57
2 Product - Music product_music 1 Y 2006-09-20 22:32:57 2006-09-20 22:32:57
3 Document - General document_general 3 N 2006-09-20 22:32:57 2006-09-20 22:32:57
4 Document - Product document_product 3 N 2006-09-20 22:32:57 2006-09-21 17:02:52
5 Product - Free Shipping product_free_shipping 1 Y 2006-09-20 22:32:57 2006-09-20 22:32:57

What do you see?

[cshart]

What is the structure of your product_types_to_category table ?

Is there an auto-increment on one of the fields? In this case, there should not be...

There is no auto increment, but shouldn't the table consist of
product-general 's number and all the categories it has and the only other product type I am using is Document_Product.

So whatever number is applied to product_general in my case should be opposite all the catergories that are in that category

and

document-product has only two categories in it that would be Memberships and Donations.

So is there a way to edit this by hand to reflect what should really be there?

I do write my own tables and database driven sites so I am somewhat familiar with populating tables, but I am not sure in this case what numbers are applied to the product_type or categories. Where exactly would I find those???

Do only the main categories go in here or the sub categories also???

C

[DrByte]

In your product_types table, do you have only 5 records, or do you have 35 records? And what are they?

[DrByte]

As far as database-layout goes ...

*if* a category has a restriction enforcing only certain product-types to be allowed within in, *then* a record for that category and the prod-type-restriction should be in the product_type_to_category table.

[cshart]

In your product_types table, do you have only 5 records, or do you have 35 records? And what are they?

In my products types table I have 5 records in my products types to categories table I have 143 records and they seemed to be auto incremented even though auto increment is not turned on.

I only have 28 categories some of which are null. So it seems to be I should only have 38 product_type to categories entries.

Is that right??

C