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

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 ...

Ajeh:

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?

How many products_id are involved here? :unsure:

Ajeh:

How many products_id are involved here? :unsure:

Worse case maybe 100, best case 10. depends on how much work is needed.

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:

  if (!IS_ADMIN_FLAG) {
    global $cart;
    $chk_exclude_products = $_SESSION['cart']->in_cart_check('products_free_shipping_exclude','1');
    $this->enabled = false;
  }

Ajeh:

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:

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?

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 ...