Changing shipping method

**scottb** · 6 Mar 2007, 09:57 PM

Hello,

I have a cart with over 1,200 products in it. I use the three different shipping methods now.

I wish to convert everything to free shipping.

What table and field do I run an SQL query to convert all products to free shipping and what do I need to set the value too?

1.3.6

**scottb** · 8 Mar 2007, 02:55 PM

Maybe I am missing it, but I can't find the table and field that sets the shipping method for a product.

**Ajeh** · 8 Mar 2007, 03:04 PM

In the products table you could use either:
products_weight
0 weight where 0 weight is set to Free Shipping in the Shipping/Packaging

Or, you could use the field:
product_is_free

where setting this to 1 means Free Shipping ...

Be sure to install the Shipping Module Free Shipping freeshipper to use either method ...