Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2009
    Location
    Barnsley, Yorkshire, England
    Posts
    8
    Plugin Contributions
    0

    Default any easy way to change all products to free shipping?

    is there any easy way to change all products to free shipping ?? i only have 400+ so not actually that many..

    could i change the product catagories type to free shipping then re up load them using easy populate??

  2. #2
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: any easy way to change all products to free?

    Probably the "easiest" way would be a mySQL statement run from your webmaster panel (outside Zen Cart). I'm not sure if there's only one field to update or not.
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

  3. #3
    Join Date
    Dec 2009
    Location
    Barnsley, Yorkshire, England
    Posts
    8
    Plugin Contributions
    0

    Default Re: any easy way to change all products to free?

    Quote Originally Posted by afo View Post
    Probably the "easiest" way would be a mySQL statement run from your webmaster panel (outside Zen Cart). I'm not sure if there's only one field to update or not.
    i found a way to do it using easy populate!...

    go to your admin screen then configuration / easy populate

    it has a box at the bottom that says "custom Product Fields" if you insert "product_is_always_free_shipping" or what every other field you want to mass change.

    then download, edit , upload! ... seemed to work for me!

  4. #4
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: any easy way to change all products to free?

    Access the db using phpMyAdmin, go to the Products table, and edit the "product_is_always_free_shipping" from 0 to 1.

    Vger

  5. #5
    Join Date
    Dec 2009
    Location
    Barnsley, Yorkshire, England
    Posts
    8
    Plugin Contributions
    0

    Default Re: any easy way to change all products to free?

    Quote Originally Posted by Vger View Post
    Access the db using phpMyAdmin, go to the Products table, and edit the "product_is_always_free_shipping" from 0 to 1.

    Vger
    yeah but does that mean that you have to do each and every item?? which is ok if you only have a few! i did it that way to check that easy pop was downloading the correct field! then just mass changed in excel

  6. #6
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: any easy way to change all products to free?

    An alternative is to set up Free Shipping for all products with zero weight, and then run this SQL command via phpMyAdmin

    Code:
    UPDATE products SET products_weight="0";
    This will set all product weights to zero and, in conjunction with allow free shipping for all products with zero weight, remove the shipping charge for all products.

    Before running any SQL commands always download a backup of your db.

    Vger

 

 

Similar Threads

  1. v139h Is there any way to batch all products types to documents?
    By gotyed in forum General Questions
    Replies: 5
    Last Post: 9 Mar 2012, 05:50 PM
  2. Any way to set all products to price by attribute?
    By lyingit in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 2 Dec 2011, 12:55 PM
  3. Replies: 7
    Last Post: 5 Dec 2008, 01:32 AM
  4. Is there any way to change $0.00 in shipping
    By Rusta in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 13 Jun 2007, 11:47 PM
  5. Any Easy way to change from product info to product music?
    By bettysue in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 26 Sep 2006, 10:07 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