Customizing ProductCart - Altering starting order number

Print Page | Close Window

Altering starting order number

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=880
Printed Date: 04-December-2024 at 5:12am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Altering starting order number

Posted By: Greg Dinger
Subject: Altering starting order number
Date Posted: 08-June-2007 at 12:01pm

A client wishes me to alter the beginning Order number (PCv3, Access db).

I figured I could turn off auto-increment for the Order table, use a SQL query to insert a higher number into that field, and then re-establish auto-increment. Unfortunately, MS-Access won't allow this and reports there is a relationship on that column.

Any way to do this?

Thanks,
Greg

Replies:

Posted By: netprofits
Date Posted: 08-June-2007 at 12:25pm

Hi Greg, just go to the control panel, Settings | Store Settings then click the Order & Customer Related tab. Change the setting for order # increase. There is also a setting for Customer # increase. For more details see the PC user's guide.

-------------
NetProfits Internet Consulting

Certified ProductCart Developer

http://www.nicwebdesign.com" rel="nofollow - Our Site

Posted By: Greg Dinger
Date Posted: 08-June-2007 at 12:49pm

Wow... Thank you.

I continue to be simply amazed at the foresight and numerous options built into ProductCart.