I need to remove some of my products from one a single website and it's store view. How do I do this, without ending up deleting it from all all stores?
The product-website association is kept in the table
If you have the product ids you can remove them fast from a specific website by running the query
DELETE FROM catalog_product_website WHERE product_id IN (your product ids here separated by comma) AND website_id = website_id_here
When you are done, rebuild your indexes.
If you don't want to touch the database you can do it via code like this:
$productIds = array(...your product ids here...); $websiteId = your website id here Mage::getModel('catalog/product_website')->removeProducts(array($websiteId), $productIds);