How do I make a product available for pick-up Only?

I'm currently using Canada Post shipping module by zones for all products as well as the store pick up. However, there are certain products that I would like to make available only for pick up so that customers won't even have the option of selecting "shipping" when checking out.

What is the best way to do this?

Thanks!

Any help with this would be greatly appreciated.

You could build in to your shipping modules a test for these products in the cart and if they exist then disable the shipping module ...

Are these Products that are only Store Pickup all in 1 Category or a mix of Products?

I'm not sure I completely understand what you mean by that. Sorry, still new to this.

They're spread out in different categories.

You can test if a product is in the cart, for example, to see if products_id 12 is in the cart use either:
$chk_cart = $_SESSION['cart']->in_cart_check('products_id','12')
$chk_cart = $_SESSION['cart']->get_quantity('12');

If a product is in the cart, then you can disable a shipping module by setting the $this->enabled to false ...

I do not have the Canada Post module handy, but if you were using UPS, you could use, to disable it when products_id 12 or 37 are in the cart with the following change:

    // disable only when entire cart is free shipping
    if (zen_get_shipping_enabled($this->code)) {
      $this->enabled = ((MODULE_SHIPPING_UPS_STATUS == 'True') ? true : false);
    }

// bof: do not show if products_id 12 or 37 are in the cart
global $cart;
if (!IS_ADMIN_FLAG) {
  $chk_cart = 0;
  $chk_cart += $_SESSION['cart']->in_cart_check('products_id','12');
  $chk_cart += $_SESSION['cart']->in_cart_check('products_id','37');
  if ($chk_cart > 0) {
    $this->enabled = false;
  }
}
// eof: do not show if products_id 12 or 37 are in the cart

    if ($this->enabled) {