Thread: Feed Tool for Bing Shopping

Is there a tool for generating a Bing Shopping feed built in or will I have to construct an XML file to do this myself?

You would need to create the feed yourself, you can look at the Google base feed to get an idea on how the file needs to be constructed, then you will need to find out what the Bing feed requirements are. The construction of the feed xmlpackage is fairly straight forward.

The Bing feed requires a tab delimited .txt file. Can this be done via the existing XmlPackage / admin site feed structure or will there need to be a workaround?

TIA

Here you go - we use this to export a tab deliminated txt file....just change the fields you want to include and add it to 'products > feeds' in the admin. You could modify this or the Google feed as appropriate.

For info, this exports customer/order data for collating customer feedback 7 days after the goods have been shipped.

HTML Code:

<?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>
</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> </xsl:text>
                <xsl:value-of select="LastName" />
                <xsl:text>	</xsl:text>
                <xsl:value-of select="Email" />
                <xsl:text>	</xsl:text>
                <xsl:value-of select="OrderDate" />
                <xsl:text>	</xsl:text>
                <xsl:value-of select="OrderedProductName" />
                <xsl:text>	</xsl:text>
                <xsl:value-of select="ShippedOn" />
                <xsl:text>	</xsl:text>
                <xsl:value-of select="OrderedProductSKU" />
                <xsl:text>	</xsl:text>
                <xsl:value-of select="OrderNumber" />
                <xsl:text>
</xsl:text>
            </xsl:template>
        </xsl:stylesheet>
    </PackageTransform>
</package>