intandem Posted August 31, 2016 Share Posted August 31, 2016 (edited) Hi! We noticed that quite a number of orders recently came through without shipping charges applied. All of the problem orders have the following circumstance in common: The customer orders a product that is set to only allow shipping to a specific zone (it's a flower delivery business). The customer has a delivery address in that zone but an invoice address outside of that zone. However, in the ps_cart database table we can see that the cart is shown with the same address ID in both the id_address_delivery and id_address_invoice fields. The ID it shows is from the actual invoice address. In the order itself, we can see the correct delivery address and invoice address as separate addresses. The issue is just in the ps_cart table. We can already see in the Shopping Cart screen in the PS backend that the shipping charge is not shown here which then feeds into the order itself. So it seems as if at some stage of the process the cart uses the invoice address as delivery address, then because that is not a permitted delivery zone it does not apply shipping which then in turn feeds through to the order, even though here the correct delivery address is shown. This problem DOES NOT happen every time there is the above circumstance. There are plenty of orders in the system with invoice address being outside of the shipping zone and shipping charged are applied correctly. The problem therefore seems to somehow rest with the ps_cart table when it is being populated. Something goes wrong from time to time. By the way, the issue only started in late July but we have no reference of anything that might have been installed or changed then that could be related. Any advice or guidance would be hugely appreciated as this is obviously a serious problem. Thanks! Edited August 31, 2016 by intandem (see edit history) Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now