Trevor - I'd like to see this if you don't mind doing a screen share with me over Skype ... it works without a hitch in every test I've done. Mind if I ping you to set something up?

FIXED!

Firstly a big thanks to Rusty for taking the time to understand my issue (mostly my confusion) and helping come up with a solution.

CONFUSION

Now, my first problem was a misunderstanding of the new features introduced in v.1.10. This feature was to allow the shop admin to enter product pricing "tax exclusive" but have the products rendered on the front end with taxes already applied (tax inclusive). That feature works as stated.

However, in NZ when it comes to consumer to consumer commerce, most shop admins only care about the tax inclusive price and want to enter in the product as $29.95 and have it displayed as $29.95 on the front end. On the resulting invoice however, we want to state that the invoice total "includes tax of $xx.xx".

SOLUTION

Merchello setup: 1. Set your country tax rate provider and leave "include in product pricing" unchecked. 2. Enter all your products with "This variant is taxable" unchecked! (I know it doesn't seem right but trust me).

Now add the following into your App_Code folder (I've named the file TaxesVisitor.cs).

using Merchello.Core;
using Merchello.Core.Gateways.Taxation;
using Merchello.Core.Models;
using Merchello.Core.Services;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Umbraco.Core.Logging;

/// <summary>
/// Summary description for TaxesVisitor
/// </summary>
public class TaxesVisitor : ILineItemVisitor
{
    private ITaxMethod _taxMethod;
    private bool _productPricingEnabled = false;
    private IGatewayProviderService _gatewayService = MerchelloContext.Current.Services.GatewayProviderService;
    private TaxationGatewayProviderBase _productTaxProvider;
    private decimal _taxTotal = 0M;
    public decimal TaxTotal { get { return _taxTotal; } }

    public TaxesVisitor()
    {
        initialise();
    }

    public void Visit(ILineItem lineItem)
    {
        if (!_productPricingEnabled) return;
        var productProvider = _productTaxProvider as ITaxationByProductProvider;
        if (lineItem.LineItemType != LineItemType.Product && lineItem.LineItemType != LineItemType.Shipping) return;
        if (productProvider != null)
        {
            var taxMethod = productProvider.GetTaxationByProductMethod(_taxMethod.Key);
            var baseTaxRate = taxMethod.TaxMethod.PercentageTaxRate;
            var taxRate = baseTaxRate > 1 ? baseTaxRate / 100M : baseTaxRate;
            // according to NZ IRD GST laws, you can calc gst one of few ways...you just have to do it consistently!
            // I'm going to calc on each line item, calculating the gst on a single unit and rounding and then
            // multiple that by the quantity ordered.
            // Therefore if the product is $29.95 (incl of 15% gst) then
            // GST = 29.95 - ( 29.95 / 1.15 ) = 3.906521 = 3.91
            // if I ordered 3 of them, the tax is $11.73.
            //
            // note, the rounding difference if you calculated GST on the total line item
            // 29.95 * 3 = 89.85 - (89.85 / 1.15) = $11.72
            _taxTotal += Math.Round(lineItem.Price - (lineItem.Price / (1M + taxRate)), 2) * lineItem.Quantity;
        }
    }

    private void initialise()
    {
        var taxationContext = MerchelloContext.Current.Gateways.Taxation;
        if (!taxationContext.ProductPricingEnabled) return;
        _productPricingEnabled = true;
        _taxMethod = _gatewayService.GetTaxMethodForProductPricing();
        _productTaxProvider = taxationContext.GetProviderByMethodKey(_taxMethod.Key);
    }
}

Now in your code that displays the order information (eg if using Merchello Bazaar, InvoiceSummary.cs script) instantiate the taxes visitor and apply it against the Invoice.

var visitor = new TaxesVisitor();
Model.Invoice.Items.Accept(visitor);

At this you can output the tax amount however you like. I've included a new table row after the invoice total that outputs the "includes GST of" amount like this:

    <tr>
        <td colspan="3" class="text-right">(includes GST of)</b></td>
        <td class="text-right"><span id="tax-total">@ModelExtensions.FormatPrice(**visitor.TaxTotal**, Model.Currency.Symbol)</span></td>
    </tr>

And voila! There you have everything calculating correctly for tax inclusive pricing.

I tryed this and it woks great in the cart. But in the order confirnation mail and in the backoffice the tax is still 0.

I'm using the latest Merchello 1.13.0.

What do I have to do to get it to update these too?

How would you go about putting variable taxes on products? That is something I can't get my head around.

Eg. Some Products have 25% VAT, some 6% etc. How?

@Marcus - you would need to create a custom tax provider based on product categories. Take a look at the included Flat Rate Tax Provider - I'd think it would be very similar, only you would need to look up the base tax rate per product for the computation.

I thought about that but I couldn't find any docs on how to create providers.

Hi,

I do have exactly the same issue.

Many webshops for Business to Consumers (B2C ) in The Netherlands do want to fill in prices vat included in backoffice and want to show the exact same price on the product in the frontend. In the checkout it needs to say how much tax was calculated.

My question, is the post from Trevor still the way to go? Does it also work for Fasttrack?

Any info would be great!

Cheers, Arjan

The best would be if you could simply put the VAT on the product individually. Otherwise it will always be a case of using extended data for non US-countries.

Simply because many Countries use differentiated VAT based on product types. For instance Books here have 6% VAT, Food 12% and rest 25%.

I did but maybe not that issue ;). Forgot where I put it.

Essentially I would like more configurations for individual products when it comes to VAT. Similar to how uCommerce does it if you need inspiration :).

is working on a reply...