Search

Index

Revindex Storefront

Order alert email

Last updated on 2022-04-20 6 mins. to read

Email alerts are sent out whenever a new order is placed on your shopping cart. By default, the Storefront will send the alert to the sender email address listed under the Configuration > General settings.

The Basic template rule can accept XSL tokens to inject dynamic data. Below is the sample XML input that you can retrieve token values from:

<in>
  <configuration>
    <generalEmailRecipient>recipient@localhost.com</generalEmailRecipient>
    <generalEmailSender>test@example.com</generalEmailSender>
    <generalStoreName>Revindex Storefront</generalStoreName>
  </configuration>
  <portal>
    <cartTabs>
      <tab>
        <tabID>57</tabID>
      </tab>
    </cartTabs>
    <checkoutTabs>
      <tab>
        <tabID>61</tabID>
      </tab>
    </checkoutTabs>
    <manageOrderTabs>
      <tab>
        <tabID>62</tabID>
      </tab>
    </manageOrderTabs>
    <manageVoucherTabs>
      <tab>
        <tabID>174</tabID>
      </tab>
    </manageVoucherTabs>
    <portalAliases>
      <portalAlias>
        <cultureCode></cultureCode>
        <httpAlias>site.com</httpAlias>
        <isPrimary>true</isPrimary>
        <portalAliasID>1</portalAliasID>
      </portalAlias>
    </portalAliases>
    <portalID>0</portalID>
  </portal>
  <salesOrder>
    <billingCity>Beverley Hills</billingCity>
    <billingCompany>Revindex</billingCompany>
    <billingCountryCode>US</billingCountryCode>
    <billingCountryName>United States</billingCountryName>
    <billingDistrict />
    <billingEmail>text@example.com</billingEmail>
    <billingFirstName>John</billingFirstName>
    <billingLastName>Doe</billingLastName>
    <billingPhone>111-111-1111</billingPhone>
    <billingPostalCode>90210</billingPostalCode>
    <billingStreet>1 Melrose</billingStreet>
    <billingSubdivisionCode>US-CA</billingSubdivisionCode>
    <billingSubdivisionName>California</billingSubdivisionName>
    <billingUnit />
    <businessTaxNumber>GB 123456789</businessTaxNumber>
    <couponCodes>
      <couponCode>free2</couponCode>
    </couponCodes>
    <cultureCode>en-US</cultureCode>
    <currency>
      <currencySymbol>$</currencySymbol>
      <isoCurrencySymbol>USD</isoCurrencySymbol>
    </currency>
    <currencyCultureCode>en-US</currencyCultureCode>
    <dynamicFormResult>
      <fields>
        <field id="CustomName">Name1</field>
        <field id="CustomText">MyText</field>
        <field id="CustomColor">
          <selected>Red</selected>
          <selected>Blue</selected>
        </field>
        <field id="CustomSize">
          <selected>XL</selected>
        </field>
      </fields>
    </dynamicFormResult>
    <exchangeRate>1.0000</exchangeRate>
    <formattedSubTotalAmount>$10.00</formattedSubTotalAmount>
    <formattedTotalAmount>$20.00</formattedTotalAmount>
    <formattedTotalHandlingAmount>$9.00</formattedTotalHandlingAmount>
    <formattedTotalSalesOrderDetailDiscountAmount>$0.00</formattedTotalSalesOrderDetailDiscountAmount>
    <formattedTotalSavingsAmount>$0.00</formattedTotalSavingsAmount>
    <formattedTotalShippingAmount>$1.00</formattedTotalShippingAmount>
    <formattedTotalTaxAmount></formattedTotalTaxAmount>
    <handlingAmount>9.00</handlingAmount>
    <handlingDiscountAmount>0</handlingDiscountAmount>
    <orderDate>2001-01-01T12:00:00</orderDate>
    <origin>1</origin>
    <parentSalesOrderID></parentSalesOrderID>
    <purchaseOrderNumber></purchaseOrderNumber>
    <rewardsPointsQualified>0</rewardsPointsQualified>
    <salesOrderDetails>
      <salesOrderDetail>
        <amount>10.0000</amount>
        <amountWithTax>10.0000</amountWithTax>
        <bookingStartDate></bookingStartDate>
        <bookingStopDate></bookingStopDate>
        <combinedAmount>10.0000</combinedAmount>
        <combinedAmountWithTax>10.0000</combinedAmountWithTax>
        <combinedPrice>10.0000</combinedPrice>
        <combinedTotalAmount>10.0000</combinedTotalAmount>
        <combinedTotalAmountWithTax>10.0000</combinedTotalAmountWithTax>
        <discountAmount>0</discountAmount>
        <dynamicFormResult>
          <fields>
            <field id="CustomURL">http://www.yahoo.com</field>
            <field id="CustomText">MyText</field>
            <field id="CustomColor">
              <selected>Red</selected>
              <selected>Blue</selected>
            </field>
            <field id="CustomSize">
              <selected>XL</selected>
            </field>
          </fields>
        </dynamicFormResult>
        <formattedAmount>$10.00</formattedAmount>
        <formattedCombinedAmount>$10.00</formattedCombinedAmount>
        <formattedCombinedDiscountAmount>$0.00</formattedCombinedDiscountAmount>
        <formattedCombinedPrice>$10.00</formattedCombinedPrice>
        <formattedCombinedTotalAmount>$10.00</formattedCombinedTotalAmount>
        <formattedDiscountAmount>$0.00</formattedDiscountAmount>
        <formattedPrice>$10.00</formattedPrice>
        <formattedTotalAmount>$10.00</formattedTotalAmount>
        <parentSalesOrderDetailID></parentSalesOrderDetailID>
        <price>10.0000</price>
        <productName>Good Book</productName>
        <productVariant>
          <basePrice>10.0000</basePrice>
          <galleries />
          <inventoryUnitType>1</inventoryUnitType>
          <msrp>10.0000</msrp>
          <name>Series 1</name>
          <product>
            <galleries>
              <gallery>
                <alternateText />
                <displayOrder>1000</displayOrder>
                <family>12</family>
                <format>1</format>
                <height>609</height>
                <mediaType>image/jpeg</mediaType>
                <mediaUrl>http://site.com/image.jpg</mediaUrl>
                <width>1000</width>
              </gallery>
            </galleries>
            <name>Good Book</name>
            <summary></summary>
          </product>
          <sku>A100</sku>
          <summary></summary>
        </productVariant>
        <productVariantExtension>
          <data>
            <shippingRate>1.00</shippingRate>
          </data>
        </productVariantExtension>
        <productVariantName>Series 1</productVariantName>
        <quantity>1</quantity>
        <salesOrderDetailID>102</salesOrderDetailID>
        <shippingStatus>3</shippingStatus>
        <sku>A100</sku>
        <status>1</status>
        <totalAmount>10.0000</totalAmount>
        <totalAmountWithTax>10.0000</totalAmountWithTax>
      </salesOrderDetail>
    </salesOrderDetails>
    <salesOrderGUID>F2CB78A0-5B3B-489a-9E62-006372ACAE34</salesOrderGUID>
    <salesOrderNumber>SA1000</salesOrderNumber>
    <salesPayments>
      <salesPayment>
        <amount>10.0000</amount>
        <creditCardHint>4345</creditCardHint>
        <formattedAmount>$10.00</formattedAmount>
        <paymentDate>2001-01-01T12:00:00</paymentDate>
        <paymentGateway>PayPalWPP</paymentGateway>
        <paymentHint></paymentHint>
        <paymentMethod>3</paymentMethod>
        <paymentMethodName>Credit card</paymentMethodName>
        <responseCode>1</responseCode>
        <transactionType>2</transactionType>
        <voucherHint></voucherHint>
      </salesPayment>
    </salesPayments>
    <salesPaymentStatus>1</salesPaymentStatus>
    <seller>
      <city>Beverley Hills</city>
      <countryCode>US</countryCode>
      <district />
      <email>test@example.com</email>
      <phone>111-111-1111</phone>
      <postalCode>90210</postalCode>
      <street>1 Melrose</street>
      <subdivisionCode>US-CA</subdivisionCode>
      <unit />
    </seller>
    <sellerID>1</sellerID>
    <shippingAmount>1.00</shippingAmount>
    <shippingCity>Beverley Hills</shippingCity>
    <shippingCompany>Revindex</shippingCompany>
    <shippingCountryCode>US</shippingCountryCode>
    <shippingCountryName>United States</shippingCountryName>
    <shippingDestinationPoint></shippingDestinationPoint>
    <shippingDiscountAmount>0</shippingDiscountAmount>
    <shippingDistrict />
    <shippingEmail>text@example.com</shippingEmail>
    <shippingExtension></shippingExtension>
    <shippingFirstName>John</shippingFirstName>
    <shippingLastName>Doe</shippingLastName>
    <shippingMethod>
      <name>Ground</name>
    </shippingMethod>
    <shippingMethodID>2</shippingMethodID>
    <shippingPhone>111-111-1111</shippingPhone>
    <shippingPostalCode>90210</shippingPostalCode>
    <shippingQuoted>false</shippingQuoted>
    <shippingStatus>1</shippingStatus>
    <shippingStreet>1 Melrose</shippingStreet>
    <shippingSubdivisionCode>US-CA</shippingSubdivisionCode>
    <shippingSubdivisionName>California</shippingSubdivisionName>
    <shippingTrackingCode>GH88888</shippingTrackingCode>
    <shippingUnit />
    <status>2</status>
    <subTotalAmount>10.00</subTotalAmount>
    <subTotalAmountWithTax>10.00</subTotalAmountWithTax>
    <taxAmount1>0.00</taxAmount1>
    <taxAmount2>0.00</taxAmount2>
    <taxAmount3>0.00</taxAmount3>
    <taxAmount4>0.00</taxAmount4>
    <taxAmount5>0.00</taxAmount5>
    <taxDiscountAmount>0</taxDiscountAmount>
    <totalAmount>20.00</totalAmount>
    <totalHandlingAmount>9.00</totalHandlingAmount>
    <totalHandlingAmountWithTax>9.00</totalHandlingAmountWithTax>
    <totalSalesOrderDetailDiscountAmount>0.00</totalSalesOrderDetailDiscountAmount>
    <totalSavingsAmount>0.00</totalSavingsAmount>
    <totalShippingAmount>1.00</totalShippingAmount>
    <totalShippingAmountWithTax>1.00</totalShippingAmountWithTax>
    <userHostAddress>127.0.0.1</userHostAddress>
    <warehouse>
      <city>Beverley Hills</city>
      <countryCode>US</countryCode>
      <district />
      <email></email>
      <phone></phone>
      <postalCode>90210</postalCode>
      <street>1 Melrose</street>
      <subdivisionCode>US-CA</subdivisionCode>
      <unit />
    </warehouse>
    <warehouseID>1</warehouseID>
  </salesOrder>
  <user>
    <email>user@address.com</email>
    <firstName>John</firstName>
    <lastName>Doe</lastName>
    <profile>
      <profileProperties>
        <Biography></Biography>
        <Cell></Cell>
        <City>Beverley Hills</City>
        <Country>United States</Country>
        <Fax></Fax>
        <FirstName>John</FirstName>
        <IM></IM>
        <LastName>Doe</LastName>
        <MiddleName></MiddleName>
        <Photo></Photo>
        <PostalCode>90210</PostalCode>
        <PreferredLocale>en-US</PreferredLocale>
        <Prefix></Prefix>
        <Region>California</Region>
        <Street>1 Melrose</Street>
        <Suffix></Suffix>
        <Telephone>111-111-1111</Telephone>
        <TimeZone>0</TimeZone>
        <Unit></Unit>
        <Website></Website>
      </profileProperties>
    </profile>
    <roles>
      <role>Role1</role>
      <role>Role2</role>
    </roles>
    <userHostAddress>127.0.0.1</userHostAddress>
    <userID>1</userID>
    <username>host</username>
  </user>
</in>

Comments

Kannan Dec 01, 2015 2:07 PM
Hi,

In any version of Revindex Storefront, is there a facility to display the fields from areas of the database other than the XSL tokens mentioned in http://www.revindex.com/Resources/Knowledge-Base/Revindex-Storefront/rvdwktid/264?

In our environment, we have specified the "Email recipient" in "Configurations -> General" and in a custom configuration parameters table (outside Revindex) we manage a configuration parameter called "Order Alert Email Recipient Name". We would like to retrieve the name stored there and display in the order alert email.

So, instead of having "Hi," in the order alert email, we could have "Hi John," (or something similar depending on whatever value stored in that configuration parameter table. Hope this makes sense. Please advise if that's possible. Thanks.
Stephen Lim Feb 11, 2016 5:07 AM
If you can figure a way to store the data with the user profile (you can create your own profile definition), then any profile information is exposed to most of the email templates as input.

XSL also has the ability to retrieve data from external source via the document() and unparsed-text() function where you can pass a URL with parameters and retrieve the data back. So in theory, if you can expose a URL that can return data that you need, you can let the XSL query your data externally.

Powered by Revindex Wiki