[christhesoul]

Forgive if this has been answered before, but I couldn't find any reference to it in the documentation.

Is there a way that Lemonstand can use the base price and calculate the tax backwards from that?

For instance, I want to sell a t-shirt for £15. The UK is a tax inclusive environment, so that has to be the final price.

Is there a setting I can trigger in Lemonstand where I can enter 15.00 as the base price, and it'll work out that 20% VAT means the t-shirt is 12.50 and the VAT is 2.50?

That'd be nice. :)

[Aleksey]

Hi!

No, sorry, this is not possible. The discount engine is very complex now, as it should calculate taxes properly for tax inclusive and tax exclusive jurisdictions, be universal as much as possible, be simple in use and be friendly to the Discount Engine. Implementing another one option would affect every aspect of the system, and it could make it unreliable and more complicated for understanding.

But I think that we can offer you something that you could like. What about a simple built-in calculator, which would allow you entering the tax inclusive price to the Base Price field, and then converting it to the tax-exclusive value with a one button click?

Thanks

[ecmark]

You need to be a little careful here, as I expect you'll want anything like price based discounts or shipping to work off the tax inclusive price. I'm not 100% sure how lemonstand deals with this, but other carts use the price in the database for this - so if you had a 5% off orders over £100, that would be £100 exc vat if your price in the db was exc vat. Similarly with price based postage (eg free postage over £50).

We've dealt with this in consumer targeted stores (as opposed to b2b) by just putting prices in tax inclusive, setting tax rates to 0, and then just having some lines of code on the invoice to work out the vat part and display it. Where this would fall down is if you had some items that were taxed at different rates or were tax free.

This wasn't using lemonstand so Alexey will know better whether there's a better way around this.

[christhesoul]

Quote

Hi!

But I think that we can offer you something that you could like. What about a simple built-in calculator, which would allow you entering the tax inclusive price to the Base Price field, and then converting it to the tax-exclusive value with a one button click?

Thanks

That'd be cool. A little indicator to show you what the tax inclusive price will be. If this could update as you type – rather than requiring a click – that'd be quite smart. Just means you wouldn't have to jump from keyboard to mouse and back to keyboard to adjust the price if it's not quite right.

[Aleksey]

Hi, Chris!

I will add this feature to the roadmap. There is another issue - there could be different tax rates and even different taxes for different states (regions). It is not the case for Australia, but all features in LemonStand should be universal.

[ed]

Hi Chris,

As a quick fix for VAT-inclusive prices, I just added a few lines to the invoice template (modules/shop/invoice_templates/ls_standard/invoice.htm) for my site to display the VAT exclusive and VAT amounts. Added these lines just before the row that displays the total:

        <tr>
            <th class="number" colspan="4">Total ex. VAT</th>
            <th class="number"><? echo format_currency($order->total*5/6); ?></th>
        </tr>
        <tr>
            <th class="number" colspan="4">VAT</th>
            <th class="number"><? echo format_currency($order->total/6); ?></th>
        </tr>

Ed