Affiliate Wiz is passing OrderID instead of Order Number

[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

[mazhar]

Read following thread about how generate tracking information
viewtopic.php?f=42&t=8826

[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

[mazhar]

In order to user order number make use of

Code: Select all

_Order.OrderNumber.ToString()

instead of

Code: Select all

_Order.OrderId.ToString()

[AlanW]

Yes that change AffiliateTracker.ascx control worked. Affiliate Wiz is passing on the correct Order Number.

Thanks,
Alan