Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Customization
 Randomized order number?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

smartgo
Starting Member

USA
11 Posts

Posted - December 12 2005 :  17:17:34  Show Profile  Visit smartgo's Homepage  Reply with Quote
Is there a way to change the order number to increase by a random amount for each order so that users don't see how many items I've sold so far?

devshb
Senior Member

United Kingdom
1904 Posts

Posted - December 12 2005 :  18:20:11  Show Profile  Visit devshb's Homepage  Reply with Quote
if you're on sqlserver, you can reseed the orderid by using this command on the sqlserver database:

DBCC CHECKIDENT(orders, RESEED,1000000)

just change the "1000000" to whatever you want to start the next orderid number with; that'll avoid you having to jump random numbers, eg you can start it with something like 5463543 and then just have it increment by the normal/default 1.

see also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_217n.asp

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on December 12 2005 18:27:51
Go to Top of Page

smartgo
Starting Member

USA
11 Posts

Posted - December 12 2005 :  21:51:45  Show Profile  Visit smartgo's Homepage  Reply with Quote
Great, thanks, that will work.
Go to Top of Page

support
Administrator

4679 Posts

Posted - December 13 2005 :  23:37:39  Show Profile  Visit support's Homepage  Reply with Quote
We also have an add-on available in our download center that allows you to set where you want the order number to start from.

Users with the VP-ASP Starter Extras! pac and higher can download from:

http://www.vpasp.com/sales/addons.asp

Thank you
VP-ASP Support
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00