Page 1 of 1

Affiliate Wiz is passing OrderID instead of Order Number

Posted: Thu Jun 04, 2009 7:25 am
by AlanW
We're using Affiliate Wiz (Verion 5.0 on Access DB)

AC sales are being recorded in Affiliate Wiz with OrderID instead of actual Order Number. (I'm not certain OrderID would be the exact field name but it's the primary key AC uses for an order)

Here's the tracking string we have in Third Party Tracker field

Code: Select all

https://www.practicerange.com/affiliates/aw.aspx?Task=AddSale&Order_Number=[OrderNumber]&Total_Amount=[OrderSubTotal]&Country=USA&Optional1=&Optional2=&Optional3=
Anyone know why it's not picking up OrderID instead of Order Number?

Thanks,
Alan

Re: Affiliate Wiz is passing OrderID instead of Order Number

Posted: Thu Jun 04, 2009 7:38 am
by mazhar
Read following thread about how generate tracking information
viewtopic.php?f=42&t=8826

Re: Affiliate Wiz is passing OrderID instead of Order Number

Posted: Wed Jun 17, 2009 10:40 am
by AlanW
AffiliateTracker.ascx control is using the save variable for OrderId and OrderNumber.
Could this be the problem passing Order Number to Affiliate Wiz?


Code: Select all

                    url = url.Replace("[OrderId]", _Order.OrderId.ToString());

                    url = url.Replace("[OrderNumber]", _Order.OrderId.ToString());

                    url = url.Replace("[OrderTotal]", _Order.TotalCharges.ToString("F2"));

                    url = url.Replace("[OrderSubTotal]", _Order.Items.TotalPrice(OrderItemType.Product, OrderItemType.Discount, OrderItemType.Coupon).ToString("F2"));
--Alan

Re: Affiliate Wiz is passing OrderID instead of Order Number

Posted: Wed Jun 17, 2009 10:45 am
by mazhar
In order to user order number make use of

Code: Select all

_Order.OrderNumber.ToString()
instead of

Code: Select all

_Order.OrderId.ToString()

Re: Affiliate Wiz is passing OrderID instead of Order Number

Posted: Wed Jun 17, 2009 3:01 pm
by AlanW
Yes that change AffiliateTracker.ascx control worked. Affiliate Wiz is passing on the correct Order Number.

Thanks,
Alan