Tag Archives: commerce server

Aborting import operations in Commerce Server 2007

Today, my Biztalk ran wild and initiated a bunch of Commerce Server catalog import operations. While trying to find a way to abort all of those I came across the CatalogStatus table in the product catalog database. According to MSDN this … Continue reading

Posted in Work | Tagged | Leave a comment

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

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

Debugging Commerce Server pipelines

To get debug information from Commerce Server pipelines you should: Add loggingEnabled=”true” to the pipelines section in web.config Next, set the “_Trace_Discounts” key in the pipeline context dictionary (or PipelineInfo[“_trace_discounts”] = 1;) before executing the basket pipeline. If you are … Continue reading

Posted in Work | Tagged | Leave a comment