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
    67,192
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  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
    67,192
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  5. #5
    Join Date
    May 2012
    Posts
    491
    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
    67,192
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

 

 

Similar Threads

  1. Free shipping on certain products
    By champpower in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 19 Sep 2010, 04:30 PM
  2. Replies: 5
    Last Post: 10 Sep 2010, 01:50 AM
  3. Can I add free-shipping images to products list and products detail page?
    By vanson in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 6 Feb 2010, 02:43 PM
  4. Free Shipping on just certain products
    By madmickc in forum Built-in Shipping and Payment Modules
    Replies: 13
    Last Post: 5 Sep 2008, 03:42 PM
  5. Strange Shipping with free and paid shipping products on same order
    By elvisanderson in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 22 Jul 2006, 10:36 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
  •