Thread: v8 - Manufacturer on Home Page

Hi,

I want to call one of my manufacturers into my home page, is there an easy way to do this?

I've had no joyt finding anything in the manual / forums.

I current have featured products and news load on the home page and all I want to do is display our "JS" manufacturer.

Any help is appreciated!

Sounds like you need to create an XML package which brings back the products for that manufacturer only, and embed that package into however you're dealing with your homepage.

Yea I was looking at entity.gridwithprices.xml.config, I just can't figure out how to just simply point it to 1 manufacturer id, ie: 515

If that's the XML package you are using then you should change the <sql> query at the beginning of the package from:

Code:

        <sql>
            <![CDATA[
                exec dbo.aspdnsf_GetProducts 
                    @categoryID = @CatID,
                    @sectionID = @SecID,
                    @manufacturerID = @ManID,
                    @distributorID = @DistID,
                    @genreID = @GenreID,
                    @vectorID = @VectorID,
                    @localeName = @locale,
                    @CustomerLevelID = @CustLevelID,
                    @affiliateID = @AffID,
                    @ProductTypeID = @ProdTypeID, 
                    @ViewType = 1,
                    @pagenum = @pgnum,
                    @pagesize = null,
                    @StatsFirst = 0,
                    @publishedonly = 1,
                    @ExcludePacks = 0,
                    @ExcludeKits = 0,
                    @ExcludeSysProds = 0,
                    @InventoryFilter = @InvFilter,
                    @sortEntityName = @entityname
            ]]>
        </sql>

to:

Code:

        <sql>
            <![CDATA[
                exec dbo.aspdnsf_GetProducts 
                    @categoryID = @CatID,
                    @sectionID = @SecID,
                    @manufacturerID = 515,
                    @distributorID = @DistID,
                    @genreID = @GenreID,
                    @vectorID = @VectorID,
                    @localeName = @locale,
                    @CustomerLevelID = @CustLevelID,
                    @affiliateID = @AffID,
                    @ProductTypeID = @ProdTypeID, 
                    @ViewType = 1,
                    @pagenum = @pgnum,
                    @pagesize = null,
                    @StatsFirst = 0,
                    @publishedonly = 1,
                    @ExcludePacks = 0,
                    @ExcludeKits = 0,
                    @ExcludeSysProds = 0,
                    @InventoryFilter = @InvFilter,
                    @sortEntityName = @entityname
            ]]>
        </sql>

I recommend keeping a copy of the XML pacakge to revert to if it doesn't work out.

Esedirect,

Thanks for the suggestion but it just errors out;

C#/VB.NET Code:

XmlPackage Exception: Exception=Last Trace Point=[]. An error occurred during a call to extension function 'EntityPageHeaderDescription'. See InnerException for a complete description of the error.

Error Calling XSLTExtension Function EntityPageHeaderDescription: Invalid value specified for EntityID ()


System.ArgumentException: Last Trace Point=[]. An error occurred during a call to extension function 'EntityPageHeaderDescription'. See InnerException for a complete description of the error.

Error Calling XSLTExtension Function EntityPageHeaderDescription: Invalid value specified for EntityID ()

at AspDotNetStorefrontCore.XmlPackage2.TransformString() at AspDotNetStorefrontCore.AppLogic.RunXmlPackage(XmlPackage2 p, Parser UseParser, Customer ThisCustomer, Int32 SkinID, Boolean ReplaceTokens, Boolean WriteExceptionMessage) 


doh!

Does the package work without that mod?

ahh it's the same error either way which seems to work back to EntityID which I can't see getting set on the page.

Well if the package doesn't work in the first place, it's not a good place to start from!