Remove Shipping when you are over weight?

[Trurb]

Hi Guys,

Are there any way you can remove the shipping field when you go over a weight.

Ex.

I have put max 50 Kg to be shiped.
I have a product on 190 kg, so when the customer wants to buy it, it should only be walk in, or call for shipping.

But it says:
Walk in
and
Post Danmark (5 x 41.80kg).

Some one have a idea to change this?
It should only be from 50 kg and up, all others can be shiped.

Thx.

[Ajeh]

What happens if the customer buys 10 Products that take the weight over 50kg ... can that be shipped?

[Trurb]

Good point Ajeh :)

Okay, lets say over 100 Kg.

Things like small lawn mower and so can be shippede to a okay price, but tractors and ATV are too expenciv to send.

But is it possible?

[Ajeh]

Since it isn't really the weight so much as the Product itself you might want to add a new field to the products table such as:
products_storepickup_only

That can be set on your Products that are only for Store Pickup and then you can use that field to test the contents of the cart and disable shipping module(s) as needed ...

[Trurb]

thats right Ajeh :) thx
But where do i edit the products table? have look around for it, also google, mabye its just me theres blind

[Ajeh]

The products table is in your database ...

Your database can be accessed via phpMyAdmin that should be available in the control panel for your site ...

NOTE: Adding the new field to the table products also would need to have code added to the admin files for adding/editing the Products to be able to access this field ...