Automatic Free Shipping for certain items/categories?

[Ajeh]

You would need to write something to identify how many products are in the cart from that category and reduce the weight by that amount before the shipping quotes are made ...

There is nothing built into Zen Cart for this, other than to mark the products as Always Free Shipping if you mean for those to be Free Shipping regardless of the amount of the order ...

You could run an update on the products table for the always free shipping based on the master categories id, if that is the case ...

[jgdovin]

That sounds like the perfect idea. Im sure its out there and will search but if you know it off the top of your head, what tables would i need to look at, im sure there will need to be some manipulation to compare a couple tables together to get the master categorie id for the product and to change the always free shipping flag.

[Ajeh]

The master_categories_id is stored in the products table ...

Which "perfect idea" do you want to use?

[jgdovin]

Sorry, the idea of doing a mass update by master_categories_id to update to always free shipping.

[Ajeh]

UPDATE products SET product_is_always_free_shipping = 1 WHERE master_categories_id = XXX;

using your Master Categories ID for XXX ...

NOTE: backup your database before doing this ...