Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2008
    Location
    NJ
    Posts
    33
    Plugin Contributions
    0

    Default 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/

    Name:  zen_forums.jpg
Views: 271
Size:  29.1 KB

  2. #2
    Join Date
    Apr 2008
    Location
    NJ
    Posts
    33
    Plugin Contributions
    0

    Default Re: Bulk edit on "Yes Always Free Shipping"

    anyone?

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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 ...
    Code:
    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: v1.5.5]
    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. #4
    Join Date
    Apr 2008
    Location
    NJ
    Posts
    33
    Plugin Contributions
    0

    Default Re: Bulk edit on "Yes Always Free Shipping"

    Quote Originally Posted by Ajeh View Post
    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 ...
    Code:
    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/

  5. #5
    Join Date
    Apr 2008
    Location
    NJ
    Posts
    33
    Plugin Contributions
    0

    Default Re: Bulk edit on "Yes Always Free Shipping"

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

    Thanks!

  6. #6
    Join Date
    Apr 2006
    Location
    Ohio
    Posts
    6,162
    Plugin Contributions
    0

    Default Re: Bulk edit on "Yes Always Free Shipping"

    Ty for posting back the solution on your problem ..
    Mark
    Hare Do

 

 

Similar Threads

  1. v139h Free shipping to just 1 country using free shipper and Yes, Always Free Shipping
    By boomy in forum Built-in Shipping and Payment Modules
    Replies: 9
    Last Post: 20 Oct 2014, 01:43 AM
  2. v150 "Always free shipping" becomes "not possible"
    By kalastaja in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 8 Mar 2013, 08:00 PM
  3. v139h Can I set all products "Always Free Shipping"?
    By zihaizi in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 12 Jul 2012, 02:12 PM
  4. "Always free shipping " option is change all item free shipping?
    By als88 in forum Built-in Shipping and Payment Modules
    Replies: 12
    Last Post: 23 Oct 2009, 04:32 AM
  5. "Yes, Always free shipping" Clarify, please.
    By wewuvanimals.com in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 22 Oct 2007, 04:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR