Help: Invalid Master Category

[Rebecca Lynn]

when I link a product to a another category I don't get master category in the dropdown menu instead I get invalid master category. I am using 1.3.6 I did not upgrade.. I use the admin area to add the products. When I delete the link it is back to normal..

I am not sure what to do any help would be great...

Rebecca

[Ajeh]

Did you ever have master_categories_id set in the products table?

Check your database via phpMyAdmin and browse the products table ...

Do you see the master_categories_id with blank or 0 ... or do you see a value in it?

NOTE: A lot of sites that use Import programs do not have this set ...

This can be fixed but it helps to have a bit more detail on how you add your products to start with ...

[Rebecca Lynn]

I do not use any import programs. When adding a new product I go to admin catergory/product and add them that way.

I went to my phpMyAdmin and went to products clicked on browse and where it says master_categories_id it has different numbers in the table.

[Ajeh]

I am not picturing how you are getting this error ...

You are in a Category of Products and decide to Link a Product to another Category ...

You click Copy as Linked Product ...

You pick the Category to Copy it to ... as a Linked Product ...

You then do what to see that this is not working right?

[Rebecca Lynn]

What I am trying to do is have a sale on just one manufactor and when I link it to the manufactor own catergory where I can set it for the sale. I try to make it the master catergory but it want let me because in the drop down menu it has Invalid Master Category

[Ajeh]

When you are trying to change the master_categories_id ... you do not do this via an Edit of the Product ...

That only lets you change which one of a Product's "existing" Linked Categories is the Master Category ...

To change it to a Category that the Product is not already Linked to, you could use the Multiple Categories Link Manager that is shown when you hit C for Copy ...

This will let you manage the Categories that a Product belongs to ... it also lets you change which is the Master Category so that the master_categories_id is correct for sales and such ...

You can also get all the Products Linked to that new manufactuers category that you made and then, using the Multiple Categories Link Manager there is a setting for changing all products in a given Category to use that Category as the Master Categories ID ...

[Rebecca Lynn]

Thank you Thank you Thank you. I did it the way you said to and I got it..Thank you so much

[Ajeh]

You are most welcome ... glad that this helped you out ...

[tvadpro]

Maybe this is an Easy Populate question & I should post there -- I dunno.

I'm running ZC 1.3.7 with Easy Populate. Product 177 has master category 74 (Wooden playhouses), and is linked into category 73 (Driftwood 10x8 shed kit). The master and linked categories were originally 73 and 74, but I reversed them.

When viewing product 177 in the catalog, it still behaves as if its master category were 73.

See for yourselves: it's the Driftwood wooden playhouse.

Given its master category is now 74, I thought the breadcrumbs should look like

Home | Wooden playhouses | Driftwood wooden playhouse kit

instead of

Home | Shed kits | Driftwood 10x8 shed kit | Driftwood wooden playhouse kit

... and the return-to-product-list button should link to the master category (Wooden playhouses) instead of the linked category (Driftwood 10x8 shed kit).

I browsed zen_products and zen_products_to_categories, and 177 has 74 as its master in both (until I reset master category IDs).

Tried resetting master category IDs in Store Manager, but this changes 177's master category from 74 back to 73. Why does it do that? Is there another table identifying the master category as 73 -- one which is unaffected by changing the master category ID in the admin?

To add insult to confusion, I looked at Easy Populate in the admin. A warning notified me that 2 partially deleted products were found. Prompted me to for a click to clean up the dross; I obliged, it failed -- and suggested I look at the log in the uploads directory.

Am I overlooking something obvious?
Sean

[tvadpro]

No idea whether the master category ID glitch and the Easy Populate glitch are related, but I looked at the East Populate error log, and it specified two products_id values that turned up in the customers_basket_attributes and customers_basket tables. The error log recommended deleting these from the database, but I hesitate to delete anything without knowing whether doing so will cause other problems. Can anyone who is familiar with customers_basket and customers_basket_attributes tables comment?