Developer forum

Setting a tag with a tag extender only changes the information merged to the template, not the information used for calculations. Use a FeeProvider to manipulate with shipping fee. Here's an example:

using System.Data;
using Dynamicweb;
using Dynamicweb.eCommerce;
using Dynamicweb.Extensibility;

namespace CustomModules.CustomModules.Classes
{
    public class FeeProvider:Dynamicweb.eCommerce.Orders.FeeProvider
    {
        public override Dynamicweb.eCommerce.Prices.PriceRaw FindFee(Dynamicweb.eCommerce.Orders.Order Order)
        {
            Dynamicweb.eCommerce.Prices.PriceRaw ReturnFee = null;

            if (Order.CustomerEmail != "")
            {
                IDataReader DR = Database.getDataReader(string.Format("SELECT TOP 1 * FROM EcomOrders WHERE OrderCustomerEmail = '{0}' AND OrderDate >= DATEADD(day, -1, GETDATE()) AND OrderComplete = {1}", Order.CustomerEmail, Database.SqlBool(true)), "Ecom.mdb");
                if (DR.Read())
                {
                    ReturnFee = new Dynamicweb.eCommerce.Prices.PriceRaw(0.00, Dynamicweb.eCommerce.Common.Application.DefaultCurrency);
                }
            }
            return ReturnFee;
        }
    }
}

I tryed the feeProvider but I get some strange numbers that I dont know where they come from.

I'm getting the order from the databese and the value of the shipping fee is 350 but when I go in to the cart the value is 437.50 and it increases everytime I relode the page.

Another thing is that this value doesn't affect the total price or VAT.

Do I have to use some other providers for these?

350*1.25=437.45 -> Could be Danish VAT calculation. What's the VAT setting on the solution?

Ok, but the VAT from the shipping is not calculated in the total with VAT and the total VAT is calculated from the shipping fee without VAT.

An exampl of the values I get:

Product whit VAT €1.39

Shipping Fee Whit VAT €437.50

Total with VAT €351.39

VAT €70.28

Total without VAT €281.11

Here you can see that the calculations are using the shipping without VAT (350) as shipping with VAT.

And if I reload the it adds the VAT to the shipping fee again.

Why does it do that?

In Control Panel -> Prices you can control whether to calculate VAT on shipping and payment.

I have allready checked that box.

Looking at the template tags I have the correct shipping fee with and without VAT. It is the total with VAT and total VAT that uses the shipping fee without VAT to calculate the total.  

Well, that depends on how you set the setting in Control panel...

Ok, the VAT is now correct but I still get the default currency.

this is the code:

Application.get_Currency("SEK");

ReturnFee =

Is there something else I have to do to change the currency for shipping?

If I try to recalculate the shipping directly on "shippingFee" the value will encrease everytine you reload the page and the total price and VAT will be one step behind.

How did you set currency in ecom and Frontpage or Language/Area module?

Sorensen wrote:

How did you set currency in ecom and Frontpage or Language/Area module?

This solution dosn't have the landuage/area module.

In the frontpage it is set to Euro the same as the default currency.

It was set to none before and it gave the same result.