Google Base v Include and Exclude Tax in Prices (Nett/Gross)

If using Google Merchant Centre (formerly Google Base, nee Google froogle) you must send prices inclusive of tax and you must also display prices with tax on your site. Normally this isn't a problem as the googlefroogle.php looks up the setting for displaying prices with tax, and if that is 'true' then the tax is added to the prices in your feed.

However, if you have the Include and Exclude Tax in Prices mod installed, that has display price settings of 'false', 'true', 'inc/ex' and 'ex/inc' - but googlefroogle.php will ONLY add tax if the value is true...which gets you into trouble with Google eventually.

Two ways around this (assuming you want to use inc/ex or ex/inc) - either manually change the Display prices with tax to true before you run a feed, then change it back to your preferred inc/ex or ex/inc after the feed is created or, because that is really unworkable, edit includes/functions/functions_taxes.php. Find the function zen_add_tax (at about line 158) and then change if ( (DISPLAY_PRICE_WITH_TAX == 'true') && ($tax > 0) ) { to ```
if ( (DISPLAY_PRICE_WITH_TAX != 'false') && ($tax > 0) ) {

This helped me out no end. I was pulling out hair trying to find what was up with my Tax not showing till I stumbled across this.

Many many thanks.
Chris.

Yes this works, but in the shopping cart sitebox the price without Tax is wrong. Replacing the old code, the shopping cart sitebox show correct prices without Tax.:blink:
It tooks me some time to find the problem, maybe there is another solution for that.

I've been having to manually change my site to include tax every single time I've uploaded the google base file for the last 2 years! So this would be a lifesaver (especially as I want to get a cron job written to automatically upload it very soon)..

However.. your solution hasnt worked for me I'm afraid.

I've changed "if ( (DISPLAY_PRICE_WITH_TAX == 'false') && ($tax > 0) ) {"

But its still not including the products with TAX in the google feed..

Please Help! Our website will have 20,000+ products soon, updated daily so I really dont want to have to manually do this every day!!:blink:

It's not

_TAX == 'false'

it's

_TAX != 'false'

You're a star!

I'm an idiot!:smile:

Thanks Ryk.. sorry to waste your time, I'm always missing silly little things like that..

Ah... seems I have the same problem as zebolon, my shopping cart totals are showing the wrong totals now..

I've had to switch it back for the time being, any ideas please?

I guess there may be a way for forcing the google base feeder to add tax to all products?

Has anyone got a solution to this please? I really need to get this sorted. We lose business if our google base feed expires and I wont want to remember have to manually upload every month if I can avoid it!

Thought this was perfect, however I've noticed its adding tax on twice going through the checkout.