I need to set a flat rate for one item.

How do i set a flat rate for one item? I sell a table which costs $140 to ship but the only module i have is set for UPS and comes up as $39.00.. So you can see my problem. I want a customer to put this item in the shopping cart and the only option to come up is LOCAL PICKUP for free or FREIGHT SHIPPING for $140.

Any ideas?

Bump. Thank you all.

This might sound silly, but maybe you can increase the item weight until the right shipping cost comes up in the UPS module.

I tried. I set them at 400 pounds and it should work, but it comes up blank without the UPS module. This would be great, if it showed up.

Also, if someone suggests to set the modules -> shipping -> max. weight to a higher setting, i set it to 1,000 pounds and it still doesnt show

I think you can check the shopping cart to see how many of a Product is in it with one of the functions from the shopping_cart class.

$_SESSION['cart']->in_cart_check('products_quantity') should return how many are in there, but check the syntax for this.

Once you know the quantity, you should be able to add that quantity * 140 to the USPS charge(s).