Do you have your eye on it CS2007 SP1
Commerce Server 2007 Service Pack 1 is due out end of June if all goes well :), keep your eye on it. There are two things note worthy:
Replication of Orders and Profiles Database
This was a design change request that was introduced right after the product went live so a lot of testing wen into it. The replication will allow to have more than one Data Centers acting as active active. If one data center goes down the other can pick up the load. Should be interesting to read all the details on how to do this.
Using Tabular functions for Catalogs SetJoin API
I am very proud of this as I had a hand in it :). I had my hand in lots of cookie jars when I was at Microsoft, still do ;). Originally the product only supported tables and views to be joined with the Product object. Some scenarios made it impossible to use the SetJoin API. Imagine if you had dynamic pricing scenario, you could write a function that runs a select statement based on parameters you passed it and the product API would then return you some results that you could then perform validations and selecting the correct price. What if you needed to search a table before the join occurred? Well now you can. I am very eager to see how this is implemented and how people will use.
And they say Microsoft doesn't listen to it's customers :). I am very proud to have been part of the product group developing such a great software. Make sure to read every little bit of what's new.