Revindex Storefront

How to use CSV tax file

Last updated on 2024-04-26 3 mins. to read

Using the custom tax rule, you can calculate tax rate from your own tax table. The tax table can be in CSV or any format you choose. The advantage of using a tax table is it makes editing tax rates quick and easy.

You can create your own tax table and modify the code below to reference the correct columns for zip, rate and city (see variables "col2", "col3", "col12" respectively). For the purposes of this example, we shall calculate the rate by using a sample CSV tax table from Zip2Tax (using the Full Breakout format). You can download a sample table here for the state of Ohio. We're merely interested in columns 2, 3 and 12.

  1. Upload the CSV to a public location on your server. You can reference a URL (e.g. "https://site/Portals/0/File.csv") or a local file (e.g. "file:///C:/Inetpub/Site/Portals/0/File.csv").
  2. Under Configuration > Taxes, add a new tax method. Give it a name like "Tax table".
  3. Choose Custom Rate type and Custom Rule for the rate rule.
  4. Paste the following XSL rule in the Rule view.

    <xsl:transform xmlns:xsl="" version="2.0">
      <xsl:template match="/">
        <!-- The following parser assumes the Zip2Tax csv file format with header on the first row. It will parse the csv file into xml that we can use to query -->
        <xsl:variable name="table" select="unparsed-text(' Storefront/Zip2TaxSample.csv')"/>
        <xsl:variable name="rows" select="tokenize($table, '\r?\n')"/>
        <xsl:variable name="data">
          <!-- Loop through each row skipping the first header record -->
          <xsl:for-each select="subsequence($rows, 2)">
              <xsl:for-each select="tokenize(., ',')">
                <xsl:element name="col{position()}">
                  <xsl:value-of select="."/>
        <xsl:variable name="city" select="lower-case(/in/salesOrder/billingCity)"/>
        <xsl:variable name="zipCode" select="substring(/in/salesOrder/billingPostalCode, 1, 5)"/>
        <xsl:variable name="taxRate">
          <!-- Try to match by exact city and zip, then by zip only and zero otherwise -->
            <xsl:when test="$data/tax[lower-case(col12) = $city and col2 = $zipCode]">
              <xsl:value-of select="$data/tax[lower-case(col12) = $city and col2 = $zipCode][1]/col3 div 100"/>
            <xsl:when test="$data/tax[col2 = $zipCode]">
              <xsl:value-of select="$data/tax[col2 = $zipCode][1]/col3 div 100"/>
            <xsl:value-of select="$taxRate * /in/this/salesOrderDetail/(amount + discountAmount)"/>
  5. Modify the XSL rule to replace the example URL with your own hosted CSV file.
  6. Save and test.


Powered by Revindex Wiki