Thread: New Pricing Feeds

We are working now on new product/pricing feed XmlPackages for:

amazon,
yahoo shopping,
pricegrabber,
shopping.com, and
shopzilla (bizrate).

Anyone with support contracts will have access to them. They "should" work with any v7.0 storefront or higher...ETA a week or so...

Thanks.

AWESOME. like you read my mind guys. and before the holidays as well? BONUS!

can't tell you how many times i've thought "damn, i'm glad i went with this company!"

Originally Posted by AspDotNetStorefront

We are working now on new product/pricing feed XmlPackages for:

amazon,
yahoo shopping,
pricegrabber,
shopping.com, and
shopzilla (bizrate).

Anyone with support contracts will have access to them. They "should" work with any v7.0 storefront or higher...ETA a week or so...

Thanks.

Any chance this is going to be done for the upcoming holiday season?

yes, we hope so

We have feeds from Dev, should be posted in the updates page on our main site as an add-on type set of files you can deploy.

Keep in mind, that we have created the feeds as given to apply to as many types of stores/sites as possible, but due to the nature of feeds and the shopping site requirements, you may have to customize the feeds to match your/their own requirements, so keep that in mind.

I hope to have this posted by tonight (Monday PT)

Feeds provided in attached download zip. Installation instructions included. Feeds are provided "as-is"...as most feeds need to be customized for each particular store site, and the feed target sites change their requirements OFTEN...use these as a starting point.

We will continue to provide support for the Googlebase feed in Customer Support.

The other feeds are only supported here in the forums.

Starting (sample) free feeds are provided for:

Yahoo!
pricegrabber
shopping.com
shopzilla and
amazon

Feeds were tested using "some" test data on v7.0.2.3 ML code base. Your mileage may vary...and you may have to customize the feeds for your own unique site/product requirements and/or listing requirements with each target site.

Feeds.zip updated 11/30/2007 with new install instructions for new web.config element required. no package mods.

Updated feeds.zip just now to 1.1 version indicate in comments in XmlPackage header.

Changes: added more SQL criteira for filtering of customer levels, honoring availablestartdate, etc...

What service do we need to sign up for with Amazon to use the Amazon feed?

You need a Pro Merchant subscription.

I'm getting this error when I try to execute a feed:

XmlPackage Exception: Exception=Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/><br/>System.ArgumentException: Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/>
at AspDotNetStorefrontCommon.XmlPackage2.TransformStr ing() in c:\...\ASPDNSFCommon\XmlPackage2.cs:line 620

I copied the XmlParse.cs to the appcode.

Are there any webconfig settings that are needed like mentioned in this thread?

what storefront version are you running? which feed also? They run just fine here for me.

The Google Base package (feed.googlebase.xml) can also be uploaded through the Google Sitemap control panel.

It is read as an RSS feed without any error...

The number of products indexed is correctly shown and takes less than 15 minutes

The googlebase feed file can be used in conjunction with the Google Sitemap Webmaster system.

googlebase feed file/v6.1/Web/Admin/XmlPackages/feed.googlebase.xml.config (old version)

We're running 7.0.2.1

Originally Posted by AspDotNetStorefront

what storefront version are you running? which feed also? They run just fine here for me.

I've tested on 7023+...you might as noted in the docs have to make some mods for older versions.

I'm getting the same error as LarryW. I downloaded the feeds today, 11/30/07. My version is 7.0.2.3.

Any ideas on where to look?

Fox

which feed exactly? I just cannot reproduce this here. I'll see if someone else here can.

I'm currently working with the Yahoo feed. I ran the GoogleBase feed before and after installing the new packages and it ran fine both times.

Sorry I didn't included that info previously

Fox

Ok, I had made this mod, but forgot to put it in the install docs. Just add this to your web.config file

Code:

<xsltobjects defaultExtension="">
  <extensions>
    <clear/>
    <add name="Feed Extensions" type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>
  </extensions>
</xsltobjects>

the new line is this one:

Code:

<add name="Feed Extensions" type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>

below the <clear/>

no wonder I couldn't reproduce this here...

zip updated (4th post in thread, updated 11/30/2007 with revised install instructions). no package mods.

Thanks a lot, the fix worked great

Fox

Cool!

Now all we need is MSN, Nextag, and Simple Simon

go for it...

Yep If you read through the installation steps the web.config settings are in there...

Code:

 Add this line to your web.config, just below the <clear/> line in the
<xsltobjects> section:
<add name="Feed Extensions"
type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>
e.g.:
<!-- Add your own custom XSLTExtensionObjects here -->
<xsltobjects defaultExtension="">
<extensions>
<clear/>
<add name="Feed Extensions"
type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>
</extensions>
</xsltobjects>

When tring to utilize these files, I get the following error

The files '/App_Code/XmlParse.cs' and '/App_Code/SkinBase.vb' use a different language, which is not allowed since they need to be compiled together.

IS there a vb version of XmlParse available somewhere? I looked on the main site but could not find.

Thank You

You can create a new folder under the app_code folder, called "Feeds", and place the XmlParse.cs file in there.

To make your website aware of the folder, add these lines to \web\web.config, under the <compilation> tag:

Code:

<codeSubDirectories>
  <add directoryName="Feeds"/>
</codeSubDirectories>

Hi

I have encountered an issue.D:\BlueLion\Work\MLVBDemo\ASPDNSFCommon\AppL ogic.vb:line
My version is AspDotNetStorefront ML 7.1.0.0/7.1.0.0



XmlPackage Exception: Exception=Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/><br/>System.ArgumentException: Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/>
at AspDotNetStorefrontCommon.XmlPackage2.TransformStr ing()
at AspDotNetStorefrontCommon.AppLogic.RunXmlPackage(X mlPackage2 p, Parser UseParser, Customer ThisCustomer, Int32 SkinID, Boolean ReplaceTokens, Boolean WriteExceptionMessage) in D:\BlueLion\Work\MLVBDemo\ASPDNSFCommon\AppLogic.v b:line 830<br />


Please help me out i am stuck here

Thanks
Gaurav
Infoquest Solutions
info@infoquestsolutions.com

Have you declared a namespace called "feed" in your XMLPackage? The error indicates that you haven't registered anything to implement that namespace. This is typically done in the <xsltobjects>-section of web.config.

thanks for reply.Yes i have done this as:

<xsltobjects defaultExtension="">
<extensions>
<clear/>
<add name="Feed Extensions" type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>
</extensions>
</xsltobjects>

regards,
Gaurav

So far the only way I can replicate the error is by not having the same namespace defined in the web.config setting as I have in my stylesheet element.

What does your stylesheet element look like?

yes...its declared as public...please help me to get out of this.thanks

regards,
Gaurav

What does your stylesheet element look like?

what stylesheet element you are talking about.Sorry not able to get you.

regards,
Gaurav

the xml package <stylesheet> element

<PackageTransform>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:a="http://www.ecb.int/vocabulary/2002-08-01/eurofxref"
xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01"
xmlns:aspdnsf="urn:aspdnsf" exclude-result-prefixes="aspdnsf a gesmes">
<xslutput method="xml" omit-xml-declaration="no" standalone="yes" indent="yes"/>

<xsl:template match="/">
<root>
<updated>
<xsl:value-of select="/root/feed/gesmes:Envelope/a:Cube/a:Cube/@time"/>
</updated>
<referencecurrencycode>
<xsl:value-of select="aspdnsf:AppConfig('Localization.CurrencyFe edBaseRateCurrencyCode')" />
</referencecurrencycode>
<xsl:for-each select="/root/feed/gesmes:Envelope/a:Cube/a:Cube/a:Cube">
<currency name="{@name}" code="{@currency}" rate="{@rate}" />
</xsl:for-each>
</root>
</xsl:template>

</xsl:stylesheet>

</PackageTransform>

This is what is there .

regards,
Gaurav

D:\BlueLion\Work\MLVBDemo\ASPDNSFCommon\AppL ogic.vb:line
this directory is not on my computer

in order for your package to use your extension you have to inlcude its namespace, for instance in your stylesheet element:

Code:

<stylesheet xmlns:myfeed="urn:feed">

<xsl:variable name="foo" select="myfeed:my_extension_function()" />
</stylesheet>

<PackageTransform>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:aspdnsf="urn:aspdnsf" xmlns:feed ="urn:feed" exclude-result-prefixes="aspdnsf feed">
<xslutput method="text" omit-xml-declaration="yes" encoding="UTF-16" />

<xsl:template match="/">product-id product-id-type item-condition price sku quantity add-delete will-ship-internationally expedited-shipping item-note item-is-marketplace item-name item-description category1 image-url shipping-fee browse-path storefront-feature boldface asin1 asin2 asin3&#xD;<xsl:apply-templates select="/root/Products/Product" />
</xsl:template>

<xsl:template match="Product">
<xsl:variable name="pfeeddata" select="feed:ConvertToNodeSet(ProductFeedData)" />
<xsl:variable name="vfeeddata" select="feed:ConvertToNodeSet(VariantFeedData)" />
<xsl:variable name="pAmazondata" select="$pfeeddata/feeddata/feed[@name='amazon']" />
<xsl:value-of select="$pAmazondata/data[@name='productid']/@value" /><xsl:text> </xsl:text><xsl:value-of select="$pAmazondata/data[@name='productidtype']/@value" /><xsl:text> </xsl:text>11<xsl:text> </xsl:text><xsl:choose><xsl:when test="number(saleprice)=0"><xsl:value-of select="format-number(price, '###0.00')" disable-output-escaping="yes" /></xsl:when><xsltherwise><xsl:value-of select="format-number(saleprice, '###0.00')" disable-output-escaping="yes" /></xsltherwise></xsl:choose><xsl:text> </xsl:text><xsl:value-of select="aspdnsf:GetMLValue(ManufacturerPartNumber) " /><xsl:text> </xsl:text><xsl:value-of select="Inventory" /><xsl:text> </xsl:text>a<xsl:text> </xsl:text><xsl:value-of select="$pAmazondata/data[@name='willshipinternationally']/@value" /><xsl:text> </xsl:text>n<xsl:text> </xsl:text><xsl:text> </xsl:text>y<xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text>
</xsl:template>
</xsl:stylesheet>
</PackageTransform


Yes this is already done in feed.amazon.xml

regards,
Gaurav

I don't understand what your trying to give us here. You've posted two different xml packages and one error message with no association asw to which package the error is coming from.
All I can tell you is that you must declare your extension's namespace in every xml package that will be using it.

Can i get the detail decription of how to create product feeds for amazon.com in aspdotnetstorefront.From e\where can i get this whole decription

regards,
Gaurav

hi
I have encountered the following problem while creating the feeds:

D:\BlueLion\Work\MLVBDemo\ASPDNSFCommon\AppL ogic.vb:line
My version is AspDotNetStorefront ML 7.1.0.0/7.1.0.0

XmlPackage Exception: Exception=Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/><br/>System.ArgumentException: Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/>
at AspDotNetStorefrontCommon.XmlPackage2.TransformStr ing()
at AspDotNetStorefrontCommon.AppLogic.RunXmlPackage(X mlPackage2 p, Parser UseParser, Customer ThisCustomer, Int32 SkinID, Boolean ReplaceTokens, Boolean WriteExceptionMessage) in D:\BlueLion\Work\MLVBDemo\ASPDNSFCommon\AppLogic.v b:line 830<br />


I have added the required code in web.config file:

Code:

<xsltobjects defaultExtension="">
<extensions>
<clear/>
<add name="Feed Extensions" type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>
</extensions>
</xsltobjects>

i have also followed all the steps required.

My XmlPackage is as given:

Code:

<?xml version="1.0" encoding="utf-8" ?>
<!-- ###################################################################################################### -->
<!-- Copyright AspDotNetStorefront.com, 1995-2007. All Rights Reserved. -->
<!-- http://www.aspdotnetstorefront.com -->
<!-- For details on this license please visit the product homepage at the URL above. -->
<!-- THE ABOVE NOTICE MUST REMAIN INTACT. -->
<!-- ###################################################################################################### -->
<!-- -->
<!-- The Amazon feed package supports basic store feeds for upload to Amazon.com. -->
<!-- v1.1 -->
<!-- -->
<!-- This version only supports basic feed data, although placeholders are in place for entering extended -->
<!-- data if desired. Feed data which does not map directly to Product or Variant data columns should be -->
<!-- stored in the ExtensionData field in an XML fragment. This ExtensionData field allows you to specify -->
<!-- attributes unique to each target feed site. See below for the xml values used for this feed -->
<!-- -->
<!-- This feed is currently limited to product default variants and reads the xml fragment from the Product -->
<!-- ExtensionData field. You will need to ensure that every product includes the appropriate extensiondata -->
<!-- field values. Many sites only let you list "one" instance of a product, so they do not support -->
<!-- variants as we do in the storefront. Also if you need to list each size/color separately, you would -->
<!-- have to modify the feed given here (again, many sites do not allow those to be listed separately) -->
<!-- -->
<!-- The "FroogleDescription" field is still used for the description. This is for backwards compatibility. -->
<!-- This field should not contain any HTML. -->
<!-- -->
<!-- Criteria: We also only list products that match all criteria shown below in the SQL query where -->
<!-- clause. By default, we exclude kits and packs also, as their price is not known now. -->
<!-- -->
<!-- Filtering: This also only shows "retail" produtcs (e.g. not mapped to a customer level and not mapped -->
<!-- to a specific "affiliate" as the default filtering used. -->
<!-- -->
<!-- Expected usage is for en-US/US sites only. If you are on a non en-US site, you will have to make mods -->
<!-- -->
<!-- Example Feed ExtensionData: -->
<!-- -->
<!-- <feeddata> -->
<!-- <feed name="amazon"> -->
<!-- <data name="productid" value="123-456-ABC-def" /> -->
<!-- <data name="productidtype" value="1" /> -->
<!-- <data name="willshipinternationally" value="n"/> -->
<!-- </feed> -->
<!-- <feed name="pricegrabber"> -->
<!-- <data name="" value=""/> -->
<!-- </feed> -->
<!-- </feeddata> -->
<!-- -->
<!-- Required elements for Amazon feed: -->
<!-- productid - Product-id is a unique identifier that describes this product. Several industry standard -->
<!-- idenifiers are currently in use (such as ISBN, UPC, EAN and Amazon's ASIN). -->
<!-- -->
<!-- productidtype - Select one of the following types: 1 = ASIN; 2 = ISBN; 3 = UPC; 4 = EAN -->
<!-- -->
<!-- willshipinternationally - "1" or "n": US only; "2" or "y": Will ship to international locations -->
<!-- -->
<!-- ###################################################################################################### -->
 
<package displayname="Amazon Feed" version="2.1" debug="false" includeentityhelper="false">
    <query name="Products" rowElementName="Product">
        <sql>
            <![CDATA[
            select 
                p.productid, 
                p.name, 
                p.description, 
                p.sename, 
                p.ImageFileNameOverride, 
                p.ManufacturerPartNumber, 
                isnull(p.FroogleDescription, '') ProductFroogleDescription, 
                isnull(pv.Weight, 0) Weight,
                pv.price,
                isnull(pv.MSRP, pv.price) MSRP,
                pv.inventory,
                isnull(pv.saleprice, 0) saleprice, 
                isnull(pv.FroogleDescription, '') VariantFroogleDescription, 
                isnull(pv.description, '') VariantDescr, 
                m.Name AS ManName,
                p.ExtensionData ProductFeedData,
                pv.ExtensionData VariantFeedData                
            from product p with (NOLOCK) 
            INNER JOIN ProductManufacturer pm with (NOLOCK) ON p.ProductID = pm.ProductID 
            INNER JOIN Manufacturer m with (NOLOCK) ON pm.ManufacturerID = m.ManufacturerID 
            INNER JOIN ProductVariant pv with (NOLOCK) ON p.ProductID = pv.ProductID
left join (select variantid, sum(quan) inventory from dbo.inventory with (NOLOCK) group by variantid) i on pv.variantid = i.variantid
            where 
                p.Published = 1
                and p.IsSystem=0 
                and p.Deleted = 0 
                and p.ExcludeFromPriceFeeds = 0
                and p.IsAKit = 0
                and p.IsAPack = 0
                and p.ShowBuyButton = 1
                and p.RequiresRegistration = 0
                and p.HidePriceUntilCart = 0
                and (p.AvailableStartDate IS NULL or p.AvailableStartDate <= getdate())
                and (p.AvailableStopDate IS NULL or p.AvailableStopDate >= getdate())
and case p.TrackInventoryBySizeAndColor when 1 then isnull(i.inventory, 0) else pv.inventory end >= @HideProductsWithLessThanThisInventoryLevel
                and pv.isdefault = 1
                and pv.published = 1
                and pv.deleted=0
                and p.ProductID not in (select ProductID from ProductCustomerLevel with (NOLOCK))
                and p.ProductID not in (select ProductID from ProductAffiliate with (NOLOCK))
            ]]>
        </sql>
<queryparam paramname="@HideProductsWithLessThanThisInventoryLevel" paramtype="appconfig" requestparamname="HideProductsWithLessThanThisInventoryLevel" sqlDataType="int" defvalue="0" validationpattern="" />
    </query>
    <PackageTransform>
        <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:aspdnsf="urn:aspdnsf" xmlns:feed ="urn:feed" exclude-result-prefixes="aspdnsf feed">
            <xsl:output method="text" omit-xml-declaration="yes" />
 
            <xsl:template match="/">product-id product-id-type item-condition price sku quantity add-delete will-ship-internationally expedited-shipping item-note item-is-marketplace item-name item-description category1 image-url shipping-fee browse-path storefront-feature boldface asin1 asin2 asin3&#xD;<xsl:apply-templates select="/root/Products/Product" />
            </xsl:template>
 
            <xsl:template match="Product">
                <xsl:variable name="pfeeddata" select="feed:ConvertToNodeSet(ProductFeedData)" />
                <xsl:variable name="vfeeddata" select="feed:ConvertToNodeSet(VariantFeedData)" />
                <xsl:variable name="pAmazondata" select="$pfeeddata/feeddata/feed[@name='amazon']" />
<xsl:value-of select="$pAmazondata/data[@name='productid']/@value" /><xsl:text> </xsl:text><xsl:value-of select="$pAmazondata/data[@name='productidtype']/@value" /><xsl:text> </xsl:text>11<xsl:text> </xsl:text><xsl:choose><xsl:when test="number(saleprice)=0"><xsl:value-of select="format-number(price, '###0.00')" disable-output-escaping="yes" /></xsl:when><xsl:otherwise><xsl:value-of select="format-number(saleprice, '###0.00')" disable-output-escaping="yes" /></xsl:otherwise></xsl:choose><xsl:text> </xsl:text><xsl:value-of select="aspdnsf:GetMLValue(ManufacturerPartNumber)" /><xsl:text> </xsl:text><xsl:value-of select="Inventory" /><xsl:text> </xsl:text>a<xsl:text> </xsl:text><xsl:value-of select="$pAmazondata/data[@name='willshipinternationally']/@value" /><xsl:text> </xsl:text>n<xsl:text> </xsl:text><xsl:text> </xsl:text>y<xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text>
            </xsl:template>
        </xsl:stylesheet>
    </PackageTransform>
</package>

Not able to know where is the problem.I want to create Amazon Feed.Please help me out of this

Thanks
Gaurav
Infoquest Solutions

I get a "Cannot find the script or external object that implements prefix 'urn:feed'." error with VB version 7.1.0.0.

I've tried both a VB-converted version of XmlParse.cs in the app_code version and the original cs version in a feeds directory.

Any suggestions?

Regards

John

I've set up the Feed XML but get an error in the XML processing:

"Cannot find the script or external object that implements prefix 'urn:feed'."

I've tried both a VB-converted version of XmlParse.cs in the app_code version and the original cs version in a feeds directory.

Any suggestions?

Regards

John

Hi gaurav,

I am looking into this. I'll post a comment later this afternoon.

I just finished testing the feed.zip download in ML 7.1 cs and vb versions.
I had no problems either way.

Some one email me their version of XmlParse.vb.

I only have the XmlParse.cs

Hi Rex

I've put that DLL in the bin folder but still the same error.

Here's my VB version which I had sitting in the App_Code/feeds folder.

Code:

' ------------------------------------------------------------------------------------------
' Copyright AspDotNetStorefront.com, 1995-2007. All Rights Reserved.
' http://www.aspdotnetstorefront.com
' For details on this license please visit the product homepage at the URL above.
' THE ABOVE NOTICE MUST REMAIN INTACT.
' ------------------------------------------------------------------------------------------
Imports System
Imports System.Xml.XPath

Namespace AspDotNetStorefrontCommon
   
    Public Class XmlParse
        Inherits XSLTExtensionBase
        Public Sub New(ByVal cust As Customer, ByVal SkinID As Integer)
            MyBase.New(cust, SkinID)
        End Sub
       
        Public Sub New(ByVal cust As Customer, ByVal SkinID As Integer, ByVal EntityHelpers As System.Collections.Generic.Dictionary(Of String, EntityHelper))
            MyBase.New(cust, SkinID, EntityHelpers)
        End Sub
       
        Public Function ConvertToNodeSet(ByVal strXML As String) As XPathNodeIterator
            Dim rootNodeName As String = "feedata"
            Return ConvertToNodeSet(strXML, rootNodeName)
        End Function
       
        Public Function ConvertToNodeSet(ByVal strXML As String, ByVal rootNodeName As String) As XPathNodeIterator
            If strXML.Contains(">") Then
                strXML = HtmlDecode(strXML)
            End If
           
            If strXML.Trim().Length = 0 Then
                strXML = String.Format("<{0} />", rootNodeName)
            End If
           
            Dim rdr As New System.IO.StringReader(strXML)
            Dim doc As New XPathDocument(rdr)
            Dim nav As XPathNavigator = doc.CreateNavigator()
           
            Dim expr As XPathExpression
            expr = nav.Compile("/")
           
            Dim iterator As XPathNodeIterator = nav.[Select](expr)
           
            Return iterator
        End Function
       
    End Class
End Namespace

Yes, I see that. It works compiled into the AspDotNetStorefrontCommon.dll but not as a separate assembly dll. I will try breaking it out into its own namespace and assembly and see if that works. Maybe there is some assembly/namespace conflict going on.

Remove the DLL I posted and put the XmlParse.cs back into a App_Code\Feeds directory

Then try adding a codeSubDirectories element to your web.config's compilation section:

Code:

<compilation debug="true">
    <codeSubDirectories>
        <add directoryName="Feeds" />
    </codeSubDirectories>
</compilation>

This should tell .Net to make a separate assembly of that directory and allow the mixture of VB and C# being used in App_Code

If this does not work for you, please submit a support ticket. You may be encountering a known issue that requires a fix be sent to you.

I have tried all the steps in this posts, and I am still having problems. This is the error message I keep getting:

XmlPackage Exception: Exception=Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/><br/>System.ArgumentException: Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.<br/><br/>
at AspDotNetStorefrontCommon.XmlPackage2.TransformStr ing() in D:\BlueLion\Work\MLVBDemo\ASPDNSFCommon\XmlPackage 2.vb:line 537
at AspDotNetStorefrontCommon.AppLogic.RunXmlPackage(X mlPackage2 p, Parser UseParser, Customer ThisCustomer, Int32 SkinID, Boolean ReplaceTokens, Boolean WriteExceptionMessage) in D:\BlueLion\Work\MLVBDemo\ASPDNSFCommon\AppLogic.v b:line 965<br />

Please help me out...

EnricoBozzetti,

I contacted Misakko and sent them the feed files, and they were able to get it fixed and working for me.

I think they charged $175

I could not get the XML Packages to find my new functions.
ASPDNSF Support said that the VB version of the VB version of the code needs a minor modification to work correctly.

If you do not have the source code, you can contact support for a new dll.

In XsltObjects\ExtensionConfiguration.vb find the following four lines.
Line numbers are approximate:
-------------------------------------------------
(I don't know if this one is important)

Code:

29: Private _Extensions As New Hashtable()

replace with

Code:

Private _Extensions As Hashtable = New Hashtable()

------------------------------------------------

Code:

32: If child.Name Is "extensions" Then

replace with

Code:

If "extensions".Equals(child.Name, StringComparison.InvariantCultureIgnoreCase) Then

------------------------------------------------

Code:

40: If extension.Name Is "add" Then

replace with

Code:

If "add".Equals(extension.Name, StringComparison.InvariantCultureIgnoreCase) Then

------------------------------------------------

Code:

42: ElseIf extension.Name Is "remove" Then

replace with

Code:

ElseIf "remove".Equals(extension.Name, StringComparison.InvariantCultureIgnoreCase) Then

------------------------------------------------

Code:

44: ElseIf extension.Name Is "clear" Then

replace with

Code:

ElseIf "clear".Equals(extension.Name, StringComparison.InvariantCultureIgnoreCase) Then

------------------------------------------------
Again, if you do not have source code access, contact support and they can send you a new DLL.

anyone know offhand if this zip on this thread works with the ML 8.0 release?

We are trying to create a feed for pricerunner, however they need the category of each item.

We have have every other part of the feed working apart from the categories.
So far we have tried to add this SQL to the feed to call the category name for each item.

Here is the SQL code we are trying to add (Not sure if it is correct)

Code:

select productID, categoryID, name
from product, productcategory, category

where category.categoryID = productcategory.categoryID
and productcategory.productID = product.productID
and here is the SQL at the moment (the feed we are editing is based off the Google feed)

Code:

<![CDATA[
            SELECT p.ProductID, pv.VariantGUID, p.Name, p.Summary, isnull(pv.Name, '') VariantName, p.Description, p.SEName, p.ImageFilenameOverride, 

isnull(p.SKU, '') ProductSKU, isnull(p.ManufacturerPartNumber, '') ProductMPN, isnull(pv.SKUSuffix, '') ProductVariantSKUSuffix, 

isnull(pv.ManufacturerPartNumber, '') ProductVariantMPN, isnull(p.FroogleDescription, '') ProductFroogleDescription, p.SEKeywords, isnull(pv.Price, 0) 

ProductVariantPrice, isnull(pv.SalePrice, 0) SalePrice, isnull(pv.FroogleDescription, '') VariantFroogleDescription, isnull(pv.Description, '') VariantDescr, 

isnull(m.Name, '') ManufacturerName, isnull(pv.Weight, 0) ProductVariantWeight
            FROM dbo.Product p INNER JOIN 
              dbo.ProductVariant pv ON p.ProductID = pv.ProductID LEFT OUTER JOIN 
              (SELECT VariantID, SUM(Quan) inventory 
              FROM dbo.Inventory 
              GROUP BY VariantID) i ON pv.VariantID = i.VariantID INNER JOIN 
              dbo.ProductManufacturer pn ON p.ProductID = pn.ProductID INNER JOIN 
              dbo.Manufacturer m ON pn.ManufacturerID = m.ManufacturerID
            WHERE (p.IsSystem = 0) AND (p.Deleted = 0) AND (p.Published = 1) AND (p.ExcludeFromPriceFeeds = 0) AND (CASE p.TrackInventoryBySizeAndColor WHEN 

1 THEN isnull(i.inventory, 0) ELSE pv.inventory END >= @HideProductsWithLessThanThisInventoryLevel)
	]]>

Are we entering in the right SQL? if so where should it be entered.

Many thanks.

I am on V 7.1.0.0. and am trying to set up a Yahoo Shopping feed.

I have checked and double checked my Yahoo account settings and I have all the FTP connection info set up but the file that kicks out has no products, only a message:

XmlPackage Exception: Exception=Last Trace Point=[]. An error occurred during a call to extension function 'ConvertToNodeSet'. See InnerException for a complete description of the error.<br/><br/>Data at the root level is invalid. Line 1, position 1.<br/><br/><br/>System.ArgumentException: Last Trace Point=[]. An error occurred during a call to extension function 'ConvertToNodeSet'. See InnerException for a complete description of the error.<br/><br/>Data at the root level is invalid. Line 1, position 1.<br/><br/>
at AspDotNetStorefrontCommon.XmlPackage2.TransformStr ing()
at AspDotNetStorefrontCommon.AppLogic.RunXmlPackage(X mlPackage2 p, Parser UseParser, Customer ThisCustomer, Int32 SkinID, Boolean ReplaceTokens, Boolean WriteExceptionMessage)<br />


I see "Data at the root level is invalid" - Does this mean it can't find any products? I have several products mapped to the Yahoo Affiliate.

The feed is set to use the "feed.yahoo.xml.config" XML Package. Is this a bug with my version or something wrong with the XML Package itself perhaps?

I was able to get my Google Base feed to work perfectly but this one is giving me a hard time.

Any insight anyone can offer would be much appreciated.

TIA,
Jay

Originally Posted by bullzeye

I am on V 7.1.0.0. and am trying to set up a Yahoo Shopping feed.

I see "Data at the root level is invalid" - Does this mean it can't find any products? I have several products mapped to the Yahoo Affiliate.

This error means that the XML data in "Extension Data" for one or more of your products is bad.

Open the feed.yahoo.xml.config and read the section at the top about extra feed data.
I don't know about the Yahoo feed specifically, but many feeds require extra data which should be saved in the ExtensionData field.

For your reference, I am pasting it here:
<!-- Example Feed ExtensionData: -->
<!-- -->
<!-- <feeddata> -->
<!-- <feed name="yahoo"> -->
<!-- <data name="category" value="Computers" /> -->
<!-- </feed> -->
<!-- <feed name="pricegrabber"> -->
<!-- <data name="" value=""/> -->
<!-- </feed> -->
<!-- </feeddata> -->

Originally Posted by EnricoBozzetti

I have tried all the steps in this posts, and I am still having problems. This is the error message I keep getting:

System.ArgumentException: Last Trace Point=[]. Cannot find the script or external object that implements prefix 'urn:feed'.

See the below correspondence regarding this issue.
For more info, PM me.

From ASPDotNetStoreFront Support
George Solomon
Posted On: 23 Nov 2008 12:12 PM
The issue was with a VB conversion that occurred when translating AspDotNetStorefront from C#. In the XSLTObjects/ExtensionConfiguraion.vb file, there are 4 lines that have been changed to use a String ".Equals", with a case-ignorant string comparison type.

Thanks,
George

got the following compiler error trying to install this on my 8.0.1.2 ML today:

Compiler Error Message: CS0246: The type or namespace name 'XSLTExtensionBase' could not be found
Source Error:

Line 11: {
Line 12:
Line 13: public class XmlParse : XSLTExtensionBase
Line 14: {
Line 15: public XmlParse(Customer cust, int SkinID) : base(cust, SkinID)

Source File: d:\MYSITETHISWASEDITED\wwwroot\App_Code\XmlParse.c s Line: 13


i:
1.) allowed write permissions to the server
2.) uploaded the 5 xml feed packages to the admin/xmlpackages folder
3.) uploaded the xmlparse.cs file to the wwwroot/App_code/ folder

at this point the whole site crashed

i did not follow the instructions after the upload xmlparse.cs file:
4.) run extrafeeds.sql to setup
5.) add the requested instruction line to web.config:

<xsltobjects> section:
<add name="Feed Extensions"
type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>
e.g.:
<!-- Add your own custom XSLTExtensionObjects here -->
<xsltobjects defaultExtension="">
<extensions>
<clear/>
<add name="Feed Extensions"
type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>
</extensions>
</xsltobjects>


my question - should i have continued with the instructions even after the xmlparse.cs file crashed my site or do i have an existing problem to resolve?

i deleted the xmlparse.cs from the server, retouched the site, and the site was fine again.

how should i proceed here? these feeds are tough. i wish full support was offered. heck, i'd pay $50/year to maintain them as part of my contract.

thanks

Originally Posted by ohmydude_ML

The type or namespace name 'XSLTExtensionBase' could not be found

Source File: XmlParse.cs Line: 13

XmlParse.cs is written for ML7.
Some classes were moved in ML8.

I do not have ML8, but I think if you change the references to ASPDNSFCommon to ASPDNSFCore, it might work.
Maybe someone with ML8 can confirm this?

Originally Posted by yakatz

XmlParse.cs is written for ML7.
Some classes were moved in ML8.

I do not have ML8, but I think if you change the references to ASPDNSFCommon to ASPDNSFCore, it might work.
Maybe someone with ML8 can confirm this?

thanks!

in XmlParse.cs you must change the 1 instance of AspDotNetStorefrontCommon to AspDotNetStorefrontCore

next, run the sql script

next, edit your web config. the pdf instructions state to add this to a specific part of web.config:

<add name="Feed Extensions"
type="AspDotNetStorefrontCommon.XmlParse" namespace="urn:feed"/>

i changed "AspDotNetstorefrontCommon.Xmlparse" to "AspDotNetstorefrontCore.Xmlparse"

after that i followed all the steps and did a web.config retouch, i could see the new feeds added into admin/feeds (ML 8.0.1.2/8.0.1.2)

from there i was able to spit out some feeds via aspdnsf admin.

a few notes:
the amazon feed (the only one we really wanted) is a bit of a mess as far as i can tell. the others look workable. for some reason the shopping.com feed spit out as XML whereas the rest were tab delimited text files.

i love ASPDNSF, but man i wish they kept this stuff updated and were a bit more on the ball for feeds and multi channel friendliness. this stuff is totally over the head of most non coders. for us multichannel is the future, and it's frustrating to keep getting referred to 3rd party (channelworks) or mods that take me "out of code update friendliness/ out of the immediate ASPDNSF circle" to their core product and by process, core audience. i recognize that updated feeds and multi channel functionality cost time and money, but everything i know/read in 10 years of selling on tells me this is already a "must-have" feature.

thanks

Originally Posted by ohmydude_ML

a few notes:
the amazon feed (the only one we really wanted) is a bit of a mess as far as i can tell. the others look workable. for some reason the shopping.com feed spit out as XML whereas the rest were tab delimited text files.

I am in the middle of implementing an Amazon feed using DTS to get the data right from the DB instead of processing it through ASPDNSF.
Amazon requires a very difficult to use format for most of their feeds and parsing and fixing the error messages returned is also very hard (although I finally managed to create a service on the computer that does it automatically).

Where can I get the Amazon price feed?

Originally Posted by TheGlowPro

Where can I get the Amazon price feed?

It is linked to earlier in this thread:
http://forums.aspdotnetstorefront.co...42&postcount=6

This thread goes back for sometime, does anyone have the most updated price threads in a zip file that they don't mind sharing before I tackle this? Thx

Originally Posted by jamotion

This thread goes back for sometime, does anyone have the most updated price threads in a zip file that they don't mind sharing before I tackle this? Thx

The feeds posted originally are a guideline. They were not made to be used in a production environment with out modification.

If you are asking for feeds that people are using in a production environment, you may want to start a new thread.

Has anyone run google feed successfully for 15,000+ products? We tried running the google feed both on a local dedicated server with only 1 concurrent user, as well as on a cloud server farm and both gave us error saying that it did not have enough resource to run the feed.

My suggestion for feed in the future is to have it write to file for every 1000 products so that it frees up memory.

What version of the software are you using? The last few versions break the export up into batches to prevent exactly that.

We're running ASPDNSF ML 8.0.1.2 with the new Google feed update that ASPNSF released to accommodate product "condition" such as "new" or "used".

When we're running it on the local server, it generates the feed text file. But the file is only 1Kbyte and when you open the file, it only has 1 line that says "Exception=Exception of type 'System.OutOfMemoryException' was thrown.<br/>"

When we're running it on the cloud server farm, it'd generate about 2/3 of the products (about 11,000 products) with all their appropriate XML tags and then get the memory error.

Thanks.

Where can I find this latest 8.0.1.2 googlebase feed ASPDNSF file with the condition parameter?

Is there an XmlParse.vb file?

Does anyone have a working product feed for amazon they would be willing to share? The file provided in the .zip isn't even close to working.

I set up the feed files, but I get the following error when I add XmlParse.cs to the app_code folder and update web.config.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0246: The type or namespace name 'XSLTExtensionBase' could not be found (are you missing a using directive or an assembly reference?)

Source Error:


Line 11: {
Line 12:
Line 13: public class XmlParse : XSLTExtensionBase
Line 14: {
Line 15: public XmlParse(Customer cust, int SkinID) : base(cust, SkinID)

Source File: c:\Websites\WestCoastCorvette.com\App_Code\XmlPars e.cs Line: 13

Originally Posted by AspDotNetStorefront Staff - Scott

What version of the software are you using? The last few versions break the export up into batches to prevent exactly that.

Running 8.0.1.2 looks like the feed is just grabbing the first 1000 items or so - what do you mean the export is being broken in to batches I only see 1 file being sent to google - what I'm I missing?

Originally Posted by TheGlowPro

Does anyone have a working product feed for amazon they would be willing to share? The file provided in the .zip isn't even close to working.

I'm also interested in a working Amazon feed. The only download I've been able to find is the one posted by Admin on the first page of this thread in 2007. Is there an updated feeds file available for download elsewhere?

I am also new to setting up the price feeds and I pretty much have the GoogleBase feed working now after asking support for the latest update. Is there an area where customers with current support contracts can download all the other feeds? Or do I have to email support and ask for them?

Nevermind, just find this post:
http://forums.aspdotnetstorefront.co...42&postcount=6

Originally Posted by save@gt

I'm also interested in a working Amazon feed. The only download I've been able to find is the one posted by Admin on the first page of this thread in 2007. Is there an updated feeds file available for download elsewhere?

Bump! Amazon...anyone?

In fact, one of the reasons it’s taken us a little longer to put this new custom feed in places is because they had to do a significant amount of software development and configuration on their end to make this work for us.

Why? Because it’s custom. You won’t find a price feed like this advertised on their website and is not available anywhere else. They literally put additional infrastructure in place in order to provide this feed we’ve negotiated. (that’s what you can do with a large membership) Here’s the short version …We now have a second custom price feed. The new price feed is commission based with a 1 pip commission per round trip lot, but also has significantly lower spreads. In fact, even when you factor back in the 1 pip commission I’m confident you’ll notice a significant improvement.

I’m pretty busy and am certainly not in a position to compare our new feed with every broker on the planet, but I am very confident we have some of the best spreads available! How to get access to the new feed? If you’re a already trading with GallantFX using our initial price feed then the feed you are on is known as the “BTM” feed. The new commission based feed is known as the “BTM_E” feed.

To switch to the new feed simply email GallantFX and give them your account info, tell them you’re from the FAP Turbo Expert Guide and that you want to be on the “BTM_E” price feed. That’s it. A simple email is all it takes. Now, if you were not already trading on our custom price feed you’ll have to hang tight for one more day. We’re putting a new web page together with all the detailed info and special links to open accounts with this new feed. This will be available in a day.





_______________
Ecommerce

Does anyone have the new feeds for

pricegrabber
shopping.com
shopzilla
amazon

The only ones that I have found are from 2007. Does anyone have the new updated feeds?

I had developed feeds for most of those in summer 2008, but the company I work for has found, after a lot of time in testing, that ASPDNSF Feeds do not give us nearly as much flexibility as generating the feeds right from the SQL database.
Generating from SQL directly is many times faster and we have a better turnaround time for new feeds (although that could just be who we are).
Unfortunately, the company has a policy of removing any unused code to keep our deployments simple, so I don't have anything for you.

All I can say is besides for the Amazon feed, they are very straightforward.
The amazon feed makes dealing with variants rather difficult (in my opinion) and our feed was never 100% functional (when we made it using ASPDNSF).

Anybody got this working with v9? we changes AspDotNetStorefrontCommon to AspDotNetStorefrontCore but still not working on v9 for us.

thanks

Here is priceGrabber.. It will need to be modified for product Category but the basics are here.. works in v9

<?xml version="1.0" encoding="utf-8" ?>
<!-- ################################################## ################################################## ## -->
<!-- PriceGrabber / Yahoo Feed -->
<!-- Copyright Dave Negusse of Mainstreethost.com, 1995-2010. All Rights Reserved. -->
<!-- http://www.mainstreethost.com -->
<!-- For details on this license please visit the product homepage at the URL above. -->
<!-- THE ABOVE NOTICE MUST REMAIN INTACT. -->
<!-- ################################################## ################################################## ## -->

<package displayname="PriceGrabber/Yahoo Feed" version="2.1" debug="false" includeentityhelper="false">
<query name="Products" rowElementName="Product">
<sql>
<![CDATA[
select
p.productid,
p.name,
p.description,
p.sename,
p.sku,
p.ImageFileNameOverride,
p.ManufacturerPartNumber,
isnull(p.FroogleDescription, '') ProductFroogleDescription,
isnull(pv.Weight, 0) Weight,
pv.price,
isnull(pv.MSRP, pv.price) MSRP,
pv.inventory,
isnull(pv.saleprice, 0) saleprice,
isnull(pv.FroogleDescription, '') VariantFroogleDescription,
isnull(pv.description, '') VariantDescr,
m.Name AS ManName,
p.ExtensionData ProductFeedData,
pv.ExtensionData VariantFeedData
from product p with (NOLOCK)
INNER JOIN ProductManufacturer pm with (NOLOCK) ON p.ProductID = pm.ProductID
INNER JOIN Manufacturer m with (NOLOCK) ON pm.ManufacturerID = m.ManufacturerID
INNER JOIN ProductVariant pv with (NOLOCK) ON p.ProductID = pv.ProductID
left join (select variantid, sum(quan) inventory from dbo.inventory with (NOLOCK) group by variantid) i on pv.variantid = i.variantid
where
p.Published = 1
and p.IsSystem=0
and p.Deleted = 0
and p.ExcludeFromPriceFeeds = 0
and p.IsAKit = 0
and p.IsAPack = 0
and p.ShowBuyButton = 1
and p.RequiresRegistration = 0
and p.HidePriceUntilCart = 0
and (p.AvailableStartDate IS NULL or p.AvailableStartDate <= getdate())
and (p.AvailableStopDate IS NULL or p.AvailableStopDate >= getdate())
and case p.TrackInventoryBySizeAndColor when 1 then isnull(i.inventory, 0) else pv.inventory end >= @HideProductsWithLessThanThisInventoryLevel
and pv.isdefault = 1
and pv.published = 1
and pv.deleted=0
and p.ProductID not in (select ProductID from ProductCustomerLevel with (NOLOCK))
and p.ProductID not in (select ProductID from ProductAffiliate with (NOLOCK))
and p.SKU is not null
]]>
</sql>
<queryparam paramname="@HideProductsWithLessThanThisInventoryL evel" paramtype="appconfig" requestparamname="HideProductsWithLessThanThisInve ntoryLevel" sqlDataType="int" defvalue="0" validationpattern="" />
</query>
<PackageTransform>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:aspdnsf="urn:aspdnsf" exclude-result-prefixes="aspdnsf">
<xslutput method="text" omit-xml-declaration="yes" />

<xsl:template match="/">Unique Retailer SKU Manufacturer Name Manufacturer Part Number Product Title Categorization Product URL Image URL Detailed Description Selling Price Condition Availability Weight
&#xD;<xsl:apply-templates select="/root/Products/Product" />
</xsl:template>

<xsl:template match="Product">

<xslaram name="ProductName" select="aspdnsf:GetMLValue(name)"></xslaram>
<xslaram name="ProductVariantName" select="aspdnsf:GetMLValue(VariantName)"></xslaram>
<xslaram name="ProductDescr" select="aspdnsf:GetMLValue(description)"></xslaram>
<xslaram name="VariantDescr" select="aspdnsf:GetMLValue(VariantDescr)"></xslaram>
<xslaram name="ProductFroogleDescription" select="aspdnsf:GetMLValue(ProductFroogleDescripti on)"></xslaram>
<xslaram name="VariantFroogleDescription" select="aspdnsf:GetMLValue(VariantFroogleDescripti on)"></xslaram>
<xslaram name="ItemImage" select="aspdnsf:ProductImageUrl(productid, ImageFileNameOverride, SKU, 'medium', 1)"></xslaram>
<xslaram name="ManufacturerPartNumber" select="aspdnsf:GetMLValue(ManufacturerPartNumber) "></xslaram>
<xslaram name="StoreURL" select="/root/System/StoreUrl"></xslaram>



<xsl:value-of select="SKU"/><xsl:text> </xsl:text><xsl:value-of select="ManName"/><xsl:text> </xsl:text><xsl:value-of select="SKU"/><xsl:text> </xsl:text><xsl:value-of select="$ProductName" /><xsl:text> </xsl:text><xsl:text>Auto Parts</xsl:text><xsl:text> </xsl:text><link><xsl:value-of select="$StoreURL" /><xsl:value-of select="aspdnsf:ProductLink(productid, sename, 0, '')" /></link><xsl:text> </xsl:text><xsl:if test="not(contains($ItemImage,'nopicture'))"><xsl: value-of select="$ItemImage" /></xsl:if><xsl:text> </xsl:text><xsl:value-of select="$ProductFroogleDescription" /><xsl:text> </xsl:text><xsl:choose><xsl:when test="number(saleprice)=0"><xsl:value-of select="format-number(price, '###0.00')" disable-output-escaping="yes" /></xsl:when><xsltherwise><xsl:value-of select="format-number(saleprice, '###0.00')" disable-output-escaping="yes" /></xsltherwise></xsl:choose><xsl:text> </xsl:text><xsl:text>New</xsl:text><xsl:text> </xsl:text><xsl:text>Yes</xsl:text><xsl:text> </xsl:text><xsl:value-of select="Weight"/><xsl:text> </xsl:text>

</xsl:template>
</xsl:stylesheet>
</PackageTransform>
</package>

And here is Amazon v9

<?xml version="1.0" encoding="utf-8" ?>
<!-- ################################################## ################################################## ## -->
<!-- Amazon Feed -->
<!-- Copyright Dave Negusse of Mainstreethost.com, 1995-2010. All Rights Reserved. -->
<!-- http://www.mainstreethost.com -->
<!-- For details on this license please visit the product homepage at the URL above. -->
<!-- THE ABOVE NOTICE MUST REMAIN INTACT. -->
<!-- ################################################## ################################################## ## -->

<package displayname="Amazon Feed" version="2.1" debug="false" includeentityhelper="false">
<query name="Products" rowElementName="Product">
<sql>
<![CDATA[
select
p.productid,
p.name,
p.description,
p.sename,
p.SKU,
p.ImageFileNameOverride,
p.ManufacturerPartNumber,
isnull(p.FroogleDescription, '') ProductFroogleDescription,
isnull(pv.Weight, 0) Weight,
pv.price,
isnull(pv.MSRP, pv.price) MSRP,
pv.inventory,
isnull(pv.saleprice, 0) saleprice,
isnull(pv.FroogleDescription, '') VariantFroogleDescription,
isnull(pv.description, '') VariantDescr,
m.Name AS ManName,
p.ExtensionData ProductFeedData,
pv.ExtensionData VariantFeedData
from product p with (NOLOCK)
INNER JOIN ProductManufacturer pm with (NOLOCK) ON p.ProductID = pm.ProductID
INNER JOIN Manufacturer m with (NOLOCK) ON pm.ManufacturerID = m.ManufacturerID
INNER JOIN ProductVariant pv with (NOLOCK) ON p.ProductID = pv.ProductID
left join (select variantid, sum(quan) inventory from dbo.inventory with (NOLOCK) group by variantid) i on pv.variantid = i.variantid
where
p.Published = 1
and p.IsSystem=0
and p.Deleted = 0
and p.ExcludeFromPriceFeeds = 0
and p.IsAKit = 0
and p.IsAPack = 0
and p.ShowBuyButton = 1
and p.RequiresRegistration = 0
and p.HidePriceUntilCart = 0
and (p.AvailableStartDate IS NULL or p.AvailableStartDate <= getdate())
and (p.AvailableStopDate IS NULL or p.AvailableStopDate >= getdate())
and case p.TrackInventoryBySizeAndColor when 1 then isnull(i.inventory, 0) else pv.inventory end >= @HideProductsWithLessThanThisInventoryLevel
and pv.isdefault = 1
and pv.published = 1
and pv.deleted=0
and p.ProductID not in (select ProductID from ProductCustomerLevel with (NOLOCK))
and p.ProductID not in (select ProductID from ProductAffiliate with (NOLOCK))

]]>
</sql>
<queryparam paramname="@HideProductsWithLessThanThisInventoryL evel" paramtype="appconfig" requestparamname="HideProductsWithLessThanThisInve ntoryLevel" sqlDataType="int" defvalue="0" validationpattern="" />
</query>
<PackageTransform>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:aspdnsf="urn:aspdnsf" exclude-result-prefixes="aspdnsf">
<xslutput method="text" omit-xml-declaration="yes" />

<xsl:template match="/">sku product-id product-id-type price item-condition quantity add-delete will-ship-internationally expedited-shipping item-note item-description item-name image-url&#xD;<xsl:apply-templates select="/root/Products/Product" />
</xsl:template>

<xsl:template match="Product">

<xslaram name="ProductName" select="aspdnsf:GetMLValue(name)"></xslaram>
<xslaram name="ProductVariantName" select="aspdnsf:GetMLValue(VariantName)"></xslaram>
<xslaram name="ProductDescr" select="aspdnsf:GetMLValue(description)"></xslaram>
<xslaram name="VariantDescr" select="aspdnsf:GetMLValue(VariantDescr)"></xslaram>
<xslaram name="ProductFroogleDescription" select="aspdnsf:GetMLValue(ProductFroogleDescripti on)"></xslaram>
<xslaram name="VariantFroogleDescription" select="aspdnsf:GetMLValue(VariantFroogleDescripti on)"></xslaram>
<xslaram name="ItemImage" select="aspdnsf:ProductImageUrl(productid, ImageFileNameOverride, SKU, 'medium', 1)"></xslaram>
<xslaram name="ManufacturerPartNumber" select="aspdnsf:GetMLValue(ManufacturerPartNumber) "></xslaram>
<xslaram name="StoreURL" select="/root/System/StoreUrl"></xslaram>


<xsl:value-of select="SKU"/><xsl:text> </xsl:text><xsl:value-of select="SKU"/><xsl:text> </xsl:text><xsl:text>3</xsl:text><xsl:text> </xsl:text><xsl:choose><xsl:when test="number(saleprice)=0"><xsl:value-of select="format-number(price, '###0.00')" disable-output-escaping="yes" /></xsl:when><xsltherwise><xsl:value-of select="format-number(saleprice, '###0.00')" disable-output-escaping="yes" /></xsltherwise></xsl:choose><xsl:text> </xsl:text><xsl:text>11</xsl:text><xsl:text> </xsl:text><xsl:value-of select="aspdnsf:GetMLValue(Inventory)" /><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text>y</xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:text> </xsl:text><xsl:value-of select="$ProductFroogleDescription" /><xsl:text> </xsl:text><xsl:value-of select="$ProductName" /><xsl:text> </xsl:text><xsl:if test="not(contains($ItemImage,'nopicture'))"><xsl: value-of select="$ItemImage" /></xsl:if><xsl:text> </xsl:text>
</xsl:template>
</xsl:stylesheet>
</PackageTransform>
</package>

We get an error on v8 stating a pattern error - is this the fields not corresponding ?

Originally Posted by Rob

Feeds provided in attached download zip. Installation instructions included. Feeds are provided "as-is"...as most feeds need to be customized for each particular store site, and the feed target sites change their requirements OFTEN...use these as a starting point.

We will continue to provide support for the Googlebase feed in Customer Support.

The other feeds are only supported here in the forums.

Starting (sample) free feeds are provided for:

Yahoo!
pricegrabber
shopping.com
shopzilla and
amazon

Feeds were tested using "some" test data on v7.0.2.3 ML code base. Your mileage may vary...and you may have to customize the feeds for your own unique site/product requirements and/or listing requirements with each target site.

Feeds.zip updated 11/30/2007 with new install instructions for new web.config element required. no package mods.

i get this error

d:\Domains\mydomain.com\wwwroot\App_Code\XmlParse. cs(13,29): error CS0246: The type or namespace name 'XSLTExtensionBase' could not be found (are you missing a using directive or an assembly reference?)
d:\Domains\mydomain.com\wwwroot\App_Code\XmlParse. cs(15,25): error CS0246: The type or namespace name 'Customer' could not be found (are you missing a using directive or an assembly reference?)
d:\Domains\mydomain.com\wwwroot\App_Code\XmlParse. cs(19,25): error CS0246: The type or namespace name 'Customer' could not be found (are you missing a using directive or an assembly reference?)
d:\Domains\mydomain.com\wwwroot\App_Code\XmlParse. cs(19,98): error CS0246: The type or namespace name 'EntityHelper' could not be found (are you missing a using directive or an assembly reference?)

I too am receiving the following error in V9 after running the sql to the db, and inserting the files necessary in order to utilize the feeds. I would guess because the instructions for the feed setup and files are for v7 and we are now in v9.

Does someone have updated installation instructions like Rob fave in the beginning of this post, except that will work for v9?

The error I get is similar the previous::

The type or namespace name 'XSLTExtensionBase' could not be found.

Thanks for any help.
James

Bump,
We're using MSx v9.1.0.1 and wanted to use these feeds and any others we can find. Where can we download them with updated instructions?

Originally Posted by sduffy77

We're using MSx v9.1.0.1 and wanted to use these feeds and any others we can find. Where can we download them with updated instructions?

This thread is now 3.5 years old.

The feeds did not work 100% out of the box, they needed other setup work to make them generate valid feeds.
Also, I am pretty sure the Google Base feed (and maybe others) is completely different and would need to be totally rewritten.
I have not heard of anyone who got the feeds working on V8, much less V9.

I think it is time to move on...

I have MultiStore 9.1.0.1/9.1.0.0. I only see ExchangeRate and GoogleBase product feeds in the list. Does this sound right? If so, how do I find/buy additional product feeds for other shopping comparison sites?

Thanks,
Nathan

This thread is about ML7 and goes back about 3 1/2 years.
I would suggest starting a new thread in the MS9 section.

Let's all chip in and hire a team of developers out of MIT so we can build a couple of feeds. Or, another option would be for the experts at Vortex to do that for us and just let us download the file each time it changes.

I'm good either way

Can someone please un sticky this. It is extremely unhelpful because it is 4 years old. Cant someone please close threads if they are not used for 1 year or something. Almost all of the threads in this section are up to 3 years old an do not have much helpful information in them.

They are still here because it establishes the foundation of how to accomplish the task.. It would almost be better to delete the messages which do not further the technical content of this thread..

Originally Posted by SarahGomez

I have no idea about your product pricing?? so please mention their prices and if are offering any discount to your customers then please mention it. If i buy two products will i get some extra benefits or simply the two products. Reply fast, as my decision depends on your reply.

This is a forum for developers of e-commerce websites. I don't think you quite understand what this is for.
If you are looking for pricing for aspdotnetstorefront software, you can find it at http://www.aspdotnetstorefront.com/.
If you are looking for pricing for something else, then we can't help you here.

Did all feeds are effective?