Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Displaying a Single Product on a Page View modes: 
User avatar
Member
Member
iweber - 5/30/2013 9:33:26 AM
   
Displaying a Single Product on a Page
Today I'm working on developing either a repeater or datalist for a page which just displays one product, the corresponding image(s), a description of the product, all the product options, and an add to cart button.

Now I'm somewhat stuck on certain parts of this. I took a long look at the API and documentation yesterday, but to no avail.

What I would really like to do, and what I think makes sense, is to develop these pages based off of the products we added to the ecommerce database. Everything that I want to display on these pages are things I've already put in the ecommerce database, for each product. (Plus we would then have one "template" which can be altered slightly for each product, making maintenance and adding more products very simple.)

Sorry for being so wordy, but here are my actual questions. I have no idea what my eval statements will be for the transformations of these pages. I'm having trouble going back and forth between the ecommerce database, and the transformation of the page. For example, if I want to pull the product description for a product from the database, what would be a way to do this?

Thank you so much for the help, I'm glad that Kentico has such good documentation and support.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 6/3/2013 1:12:59 AM
   
RE:Displaying a Single Product on a Page
Hi,

I am just copying my answer from the e-mail conversation in case anybody else is interested into this.

I am not sure from your description whether there will be any documents in the content tree that will represent the SKU objects - basically there will be connection between the two of them.

If you will use documents, you can use whatever listing and viewer web part and use the column names (the fields from document type or COM_SKU table since they are joined in View_CMS_Tree_Joined) in the EVAL transformation fuction.

If you want to work just with SKUs and no documents, you can use the product datalist which is set to work with the COM_SKU table - so, in the transformation you can use its column names. Or, you can use e.g. the Repeater with custom query - the query will return the columns you need and again, you can use these column names in the transformation.

Best regards,
Juraj Ondrus