Zen Follower
- Join Date:
- Apr 2012
- Posts:
- 127
- Plugin Contributions:
- 0
Changing products to 'virtual' en-masse
I have some questions posted today regarding issues with PP express & 'blank address' errors when my customers try to checkout.
I would like to use Dr. Byte's fix shown here:
http://www.zen-cart.com/showthread.php?190388-PayPal-has-unexpectedly-returned-a-blank-address&p=1093291#post1093291
Is there an SQL patch that I can use to mass change my products to 'virtual'? I have 700+ products and I *reeeeally *don't want to click through them all one at a time.
I don't know if I need to change the 'free shipping' option, too... right now my products are set to this:
virtual->NO, shipping address required
free shipping->NO, normal shipping rules
I only sell digital downloads and maybe 5 gift certificates.
ANYWAY, thanks in advance for any/all help! :D