Major issue in ProductCart APIs????

Hi All,

I'm getting one major issue as follows with ProductCart API:

I'm using following two methods to retrieve NewOrders and GetOrderDetails.

1. Sample New Order response is as follows:

<?xml version="1.0"?>
<NewOrdersResponse><RequestKey>Q8MYP0A553PLT51</RequestKey><RequestStatus>200</RequestStatus><Count>52</Count><Orders><OrderID>8545</OrderID><OrderID>8546</OrderID><OrderID>8548</OrderID><OrderID>8549</OrderID><OrderID>8550</OrderID><OrderID>8552</OrderID><OrderID>8553</OrderID><OrderID>8554</OrderID></NewOrdersResponse>, etc....

2. Now when I try to call GetOrderDetails by passing this Id it's returning me response for orderid passed but it's not same as when I try to search with same order id in product cart admin backend.  E.g. when I use API and pass 8545 as OrderId and it gives me order response. But when I try to search same order id i.e. 8545 in product cart back-end then order returns there is not same which is returned from API.

So it seems that for API it's using Primary key (identify column of database) but it's not returning actual order # which is used in product cart admin section? How would I get Order Number (not Order ID) from API response?


Thank you.

Regards,

Viresh




Edited by meanddreams - 05-August-2012 at 3:29am

Thanks for your quick reply.

It's really SHAME that ProductCart website is claiming to be in development of this product since last 10 years and guys missed this silly bug. I really feel now that API is useless because of this bug. We've other application is dependent on this order number and if that goes wrong then everything.

Can you please do something to fix this for us or escalate this bug on high priority from your end? I would really appreciate your help in this context.

Thank you.

Regards,

Viresh

Hi Hamish,

Thanks for your reply. Your prompt action in this matter would be highly appreciated. Somehow I need actual order# from API not OrderId. Somehow API method should return Order# as well. End-user don't care about adding offset to orderid. We search by Order# not Id and you're already displaying order# in back-end of a product cart then it must be returned from API as well when we call method by OrderId.

I would suggest to fix this in API and return OrderNumber field as well in XML response of GetOrderDetails method.

Thanks,

Viresh

Oh and in answer to the title - no, it's not a major issue, more of an irritation :-)

Having looked under the hood at this the other day, it seems to me that if EI were to address this concern (which I believe is a completely valid concern), a new node would need to be added to the XML output to store the "Customer Order ID" (idOrder + scPre) as the node for idOrder is also used to check which orders have already been exported (I believe) and/or is otherwise useful data.