Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2010
    Posts
    77
    Plugin Contributions
    0

    Default No free shipping on specif product

    Hi, we offer several shipping options including a free option. However we're running a clearance sale and some of the products are heavily discounted and as such I do not want customers to be able to choose the free shipping option on these products. i.e. they must pay shipping on these specific clearance products. Is there a way to do this?

    I need to do this in the event that a customer returns one of these clearance items back to us. Under the distance selling regulations I have to make a full refund on the product price and as such I can not recoup the cost of the of any "free" postage. However if I charge/show the shipping as a separate service then I do not have to refund it.

    in basic terms we have a couple of items that are costing us more to ship than we are actually making on the product. If the customer retunes it to us its like being hit by a double blow

    Please advise.
    Thanks
    T

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

    Default Re: No free shipping on specif product

    Do the Products all use the same master_categories_id in the products table?

    Are the Products all in the same categories_id or more than 1 categories_id ...

    The idea here is to identify these Products and test the cart to see if 1 or more are in there ...
    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
    Mar 2010
    Posts
    77
    Plugin Contributions
    0

    Default Re: No free shipping on specif product

    Quote Originally Posted by Ajeh View Post
    Do the Products all use the same master_categories_id in the products table?

    Are the Products all in the same categories_id or more than 1 categories_id ...

    The idea here is to identify these Products and test the cart to see if 1 or more are in there ...
    Hi,

    Do the Products all use the same master_categories_id in the products table? No, not all

    Are the Products all in the same categories_id or more than 1 categories_id - More than one

    The idea here is to identify these Products and test the cart to see if 1 or more are in there ...Would the product_id not do?

    Regarding the first 2 questions it wouldnt be to hard for me to group all the products under a single master_categories_id, surely this would just mean creating a category 'clearance' and adding all those products to it?

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

    Default Re: No free shipping on specif product

    How many products_id are involved here?
    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
    Mar 2010
    Posts
    77
    Plugin Contributions
    0

    Default Re: No free shipping on specif product

    Quote Originally Posted by Ajeh View Post
    How many products_id are involved here?
    Worse case maybe 100, best case 10. depends on how much work is needed.

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

    Default Re: No free shipping on specif product

    If you were to create a Category for Clearance ... you have a few choices:

    1 Move all of these Products to the new Clearance category
    -- this makes that new Clearance category the master_categories_id

    2 Copy as Duplicate Product all of these Products to the new Clearance category and then go use the Multiple Categories Links Manager, also located under the C for copy, and at the bottom of the page you will see:
    Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ...
    Example: Resetting Category 22 would set ALL Products in Category 22 to use Category 22 as the Master Category ID
    Reset the Master Categories ID for All Products in Category:
    -- this allows you to keep the Products in their original category or categories but set them up to use the Clearance category as the master_categories_id ...

    3 Leave the Products as they are and maintain a list of the 100 products_id for these Products ...

    4 see if you can figure out the code that a few other members worked through for excluding categories which this thread should give you most of the information and links to other threads to piece it together:
    http://www.zen-cart.com/forum/showthread.php?t=172745

    NOTE: option 4 may be too broad of a scope on the selection for the Products to exclue

    5 add a new field for the products table for:
    products_free_shipping_exclude

    and add the code to the Admin to manage that field so you can turn it on/off (set to 1 or 0) as needed on your Products to flag them as excluded from the Free Shipping Options and then just check for that flag in the shopping cart by adding this code to the shipping module:
    Code:
      if (!IS_ADMIN_FLAG) {
        global $cart;
        $chk_exclude_products = $_SESSION['cart']->in_cart_check('products_free_shipping_exclude','1');
        $this->enabled = false;
      }
    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!

  7. #7
    Join Date
    Mar 2010
    Posts
    77
    Plugin Contributions
    0

    Default Re: No free shipping on specif product

    Quote Originally Posted by Ajeh View Post
    If you were to create a Category for Clearance ... you have a few choices:

    1 Move all of these Products to the new Clearance category
    -- this makes that new Clearance category the master_categories_id

    2 Copy as Duplicate Product all of these Products to the new Clearance category and then go use the Multiple Categories Links Manager, also located under the C for copy, and at the bottom of the page you will see:


    -- this allows you to keep the Products in their original category or categories but set them up to use the Clearance category as the master_categories_id ...

    3 Leave the Products as they are and maintain a list of the 100 products_id for these Products ...

    4 see if you can figure out the code that a few other members worked through for excluding categories which this thread should give you most of the information and links to other threads to piece it together:
    http://www.zen-cart.com/forum/showthread.php?t=172745

    NOTE: option 4 may be too broad of a scope on the selection for the Products to exclue

    5 add a new field for the products table for:
    products_free_shipping_exclude

    and add the code to the Admin to manage that field so you can turn it on/off (set to 1 or 0) as needed on your Products to flag them as excluded from the Free Shipping Options and then just check for that flag in the shopping cart by adding this code to the shipping module:
    Code:
      if (!IS_ADMIN_FLAG) {
        global $cart;
        $chk_exclude_products = $_SESSION['cart']->in_cart_check('products_free_shipping_exclude','1');
        $this->enabled = false;
      }
    Sorry but I really dont understand any of this. You say I have a few choices but I dont understand what these choices are?! Are you saying the 5 methods above are all alternative methods i.e. do 1 OR 2 OR 3 OR 4 OR 5. Or are you saying do 1 OR 2 OR 3 AND then do 4 AND then do 5?

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

    Default Re: No free shipping on specif product

    Each choice is an alternative on how to approach this ... you need to pick which method would be best for you then adapt for it ...
    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. v153 Product is Free, Free Shipping Orders - How to change Order Status
    By Matt Staines in forum Customization from the Admin
    Replies: 3
    Last Post: 13 Apr 2016, 09:08 AM
  2. v139h Free shipping to just 1 country using free shipper and Yes, Always Free Shipping
    By boomy in forum Built-in Shipping and Payment Modules
    Replies: 9
    Last Post: 20 Oct 2014, 01:43 AM
  3. Replies: 18
    Last Post: 28 Aug 2012, 02:24 PM
  4. Discount coupon with free shipping and free shipping if purchasing additional product
    By webmiss in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 4 May 2012, 02:04 PM
  5. Always free shipping by product but only free in the US?
    By KingBono in forum Built-in Shipping and Payment Modules
    Replies: 7
    Last Post: 4 Oct 2008, 10:51 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