Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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:

      Code:
      <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:

      Code:
      <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:

      Code:
      <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:
      Code:
      <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.
Working...
X