Ok, so I used the the data import features and while building out the content in a spreadsheet, I assigned the category_ids based on the ID numbers from the categories. This allowed me to quickly categorize them prior to importing. After successfully importing the 800 or so products, from the admin tool Manage Categories, all seems well. Each of my categories has the correct products. Great…
Not so great… Although the backend seems to show that everything is in order, the frontend however is a very different story.
There are no products matching the selection.
Seems to be the party line. Now I created all these categories in the admin tool before importing. However, I wonder if there is some junction table thing that did not happen during import that makes this stuff work on the frontend.
Any ideas on how to get these to show up would be great. Again the backend seems to have everything in order, and all caching is off right now.
EDIT: just checked catalog_category_product, and it seems that the import did correctly create these records, so that is not it.