Mass edit products to become virtual.

20 Aug 2010, 10:50 PM

#1

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

#2

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?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

22 Aug 2010, 3:59 AM

#3

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

#4

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

#5

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;

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Aug 2010, 11:52 PM

#6

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

#7

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:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!