Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Ecommerce - System Tables for Featured Products? View modes: 
User avatar
Member
Member
iweber - 6/7/2013 11:16:49 AM
   
Ecommerce - System Tables for Featured Products?
Where are the system tables for featured products located? I want to be able to mark certain products as featured, and display them using a Repeater (which is using a query) on the Home page of this ecommerce website. I looked in the system tables but could not find it anywhere -- is it possible I am going about this the wrong way? (Perhaps there is another option somewhere in some web parts properties that I glossed over, such that I can just display certain products that are featured).

User avatar
Certified Developer 13
Certified Developer 13
kentico_josefd - 6/8/2013 10:43:11 AM
   
RE:Ecommerce - System Tables for Featured Products?
Hello,

You can set any SKU to Featured status using this property:

CMS Desk -> E-Commerce -> Products -> {Edit} -> General -> Public status: Featured

This property is set in the COM_SKU table, column SKUPublicStatusID, which uses table COM_PublicStatus to store definitions of Public Statuses.

The easiest way to show the featured products is by placing either Products or Random products web part on the document and set the Public status property to Featured.

All of the above of course applies to any Public status.

Regards,
Josef Dvorak