uCommerce will automatically assign a payment reference to each transaction that you can use. You can grab it directly from your payment using the reference field. If you assign an order number to the order before passing it to SagePay it will be used as payment reference instead.

Suppose the success url is http://localsite/success.aspx then how can we grab the order number / reference number from this page?

Can you please tell me the name of the variable to be checked?

do we get something like this from the payment site?

http://localsite/success.aspx?orderNumber=Ref123 ;

So that I can get the value of orderNumber.

Please reply.

Hi Neo,

Usually the payment gateway supply you with those values either as a post or part of the query string.

Please see the attached image of the sagepay page.

In this Customer e-mail, Billing Phone and Delivery Phone is not populated. Can you tell me which all fields of OrderAddress corresponds to thes fields? I have assigned BillingAddress to the purcahse order while submiting to the payment site.

Hi Neo,

uCommerce is not passing along these values to SagePay. I'll make sure and add that for the next incremental update.

Thanks for reporting this.

Thanks Soren for the reply. By the way then how is the value of Name and Postcode displaying properly in the sagepay page. Is there any quick workaround for this? I really need to fix this urgently.

Best Regards,
Neo

Everything is grabbed from the billing address stored on the order.

First name and last name are used for the name.

PostalCode is used for postcode.

You can update this information using CommerceLibrary:SetBillingInformation() from XSLT or set the billing address directly on the purchase order object from .NET using SiteContext.Current.OrderContext.GetBasket().PurchaseOrder.BillingAddressId = billingAddress.OrderAddressId.

BTW could you markup the values not being display properly to be sure we're talking about the same ones? Thanks.

These are the fields used:

string surname = UrlEncodeString(address.LastName);

string firstnames = UrlEncodeString(address.FirstName);

string address1 = UrlEncodeString(address.AddressName);

string city = UrlEncodeString(address.City);

string postcode = UrlEncodeString(address.PostalCode);

string phone = UrlEncodeString(address.PhoneNumber);

string email = UrlEncodeString(address.EmailAddress);

Sorry Soren. Its not working.Still the same as shown in the screenshot. Btw is there any relation between uCommerce_Address and uCommerce_Customer tables. There are fields like email, phone number etc in these tables also.

I've got the issue repro'd on my end. Working on a fix.

Thanks a lot Soren. Will defenitely try this out and will get back to you.

It worked! Thanks a lot Soren for fixing this. This is what you call Customer Support!!! Now all the fields are showing proerly in the sage page site. Excellent!

Neo.

Hi Neo,

I'm glad to hear it. Thanks for your kind words :)

is working on a reply...