Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2008
    Posts
    84
    Plugin Contributions
    0

    Default Mark Free Shipping to all products

    Hi,

    I have around 900 products on my store.
    Previously, i used to charge extra shipping apart from the product cost during checkout.

    I have now changed the policy and going to give all products as FREE SHIPPING.

    However, right now, all my products are "Normal Shipping" products.

    How do i change them to "Yes always Free Shipping" in bulk.
    Doing it individually for all products would be really tough and time consuming.

    Is there a way wherein i can change the indicator of all the products to "Yes always free shipping" at one go. Something like Easy Populate.

    This will also enable me to display the FREE SHIPPING image on all the product descriptions.

    All help is highly appreciated.

    Thanks

  2. #2
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: Mark Free Shipping to all products

    I am not sure how you can do it from easpopulate but you can change it using phpmyadmin
    Before making this change backup the database
    Run the following query
    Code:
    update products set product_is_always_free_shipping=1;
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  3. #3
    Join Date
    Jul 2008
    Posts
    84
    Plugin Contributions
    0

    Default Re: Mark Free Shipping to all products

    Hi,

    I am a novice and not very techie. Can you help me out as to how to run this query and from where.

    Is this the SQL query we run from the admin ?

    Or how ?

    Any help highly appreciated...

  4. #4
    Join Date
    Jul 2008
    Posts
    84
    Plugin Contributions
    0

    Default Re: Mark Free Shipping to all products

    Somehow i tried doing this in php myadmin.
    When i run the sql thing, i get the following error...

    #1146 - Table 'vastucon_zc1.products' doesn't exist

    Please suggest..

    Chetan

  5. #5
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: Mark Free Shipping to all products

    please see the name of your product table and change it accordingly in the database
    or give the following query in the Tools->Install SQL patches n the admin area[PLEASE KEEP BACKUP]

    update products set product_is_always_free_shipping=1;
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  6. #6
    Join Date
    Jul 2008
    Posts
    84
    Plugin Contributions
    0

    Default Re: Mark Free Shipping to all products

    Wow... Superprg..

    You are really super..

    This has done the trick.. Problem resolved...

    Regards
    Chetan

 

 

Similar Threads

  1. v152 How to mark all products out of stock at once?
    By joecooper in forum General Questions
    Replies: 5
    Last Post: 1 Mar 2016, 01:58 AM
  2. v154 Need help setting up free shipping for all products in store.
    By Zappa Aviaries in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 7 Feb 2015, 09:00 AM
  3. Can I set up Retail all free shipping, Wholesale free shipping >$500 ?
    By GTHENRY in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 19 Aug 2010, 10:34 PM
  4. any easy way to change all products to free shipping?
    By hungrytazman in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 8 Apr 2010, 10:59 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