Shipping price is calculated wrongly / additional amount is added, but why?

[nielsr]

I've been running a webshop for some months now and since today I've a very weird problem.

 

I've a carrier configured that costs 4,95 €, but on checkout it shows 14,02 €.

 

This is what is produced in the output of the checkout shipping page:

<input id="delivery_option_102_0" class="delivery_option_radio" type="radio" name="delivery_option[102]" data-key="67," data-id_address="102" value="67," checked="checked">

If I check the database I clearly see that the delivery record with id_range_price = 102 and the correct id_zone has a price configured of 4,090909 € (excl. 21% VAT) which should result in a shipping price of 4,95 € (incl. 21% VAT).

 

 

I have no idea where the additional costs are from. I have not set any handling costs whatsoever. Also, the fact that this happened out of the blue is a bit strange too.

 

Any ideas how I can start debugging this issue?

 

- Niels

Edited October 31, 2015 by nielsr (see edit history)

[nielsr]

OK, I've found some more information:

• Sending to Zone 1 = 4,95 €, but 14,02 € is charged
• Sending to Zone 2 = 10,95 €, but 20,02 € is charged

When deducting the correct fee from the calculated fee you get 9,07 (which is 7,4958 without 21% VAT).

 

So it looks that an additional 7,49 (or 7,50) excl. VAT is added to the shipping cost.

 

In the Carrier Preferences the Handling fees are set to 0.

 

What else can be configured to be added to the shipping cost?

 

- Niels

[nielsr]

I "fixed" this issue by running a SQL statement which deducted 7.50 € from all shipping costs. This seems to "fix" the problem in the frontend.

 

However, if I create an order in the backend (manual) order the shipping cost is wrong (-4,125 €). So the mysterious 7.50 € is only added to orders on the backend.

 

I would really really like to get rid of this issue as I don't know when it "magically" would correct itself again and people will start getting discounts because of negative/low shipping fees.

 

- Niels