Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2009
    Posts
    28
    Plugin Contributions
    0

    Default Can I set all products "Always Free Shipping"?

    Hey Guys,
    I want to set all products "Always Free Shipping" but it seems I need to edit these products one by one.
    Is there any way to complete it all?
    I've google it, and I followed one of the instruction:

    In my zen cart admin go to Tools -> Install SQL Patches

    Copy and pate the sql code with my added category ID number into the box and click on the “send” button.

    "UPDATE products SET product_is_always_free_shipping = 1 WHERE master_categories_id = xx;"

    But it NOT working for me. Anybody has better idea?
    Thanks a lot!

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

    Default Re: How to set all products "Always Free Shipping"?

    If you want ALL Products to be Always Free Shipping, use:
    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!

  3. #3
    Join Date
    Jul 2009
    Posts
    28
    Plugin Contributions
    0

    Default Re: How to set all products "Always Free Shipping"?

    Quote Originally Posted by Ajeh View Post
    If you want ALL Products to be Always Free Shipping, use:
    Code:
    UPDATE products SET product_is_always_free_shipping = 1;
    Cool, that works.
    Thank you very much.
    But what's wrong with previous code? What if I want only one category "Free Shipping"?
    Maybe I just need to change the category number?

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

    Default Re: Can I set all products "Always Free Shipping"?

    You needed to change the code for each master_categories_id ... but since you wanted ALL Products changed, you did not need the WHERE statement on it ...

    Thanks for the update that this worked for you ...
    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!

  5. #5
    Join Date
    May 2012
    Posts
    564
    Plugin Contributions
    0

    Default Re: How to set all products "Always Free Shipping"?

    Quote Originally Posted by Ajeh View Post
    If you want ALL Products to be Always Free Shipping, use:
    Code:
    UPDATE products SET product_is_always_free_shipping = 1;
    Where do I put this line of code?

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

    Default Re: How to set all products "Always Free Shipping"?

    Go to the Tools ... Install SQL Patches ... and paste that in there and hit SEND ...
    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!

 

 

Similar Threads

  1. v151 Visually Highlight/Flag "Always Free Shipping" products in the shopping cart
    By DivaVocals in forum Templates, Stylesheets, Page Layout
    Replies: 13
    Last Post: 18 Jun 2014, 08:22 AM
  2. Add "| Free Shipping" to the end of all products/categories Meta Titles?
    By bi11i in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 3 Oct 2013, 08:36 PM
  3. 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
  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. Want to use "Always Free Shipping Products"
    By awaes786 in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 8 Jun 2008, 05:39 PM

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