To set a product to freight, go to the “Shipping” tab and set “Freight” to yes:

When only freight items are in the cart or “Disable all other rates when freight products in cart” is set to “Yes”:

When freight and non-freight items are in the cart and “Disable all other rates when freight products in cart” is set to “No”: