I have entered about 600 items by hand using the duplicate function from a pattern item. I have found that not all items have had a products_to_categories created for it.... this seems to have happened in groupings of items done one after the next? The items show up on the new items but I don't believe they show up on searches or anywhere else. Not sure how to reproduce this issue.