I am working on one website multiple stores.My issue is when i search from frontend with one store then other store products also coming.
For the Sports Store you have to disable all music products from product grid and for the music store you have to disable all sports products. you can do it from product Grid.
Admin > Catalog > Manage Products
Choose Store View : Sports Store And select All Music Store Products if there and from mass action select Change Status to Disable.
Choose Store View : Music store And select All Sports Store Products if there and from mass action select Change Status to Disable.
Once all done do the Re-Indexing for all.
I am having the same issue. So far I am able to do this at the website level but not at the store level.
You might want to try out the visibility option which is at the store view level:
This is only in theory, I have not tested. For e.g.
Product A and Product B Store A and Store B
Store A -> Product A [Visibility: Catalog, Search]
Store B -> Product A [Visibility: Not Visible Individually]
Store A -> Product B [Visibility: Not Visible Individually]
Store B -> Product B [Visibility: Catalog, Search]