Virtual Product

[honrheart]

Well I've fixed part of my problem and I hope you can help me with the other part. My store only has Virtual products so I manually have to change two settings on the store or my customers run into problems checking out. These two settings are:

Product is Virtual: Yes, Skip Shipping Address No, Shipping Address Required (I have to change it from No to Yes)
Always Free Shipping: Yes, Always Free Shipping No, Normal Shipping Rules (Change from No to Yes)

My questions are:

1) is there a way to change the settings to where they are default to yes instead of no
2) is there a mysql code to change all the products in store to this setting or will I need to go in and manually change each product to yes for both settings.

[lat9]

1) is there a way to change the settings to where they are default to yes instead of no

Go to your admin's Catalog->Product Types. Select the product type (most likely Product - General) using the "Info" icon, then click the "Edit Layout" button. The bottom of the screen contains the default attribute properties when you're creating a new product.

[honrheart]

ty that fixed it for any new products. Now I just need to find out if there is away to set all current products to yes for both options with one shot or if I have to manually edit each product

[lat9]

Be sure to make a backup of your database first ... you can run this in your admin's Tools->Install SQL Patches:

UPDATE products SET products_virtual=1, product_is_always_free_shipping=0;

Note that this sets the "Always Free Shipping" to "No, normal shipping rules apply" ... which is the suggested value for virtual products.