Products Price Manager Dissapearing from some items will not diplay those items

I was an upgrade from v 1.3.8a we upgraded over a year ago

Are you using those categories_id that you see listed?

If so, were any of the Products that had the missing products_type in those Categories?

Ajeh:

Are you using those categories_id that you see listed?

If so, were any of the Products that had the missing products_type in those Categories?

How do I find out the name of the categories id, like these numbers, 62,63,65,70,74,75,76,132,133,134,135,136,137,138 cause those were in the table, ho do i know the what the categories id is for the items with the problem>? I see each item has a product id, but how do i see their category id? look at the category and read what the id says next to it>? What if the item is cross listed? go by the master or?

All valid categories_id will be in the tables:
categories
categories_description

All Products would have a reference in the table:
products_to_categories

If you use Linked Products, then you will see multiple categories_id for the products_id ...

I am just trying to see if you have any bad data in the tables ...

As you say you only use Product - General, I am trying to determine if those categories_id that you see in the table:
product_types_to_category

are there because of old data that was never cleaned up or if you have set up some of your Categories to only hold Products - General Products in them ... what that means is if you were in the Category with one of the categories_id listed, in the dropdown, you would only see the Products - General and not the other Product Types ...

More or less, I am trying to hunt for clues here as to the possible cause or your issue of have found those 5 Products with products_type set to 0 ...

Ajeh:

All valid categories_id will be in the tables:
categories
categories_description

All Products would have a reference in the table:
products_to_categories

If you use Linked Products, then you will see multiple categories_id for the products_id ...

I am just trying to see if you have any bad data in the tables ...

As you say you only use Product - General, I am trying to determine if those categories_id that you see in the table:
product_types_to_category

are there because of old data that was never cleaned up or if you have set up some of your Categories to only hold Products - General Products in them ... what that means is if you were in the Category with one of the categories_id listed, in the dropdown, you would only see the Products - General and not the other Product Types ...

More or less, I am trying to hunt for clues here as to the possible cause or your issue of have found those 5 Products with products_type set to 0 ...

ok i just checked 3 of the bad products, and their master category is not the same as any in that table i gave you.

Are you able to browse the table:
categories_description

and if you sort on:
categories_id

to you see any Categories that you are actually using that are in that table?

Another way to test is go to your Catalog (Store) and try them:
your_domain_name.com/index.php?main_page=index&cPath=XXX

where you just change the XXX to each of those categories_id and see what comes up ...

Ajeh:

Are you able to browse the table:
categories_description

and if you sort on:
categories_id

to you see any Categories that you are actually using that are in that table?

Another way to test is go to your Catalog (Store) and try them:
your_domain_name.com/index.php?main_page=index&cPath=XXX

where you just change the XXX to each of those categories_id and see what comes up ...
I looked in the table and it looks like they are all being used except for 5 of them i cant find

WiccanWitch420:

I looked in the table and it looks like they are all being used except for 5 of them i cant find

63,62,74,75,76 cannot find, not being used. But all the products that originally had a problem, none of them were ones in this table or anything

Now that all are fixed, you can try working with your Products and pay attention to any that lose the green $ for Products Price Manager to see if there is any pattern or something that can help reproduce this issue ...

I still have not been able to reproduce the problem ...

Ajeh:

Now that all are fixed, you can try working with your Products and pay attention to any that lose the green $ for Products Price Manager to see if there is any pattern or something that can help reproduce this issue ...

I still have not been able to reproduce the problem ...

I found out what it was, and it was when going to a product through the products with prducts with attributes module, and then editing the item it will create this error. Thank you for the help.