any easy way to change all products to free shipping?

**hungrytazman** · 22 Mar 2010, 08:19 PM

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??

**afo** · 24 Mar 2010, 03:34 PM

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.

**hungrytazman** · 7 Apr 2010, 10:23 PM

Originally Posted by 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.

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!

**Vger** · 8 Apr 2010, 05:49 PM

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

Vger

**hungrytazman** · 8 Apr 2010, 09:52 PM

Originally Posted by 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

**Vger** · 8 Apr 2010, 10:59 PM

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

Code:

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