any easy way to change all products to free shipping?

is there any easy way to change all products to free shipping ?? i only have 400+ so not actually that many.. :(

could i change the product catagories type to free shipping then re up load them using easy populate?? :wacko:

Probably the "easiest" way would be a mySQL statement run from your webmaster panel (outside Zen Cart). I'm not sure if there's only one field to update or not.

afo:

Probably the "easiest" way would be a mySQL statement run from your webmaster panel (outside Zen Cart). I'm not sure if there's only one field to update or not.

:clap: i found a way to do it using easy populate!...

go to your admin screen then configuration / easy populate

it has a box at the bottom that says "custom Product Fields" if you insert "product_is_always_free_shipping" or what every other field you want to mass change.

then download, edit , upload! ... seemed to work for me! :clap:

Access the db using phpMyAdmin, go to the Products table, and edit the "product_is_always_free_shipping" from 0 to 1.

Vger

Vger:

Access the db using phpMyAdmin, go to the Products table, and edit the "product_is_always_free_shipping" from 0 to 1.

Vger

yeah but does that mean that you have to do each and every item?? which is ok if you only have a few! i did it that way to check that easy pop was downloading the correct field! then just mass changed in excel
:cool:

An alternative is to set up Free Shipping for all products with zero weight, and then run this SQL command via phpMyAdmin

UPDATE products SET products_weight="0";

This will set all product weights to zero and, in conjunction with allow free shipping for all products with zero weight, remove the shipping charge for all products.

Before running any SQL commands always download a backup of your db.

Vger