in

dashCommerce

An ASP.NET Open Source e-Commerce Application

How do I get inventory and backorder to display with each prodcut on a catalog page?

Last post 03-29-2008 2:12 PM by sean.vox. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-24-2008 4:56 PM

    How do I get inventory and backorder to display with each prodcut on a catalog page?

    How do I get inventory and backorder to display with each prodcut on a catalog page?

    For \dashcommerce\Commerce.Web\Modules\Products\ProductTopDisplay.ascx, I have created an inventory and backorder display (which displays whenever a Product is selected) as

    <h4><%=product.ProductName %></h4>
    <h4>Inventory <%=product.Inventory %></h4>
    <h4>Backorder <%=product.Backorder %></h4>

    and

    but for \dashcommerce\Commerce.Web\Modules\Products\ProductSummaryDisplay.ascx, the display does not work (when the catalog is shown with various products) as

                <div>
                    <%=Inventory %>
                    </div>
                    <div>
                    <%=Backorder %>
                    </div>

    with \dashcommerce\Commerce.Web\Modules\Products\ProductSummaryDisplay.ascx.cs

        public string Inventory;
        public string Backorder;

    My dashcommerce version is 2.2, using VS 2005 to edit, SQLExpress for database, and IIS 6.0 with 2.0 framework.

    Any ideas?

    Filed under: , ,
  • 03-29-2008 2:12 PM In reply to

    Re: How do I get inventory and backorder to display with each product on a catalog page?

    I did this, so it is possible!  But I am not very good at giving directions, so this is not up to the level of other forum helpers, sorry!

     You need to change the stored procedures inside the SQL server (using SQl Server Management Studio Express) to return inventory in addition to all the other bits of data.  Look in \Programmability\Stored Procedures for

    CSK_Store_Product_GetByCategoryID

    And add inventory like in this example (don't copy/paste, I think mine is different!!)

    SELECT productID, sku, productGUID, productName, shortDescription, manufacturerID, statusID, productTypeID, shippingTypeID, shipEstimateID, taxTypeID, stockLocation, ourPrice, retailPrice, weight, currencyCode, unitOfMeasure, adminComments, length, height, width, dimensionUnit, isDeleted, listOrder, RatingSum, totalRatingVotes, createdOn, createdBy, modifiedOn, modifiedBy, shippingEstimate, leadTimeDays, imageFile, categoryID, rating, manufacturer, status, taxType, taxCode, shippingType, shippingCode, inventory

    And do this for all the other stored procedures that select a similar set of data.

    In the catalog page code, you need to add one part to the datalist that builds the page... you need to pass it inventory.  You can follow the way the others look.  That should help.  Sorry I can't be more specific!

    Sean
    www.pinkpropaganda.com

Page 1 of 1 (2 items)