Forums / Setting Up Categories, Products, Attributes / Mass edit products to become virtual.

Mass edit products to become virtual.

Locked

Results 1 to 7 of 7

This thread is locked. New replies are disabled.

20 Aug 2010, 10:50 PM

nikwilliamson

New Zenner

Join Date:: Aug 2010
Posts:: 9
Plugin Contributions:: 0

Mass edit products to become virtual.

Hi. so I have set up a store selling images. I didn't realize that I could bypass shipping information by making my products virtual. Is there a way to convert all of my products to virtual at the same time? Thank's.

21 Aug 2010, 2:36 AM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Mass edit products to become virtual.

If your Products are all Downloads ... if setup correctly, then there is no shipping ...

Are your images that you sell all Downloads?

22 Aug 2010, 3:59 AM

nikwilliamson

New Zenner

Join Date:: Aug 2010
Posts:: 9
Plugin Contributions:: 0

Re: Mass edit products to become virtual.

Posted via Mobile Device

22 Aug 2010, 4:00 AM

nikwilliamson

New Zenner

Join Date:: Aug 2010
Posts:: 9
Plugin Contributions:: 0

Re: Mass edit products to become virtual.

No. I need to make them virtual. What is the fastest way to do it?
Posted via Mobile Device

22 Aug 2010, 2:20 PM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Mass edit products to become virtual.

Backup your database ... the you can run this SQL in the Tools ... Install SQL Patches ... to change ALL Products on your site to be Virtual ...

UPDATE products SET products_virtual = 1;

23 Aug 2010, 11:52 PM

nikwilliamson

New Zenner

Join Date:: Aug 2010
Posts:: 9
Plugin Contributions:: 0

Re: Mass edit products to become virtual.

I love you. Really. I do.

24 Aug 2010, 2:22 AM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Mass edit products to become virtual.

Glad that this worked for you ... it can be a real time saver ... :cool: