Archive for January 2009
January 30, 2009 | 
Author Property is the basic capturing unit of a product/category behavior. We should create properties first and later assign them to the product/category definition. One thing many developers don’t know is that we can also create capturing units of a property, i.e., we can create a top level property behavior with the set of available properties and we can associate top level property to a product or category.
For example, I would like to associate a Boolean value which says whether the property can be exported to partners or not. The steps to follow are
1. Open Commerce Server Catalog & Inventory Schema manager.
2. Click on “Property Definition” under views.
3. Click on “Create New Property” under task.
4. Create a Boolean property named “IsExported” as shown below.
5. Now click on “Edit Property Metadata” under tasks. A new windows gets opened.
6. Click “Is Exported?” from available properties list and click add button. Now the property will move to Assigned properties list.
7. Now click Save & Close.
Now we have associating a new property to the property metadata. If you observe the database, a new Boolean filed is added to catalogAttributes table.
Displaying the column in “Catalog and inventory schema manager” is not possible as partner SDK supports extending Catalog Manager, Marketing Manager, and Customer and Orders Manager only.
If you like this post, please click on our sponsor advertisement.
Posted in 
Tags: 
Whenever the user search for a product, commerce server 2009 will not show any results if there are matches in database as shown below.
The following error is recorded in the event log.
|
An exception of type ‘Microsoft.Office.Server.Search.Query.SearchServiceNotFoundException’ occurred and was caught. Additional Info: MachineName : MOJAVENOVCTP |
The problem may occur because the search service may not be able to take requests from other application. The resolution is to restart, Office SharePoint Server Search and Windows SharePoint Services Search services. If still doesn’t working, just restart IIS to make it work.
If you like this post, please click on our sponsor advertisement.
On 16th January, Microsoft has released commerce server 2009 Release Candidate. CS 2009 RC delivers the ability to increase your business reach by making it possible to sell via multiple channels by using an out-of-the-box shopping site, SharePoint Commerce Services, and the Multi-Channel Commerce Foundation. So, what are you waiting for, download RC version from MS site and the link is.
Keep visiting this site to know more about the new product.
If you like this post, please click on our sponsor advertisement.
In December CTP/commerce server 2009, there are many SharePoint out of box web parts provided. Each web part has it’s own significance. Check below web part list to know more about them.
| Sl. No | Name | Description |
| 1 | Address | A web part that provides address manipulation capabilities. |
| 2 | Address List | A web part which provides a list of addresses. |
| 3 | Add To Cart | An Add To Cart Web Part for Commerce Server 2007. |
| 4 | Advertisement List | A Web Part that displays advertisements/discounts |
| 5 | Shopping Cart | A Shopping Cart web part for Commerce Server 2007. |
| 6 | Change Password | A Web Part that provides users with the ability to change their passwords. |
| 7 | Checkout | A checkout web part for Commerce Server 2007. |
| 8 | Content Query | Use to display a dynamic view of content from your site on a web page |
| 9 | Credit Card | A web part which provides credit cards manipulation. |
| 10 | Credit Card List | A Web Part that provides a list of credit cards. |
| 11 | Forgot Password | A Web Part which provides the user the ability to recover their password. |
| 12 | MiniCart | A mini shopping cart web part for Commerce Server 2007. |
| 13 | XML Web Part | Use for XML, and XSL Transformation of the XML. |
| 14 | My Profile | Use to display a shopper’s profile. |
| 15 | My Shopper Lists | A My Shopper lists web part for Commerce Server 2007. |
| 16 | Order Details | An order details web part for Commerce Server 2007. |
| 17 | Order History | An order history web part for Commerce Server 2007 |
| 18 | Product Details | Used to display product properties of a web part through XSL transformations |
| 19 | Product Filter | Used to filter the contents of another web part for the catalog and product in the URL. |
| 20 | Product Provider. | Used to retrieve a product. |
| 21 | Product Query | Used to retrieve a collection of products. |
| 22 | Reviews and Ratings – Average Rating | Displays the average product rating |
| 23 | Registration Wizard | Allows for the Registration of new users. |
| 24 | Reviews and Ratings – List | Displays a list of product reviews and ratings |
| 25 | Search Box | A web part which conducts catalog and/or static contents search |
| 26 | Search Paging | A web part iterate through catalog and/or static contents search results on Search Results web part |
| 27 | Search Results | A web part which displays catalog and/or static contents search results |
| 28 | Shopper List Detail | A shopper list detail web part for Commerce Server 2007 |
| 29 | Simple Property List | Used to display properties of a product. |
| 30 | Store Locator | A Web Part that allows user to pick nearest store on a virtual earth map |
| 31 | Summary Link | Use to display links on your web page that can be grouped and styled and can be organized by dragging and dropping |
| 32 | Table Of Contents | Use to display the navigation hierarchy of your site on a web page |
If you like this post, please click on our sponsor advertisement.
I had a decimal property (“Weight”) created using commerce server catalog and inventory schema manager tool and I added this property as base property for all products. During catalog import, I am able to insert value with three or four precision into this field but when the business user opens through catalog manager, the value is getting round off (only two precision showed). If mistakenly if he saves, wrong data is saved back to database.
For example, if the value in database is 4.2345, in catalog manager, it is showing as 4.23 as shown in the figure.
After analyzing the facts, what I found out is whenever a property of decimal is created from catalog manager, a new data column is created database products table of type float. Replacing float with Decimal (18,4), I am able to get back the entire value back in catalog manager, as shown in below.
If you like this post, please click on our sponsor advertisement.
