Thread: Google Base Brand/Manufacturer Support

Can someone advise on how to properly add support for the brand attribute in the Google Base feed? Pulling the product manufacturer name is not the easiest of tasks!

C#/VB.NET Code:

<g:brand>m.Manufacturer?</g:brand> 


I am guessing something like this goes somewhere in the feed file... but I need a little extra push to get it working please :-)

C#/VB.NET Code:

from ProductVariant pv
inner join Product p on pv.ProductID = p.ProductId
inner join ProductManufacturer pm on pm.ProductId = p.ProductId
inner join Manufacturer m on m.ManufacturerId = pm.ManufacturerId 


First you need to make sure you are getting the manufacturer in the query

Then you need to add a line like this one

Code:

<xsl:param name="ProductManufacturer" select="aspdnsf:GetMLValue(manufacturer)"></xsl:param>

Then at the need to add a line like this

Code:

<g:brand>
            <xsl:value-of select="$ProductManufacturer" />
</g:brand>

Thank you, that helps but my main issue is actually getting the manufacturer in the query. I think I have a good start with the code below, but I am not sure how to tweak it to work correctly. Can you provide some input on this?

C#/VB.NET Code:

from ProductVariant pv
inner join Product p on pv.ProductID = p.ProductId
inner join ProductManufacturer pm on pm.ProductId = p.ProductId
inner join Manufacturer m on m.ManufacturerId = pm.ManufacturerId 


Can anyone help, for the sake of the greater good of the community?

Anyone? This could be a valuable little mod for most stores out there!

Hi,

When Webopius created an updated GoogleBase feed, the query was modified along these lines...

Change the select to:

Code:

select p.productid, p.name, m.name brandname, ....and keep all the other select items...

Add this to the from clause:

Code:

left join dbo.productmanufacturer pm with (NOLOCK) on p.productid = pm.productid
join dbo.manufacturer m with (NOLOCK) on pm.manufacturerid = m.manufacturerid

Then in the Product template, retrieve the brand name:

Code:

<xsl:param name="BrandName" select="aspdnsf:GetMLValue(brandname)"></xsl:param>

..and use it:

Code:

<g:brand>
            <xsl:value-of select="$BrandName" />
</g:brand>

Hope this helps,
Adam. Webopius.com

Wow, you sure did solve this one... thoroughly too!! Thank you!

Adam of Webopius.com - THANK YOU SO MUCH!!!!

I now have my www.wwillie.com feed in perfect Google compliance!