How to create two Google shopping feeds for tax inclusive and exlusive prices

[G.W.Green]

The SellerDeck feed for Google Shopping can be configured for either tax-inclusive or tax-exclusive prices via its configuration dialog. But if you are selling to the US as well as the UK and/or Europe, you need feeds in both price formats. In SellerDeck 2016 using the following method you can add a second feed for Google Shopping, configured with tax-exclusive prices for the US market:

1. Select 'Library' from the 'Design' menu
2. Click the 'Layouts' tab, scroll down to the 'XML Feeds' layout type and expand it
3. Right-click 'Google Product Feed Layout’ and select 'Copy'
4. Right-click the copy, select 'Rename' and change the name to something like 'Google Product Feed Layout US'
5. Double-click the new layout.
6. Click 'Edit Layout Details' (bottom left) and change 'Online File Page Name' from 'google-products.xml' to 'google-products-us.xml'. Click ‘OK’
7. Find the first <g:price> tag and replace the whole line that (in Advanced View) looks like:
   
   

   <g:price><actinic:block if="%3cactinic%3avariable%20name%3d%22IsGoogleExportIncludeTax%22%20%2f%3e%20%3d%3d%200" ><actinic:variable name="TaxExclusivePriceRaw" /></actinic:block><actinic:block if="%3cactinic%3avariable%20name%3d%22IsGoogleExportIncludeTax%22%20%2f%3e" ><actinic:variable name="TaxInclusivePriceRaw" /></actinic:block> <actinic:variable name="DefaultIntCurrencySymbol" /></g:price>

   with:
   
   

   <g:price><actinic:variable name="TaxExclusivePriceRaw" /> <actinic:variable name="DefaultIntCurrencySymbol" /></g:price>

8. Find the second <g:price> tag and replace the whole line that (in Advanced View) looks like:
   
   

   <g:price><actinic:block if="%3cactinic%3avariable%20name%3d%22IsGoogleExportIncludeTax%22%20%2f%3e%20%3d%3d%200" ><actinic:variable name="ProductShipAndHandlingExcTax" /></actinic:block><actinic:block if="%3cactinic%3avariable%20name%3d%22IsGoogleExportIncludeTax%22%20%2f%3e" ><actinic:variable name="ProductShipAndHandlingIncTax" /></actinic:block> <actinic:variable name="DefaultIntCurrencySymbol" /></g:price>

   with:
   

   <g:price><actinic:variable name="ProductShipAndHandlingExcTax" /> <actinic:variable name="DefaultIntCurrencySymbol" /></g:price>

9. Click OK and Close, and upload

This will upload a second feed 'google-products-us.xml' to the site root with all prices tax-exclusive.