[TYPO3-shop] No tax outside of country

[Franz Holzinger]

Hello Simon,

> I'm trying to set it so that no tax is charged outside of Canada, I've
> evidentally got something wrong with the below though, when I add in the
> 10.where line, I get a mysql error on the website (mysql_fetch_assoc():
> supplied argument is not a valid MySQL result resource in
> /home/allergy/typo3_src-4.1.5/t3lib/class.t3lib_db.php on line 796), and
>  the cart pops up a "you have not entered your country" message.

And which SQL statement is shown in error_log?

> I'm using the useStaticInfoCountry=1 and have the country dropdowns,
> they seem to work find unless I add the 10.where line.
> 
>   shipping {
>       10.title = Standard Shipping
>       10.where.static_countries = cn_short_local != 'Canada'

> Where have I erred? Also, will this kill all tax outside Canada, or just
> the tax on shipping?  If shipping,  do I need to then do similar under
> payment?

It must be like this at the moment (tt_products 2.6.0-2.8.0):

    10.title = Shipping ###STATICCOUNTRIES_CN_OFFICIAL_NAME_EN###
    10.where.static_countries = cn_short_local != 'Canada'
    10.replaceTAXpercentage = 0
    10.price.type = price
    10.price.0 = 10
    10.price.200 = 16
    10.price.400 = 22


The title field must contain a STATICCOUNTRY marker. Otherwise the where
condition will not be taken into account.

- Franz