Forums / Basic Configuration / Bulk edit on "Yes Always Free Shipping"

Bulk edit on "Yes Always Free Shipping"

Views: 1,705

Results 1 to 6 of 6
3 May 2012, 7:05 PM
#1
retailproductsgroup avatar

retailproductsgroup

New Zenner

Join Date:
Apr 2008
Location:
NJ
Posts:
29
Plugin Contributions:
0

Bulk edit on "Yes Always Free Shipping"

Hi everyone,

I need to change all my greeting cards (only) to "Yes Always Free Shipping".

Is their a line of code that I can use and enter into the SQL Query Executor

Please see image attached.

There are several hundred cards and this would be a big help.

Thanks...:)
Garry
http://treefreegreetingcards.com/

Attachment 10408

4 May 2012, 1:08 PM
#2
retailproductsgroup avatar

retailproductsgroup

New Zenner

Join Date:
Apr 2008
Location:
NJ
Posts:
29
Plugin Contributions:
0

Re: Bulk edit on "Yes Always Free Shipping"

anyone?

4 May 2012, 1:20 PM
#3
ajeh avatar

ajeh

Oba-san

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

Re: Bulk edit on "Yes Always Free Shipping"

If you want to change ALL Products in your database table:
products

to be Always Free Shipping, you can use this in the Tools ... Install SQL Patches ...

UPDATE products SET product_is_always_free_shipping = 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!

4 May 2012, 3:20 PM
#4
retailproductsgroup avatar

retailproductsgroup

New Zenner

Join Date:
Apr 2008
Location:
NJ
Posts:
29
Plugin Contributions:
0

Re: Bulk edit on "Yes Always Free Shipping"

Ajeh:

If you want to change ALL Products in your database table:
products

to be Always Free Shipping, you can use this in the Tools ... Install SQL Patches ...

UPDATE products SET product_is_always_free_shipping = 1;


Thank you but......i only need to do it for the greeting cards.

There are other products/categories which I don't want to change

Can we do for specific categories?

I appreciate your help on this...:)

Garry
<http://treefreegreetingcards.com/>
4 May 2012, 9:30 PM
#5
retailproductsgroup avatar

retailproductsgroup

New Zenner

Join Date:
Apr 2008
Location:
NJ
Posts:
29
Plugin Contributions:
0

Re: Bulk edit on "Yes Always Free Shipping"

OK.....I was able to get it done with the Apsona addon.

Thanks!

4 May 2012, 9:33 PM
#6
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,185
Plugin Contributions:
0

Re: Bulk edit on "Yes Always Free Shipping"

Ty for posting back the solution on your problem ..

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.

Zen Cart Certified hosting at myZenCartHost.com.