Commerce Server 2007 Forum

Component Execution failed for component[0x2] hr: 0x80004005 ProgID: Commerce.CheckInventory 对 COM 组件的调用返回了错误 HRESULT E_FAIL

Wed, 25 Nov 2009 09:38:30 Z

hi,

this problem is Random, I donot know why. i'm introble.

this is my code : add products to basket

LineItem li = new LineItem();

li.ProductId = pid;

if (!String.IsNullOrEmpty(varid))

{

li.ProductVariantId = varid;

}

li.ProductCatalog = "viyas products";

li.Quantity = 1;

CurrentBasket.OrderForms["cart"].LineItems.Add(li, true);

PipelineInfo pipeline = new PipelineInfo("basket", OrderPipelineType.Basket);

CurrentBasket.RunPipeline(pipeline); // this line got wrong

thanks everyone

3 for 2 offer in marketing manager, commerce server 2007

Tue, 24 Nov 2009 12:01:41 Z

Hi, hopefully someone can help!?

I'd like to apply a 3 for 2 offer across a select range of products where the cheapest value item is always the one you get free...

So, for example, within the offer there are four different products:

W = £6.99
X = £7.99
Y = £12.99
Z = £13.99

I want to be able to offer the customer these options (as examples of what customers might buy):

Buy 3 x "W" get one of the "W's" free
Buy 2 x "X" and 1 x "W" and get "W" free
Buy 2 x "W" and 1 x "Z" and get one of the "W's" free
Buy 2 x "Z" and 1 x"Y" and get "Y" free...

Plus other options within the same rules.

Am I able to set this up in Marketing Manager as it stands?

Any help on this would be great.

Thanks in advance
TD

Commerce server 2007

Mon, 02 Nov 2009 12:41:09 Z

How to add new table to commerce server database to implement/extend rma etc

Extending OrderForm Issue

Tue, 24 Nov 2009 12:21:52 Z

Hi,
I have extende my OrderForm by update a new Parameters which will be returned by verisign after Creditcard Transaction
I have following the steps mentioned as in
http://blogs.msdn.com/sathishcg/archive/2006/11/08/extending-commerce-server-order-system.aspx
after
this i also have updated new column in the en_OrdersPresentationInfo.xml for the change in orderform
as below
<Class Name="OrderForm" DisplayName="Order form">
<Property Name="cc_auth_number" DisplayName="cc_auth_number" />/*my new field*/

now i am added my products in one page...
as below

Microsoft.CommerceServer.Runtime.Orders.

Basket bas = CommerceContext.Current.OrderSystem.GetBasket(UserID, "default");

SiteOrderForm frm = new SiteOrderForm ();

frm.cc_auth_number= "65";/*my new field just for verification i am updating here*/

LineItem item = new LineItem(CatalogName, ProductID, "", Quantity);

frm.LineItems.Add(item); bas.OrderForms.Add(frm);

bas.Save();

PipelineInfo pipeline = new PipelineInfo("basket", OrderPipelineType.Basket);

Profile profile = CommerceContext.Current.ProfileSystem.GetProfile(Session["AuthUserId"].ToString(), "UserObject"); if (profile != null)

if(profile != null)

{

pipeline.Profiles.Add("UserObject", profile);

bas.RunPipeline(pipeline);

}

In my checkout page
after verisignApproval

Basket bas = CommerceContext.Current.OrderSystem.GetBasket(UserID, "default");

SiteOrderForm orderform = GetSiteOrderForm();

orderform.cc_auth_number = "232";

bas.OrderForms.Add(orderform);/*throws error over here*/
//*Error thrown is "An order form by the same name or ID already exists in the order forms collection."*/
//If i comment the section bas.OrderForms.Add(orderform); no error is thrown but i am not getting the updated value in the cc_auth_number.Please let mw know where i am wrong
bas.Save();

bas.SaveAsOrder();

        public SiteOrderForm GetSiteOrderForm(string orderFormName)
        {
            if (String.IsNullOrEmpty(orderFormName))
            {
                orderFormName = SiteOrderForm.DefaultOrderFormName;
            }

            Guid registeredUserID = new Guid(Session["AuthUserId"].ToString());
            Basket registeredBasket = OrderContext.Current.GetBasket(registeredUserID, "default");
            SiteOrderForm orderForm = registeredBasket.OrderForms[orderFormName] as SiteOrderForm;

            if (orderForm == null)
            {
                orderForm = new SiteOrderForm(orderFormName);
                registeredBasket.OrderForms.Add(orderForm);
            }

return orderForm;
}

        public SiteOrderForm GetSiteOrderForm()
        {
            return this.GetSiteOrderForm(null);
        }

Export discounts from one server to another

Tue, 01 Apr 2008 07:43:58 Z

Hello

Is there a way to export discounts from on server to another.

I want to export the discount i've created in my development enviorment to the production server.

Thanks

Arik

Does a tool exist to export Commerce Server 2007 marketing data (e.g. campaigns, ads, discounts, etc)?

Wed, 17 Oct 2007 14:54:34 Z

Hi,

Can anyone confirm whether there exists any tools for Commerce Server 2007 which allow users to import/export marketing data (e.g. campaigns, ads, discounts, etc) as xml?

Currently we are writing directly to the database using sql scripts to populate our test data.

We find the catalog import/export command line tool really useful, and we're hoping that there is a similar tool available somewhere that handles marketing data.

Thanks in advance

Chris

Navigation doesn't work anymore

Mon, 23 Nov 2009 09:11:32 Z

Hello,

Our navigation for the webshop doens't work anymore
When we want to go to the site, I get the following error;

The DataSourceID of 'CurrentNav' must be the ID of a control of type IHierarchicalDataSource. A control with ID 'SiteMapDS' could not be found.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The DataSourceID of 'CurrentNav' must be the ID of a control of type IHierarchicalDataSource. A control with ID 'SiteMapDS' could not be found.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): The DataSourceID of 'CurrentNav' must be the ID of a control of type IHierarchicalDataSource.  A control with ID 'SiteMapDS' could not be found.]
   System.Web.UI.WebControls.HierarchicalDataBoundControl.GetDataSource() +2332337
   System.Web.UI.WebControls.HierarchicalDataBoundControl.ConnectToHierarchicalDataSource() +212
   System.Web.UI.WebControls.HierarchicalDataBoundControl.OnLoad(EventArgs e) +28
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

And I use the following code in the masterpage;

      
      <SharePoint:AspMenu ID="CurrentNav" runat="server" datasourceID="SiteMapDS" orientation="Vertical"
                      StaticDisplayLevels="3"
                      MaximumDynamicDisplayLevels="1"
                      ItemWrap="true" AccessKey="3"
                      CssClass="Skin_Menu"
                      StaticMenuItemStyle-VerticalPadding="3px"
                      SkipLinkText="<%$Resources:defaultSite,masterpages_skiplinktext%>"
          StaticHoverStyle-CssClass="Skin_MenuItemHover">

                <LevelMenuItemStyles>
                    <asp:MenuItemStyle CssClass="Skin_MenuHeader" />
                    <asp:MenuItemStyle CssClass="Skin_MenuItem" />
                </LevelMenuItemStyles>

      </SharePoint:AspMenu>

I hope somebody know what is wrong or what is missing.

Thanks!
Stefan

VAT Calculation in Custom Pipeline

Mon, 05 May 2008 06:13:56 Z

Hi,

My Requirement is

I want calculate the VAT tax based on the delivery address(with in country) and Line item.The line item unit price is above $100, i need calculate VAT tax.

I have created a custom pipeline and inserted new component in after "Commerce DefaultTaxCy" in "total.pcf".

After that i have run my custom pipeline, it thrown exception is "Unable to cast object of type 'System.Int32' to type 'Microsoft.CommerceServer.Runtime.ISimpleList'."

My codes are below

Execute Method

private const String AddressesKey = "Addresses";

private const String AdjustedPriceKey = "_cy_oadjust_adjustedprice";

private const String BasketErrorsKey = "_Baseket_Errors";

private const String CountryCodeKey = "country_code";

private const String DecimalPlacesKey = "_currency_decimal_places";

private const String ItemIndexesKey = "ItemIndexes";

private const String ItemsKey = "Items";

private const String MessageManagerKey = "MessageManager";

private const String ShipmentsToProcessKey = "shipments_to_process";

private const String ShippingAddressIdKey = "shipping_address_id";

private const String VATTotalKey = "_cy_tax_total";

public int Execute(object pdispOrder, object pdispContext, int lFlags)

{

IDictionary Order = null; // OrderForm dictionary representing the basket

IDictionary Context = null; // Context dictionary

ISimpleList ShipmentsToProcess = null; // Simplelist of shipments in this order

ISimpleList Items = null; // Simplelist of items to process for each shipment

IDictionary Addresses = null; // Dictionary object representing a shipping address

IMessageManager MessageManager = null; // MessageManager used to return pipeline errors

Object ErrorMessage = null; // Error message returned from pipeline component

Int32 ReturnValue = StatusSuccess; // Status level for component execution

try

{

Order = (IDictionary)pdispOrder;

Context = (IDictionary)pdispContext;

Addresses = (IDictionary)Order[AddressesKey];

Items = (ISimpleList)Order[ItemsKey];

MessageManager = (IMessageManager)Context[MessageManagerKey];

// retrive the shipments that must be processed

ShipmentsToProcess = (ISimpleList)Context[ShipmentsToProcessKey]; // Exception thorwn here

foreach (IDictionary Shipment in ShipmentsToProcess)

{

decimal VATItemTotal = 0;

IDictionary Item;

foreach (Int32 ItemIndex in (ISimpleList)Shipment[ItemIndexesKey])

{

Item = (IDictionary)Items[ItemIndex];

VATItemTotal += Convert.ToDecimal(Item[VATTotalKey]);

}

String ShippingAddressId; // shipping address Id

String Country; // destination country for shipment

IDictionary Address; // Address dictionary

// examine address information

ShippingAddressId = Shipment[ShippingAddressIdKey].ToString();

Address = (IDictionary)Addresses[ShippingAddressId];

// retrieve the destination country of the shipment

Country = Address[CountryCodeKey].ToString();

// determine what the shipping cost is as a percentage of the item totals

decimal VATPrice = VATItemTotal * 25 / 100M;

}

catch (Exception ex)

{

ErrorMessage = ex.Message;

((ISimpleList)Order[BasketErrorsKey]).Add(ref ErrorMessage);

return StatusError;

}

return ReturnValue;

}

#endregion

public object ContextValuesRead()

{

object[] contextValuesRead = new object[0];

return contextValuesRead;

}

public object ValuesRead()

{

object[] valuesRead = new object[1];

valuesRead[2] = "_cy_tax_total";

return valuesRead;

}

public System.Object ValuesWritten()

{

object[] valuesWritten = new object[1];

valuesWritten[0] = "_cy_tax_total";

return valuesWritten;

}

Thanks for your compliment,

Arun.

Unable to cast object of type 'System.DBNull' to type 'Microsoft.CommerceServer.Runtime.IDictionary

Thu, 17 Apr 2008 18:52:40 Z

Hi,

We've deployed our CS2007 site into production and have an interesting intermittent error.

The commerce website runs correctly for 3 to 5 days. During this period all users are able to successfully place orders and their credit cards are successfully processed through our custom payment method component which calls our third party payment processing gateway for authorization.

At a certain point, usually after 3-5 days of server uptime, a user attempts to submit an order and they receive the following error "Unable to cast object of type 'System.DBNull' to type 'Microsoft.CommerceServer.Runtime.IDictionary'". Once this error has occurred the site will not process any orders for any users.

We shut down and restart the server. At that point the website runs correctly again and processes orders for all users. This lasts again for approximately 3 to 5 days when we experience the error again.

Our troubleshooting to this point has shown that the "payment_to_process" dictionary is coming through as null, .... but only after several days of working correctly! Here is a snippet from our custom payment method code:

PipelineUtility.Log("Entering Credit Payment Pipeline Component");

// initialize the Order and Context dictionaries

Order = (IDictionary)pdispOrder;

Context = (IDictionary)pdispContext;

// retrieve details required for processing payment

IDictionary payment = (IDictionary)Context["payment_to_process"];

if (payment != null)

{

// ... web service call to 3rd party payment gateway to process the payment

}

The error appears to be occurring on this line:

IDictionary payment = (IDictionary)Context["payment_to_process"];

We believe the code is correct, but have not been able to identify any reason for the payment_to_process dictionary to be null (after running properly for several days). Perhaps there is some issue with the PaymentMethodRouter component or with the underlying com+ components?

Any help is greatly appreciated!

Thanks!

Mike

Error in Refresh Site Cache

Wed, 03 Jan 2007 11:07:53 Z

Hi,

I have a problem whem I want to refresh a Site Cache from one of the business applications. The error I get is:

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: There was an error generating the XML document. ---> System.InvalidOperationException: Instance validation error: '0' is not a valid value for System.Net.HttpStatusCode.

Whats there the problem? I've read that tehere was a Hotfix (http://support.microsoft.com/default.aspx/kb/922068) but i cantot download this Hotfix.
When I open this link: SiteCacheRefresh.axd?CacheToRefresh=CatalogCache for example, I get the problem that It dosen't find the file SiteCacheRefresh.axd. In additon tho that I've enshured that in the config file the correct Authorisation rights are set.

Even with all of those, I still get this Error. What does it really mean and how can I solve this?

Thanks
.

How to Convert M2TS to AVI, WMV, MP4, MOV, 3GP, FLV (Windows/Mac)

Fri, 20 Nov 2009 01:22:09 Z

What is M2TS?
M2TS is a Sony high definition video file type. M2TS files are raw AVCHD videos recorded using Sony’s camcorders, such as the HDR-SR1 and HDR-SR5 models. Panasonic, Canon and other brands of AVCHD camcorders also record in M2TS format.
However, this format cannot be usually played on your computer or portable players. So firstly you need convert the format to the common video formats such as AVI, WMV, MP4, MOV, 3GP, FLV, SWF, DivX, XviD etc..
With this easy-to-use M2TS Converter, you can convert m2ts file to the common video format. Furthermore, this poweful tool can let you playback your converted files on all popular portable players such as iPod, iPhone, Archos, video mobile phone, Zune, PSP, etc..
Part 1: How to convert m2ts to AVI, WMV, MP4, MOV, 3GP, FLV on Mac
The converter you need is Tipard M2TS Converter for Mac.
How to operate the converter:
Firstly, Download and install the M2TS Converter for Mac (Intel Version) or (Power PC Version). After the action, you will see the following screenshot:

Step 1: Run the converter and load your files.
Step 2: Select the format you want to convert from “Profile”. If you like to set your own data, please click “Settings” button.
Step 3: Set up the output profile and the output file path. You can default the output file path or select your own path by clicking “Browse” button on the line of Destination.
Step 4: Start conversion.
After you set all the settings, you can click “Start” to start conversion.
This converter also has powerful editing functions besides conversion. Take some examples below:
1: Snapshot
If you like the current image of the video you can use the “Snapshot” option, just click the “Snapshot” button and the image will be saved and then click the “Open” button next to “Snapshot” button to open your picture.
2: Merge
If you want to merge several videos into one file you can choose them at one time and click the “Merge into one file” to do it.
3: Effect
Click “Effect” button you can do these actions: adjusting brightness, contrast and saturation of the video. You can easily adjust the video through two windows in the same interface.

4: Trim
If you just want convert a clip of your video, then you can use the "Trim" icon to set the Start time and End time of the clip or you can directly drag the slide bar to the accurate position.

5: Crop
By using the “Crop” function you can crop the black edge of your video and you can also drag the line around the video image to adjust your video to your Google Phone.

Part 2: How to convert M2TS to AVI, WMV, MP4, MOV, 3GP, FLV on Windows
The converter you need is Tipard M2TS Converter.
Firstly, download and install Tipard M2TS Converter.
Step 1: Run Tipard M2TS Converter and load your files.

Step 2: Select the format you want to convert from “Profile”. If you like to set your own data, please click “Settings” button.
Step 3: Set up the output profile and the output file path. You can default the output file path or select your own path by clicking “Browse” button on the line of Destination.
Step 4: Start conversion.
After you set all the settings, you can click “Start” to start conversion.
Tips:
The key features are shown below:
1: How to set effect of video
You can adjust the video such as brightness, contrast and saturation

2: How to split your video
The "Trim" function also servers as a video splitter for you to get any time-length video episode. You can set the "Start Time" and "End Time" to set the time of the clip or you can directly drag the slide bar to the accurate position.

3: How to crop off the black edges and adjust the size of video play region
By using the "Crop" function you can crop the black edge of your video and you can also drag the line around the video image to adjust the video play region to fit for your mobile devices. Have you found out the difference from the two windows? The bride and the old man are only in the picture.

4: How to save your favorite picture
If you like the current image when preview video, you can use the "Snapshot" option. Just click the "Snapshot" button the image will be saved and you can click the "Open" button next to "Snapshot" button to open your picture.
5: How to join your file pieces
If you want to merge several files into one file you can choose them and click the "Merge into one file" to do it.
Now your recorded video is well converted and edited.
iPhone Video Converter
FLV Converter

How to show the properties of an variant product on the product.aspx page

Thu, 19 Nov 2009 15:59:25 Z

Hello,

I've got a product with five different variant properties.
For those variant properties, i've got different custom properties.
When I choose a variant property from the dropdown box, i want to show the properties of that variant.
But how do I do that?

I can choose the simple property list web part, but I can get it only work with custom properties. All I want to do is that these propertys change when I choose an other variant property from the dropdown box.

Example dropdownbox:

Producttype:   Product Variant 1
                     Product Variant 2
                     Product Variant 3
                     Product Variant 4
                     Product Variant 5

When I choose Product Variant 2 from the dropdownbox, I want some variant properties to be changed on the product page

I hope somebody has an answer for this?!

Thanks!
Stefan

Issue in Catalog manager

Tue, 17 Nov 2009 13:07:31 Z

Hi,

I have created a product in catalog manager. Also there are 3 variants added to the product. For those varaints, there is a dropdown - color which has values - Blue, Black and Green. These values are from the property - Product Color from Catalog and Inventory schema manager. But I need to change the value 'Green' to 'Green color'. I am able to change the value in Catalog and Inventory schema manager. But on accessing the product and on selecting the varaint which is having the changed value, it is throwing an error message "System.Argument.Exception: DataGridViewComboBoxCell value is not valid". what could be the issue? Is it possbile to change existing dropdown values in Catalog and Inventory schema manager which is used in the products.

Regards,
Ginu

Timeout?

Wed, 21 Oct 2009 15:04:26 Z

Particularly when our site is busy I am getting a number of SQL timeout error exceptions from the call PurchaseOrderManager.GetPurchaseOrderAsDataSet. Is there any way to increase the timeout value for this call so I can avoid the exception?

Thank you.

Kevin

Product Images

Thu, 12 Nov 2009 20:28:55 Z

My product images are hosted on another external web server. How can I map the product images so that it does not pickup my local URL?

Commerce Server 2009 Info

Tue, 17 Nov 2009 07:13:54 Z

Could any one suggest a good ebook for commerce server 2009?

Tuning Advisor on CS2007 database

Tue, 17 Nov 2009 09:30:29 Z

Hello

My host wants to run the SQL Server tuning advisor tool (TA) on a commerce server database. As a result, the TA will generate new indexes on tables, or modify existing indexes on the CS database

Any recommandations ? I don't like the idea od modifying the CS database, as some tables columns are created, modified, etc by CS on runtime.

Olivier

where to find commerce server 2007 trial version?

Sun, 15 Nov 2009 05:54:53 Z

hi there,

i want to know where i can find commerce server trial download? how can you learn it without it installed. thanks.

allan

Using the UpmProvider on WCF Service

Thu, 24 May 2007 02:30:43 Z

Hi Folks,
i m trying to use the UpmMembershipProvider on a WCF service for authentication but i was enable to do so i got an error that says he can not load the assembly "Microsoft.CommerceServer.Runtime.Profiles.UpmMembershipProvider" i ve followed exactly the same steps as for using UpmProvider inside sharepoint 2007

Thanks

Younes

Products page loading slowly in starter site

Sun, 15 Nov 2009 04:29:21 Z

Hi,

Suppose there are more products mapped under a catalogue or category, on clicking the catalogue name or category name, the starter site product list page is taking some time(around 12 secs) to load the page. how can we make it to reduce 2 to 4 secs even if there are more products under it?

Regards,
Ginu

Microsoft.CommerceServer.Runtime.Orders.UnexpectedContainedTypeException

Thu, 12 Nov 2009 06:59:03 Z

I am working on commerce server 2007 I have extend orderform by adding two new fields.

After that am getting following error on submitting order.

Class collection property PurchaseOrder.OrderForms contains an object of type OrderForm that was not specified in the storage mapping.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.CommerceServer.Runtime.Orders.UnexpectedContainedTypeException: Class collection property PurchaseOrder.OrderForms contains an object of type OrderForm that was not specified in the storage mapping.

Source Error:

Line 360: // Save the basket as an order, send an email receipt,

Line 361: // and redirect to the order detail page.

Line 362: order = this.CheckoutData.BasketHelper.Basket.SaveAsOrder();

Line 363: transaction.Complete();

Line 364: }

Source File: d:\StarterSiteProjects\StarterSite\Checkout\Default.aspx.cs Line: 362

Stack Trace:

[UnexpectedContainedTypeException: Class collection property PurchaseOrder.OrderForms contains an object of type OrderForm that was not specified in the storage mapping.]

Microsoft.CommerceServer.Runtime.Orders.PurchaseOrder.Save(Boolean deleteOrder, ITransaction trans) +4260

Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder(ITransaction trans) +131

Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +7

Checkout_Default.ExecuteTransactedCheckout() in d:\StarterSiteProjects\StarterSite\Checkout\Default.aspx.cs:362

Checkout_Default.Checkout() in d:\StarterSiteProjects\StarterSite\Checkout\Default.aspx.cs:222

Checkout_Default.CheckoutWizard_FinishButtonClick(Object sender, EventArgs e) in d:\StarterSiteProjects\StarterSite\Checkout\Default.aspx.cs:561

System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111

System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Orders Extensibility in commerce server 2007 thrown an error message(basket.SaveAsOrder()) - Using Web service

Thu, 22 May 2008 11:35:41 Z

Hi,

I have extended the LineItems, OrderForms and PurchaseOrders based on the SDK sample code and it is working fine when I am placing orders through StarterSite. Then for my requirement I created a new web service and accessing the StarterSite_OrderWebService to place the order. But I am getting an error on placing the order.

I have pasted my code here .

In web.config file,

Code Snippet

</< FONT>appSettings>

My Web Service Code,

Code Snippet

Configuration objConfig = WebConfigurationManager.OpenWebConfiguration("~");

AppSettingsSection objAppsettings = (AppSettingsSection)objConfig.GetSection("appSettings");

if (objAppsettings != null)

{

orderSiteName = objAppsettings.Settings["EXTENOrder.SiteName"].Value;

OrderContext orderContext = OrderContext.Create("orderSiteName "); //SiteName

}

Guid userid = Guid.NewGuid();

Guid soldToID = Guid.NewGuid();

Basket basket;

EXTENOrderForm orderform = new EXTENOrderForm ("default");

basket = orderContext.GetBasket(userid, "DefaultBasket");

EXTENLineItem lineitem = new EXTENLineItem();

lineitem.ProductCatalog = "Adventure Works Catalog";

lineitem.Quantity = Convert.ToDecimal("12");

lineitem.ProductId = "AW042-03";

lineitem.ProductVariantId = "AW042-03-71";

lineitem.ShippingMethodId = new Guid("373ca40c-0000-4db2-8d9b-9fb507e33662");

lineitem.ShippingMethodName = "Esplanaden Express";

lineitem.ListPrice = Convert.ToDecimal("32.00");

lineitem.ExtendedPrice = Convert.ToDecimal("32.00");

lineitem.DisplayName = "Men's button-down (Blue)";

lineitem.Description = "Men's button-down (Blue)";

lineitem.Logo = "LogoTest";

lineitem.ProductColor = "Red";

lineitem.ProductSize = "30";

lineitem.WarehouseCode = "XYZ";

lineitem.VolumetricWeight = 2;

lineitem.CostPrice = Convert.ToDecimal("23.00");

lineitem.QtyPerUnit = 1;

OrderAddress orderAddress = new OrderAddress("HomeAddress", "{0e6bc808-ed6e-4269-8645-1a86edc99af7}");

lineitem.ShippingAddressId = "{b00dd6a0-8e46-4447-81b2-d5696647a064}";

orderform.LineItems.Add(lineitem);

basket.OrderForms.Add(orderform);

basket.Addresses.Add(orderAddress);

basket.SetShippingAddress("{b00dd6a0-8e46-4447-81b2-d5696647a064}");

basket.SetBillingAddress(orderAddress.OrderAddressId.ToString());

basket.SoldToAddressId = orderAddress.OrderAddressId.ToString();

basket.Status = "NewOrder";

basket.Save();

EXTENPurchaseOrder po = (EXTENPurchaseOrder)basket.SaveAsOrder();

I am getting the error on the line marked in blue i.e., Saving an order from basket.

The error is,

Microsoft.CommerceServer.Runtime.Orders.UnexpectedContainedTypeException: Class collection property PurchaseOrder.OrderForms contains an object of type EXTENOrderForm that was not specified in the storage mapping.
   at Microsoft.CommerceServer.Runtime.Orders.PurchaseOrder.Save(Boolean deleteOrder, ITransaction trans)
   at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder(ITransaction trans)
   at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder()

If I remove this line of code (EXTENPurchaseOrder po = (EXTENPurchaseOrder)basket.SaveAsOrder() and execute the application. The items are saved in the basket successfully without any error. I am able to view the the created items in the Commerce Server 2007 - Customer and Order Manager.

I am facing the above problem when I use the extended Order classes but the Orders are getting placed successfully if I use the existing Order classes instead of extended Order classes.

So I think there is some problem when I am converting my basket to Order using the extended Order classes. Do I have to make any other configuration changes for accessing the extended classes through my new web service.

Modify a purchase order

Wed, 28 Oct 2009 15:43:10 Z

This question is regarding SavePurchaseOrder, UpdatePurchaseOrder, and UpdatePurchaseOrderProperties methods in the PurchaseOrderManager class.

1) Is there a functional difference between SavePurchaseOrder and UpdatePurchaseOrder?
2) If I have a purchase order as XML (GetPurchaseOrderAsXml) and I want to change one of the attributes of one of the nodes can I use UpdatePurchaseOrderProperties or am I forced to SavePurchaseOrder even if all I changed was an attribute? If I can use UpdatePurchaseOrderProperties what is the format of the XmlElement for a "property" that is an attribute?

I see that if I want to search the database for a particular purchase order it seems that I am better off programming using the DataSet model. What are the scenarios which I am better off using XML?

Thank you.

Kevin

Login user name field pre-filled with email address!

Thu, 22 Oct 2009 14:02:28 Z

Hi,

i'm developing based on startersite, i have followed the online resources to change the login field from email to the memeber id. it works fine.

BUT often, the username field is pre-filled with the user email on their login screen. anything that i might have missed out?

thanks.

The Commerce Server 2009 Evaluation VPC (September 2009 version) is now available for download??? Links do NOT work

Wed, 11 Nov 2009 15:36:13 Z

The Commerce Server Blog posts >>
The Commerce Server 2009 Evaluation VPC (September 2009 version) is now available for download.

This VPC has Commerce Server 2009 and Microsoft Office SharePoint® Server 2007 (MOSS) fully installed and configured (Core Systems, Multi-Channel Commerce Foundation, SharePoint Commerce Services), including the new Default site with the Template Pack running in SharePoint using the 30 new Web Parts.
http://blogs.msdn.com/commerce/archive/2009/09/25/commerce-server-2009-evaluation-vpc-september-2009-version-is-available-for-download.aspx

Download the latest VPC - complete with a demo script, sales collateral, samples and videos from Microsoft Connect.

However, the download link for both the august and september VPCs do not work....

Does anyone know the correct link for the download?

Thank you,

-Ivan

Ivan Sanders http://www.linkedin.com/in/iasanders http://dimension-si.com/blog

trying hire commerce server developer- please help

Fri, 06 Nov 2009 16:49:01 Z

We have a very good company that we are happy with but they are small and we need more in house development. I code a little bit but i do not understand commerce server that well. I was wondering if i hired a developer full time what languages should they know? Do they have to know commerce server and can they learn commerce server on the job if they know C# and .net really well. We have a website that does 10 million a year so we need someone who understands pipelines and all that ____ but i am confused about how to hire someone. Hope someone can help

For web business- is there an accounting system or refund module in commerce server?

Tue, 10 Nov 2009 18:49:45 Z

Is there a one stop package for commerce server

1. Charging the cc

2. Collecting cash

3. Paying bills

4. Issuing financial statement

5. Issuing refunds and return merchandise authorization

Browse items by category or by manufacturer

Fri, 06 Nov 2009 19:06:13 Z

I want to allow my customer to not only browse by category but also by manufacturer. How is the best way of handling this?

Product Search Keywords

Tue, 10 Nov 2009 03:42:41 Z

My supplier provides me with a database file of the items they sell to me. I am taking this file and loading it into CS2009 to load my products into CS2009. My import file has a field that contains the search keywords for the item.

My question, where/how would you suggest that I use this field in CS2009?

Is there a limit on the number of items or categories?

Sun, 08 Nov 2009 01:46:37 Z

After loading my products via XML import I get the follow error after tring to access the web site. I've isolated the possibility of data issues and I'm sure it is related to the number of records loaded. Attached is the error from the event log:

Event Type: Error
Event Source: SharePoint Commerce Services Exceptions
Event Category: None
Event ID: 0
Date:  11/7/2009
Time:  7:45:59 PM
User:  N/A
Computer: WEB
Description:
An exception of type 'System.Threading.ThreadAbortException' occurred and was caught.
-------------------------------------------------------------------------------------
11/07/2009 19:45:59
Type : System.Threading.ThreadAbortException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Thread was being aborted.
Source : System.Data
Help link :
ExceptionState : System.Web.HttpApplication+CancelModuleException
Data : System.Collections.ListDictionaryInternal
TargetSite : IntPtr SNIPacketGetConnection(IntPtr)
Stack Trace :    at SNINativeMethodWrapper.SNIPacketGetConnection(IntPtr packet)
   at System.Data.SqlClient.TdsParserStateObject.ProcessSniPacket(IntPtr packet, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, CatalogDataSetType catalogDataSetType, SqlParameter[] commandParameters, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(ExecutionContext executionContext, String spName, Object[] parameterValues, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(ExecutionContext executionContext, String spName, CatalogDataSetType catalogDataSetType, Object[] parameterValues)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogCache.GetDataset(ExecutionContext executionContext, CacheItemType cacheItemType, String storedProcedureName, CatalogDataSetType catalogDataSetType, Boolean getFromCache, Object[] parameters, String outParameterName, Object& recordCount, Boolean& obtainedFromCache)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogCache.GetDataset(ExecutionContext executionContext, CacheItemType cacheItemType, String storedProcedureName, CatalogDataSetType catalogDataSetType, Boolean getFromCache, Object[] parameters, Boolean& obtainedFromCache)
   at Microsoft.CommerceServer.Catalog.Internal.Category.GetCategoryProperties(CatalogExecutionContext context, String baseCatalogName, String catalogName, Int32 oid, String language, Boolean getFromCache, Boolean isVirtualCatalog)
   at Microsoft.CommerceServer.Catalog.Internal.Category.PreLoadCategory(CatalogExecutionContext context, Category category, CategoryConfiguration config, Boolean getFromCache, Boolean relationshipsExist)
   at Microsoft.CommerceServer.Catalog.Internal.Category.GetCategoryData(CatalogExecutionContext catalogExecutionContext, String catalogName, String categoryName, String language, Nullable`1 isVC, Nullable`1 validateLanguage, CategoryConfiguration config, Boolean getFromCache)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config, Boolean getFromCache, Nullable`1 isVirtualCatalog, Nullable`1 validateLanguage)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config)
   at Microsoft.CommerceServer.Catalog.Category.Get(CatalogContext catalogContext, String catalogName, String categoryName, String language, CategoryConfiguration config, Nullable`1 isVirtualCatalog, Nullable`1 validateLanguage)
   at Microsoft.CommerceServer.Catalog.Category.Get(CatalogContext catalogContext, String catalogName, String categoryName, String language, CategoryConfiguration config)
   at Microsoft.CommerceServer.Catalog.CatalogContext.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config)
   at Microsoft.Commerce.Providers.CSHelpers.CatalogHelper.GetCategory(String siteName, String catalogName, String locale, String categoryName, CategoryConfiguration categoryConfiguration)
   at Microsoft.Commerce.Providers.Components.CategoryLoader.ExecuteQuery(CommerceQueryOperation queryOperation, OperationCacheDictionary operationCache, CommerceQueryOperationResponse response)
   at Microsoft.Commerce.Providers.Components.OperationSequenceComponent.Execute(CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)
   at Microsoft.Commerce.Broker.OperationSequence.ExecuteComponentTree(List`1 executionTreeList, CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)
   at Microsoft.Commerce.Broker.OperationSequence.ExecuteComponentTree(List`1 executionTreeList, CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)
   at Microsoft.Commerce.Broker.OperationSequence.Execute(CommerceOperation operation)
   at Microsoft.Commerce.Broker.MessageHandler.ProcessMessage(String messageHandlerName, CommerceOperation operation)
   at Microsoft.Commerce.Broker.OperationService.InternalProcessRequest(CommerceRequest request)
   at Microsoft.Commerce.Broker.OperationService.ProcessRequest(CommerceRequest request)

Additional Info:

MachineName : WEB
TimeStamp : 11/8/2009 1:45:59 AM
FullName : Microsoft.Commerce.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
AppDomainName : /LM/W3SVC/869253099/Root-1-129021175427962012
ThreadIdentity :
WindowsIdentity : MIKEKELLEYCONSU\csRunTimeUser

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Explaination of the web sites created by the configuration tool

Fri, 06 Nov 2009 13:45:21 Z

I am just starting out with Commerce Server 2009 and I am not quite understanding how everthing is tied together. When I run the sharepoint configuration tool it creates a new web site and what is called an extended web site. My question is, do both of these web sites need to be available to the general public? If so, which one? Should the public site be assigned port 80 or should the port be remapped using a router/firewall?

List of Commerce Server Supported Languages and Currencies

Mon, 09 Nov 2009 15:16:42 Z

Where I can find list of Commece Server Languages and Currencies respective to countries?

Display Basket Message For Order Form

Mon, 09 Nov 2009 15:51:45 Z

On my shopping cart page I want to display a list of all basket messages (MultilingualBasketDisplay) for the discounts applied to the customers Order Form. Is it possible to access the Basket Messages at the Order Form level? I see how I to get them at the Line Item level through the ItemLevelDiscountsApplied property but it seems like I should be able to retrieve them at the order level. Does anyone have any experience with this?

Thanks.

Realtime inventory managment

Fri, 06 Nov 2009 11:27:11 Z

Hello

I've tryied to set a realtime inventory system wuth CS2007. Let's explain :
My products only have 2 inventory states : They are in Stock or not. No backorderable stuff or anything else. As soon as a variant is added to the basket, the rule is that it is "reserved" for 15 minutes, and it can't be added to any other basket. After 15 minutes with no activity on the basket, the variant ihas to be removed from the basket, and the inventory quantity has to be corrected.

Here's what we've done, wich is probably not the best solution :

We've remove the pipeline Inventory steps, so the inventory quantity is never corrected by the pipelines
When a variant is added to the basket, we immediatly modify it's quantity.
If the variant is removed from the basket (by tje customer), we put it back to the inventory
Every 15 minutes, we check all baskets, and if a basket wasn't modified for more than 15 minutes (and if the user isn't currently checking-out), we empty it and replace its variants to the inventory.
Each night, we get an inventory file from the logistic team, containing the real quantities available. We import this file, with quantity correction if there are still baskets containing the concerned variant, which were not allready cleared.

It seams to work, but there's probably a better way of managing this rules

Any suggestions / recommandations ?

Thanks a lot

Olivier

Catalog Lists for Searching

Mon, 09 Nov 2009 13:07:06 Z

The FreeText search source in Startersite is using the code

search.CatalogNamesCollection =

CatalogHelper.GetCatalogsForUser(); for getting the Catalog Name collection.

Is it possible If we want to get the catalogs which exists in two catalogsets? mean to say if we create 2 new catalog sets and added few catalog names to these catalog sets. So on getting the CatalogName colelction, we need only the catalog names that added to the 2 catalog sets?

Regards,
Ginu

Searching with ProductID or Variant ID

Thu, 05 Nov 2009 06:00:15 Z

Hi,

Is it possible to include searching with ProductID or Variant ID to the Search functionality in Starter site. That is on providing ProductId or VariantId, is it possible to get the corressponding products to the search results.

Regards,
Ginu

Can not add more then 42 items in the multivalued field of user profile

Sat, 07 Nov 2009 01:28:49 Z

Hello,

I'm trying to add about a 100 items to a multivalued field of the user object and it limits me to 42. Is there some config setting to over come this limitation? Any suggestion is greatly appreciated

Thanks
Vadim

Catalog Manager - Manual Import Status

Sat, 07 Nov 2009 20:11:13 Z

I'm manual importing about 20k items and about 5k categories by using the Cataglog Manager. In the Catalog Manager when I select the Status under views, I notice that the import does not always show the the correct status. I can confirm by exiting and restarting the Catalog Manager then show the correct status and by the event log event showing that the import was complete. Can anyone please confirm that this is a display bug in the Catalog Manager and not a error in my import.

Thanks, Mike

Favorite item does not display while changing catalog set for an user.

Fri, 06 Nov 2009 14:17:10 Z

We have developed a webstore running in Commerce Server 2007.

There are two catalog sets called A and B.Both are having same items.
The user has been assigned with catalog set A and then the user has added several items as his favorites.

Then a user is changed from a catalog set A to catalog set B through commerce server manager.
The favorite items page does not display any favorites stored by the user.

I tried to find out where the relation between user and favorite items is stored in the database but I couldn't.

Can anyone explain this?
where and how the relation between user and favorite items is stored?
Is there anyway that we can display the favorite items of the user while changing the catalog set as the items are going to be same?

How to connect MArketingItem to Marketing Manager advertisments ?

Fri, 06 Nov 2009 09:49:55 Z

I'm having troubles displaying my advertisments on my website.

I'm creating advertisments in the marketing manager, type image, viisble every days, with a industry code... And I validate them.

On the other end, I added a marketingItem control, Set its contentsize with my ad contentsize and industrycode with my ad industrycode, and filled the sitecontext, the targetcontext and the pagegroup from surrent datas.

Despite all that, the ad isn't visible.

What am I missing ?