Using ProductCart - Order XML Export

Print Page | Close Window

Order XML Export

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4782
Printed Date: 06-March-2025 at 12:19pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Order XML Export

Posted By: mgreine
Subject: Order XML Export
Date 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

Replies:

Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: mgreine
Date Posted: 06-October-2011 at 10:19am

Hi,

Thanks for the response, that's exactly what it was!

Mike

Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: mgreine
Date 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

Posted By: Hamish
Date 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.

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: mgreine
Date 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

Posted By: Hamish
Date 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 http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code