ProductCart Shopping Cart Software Forums : Order XML Export https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 06:00:34 +0000 Thu, 06 Oct 2011 19:27:43 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4782 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Order XML Export : Hi Mike, I suspect it was deliberate...]]> https://forum.productcart.com/order-xml-export_topic4782_post18458.html#18458 Author: Hamish
Subject: 4782
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.    ]]> Thu, 06 Oct 2011 19:27:43 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18458.html#18458 <![CDATA[Order XML Export : All of which are very good points....]]> https://forum.productcart.com/order-xml-export_topic4782_post18451.html#18451 Author: mgreine
Subject: 4782
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
]]> Thu, 06 Oct 2011 11:07:48 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18451.html#18451 <![CDATA[Order XML Export : Hi Mike, There are several reasons...]]> https://forum.productcart.com/order-xml-export_topic4782_post18450.html#18450 Author: Hamish
Subject: 4782
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]]> Thu, 06 Oct 2011 10:51:13 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18450.html#18450 <![CDATA[Order XML Export : Thanks again for your help. The...]]> https://forum.productcart.com/order-xml-export_topic4782_post18449.html#18449 Author: mgreine
Subject: 4782
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
]]> Thu, 06 Oct 2011 10:44:34 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18449.html#18449 <![CDATA[Order XML Export : Hi Mike, Now we know why, but...]]> https://forum.productcart.com/order-xml-export_topic4782_post18448.html#18448 Author: Hamish
Subject: 4782
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 :-) 
]]> Thu, 06 Oct 2011 10:29:10 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18448.html#18448 <![CDATA[Order XML Export : Hi, Thanks for the response,...]]> https://forum.productcart.com/order-xml-export_topic4782_post18447.html#18447 Author: mgreine
Subject: 4782
Posted: 06-October-2011 at 10:19am

Hi,

Thanks for the response, that's exactly what it was!
 
Mike
]]> Thu, 06 Oct 2011 10:19:16 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18447.html#18447 <![CDATA[Order XML Export : Hi Mike, In your stores admin...]]> https://forum.productcart.com/order-xml-export_topic4782_post18446.html#18446 Author: Hamish
Subject: 4782
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?  
]]> Thu, 06 Oct 2011 10:15:01 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18446.html#18446 <![CDATA[Order XML Export : I am using the XML tools manager...]]> https://forum.productcart.com/order-xml-export_topic4782_post18445.html#18445 Author: mgreine
Subject: 4782
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
]]> Thu, 06 Oct 2011 09:57:01 +0000 https://forum.productcart.com/order-xml-export_topic4782_post18445.html#18445