Adding fields to the main inventory report

[tntmjr]

I found a post that added the sku to the Low inventory report :
viewtopic.php?f=44&t=8713&hilit=inventory+report..
I was wondering would this work on the Inventory report under Manage and what other fields are available. I would like to see Prices, Manufacturer, categories, featured, vendor, visibility and whatever else can be seen. If they are available how do I access them.

[mazhar]

Yes it will work. Use it in very same as described in that post.

I would like to see Prices, Manufacturer, categories, featured, vendor, visibility and whatever else can be seen. If they are available how do I access them.

You can create other function similarly like the one defiend for Sku. For example for vendor you can define the GetVendor and in function load the product and return its vendor.

Code: Select all

public string GetVendor(Object dataItem)
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.Vendor.Name;
    }

For manufacturer you can use

Code: Select all

return product.Manufacturer.Name;

For price you can use

Code: Select all

return product.Price.ToString();

For featured product

Code: Select all

if(product.IsFeatured)
            return "Featured";
else
    return string.Empty;

For visibility you can use

Code: Select all

product.Visibility.ToString();

[tntmjr]

Thanks Mazhar,

I did have to modify the <asp:HyperLink ID="ProductLink" to have unique id's so the sorting would work but otherwise this was pretty simple. I also added a couple more columns. Now I have to figure out how to get the Products category in there and I'm all set. We'll also be working on a way to send this report to excel (if anyone has any ideas hit me up).

Here is the modified code for anyone else that might have a need for it.

Code: Select all

<%@ Page Language="C#" MasterPageFile="~/Admin/Admin.master" Title="Manage Inventory" Inherits="CommerceBuilder.Web.UI.AbleCommerceAdminPage" %>
<%@ Register TagPrefix="ComponentArt" Namespace="ComponentArt.Web.UI" Assembly="ComponentArt.Web.UI" %>
<%@ Register Assembly="CommerceBuilder.Web" Namespace="CommerceBuilder.Web.UI.WebControls" TagPrefix="cb" %>
<script runat="server">

    protected string GetName(object dataItem)
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        if (string.IsNullOrEmpty(detail.VariantName)) return detail.Name;
        return string.Format("{0} ({1})", detail.Name, detail.VariantName);
    }
	
	
	public string GetSku(Object dataItem) 
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.Sku;
    }
	
	public string GetPrice(Object dataItem) 
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.Price.ToString();
    }
	
	
	public string GetMsrp(Object dataItem) 
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.MSRP.ToString();
    }
	
	public string GetManu(Object dataItem) 
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.Manufacturer.Name;
    }
	
	public string GetFeat(Object dataItem) 
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        if(product.IsFeatured)
            return "Featured";
else
    return string.Empty;
    }
	
	public string GetVis(Object dataItem) 
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.Visibility.ToString();
    }	
	
	public string GetCost(Object dataItem) 
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.CostOfGoods.ToString();
    }	
	

    protected void InventoryGrid_DataBound(object sender, EventArgs e)
    {
        SaveButton.Visible = (InventoryGrid.Rows.Count > 0);
        InventoryGrid.GridLines = (SaveButton.Visible) ? GridLines.Both : GridLines.None;
    }

    private int GetControlValue(GridViewRow row, string controlId)
    {
        TextBox tb = row.FindControl(controlId) as TextBox;
        if (tb != null)
        {
            return AlwaysConvert.ToInt(tb.Text);
        }
        return 0;
    }    

    protected void SaveButton_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in InventoryGrid.Rows)
        {
			int dataItemIndex = row.DataItemIndex;
			dataItemIndex = (dataItemIndex - (InventoryGrid.PageSize * InventoryGrid.PageIndex));
            int productId = (int)InventoryGrid.DataKeys[dataItemIndex].Values[0];
            int productVariantId = AlwaysConvert.ToInt(InventoryGrid.DataKeys[dataItemIndex].Values[1].ToString());
            int inStock = GetControlValue(row, "InStock");
            int lowStock = GetControlValue(row, "LowStock");
            if (productVariantId.Equals(0))
            {
                Product product = ProductDataSource.Load(productId);
                product.InStock = inStock;
                product.InStockWarningLevel = lowStock;
                product.Save();
            }
            else
            {
                ProductVariant variant = new ProductVariant();
                variant.Load(productVariantId);
                variant.InStock = inStock;
                variant.InStockWarningLevel = lowStock;
                variant.Save();
            }
        }
        SavedMessage.Text = string.Format(SavedMessage.Text, DateTime.Now);
        SavedMessage.Visible = true;
        InventoryGrid.DataBind();
    }

    protected void GoButton_Click(object sender, EventArgs e)
    {
        InventoryGrid.DataBind();
    }
</script>

<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" Runat="Server">
   
<ajax:UpdatePanel ID="ReportAjax" runat="server" UpdateMode="Conditional">
    <ContentTemplate>
	    <div class="pageHeader">
	    	<div class="caption">
	    		<h1><asp:Localize ID="Localize1" runat="server" Text="Manage Product Inventory"></asp:Localize></h1>
	    	</div>
	    </div>
		<table cellpadding="2" cellspacing="0" class="innerLayout">
            <tr class="noPrint">
                <td style="padding:10px 20px 0px 20px;">
                    <asp:Label ID="MaxInStockLabel" runat="server" Text="Show stock levels at or below:" SkinID="FieldHeader"></asp:Label>
                    <asp:TextBox ID="MaxInStock" runat="server" Text="0" Columns="4"></asp:TextBox>
                    <asp:Button ID="GoButton" runat="server" Text="Go" OnClick="GoButton_Click" /><br /><br />
                    <asp:Label ID="SavedMessage" runat="server" Text="Data saved at {0:g}" EnableViewState="false" Visible="false" SkinID="GoodCondition"></asp:Label>
                 </td>
			</tr>            
            <tr>
                 <td class="itemList">
                    <cb:SortedGridView ID="InventoryGrid" runat="server" AutoGenerateColumns="False" DataSourceID="InventoryDs" DataKeyNames="ProductId,ProductVariantId"
                    DefaultSortExpression="Name" AllowPaging="True" AllowSorting="true" PageSize="20" 
                    CellPadding="4" RowStyle-CssClass="odd" AlternatingRowStyle-CssClass="even" 
                    OnDataBound="InventoryGrid_DataBound" SkinID="Summary" Width="100%">
                    <Columns>
                       		<asp:TemplateField HeaderText="Name" SortExpression="Name">
                            <ItemTemplate>
                                <asp:HyperLink ID="ProductLink" runat="server" Text='<%# GetName(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                            </ItemTemplate>                    
                                       <HeaderStyle HorizontalAlign="Left" />
                        	</asp:TemplateField>
                        
                        
                           <asp:TemplateField HeaderText="Sku" >
                                <ItemTemplate>
                                    <asp:HyperLink ID="ProductLink1" runat="server" Text='<%# GetSku(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:TemplateField>

                  			<asp:TemplateField HeaderText="Cost" >
                                <ItemTemplate>
                                    <asp:HyperLink ID="ProductLink7" runat="server" Text='<%# GetCost(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:TemplateField>
                            
 							<asp:TemplateField HeaderText="Price" >
                                <ItemTemplate>
                                    <asp:HyperLink ID="ProductLink2" runat="server" Text='<%# GetPrice(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:TemplateField>
                            
                            
                            <asp:TemplateField HeaderText="MSRP" >
                                <ItemTemplate>
                                    <asp:HyperLink ID="ProductLink6" runat="server" Text='<%# GetMsrp(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:TemplateField>
                            
                            
                             <asp:TemplateField HeaderText="Manufacturer" >
                                <ItemTemplate>
                                    <asp:HyperLink ID="ProductLink3" runat="server" Text='<%# GetManu(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:TemplateField>
                            
                            <asp:TemplateField HeaderText="Featured" >
                                <ItemTemplate>
                                    <asp:HyperLink ID="ProductLink4" runat="server" Text='<%# GetFeat(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:TemplateField>
                            
                            <asp:TemplateField HeaderText="Visibility" >
                                <ItemTemplate>
                                    <asp:HyperLink ID="ProductLink5" runat="server" Text='<%# GetVis(Container.DataItem) %>' NavigateUrl='<%#Eval("ProductId", "../Products/EditProduct.aspx?ProductId={0}")%>'></asp:HyperLink>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:TemplateField>
                            
                                      

                        
                        
                        <asp:TemplateField HeaderText="In Stock" SortExpression="InStock">
                            <ItemStyle HorizontalAlign="Center" />
                            <ItemTemplate>
                                <asp:TextBox ID="InStock" runat="server" Text='<%# Eval("InStock") %>' Columns="4"></asp:TextBox>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="Low Stock">
                            <ItemStyle HorizontalAlign="Center" />
                            <ItemTemplate>
                                <asp:TextBox ID="LowStock" runat="server" Text='<%# Eval("InStockWarningLevel") %>' Columns="4"></asp:TextBox>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                    <PagerStyle CssClass="paging" HorizontalAlign="right" />
                    <PagerSettings NextPageText="»" PreviousPageText="«" />
                    <EmptyDataTemplate>
                        <div class="emptyResult_FromCustomFile">
                            <asp:Label ID="EmptyResultsMessage" runat="server" Text="There are no items currently at or below the indicated stock level."></asp:Label>
                        </div>
                    </EmptyDataTemplate>
                    </cb:SortedGridView>
                    <br /><asp:Button ID="SaveButton" runat="server" Text="Save" OnClick="SaveButton_Click" />
                </td>
            </tr>
        </table>
    </ContentTemplate>
</ajax:UpdatePanel>
        
    <asp:ObjectDataSource ID="InventoryDs" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetProductInventory" 
        TypeName="CommerceBuilder.Reporting.ProductInventoryDataSource" SortParameterName="sortExpression" EnablePaging="true" 
        SelectCountMethod="GetProductInventoryCount">
        <SelectParameters>
            <asp:ControlParameter ControlID="MaxInStock" Name="maxInStock" PropertyName="Text" Type="Int32" />
        </SelectParameters>
    </asp:ObjectDataSource>
</asp:Content>

Thanks again Mazhar. You have all the answers!!!

[mazhar]

that's great. Thanks for sharing the code

[niall08]

Is there any way to show the Variant SKU instead of the product Sku (where applicable) in this inventory report?

[mazhar]

Its possible. You can try following code.

Code: Select all

 public string GetSku(Object dataItem)
    {
        ProductInventoryDetail detail = (ProductInventoryDetail)dataItem;
        if (detail.ProductVariantId > 0)
        {
            ProductVariant productVariant = ProductVariantDataSource.Load(detail.ProductVariantId);
            if (!string.IsNullOrEmpty(productVariant.Sku))
                return productVariant.Sku;
        }
        
        Product product = ProductDataSource.Load(detail.ProductId);
        return product.Sku;
    }