Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > Ecomm product options descriptions View modes: 
User avatar
Member
Member
eagleag - 3/1/2011 2:28:32 AM
   
Ecomm product options descriptions
Hi,
I'm have an ecommerce site and products the use products options (as drop down).
I;ve filled out 2 fields: Product name and Price.

i want to create some dynamic ajaxi functionality that when a user chooses an option from dropdown list some info under it will update (according to what is currently selected).
I thought of using the DESCRIPTION fields for the additional info but cant seem tog grab its content. where is it stored in db?

Any recommendations on how to achieve this whole idea?

THANKS :)
User avatar
Kentico Consulting
Kentico Consulting
kentico_mirekr - 3/1/2011 6:08:53 AM
   
RE:Ecomm product options descriptions
Hi,

Products as well as product options data is stored in database in COM_SKU table, so probably you are looking for SKUDescription column/field from this table.

Your request is just matter of ShoppingCartItemSelector control customization (~\CMSModules\Ecommerce\Controls\ProductOptions\ShoppingCartItemSelector.ascx.cs).

In Page_PreRender method (this one is called when the dropdownlist selected value is changed) you can access selected option/s from the dropdownlist via ProductOptions property (this holds list of product options SKUIDs). So, since you know now how to get product option SKUID (product options are also products stored in COM_SKU table) you can get any additional data like SKUDescription etc. of your product option from COM_SKU table according to SKUID and display them somewhere in your ShoppingCartItemSelector control.

You can use our API to get such data from COM_SKU table according to SKUID.

I hope this will help you. If not, please let me know.

Best regards,
Miro Remias.
Top