VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 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
1898 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

4266 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