Monthly Archives: April 2011

Field not found: CatalogResourceMajorVersion from Commerce Server 2007

So I was trying to troubleshoot this Biztalk 2006 R2 orchestration that includes importing some data into a Commerce Server 2007 instance. CS doesn’t really want to play ball, so I decide to upgrade it to the latest service pack … Continue reading

Posted in Work | Tagged | 1 Comment

NULL values in SOAP requests

Question: how to pass a NULL value in a SOAP envelope? Answer: Use the xsi:nil=”true” attribute on the element, and don’t forget the xsi namespace in the envelope. Example SOAP request:

Posted in Work | Tagged , , , | Leave a comment

Listing subcategories for a category in Commerce Server 2007 using a SQL query

As promised, here is the follow-up to the last post. This query gets us the names of all subcategories of a particular category in Commerce Server 2007.

Posted in Work | Tagged , | Leave a comment

Listing categories for a product in Commerce Server 2007 using a SQL query

Commerce Server API is not exactly known for being lightning-fast, so sometimes you want to skip it altogether and just use plain old SQL to get the data. This time I needed to find all categories (at a particular level) … Continue reading

Posted in Work | Tagged , | Leave a comment