Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Free shipping coupon not working with Table Rates shipping - Sorry, no quotes are available for this order. #8172

Closed
gabriel-sf opened this issue Jan 18, 2017 · 15 comments
Assignees
Labels
bug report Component: Checkout Fixed in 2.1.x The issue has been fixed in 2.1 release line Issue: Clear Description Gate 2 Passed. Manual verification of the issue description passed Issue: Confirmed Gate 3 Passed. Manual verification of the issue completed. Issue is confirmed Issue: Format is not valid Gate 1 Failed. Automatic verification of issue format is failed Issue: Ready for Work Gate 4. Acknowledged. Issue is added to backlog and ready for development Reproduced on 2.1.x The issue has been reproduced on latest 2.1 release Reproduced on 2.2.x The issue has been reproduced on latest 2.2 release Reproduced on 2.3.x The issue has been reproduced on latest 2.3 release

Comments

@gabriel-sf
Copy link

The shopping cart I am working has its shipping based on the shipping table rate.
This is working perfectly fine by itself.
The problem happens when we have a coupon code created to provide free shipping.

Coupon details
Coupon Code: FREESHIP
Enabled from/To: 01/01/2016 - 01/01/2022
Apply: Percent of product price discount
Discount Amount: 0
Discard subsequent rules: YES
Apply to Shipping Amount: YES
Free Shipping: For Shipment with matching items

When I apply a coupon, the shipping does not work and returns a Sorry, no quotes are available for this order.

Preconditions

  1. Magento 2.1.3
  2. MySQL

Steps to reproduce

  1. Add products to the shopping cart
  2. Go to checkout
  3. Get shipping price correctly.
  4. Apply coupon for FREESHIP
  5. Get Sorry, no quotes are available for this order. in the shipping instead of updating the pricing total to reduce the amount of the shipping

Thanks for your help.

Cheers,
Gabriel

@EricSeastrand
Copy link

I'm encountering this same issue on Magento 1.9.3.1. I realize this is the Magento 2.x GitHub; only commenting in hopes that this may help to diagnose and debug the issue.

@janmech
Copy link

janmech commented Mar 23, 2017

I encountered a similar problem in Magento 2.1.5:

  • Coupon: x% discount on product price and shipping when product is in a certain category (in this case called "DISCOUNT")
  • Shipping Method: Table Rate
    Discount coupons were either rejected (when shipping amount was 0) or Discount was not applied on shipping costs (when shipping amount was > 0).

It appears to be a bug in Magento: The error occurs if the category used to filter the "Action" of the cart price rule is either a Root Category or too deep down in the hierarchy.

My Solution:

  • Delete Cart Price Rule
  • Move the "Filter Category - in my case "DISCOUNT" one level under the default root category
  • Re-create the shopping cart rule.

@gabriel-sf
Copy link
Author

@veloraven Do you have any update on this issue? It seems that whenever the Table Rate shipping is implemented it interferes with other coupons / shipping methods.

Any way we can solve this?

@veloraven
Copy link
Contributor

@gabriel-sf is this issue still actual?
We were not able to reproduce it on the latest version.

@gabriel-sf
Copy link
Author

@veloraven I haven't implemented the latest version version yet. I will be able to do this in a few weeks given we are about to launch. Will update once this is ready

@smoskaluk
Copy link

Internal ticket created MAGETWO-69940

@magento-engcom-team magento-engcom-team added Issue: Clear Description Gate 2 Passed. Manual verification of the issue description passed and removed Progress: needs update labels Sep 18, 2017
@magento-engcom-team magento-engcom-team added 2.2.x Issue: Ready for Work Gate 4. Acknowledged. Issue is added to backlog and ready for development Issue: Confirmed Gate 3 Passed. Manual verification of the issue completed. Issue is confirmed Reproduced on 2.1.x The issue has been reproduced on latest 2.1 release Reproduced on 2.2.x The issue has been reproduced on latest 2.2 release Reproduced on 2.3.x The issue has been reproduced on latest 2.3 release labels Oct 11, 2017
@lewisvoncken
Copy link
Contributor

lewisvoncken commented Oct 15, 2017

@gabriel-sf @magento-engcom-team

I just supplied a fix in the partner github for the develop branch but if the pull request is accepted I will backport it for you.

@lewisvoncken
Copy link
Contributor

I'm working on it #SQUASHTOBERFEST

@jcsgithub
Copy link

I also encountered a quite similar problem in Magento 2.1.8.

Scenario:

  • Enabled Table Rate shipping method and created price rates based on weight v. destination.
  • Disabled Free Shipping shipping method

Coupon actions:

  • Apply - Percent of product price discount
  • Free shipping - For matching items only.

Issues encountered:

  • Case 1 - "Carrier with such a method not found..." error
    After submitting the coupon code on the Review & Payments of checkout page, the coupon was successfully accepted. But when I tried to go back to the previous step (for instance, the customer will modify his/her shipping address), the Shipping Methods section shows the Table Rate method and clicking next would produce "Carrier with such a method not found..." error.

  • Case 2 - "Sorry, no quotes are available for this order at this time"
    After submitting the coupon code on the cart page, the coupon was successfully accepted. But when I proceed to checkout, the Shipping Methods section does not show the Table Rate method and only shows the text "Sorry, no quotes are available for this order at this time".

Similarly, you can reproduce Case 2 by submitting the coupon code like in Case 1 and after that click "Go to Checkout" button from the minicart again.

@okorshenko
Copy link
Contributor

The issue has been fixed in 2.1-develop branch. Will be available with next patch release
Fix to 2.2-develop is on the way

@okorshenko okorshenko added the Fixed in 2.1.x The issue has been fixed in 2.1 release line label Nov 13, 2017
@Rickertje
Copy link

Rickertje commented Mar 3, 2018

The original case is still not working properly in 2.2.2:

Coupon details
Coupon Code: FREESHIP
Enabled from/To: 01/01/2016 - 01/01/2022
Apply: Percent of product price discount
Discount Amount: 0
Discard subsequent rules: YES
Apply to Shipping Amount: YES
Free Shipping: For Shipment with matching items

When I apply a coupon, the shipping costs are lowered to the minimum table rate but not to 0 as expected

@EricSeastrand
Copy link

@Rickertje you could try adding a row in the rate table for $0 carts to have them ship for $0.

If that doesn't work, you could try turning on query logging and checking to see what minimum cart amount is being passed in the query. This should give some insight into why no rates are being found. Probably the conditions in the query are wrong, or just the rows are missing (see suggestion above).

@Rickertje
Copy link

@willcodeforfood Thanks! It tried this (see attached) and it seems to be a very nice workaround. Still it should be solved in an appropriate way.
afbeelding

@nmallepally
Copy link

After applying the Fix 6637cde on Magento 2.1.8v , It still does not work.
Any work around in 2.1.8v ?

coupon code : FreeDelivery
Actions:
Apply : percent of product price discount
Discount Amount : 0
Apply to shipping amount - yes
Free shipping ( For shipping with matching items).
Assign a particular category for the coupon to be applied and save.
code applies but won't show free shipping 0 value.
image

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug report Component: Checkout Fixed in 2.1.x The issue has been fixed in 2.1 release line Issue: Clear Description Gate 2 Passed. Manual verification of the issue description passed Issue: Confirmed Gate 3 Passed. Manual verification of the issue completed. Issue is confirmed Issue: Format is not valid Gate 1 Failed. Automatic verification of issue format is failed Issue: Ready for Work Gate 4. Acknowledged. Issue is added to backlog and ready for development Reproduced on 2.1.x The issue has been reproduced on latest 2.1 release Reproduced on 2.2.x The issue has been reproduced on latest 2.2 release Reproduced on 2.3.x The issue has been reproduced on latest 2.3 release
Projects
None yet
Development

No branches or pull requests

13 participants