This provider manages the products (SKUs). It uses the SKUInfo class.
• | object GetSKUInfo(int sKUId) – returns the SKUInfo object selected by given ID. |
• | object GetSKUInfo(Guid sKUGuid) - returns the SKUInfo object selected by given GUID. |
• | void SetSKUInfo(object sKU) – updates/inserts the SKU record from given SKUInfo object. If SKUID is set, updates, else inserts a new record. |
• | void DeleteSKUInfo(int sKUId) – deletes specified SKU record. |
• | bool CheckDependencies(int sKUId) – returns true if some objects depend on given SKU. |
• | DataSet GetSKUs() – returns the DataSet of all products. See database reference for detailed column information |
• | DataSet GetSKUs(string where, string orderBy) – returns DataSet of products selected with condition and order. |
• | DataSet GetSKUs(bool products, bool productOptions, string where, string orderBy) – returns DataSet of products and/or product options selected with condition and order. |
• | DataSet GetSKUList(string where, string orderBy) – returns the DataSet of product list. Result contains the SKU data and public and internal status display name. |
• | DataSet GetTopNProductsBySales(int topN, int siteId, string where) - returns the DataSet with top N products by sales for the specified site and according to the where condition. |
• | void AddSKUToWishlist(int userId, int skuId, int siteId) – adds specified SKU to user's wishlist. |
• | void RemoveSKUFromWishlist(int userId, int skuId, int siteId) – removes specified SKU from the wishlist of the given user. |
• | bool IsSKUInWishlist(int userId, int skuId, int siteId) - returns true if the given SKU is present in the user's wish list. |
• | DataSet GetWishlist(int userId, int siteId) - returns the content of wish list for the given user as a DataSet. |
• | DataSet GetOptionCategorySKUs(int categoryId, string where) – returns the DataSet of all product options from the specified product option category filtered by specified where condition. |
• | void MoveSKUOptionUp(int skuId) – moves specified product option up within the parent product option category. |
• | void MoveSKUOptionDown(int skuId)- moves specified product option down within the parent product option category. |
Read also: Using the Product datalist web part
|