ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - Order XML Export
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Order XML Export
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
mgreine View Drop Down
Newbie
Newbie


Joined: 06-October-2011
Location: Lancaster, PA
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mgreine Quote  Post ReplyReply Direct Link To This Post Topic: Order XML Export
    Posted: 06-October-2011 at 9:57am
I am using the XML tools manager and exporting my orders to XML.  It appears that the orderId node value is off by exactly 100 for each order.  So orderId 1000 in the exported file correlates to orderId 1100 when I use the Locate Order search from the website. 
 
Has anyone else seen this?  Is there a fix?
 
Thanks,
 
Mike
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 06-October-2011 at 10:15am
Hi Mike,
  In your stores admin pages under Settings > Store Settings > Order and Customer Settings is the "Order Number Increase" set to 100?  
Editing ProductCart Code?

See WIKI Guidelines for Editing ProductCart's ASP Source Code
Back to Top
mgreine View Drop Down
Newbie
Newbie


Joined: 06-October-2011
Location: Lancaster, PA
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mgreine Quote  Post ReplyReply Direct Link To This Post Posted: 06-October-2011 at 10:19am

Hi,

Thanks for the response, that's exactly what it was!
 
Mike
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 06-October-2011 at 10:29am
Hi Mike,
    Now we know why, but is this still a problem for you? I'm sure it's behaving as designed (accessing the true orderid).  If it's still a problem then I can check with our XML expert on possible fixes. Of course the alternative is to add the same offset in the code that's accessing the XML data if it's needed :-) 
Editing ProductCart Code?

See WIKI Guidelines for Editing ProductCart's ASP Source Code
Back to Top
mgreine View Drop Down
Newbie
Newbie


Joined: 06-October-2011
Location: Lancaster, PA
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mgreine Quote  Post ReplyReply Direct Link To This Post Posted: 06-October-2011 at 10:44am
Thanks again for your help.
 
The background of my original post is that I am working on an automated way to import sales from the online store into our internal system.  I did inherit this so I am not very familiar with ProductCart. 
 
I am not sure I understand the point of the offset the way it is implemented, but if it is going to be implemented that way, then it should be respected every place that orderID is displayed/exported.
 
As a sidenote, I did add the offset to my local processing of the xml data so I am good for now.
 
Thanks,
 
Mike
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 06-October-2011 at 10:51am
Hi Mike,
     There are several reasons for the offset.
A) To fit in withexisting order numbers when companies migrate to ProductCart.
B) To allow companies to not appear as if they are brand new. As a customer being order number 2 might be worrying.
C) Because enough of our customers wanted it as a feature :-)

Don't forget if you have data flowing both ways then the adjustment also needs to be applied (the other way) when data is going ack to the ProductCart site.   


Edited by Hamish - 06-October-2011 at 10:57am
Editing ProductCart Code?

See WIKI Guidelines for Editing ProductCart's ASP Source Code
Back to Top
mgreine View Drop Down
Newbie
Newbie


Joined: 06-October-2011
Location: Lancaster, PA
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mgreine Quote  Post ReplyReply Direct Link To This Post Posted: 06-October-2011 at 11:07am

All of which are very good points.  I was questioning the way the offset is implemented and I was more so referring to just adding an offset vs what I have seen more which is setting the starting point directly.  If I could say that I want to start at 1000 (and behind the scenes the autonumber is started at 1000), then when I search, export, view, etc. there is no calculation code to handle the offset. 

I think that calculation to handle the offset was probably just missed in the export because there would be no reason to ever show the actual orderId if I have an offset defined.
 
Thanks,
 
Mike
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 06-October-2011 at 7:27pm
Hi Mike, I suspect it was deliberate as it keeps the true orderid in the XML, which makes it very clear, from a ProductCart database perspective, which order it is related to. It's one of those situations where there isn't necessarily a "right" answer.    
Editing ProductCart Code?

See WIKI Guidelines for Editing ProductCart's ASP Source Code
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.