ProductCart Shopping Cart Software Forums : Get OrderNumber in ProductCart API https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 14:46:14 +0000 Mon, 06 Aug 2012 13:34:21 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5241 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Get OrderNumber in ProductCart API : Hi Viresh,In ProductCart you have...]]> https://forum.productcart.com/get-ordernumber-in-productcart-api_topic5241_post20046.html#20046 Author: Guests
Subject: 5241
Posted: 06-August-2012 at 1:34pm

Hi Viresh,

In ProductCart you have the option to start your order numbers at a number greater than the primary key enumeration in the database. If a value is set for this, it's added to the value of the order id in the db to create the apparent Order Id displayed in the application.

The value for this is stored in the /includes/settings.asp page as the value for the constant "scPre".

It would be nicer if there were a comment in the code here, but if you open /pc/orderCompleteTracking.asp you'll notice the following at the top:
pOrderNumber = (int(pOID)+scpre)

Here, pOID is the raw id of the order in the database and scPre is the number added to it to derive the apparent Order ID displayed in the application.
]]> Mon, 06 Aug 2012 13:34:21 +0000 https://forum.productcart.com/get-ordernumber-in-productcart-api_topic5241_post20046.html#20046 <![CDATA[Get OrderNumber in ProductCart API : Hi,I&#039;m using ProductCart...]]> https://forum.productcart.com/get-ordernumber-in-productcart-api_topic5241_post20044.html#20044 Author: meanddreams
Subject: 5241
Posted: 06-August-2012 at 8:31am

Hi,

I'm using ProductCart API to fetch new orders and their details. GetOrderDetails method takes "OrderId" parameter however I found that it's the actual Primary key value of the database. Response given by this method doesn't have actual Order# (which can be used in product cart admin section to search an order).

Can anybody tell me how to get actual Order# (not OrderId)?

Thanks,

Viresh
]]> Mon, 06 Aug 2012 08:31:15 +0000 https://forum.productcart.com/get-ordernumber-in-productcart-api_topic5241_post20044.html#20044