Very strange databsae problem.

[chalfontgifts]

I have done a mod to import products and transfer pictures from a suppliers web site to my site. I am using 1.2.5 of zen, which before anyone say's something is being upgraded soon to 1.3.8a.

The problem I have is that out of the 1012 products that are in the feed, only 706 show up in the admin and the shop itself. The products that do show up, show correctly. When I started investigating this, thinking that it was a problem with the code I had written, it turned out that the missing products are present in the database. I cannot see any difference between the data of a product that does show in the shop, and a product that does not show in the shop.

Anybody every had an issue like this, or got any ideas of what could cause these not to show in the admin or the shop front.

Thanks for any help given,
Laurie

[DrByte]

You are probably missing products_to_categories table entries for those products which are not appearing anywhere.

Also worth noting is that you should never mix both products and sub-categories at the same level. v1.2 didn't enforce that, but v1.3 does.

[chalfontgifts]

Thanks for your response.

Checked the products to catagories entry and the entry for one of the many missing products is present and correct.

Any other ideas. Racking my brains over this one !!!!!!!!!!!

Regards
Laurie

[DrByte]

If your products are not showing in the list, then they're likely missing the master_categories_id.

The fast way to set that if your custom feed code doesn't already do it, is to use the Store Manager's "reset master categories ID" option to go through all your products and set a master categories id.

But before you do that, check that your data is intact:
- count of products table matches count of products_description table
- count of products table matches count of products_to_categories table
- each product in products table needs to have a non-zero products_type entry (you should be setting it to "1" if in doubt of what to put there)