harrisorganic Posted February 13, 2023 Share Posted February 13, 2023 After upgrading to 6.4.9 and using Foundation skin I have just noticed a regular customer has applied his coupon code for free shipping. However: The shipping price is included but not added to the total price. The $15.15 should be zero. What code needs to change, please? Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 13, 2023 Share Posted February 13, 2023 This appears to be the summary view of the order in admin, correct? If so, I agree that the summary should indicate both what the shipping would otherwise have been, but that has been reduced because of some other function. (That function should be mentioned in the Notes tab.) I think this is not directly related: https://github.com/cubecart/v6/issues/2998 Let me see what I can find. 1 Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted February 13, 2023 Author Share Posted February 13, 2023 Yes, that is correct and is the same as the New Order email. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 13, 2023 Share Posted February 13, 2023 (edited) I am not able to replicate or confirm your experience. However, I need to know some more details. You are viewing an order that (at the time you posted the image above) is at Processing? What does the Shipping Information box show? Using an external database utility, what are the contents related to shipping for this order in CubeCart_order_summary? Are there any notes on the Notes tab? Do you have any better idea of the steps the customer took to make the purchase? For example: 1) the customer entered the Free Shipping coupon code before actually accepting the default selected/calculated shipping charges, or 2) accepted/changed the default selected/calculated shipping charges and then entered the Free Shipping coupon code? Was this actually a Free Shipping coupon (as indicated in admin, Promotional Codes, editing a Free Shipping coupon, with the "Free shipping" checkbox selected)? Edited February 14, 2023 by bsmither Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted February 14, 2023 Author Share Posted February 14, 2023 Yes, the order is at processing. What does the Shipping Information box show? I don't know what this is. contents related to shipping for this order in CubeCart_order_summary are $15.15 Yes, there are notes in the notes tab, due to the free shipping coupon. Dont know the order of the steps. ( I would have to call him) As a regular customer, using Paypal I assume he put in the free shipping code (without clicking apply) and clicked secure checkout PayPal. The Free Shipping coupon (as indicated in admin, Promotional Codes, editing a Free Shipping coupon, with the "Free shipping" checkbox selected.) Yes, see below. Its a mystery I could not replicate it either. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 14, 2023 Share Posted February 14, 2023 When viewing an order summary, Overview tab, there is a table listing the Items. Below that is a table listing Contact Details. Below that is a table showing Shipping Information. In Shipping Information, my experiment shows: Shipping Method: Free Coupon Shipping Shipping Product: Free Shipping from Promotional Code Gateway: XXXXXXX In CubeCart_order_summary, the shipping value, does it include the dollar sign? Can you determine where the 15.15 value came from? That is, what shipping module was used to get this shipping cost? Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted February 14, 2023 Author Share Posted February 14, 2023 Bottom line has 15.15, no $ sign The shipping price `15.15" is normally from AIOS and is NOT the normal shipping price without a coupon. It should be 14.50 + tax (10%) Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 14, 2023 Share Posted February 14, 2023 "As a regular customer, using Paypal I assume he put in the free shipping code (without clicking apply) and clicked secure checkout PayPal." Not knowing what exactly happens (sequence of calling the next page and code execution) when one clicks the PayPal Checkout button, it is entirely plausible that the customer failed to click "Apply" nor "Update Basket". So, maybe the customer did actually pay for shipping as calculated by "Aust Post"? But then, what is controlling the listing of the order's details in admin? (Shipping is listed but not summed.) Looking into that. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 15, 2023 Share Posted February 15, 2023 Looking at the screen grab of the database table details, I see that the 'total' is 264.00 (which is a correct calculation from 240.00 + 24.00 tax). So, there is no issue to be found when showing the Order Summary for that order. The values shown is taken directly from the database record. I am leaning toward thinking that the PayPal module, which allows for accepting data being sent back from PayPal, updated the database record with data determined by PayPal, including some sort of shipping estimate (and the shipping provider ???). Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted February 15, 2023 Author Share Posted February 15, 2023 Anything is possible at this stage. I will give the client a call and report back. The last 4 orders have the same issue with shipping of $15.15 showing on the invoice. Orders before that were OK. The first occurrence was on the 21st of November 2022 after the CC647 update. I don't know what version of PPal was used, but I always update to the latest version. Quote Link to comment Share on other sites More sharing options...
bsmither Posted February 15, 2023 Share Posted February 15, 2023 (edited) What I was thinking was that there may be a setting in your PayPal Merchant's Account Control Console regarding the enabling of PayPal calculating the shipping charges, and sending that info back to your store. (PayPal can do this for the customer's delivery address and phone number, overwriting whatever was originally provided by the customer at checkout - if the customer even logged in.) So, the last four orders?? Did the last four orders all use the Free Shipping coupon? Edited February 15, 2023 by bsmither Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted February 15, 2023 Author Share Posted February 15, 2023 Yes, the last six orders used the free shipping coupon option and since November the last 4 have the issue. I have looked over Paypal and can not find any shipping payment options. This is a screen shot of the PayPal invoice, showing no shipping. I thought the $15.15 may have appeared here. In my AIOS there is an entry for $15.15. However, that price is for a different state. I will alter the price to $15.16 and see if it comes up in the next order. Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 1, 2023 Share Posted March 1, 2023 Has your shipping calculation anomaly made itself known since the above? Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted March 20, 2023 Author Share Posted March 20, 2023 There is a new order from the same guy with the free shipping coupon, and the same issue has occurred. However, I changed the shipping amount from $15.15 to $15.16 in the AIOS and the shipping amount of 15.16 shows up but is not added to the price. Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted July 16, 2023 Author Share Posted July 16, 2023 Hi Brian, this may be a different issue, but I will post it here. The current version is the latest 1.0.26. I have a few orders from the UK to ship from Australia. Here are my shipping rates. Most people order one bottle and are charged $92.26 for the 1.501 -4.1 kg category. However, the ordered bottle is 1.35 kg basket weight and therefore should be only $59.00 postage. Any suggestions? regards Duncan Quote Link to comment Share on other sites More sharing options...
bsmither Posted July 16, 2023 Share Posted July 16, 2023 I don't see a "Flat Rate" amount that contributes to the cost for that range. So that wouldn't be the problem. On the General tab, is there an amount entered in the Packaging Weight field? Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted July 17, 2023 Author Share Posted July 17, 2023 "Two heads are better than one", yes, there is a packaging weight of 0.2 which "kicks" the weight into the next section. However, the basket weight at the checkout remains the same. ie 1.35 kg Reducing the packaging weight to zero solves the issue. Thanks. PS the issue regarding the free shipping (above) continues Quote Link to comment Share on other sites More sharing options...
bsmither Posted July 17, 2023 Share Posted July 17, 2023 Regarding the calculated shipping cost being shown - but not included into the total - when viewing an order summary (and customer invoice?): Noted. Quote Link to comment Share on other sites More sharing options...
harrisorganic Posted July 17, 2023 Author Share Posted July 17, 2023 Yes, the customer order confirmation, invoice and order receipt have the same shipping price instead of zero. The above is one order I made today using print order form. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.