catalog-price-rulesfree-shipping
we use magento 1.8.1CE
People now get Free shipping over 49,95 (with free shipping shipment method)
But we want to disable this when a product gets a special price (defined by a catalog price rule).
But when they have a mixed cart ….
With some Sale items and some Not-Sale items, and the none sale items get over the 49,95 the free shipping is applied.
What i would like to have …
Is that the free shipping is only being calculated with non-sale items.
Can this be done in magento?
Setting Up Free Shipping
Free shipping is one of the most effective promotions you can offer. It can be based on a minimum purchase, or set up as a shopping cart price rule that applies when a set of conditions has been met. If both apply to the same order, the configuration setting will take precedence over the shopping cart rule.
See your shipping carrier configuration for any additional settings that may be required for free shipping.
Free Shipping In Shopping Cart
To set up free shipping:
To use Free Shipping with Table Rates, you must enter a Minimum Order Amount so high that it is never met. This prevents Free Shipping from going into effect, unless triggered by a price rule.
In the Displayed Error Message box, type the message to appear if this method becomes unavailable. Set Ship to Applicable Countries to one of the following:
Here is a list of known Magento versions and shipping methods this technique works with, based on personal success and community feedback. Please comment if you can confirm other shipping methods or versions to add to this list.
1.4.x
1.5.x
1.6.x
1.7.x
1.8.x
The first thing we’ll want to do is create a product attribute giving us the option to allow free shipping on our products. I find it easier to make this a drop-down box, shown below.
Here’s the goal:
1. Go to Catalog > Attributes > Manage Attributes
2. Click add new attribute
3. Fill in the fields as shown in the image below exactly. You may select your store name for the Scope if applicable. You may also name the Attribute Code something else, but keep it simple as we will be using this field later.
4. Make sure to select Yes for the following choices to make the free shipping option visible on the front-end and use the attribute for Price Rule Conditions.
5. Click Manage Label/Options from the left sidebar. The field under Admin is the text visible to administrators in the Magento backend (best to call this Free Shipping). Below, click add an option to make our drop-down choices. We only need to make one choice (Yes), which will turn free shipping on for a particular product. The admin field here will be the choice visible in the drop down menu. The field under your store name is the text front-end users will see. Position should be 1. Do not set this as default to avoid automatically giving all products a Yes value (that would be bad).
6. Our attribute is made, but we need to assign this new attribute to an attribute set to actually use it when creating or editing our products. Go to Catalog > Attributes > Manage Attribute Sets
7. If you’re lucky, you’ve been using the default attribute set for your products. If you’re unlucky like me, you already have quite a few sets made. For this option to show up, you have to select each attribute set and perform step #8 to each one.
8. After clicking an attribute set, you will see the free shipping attribute we created over in the Unassigned Attributes column to the right. Click+drag the attribute into one of the sections to the left. You can put this item anywhere you want, and this will determine where it is available in the Manage Products area. Typically, the General or Prices section makes the most sense here. Remember to do this for every attribute set you want this available
9. Now you should be able to go to Catalog > Manage Products and select a product from the list. Go to the section where you dragged the free shipping attribute under (General, in my case), and scroll down to find our new free shipping attribute.
Right now: Here’s what we have. We just added an option to allow free shipping for products. Leaving the selection blank will do nothing, but selecting Yes will eventually allow free shipping for this specific product. However, free shipping will not be applied to the product just yet. Read on to learn how to get Magento to assign free shipping to products that have this attribute assigned to Yes.We have the interface set up, but now we have to make it function properly.
1. Click Promotions > Shopping Cart Price Rules
2. Click Add new rule
3. Give the rule a name and description (these are for administrator reference only). Set the status to Active. Be sure to to leave the “to date” blank, unless you want an expiration date for free shipping (note: if you set an expiration date, it will be site wide, not per product).
4. Ignore the Conditions tab. Instead, click Actions in the left sidebar.
5. Match your fields with the ones in the image below.
Apply: Percent of product price discount
Discount amount: 0
Maximum Qty Discount: 0
Discount Qty step: 0
Free shipping: For matching items only (very important)
Stop further rules processing: No
For the rules, keep the default “if ALL of these conditions are TRUE”. Click the plus sign to add a condition. Select Free Shipping from the list. Click the elipses and select Yes from the drop down (note: if Free Shipping is not in this list, refer back to step 4 in the last section, and make sure Use for price rule conditions is set to Yes).
6. Save the rule
Right now: We have added a Free shipping option to our products and created the conditions needed to apply the rule. The last thing we have to do is enable Magento’s core free shipping option…kind of.As we already know, Magento’s core free shipping option only works for a minimum order amount; this is not what we’re after. However, we do need to activate Magento’s core free shipping function so it knows how to deal with our rule.
1. Click System > Configuration
2. Find Sales > Shipping Methods in the left sidebar.
3. The next step will be determined by your shipping method. I will cover external and internal calculators.
1. If you are not using external calculators, select Free Shipping from this list.
2. Set Enabled to Yes. Here’s the trick: Set the Minimum order amount to some outrageous number, like 9999999999.99. This lets us enable free shipping without having to worry about false positives.
1. In my case, I use UPS for my shipping calculator. The other providers offer similar fields, so you should be able to follow along.
2. Fill in all appropriate fields, such as Gateway URL, allowed methods, etc. This data can be found on your shipping provider’s website. (This information must be correct for Magento to reach the 3rd party calculator. Also, your shipping account must be in production mode)
3. We’re most interested in the Free Method option. In my case, I want my products to receive Free Ground Shipping. Free shipping with minimum order amount is set to disabled. I still set my Minimum order amount to some outrageous number like 9999999999.99 just in case. This lets us enable free shipping without having to worry about false positives.
4. Enable the provider.
5. Test the free shipping rule by editing a product, select Yes for free shipping, add it to the cart, and run the Estimate shipping and tax quote. I chose Free Ground Shipping, so this is reflected by the quote generator.
Right now: At this point, you can create or edit a product, select Yes from the free shipping drop-down box, and that product will receive free shipping. If users have an item with and without free shipping, it will only get applied to the ones with free shipping enabled (assuming you followed step 5 in the first section by selecting For matching items only). You could call it quits here, or read on to learn how to let customers know which items have free shipping enabled.Here’s the goal:
1. Locate the template file you want to add the Free Shipping text to, a product page, for instance. Finding specific template files is outside the scope of this tutorial.
2. Assuming you named your rule the same attribute code I did (free_shipping_discount) in step 3 of the first section, paste the following code wherever you want the free shipping text to show. The first line checks if the item has free shipping, second line displays the text, then end the if statement.
view sourceprint?
1<?php2if ($_product->getFreeShippingDiscount()) :3 echo '<span class="freeShip">'.$_product->getAttributeText('free_shipping_discount').'</span>';4endif ?>
3. Notice I put the text to a p tag with a class. You can alter this however you wish. This lets me style the text and assign a background image to complete the effect.
4. It is best practice to also include this code on the shopping cart page since free shipping only applies to specific items. This will let users know which items in their cart receive free shipping.
The cart.phtml page requires a different call. Use the code below in your template/checkout/cart/item/default.phtml:
view sourceprint?1<!-- if item has free shipping -->2<?php3 echo '<span class="free-ship">'.Mage::getModel('catalog/product')->load($this->getProduct()->getId())->getAttributeText('free_shipping_discount').'</span>';4?>
Best Answer
There is no relation between catalog rules and shipping methods. Basically shipping charges are applied after product and cart item prices.
Magento does not have a feature "Disable free shipping with Catalog Price Rule" by default.
See this link for further explanation: How to Ignore Catalog Pricing Rule when applying Shopping Cart Price Rule?