Forums / General Questions / Free Shipping for Multiple Products

Free Shipping for Multiple Products

Locked

Started by bgroup99 on 9 Nov 2006, 11:12 PM · Views: 1,354

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
9 Nov 2006, 11:12 PM
#1
bgroup99 avatar

bgroup99

Zen Follower

Join Date:
Aug 2006
Posts:
197
Plugin Contributions:
0

Free Shipping for Multiple Products

Hi,

I was wondering if there was a quick way to turn free shipping on for multiple products at once without having to go into each individual product and changing to free shipping.

In other words, is there a way I could make all the products on my ship for free temporarily?

Thanks!

10 Nov 2006, 4:25 AM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Free Shipping for Multiple Products

If you want every single product in your shop to have Free Shipping ...

Backup your database ...

Did you backup your database? :lamo:

Next, in the Tools ... Insert SQL Patch ... you can run the command:

UPDATE products SET product_is_always_free_shipping = 1;

Now every single product in your shop has Free Shipping ...

Be sure to turn on the Shipping Module Free Shipping freeshipper ... so that your checkout continues to work ...

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!

14 Nov 2006, 5:16 PM
#3
bgroup99 avatar

bgroup99

Zen Follower

Join Date:
Aug 2006
Posts:
197
Plugin Contributions:
0

Re: Free Shipping for Multiple Products

Thanks for the tip.:smile: Before I actually carry this out, will I be able to switch all my products back to regular shipping with a similar command?

15 Nov 2006, 4:44 AM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Free Shipping for Multiple Products

Set them to 0 instead and that Always Free Shipping is OFF for ALL products ...

NOTE: always backup before making changes like this ...

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!

15 Nov 2006, 10:19 PM
#5
bgroup99 avatar

bgroup99

Zen Follower

Join Date:
Aug 2006
Posts:
197
Plugin Contributions:
0

Re: Free Shipping for Multiple Products

Thanks, this worked like a charm :smile: