Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    62
    Plugin Contributions
    0

    Default Changing shipping settings of all products using SQL

    I found a solution for product quantity boxes here.

    It worked well for me. I was wondering if there was an sql script to change the shipping for all of my products. I want to change all of my product's Always Free Shipping in the Product Admin to No.

    Thanks

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

    Default Re: Changing shipping settings of all products using SQL

    You could run in the Tools ... Install SQL Patches ...
    UPDATE products SET product_is_always_free_shipping = 0;
    NOTE: you should always backup your database before running things 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: 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
    Jan 2012
    Posts
    62
    Plugin Contributions
    0

    Default Re: Changing shipping settings of all products using SQL

    Worked great.

    Thank you sir!

    BTW is there a Zen Cart SQL guide/ wiki anywhere?

 

 

Similar Threads

  1. Adding an attribute to all products using SQL command?
    By arniesbarmyarmy in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 20 Oct 2009, 03:47 AM
  2. Linking Products using a SQL script
    By guzzer in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 11 Oct 2009, 08:19 PM
  3. SQL for changing all products' prices?
    By dinki in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 18 Jun 2009, 06:31 PM
  4. changing "Products Shipping Weight" for all
    By pglenn in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 25 Jan 2009, 07:20 PM
  5. Replies: 2
    Last Post: 8 Jan 2009, 01:00 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