Items disappearing from categories

[Ajeh]

This was a clean install with an imported database. All items are manually entered (after the database install).

When you import all those Products ...

If you look in the products table via phpMyAdmin, are you missing the:
master_categories_id
products_price_sorter

Most importers have the master_categories_id set to 0 ...

This could be contributing to your problems ...



On the images ... if you look at the 3rd product down ... start with:
015

and end in:
.JPG

this means that this Product "owns" all images that start with:
015

and end in:
.JPG

so whether or not you mean for it to have multiple image, you have images that match this pattern ... so instead of seeing 1 image you see two:
/images/015%20(2).JPG
/images/015%20(4).JPG

NOTE: it would be a good idea not to use spaces, special characters etc. in the filenames ...

[sports guy]

Ajeh,

In phpMyAdmin under the "products: table structure I do see:
master_categories_id
products_price_sorter

The default for master_categories_id is set to 0 and the default for products_price_sorter is set to: 0.0000.

Should I change the defaults to something else or leave them as is?

The image naming is a huge problem I can already see. That might be causing lots of these issues. I can see that their camera is using the same image names over and over. I will have to correct this soon. Thank you I think we are getting to the bottom of this now!

[Ajeh]

I am not asking about the table structure ...

I am asking about the data in the table for each Product that you see when you browse the table ...

Do you see the field:
master_categories_id

set to 0 on your Products if you browse the table?

NOTE: a quick way to do this is to Browse the table then click on the fieldname:
master_categories_id

so it sorts it for you and then you can see if there are master_categories_id set to 0 ...

Also check the products_price_sorter as this field should be the lowest Price available for your Products and not 0.00 ...

[sports guy]

I hope I am doing this right.

In phpMyAdmin I clicked on the products field and then I was able to see many of my products. I scrolled over to the: master_categories_id and looked down the column. Every product had a number other than 0 (except for one product that had a 0). If I click on the master_categories_id it then organized all products according to this number. Only one product has a zero (all others have a number other than zero). It is this product: Pink with Gold Chains Silk Belt

Do I need to change this?

[Ajeh]

You should fix that one to have a valid master_categories_id ...

The master_categories_id is either the only Category that it is in or the "main" Category, if it belongs to more than 1 Category ...

[sports guy]

Ok that was easy. Done!