For users of AspDotNetStorefront,  kindly presented by Mike Murphy.

Code to export sales data to Feefo using XML

add this codet to the '/admin/XMLpackages' folder and then add it to the 'product feeds page'
in admin....it then can be executed from the admin side

The package checks for orders which have been ordered in the last 30 days and shipped + 7days



<?xml version="1.0" standalone="yes" ?>
<package>
    <query name="OrderLines" rowElementName="Line">
        <sql>
            <![CDATA[
                select Orders.OrderNumber, Orders.LastName, Orders.FirstName, Orders.Email, Orders.Deleted, 
                convert(nvarchar(10),Orders.OrderDate,103) as OrderDate, convert(nvarchar(10),Orders.ShippedOn,103) as ShippedOn, 
                Orders.OrderTotal, Orders_ShoppingCart.OrderedProductName, Orders_ShoppingCart.OrderedProductSKU 
                from Orders, Orders_ShoppingCart 
                where (Orders.ShippedOn <= DATEADD(DAY,-7,GETDATE()) or Orders.DownloadEMailSentOn <= DATEADD(DAY, -7, GETDATE())) and Orders_ShoppingCart.OrderNumber = Orders.OrderNumber and Orders.OrderDate >= DATEADD(DAY,-31,GETDATE())
            ]]>
        </sql>
    </query>
    <PackageTransform>
        <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:aspdnsf="urn:aspdnsf" exclude-result-prefixes="aspdnsf">
            <xsl:output method="text" omit-xml-declaration="yes" indent="no"  encoding="utf-8"/>
            <xsl:template match="/">
                <xsl:text>Name	Email	Date	Description	Logon	Completion Date	Order line reference(SKU)	Order Ref</xsl:text><xsl:text>&#0013;&#0010;</xsl:text>
                <xsl:text>
</xsl:text>
                <xsl:apply-templates select="root/OrderLines/Line" />
            </xsl:template>
            <xsl:template match="Line">

                <!--<xsl:param name="OrderDate">
                    <xsl:value-of select="OrderDate" />
                </xsl:param>-->
                <xsl:value-of select="FirstName" />
                <xsl:text>&#0032;</xsl:text>
                <xsl:value-of select="LastName" />
                <xsl:text>&#0009;</xsl:text>
                <xsl:value-of select="Email" />
                <xsl:text>&#0009;</xsl:text>
                <xsl:value-of select="OrderDate" />
                <xsl:text>&#0009;</xsl:text>
                <xsl:value-of select="OrderedProductName" />
                <xsl:text>&#0009;</xsl:text>
                <xsl:text>www.thefreemason.com</xsl:text>
                <xsl:text>&#0009;</xsl:text>
                <xsl:value-of select="ShippedOn" />
                <xsl:text>&#0009;</xsl:text>
                <xsl:value-of select="OrderedProductSKU" />
                <xsl:text>&#0009;</xsl:text>
                <xsl:value-of select="OrderNumber" />
                <xsl:text>&#0013;&#0010;</xsl:text>
            </xsl:template>
        </xsl:stylesheet>
    </PackageTransform>
</package>