Hi,
Because manufacturing for my company runs on its own system, the e-commerce orders will need to be recreated in this back office system.
I would like to have the same order number in both systems.
Currently the back office system has already used orders through 1,000,000, so I would like to start web base orders at 2,000,000.
This way if a customer calls with a question about a order the same number will be use in the e-commerce and back office system.
The problem I am having is that I can’t get the Able system to take a order number larger than 999,999.
Is there an SDK info as to what I would need to change to make this work?
I think the SQL database use a 32 bit Int for this value so that should not be an issue.
Most tables use identity seed values and increment the number, but the orders are different.
I would like to change the starting order number in the database and see if it would work, but I have not been able to find its location yet, do you where it is?
Also, I am not sure if this can be changed in the ASP code or if a complied DLL will need to be change to allow 2,000,000 as a starting order number?
It may just be configuration page that needs to be changed.
Any info you would have on this would be helpful.
Thanks
Kent
starting order number of 2000000
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Re: starting order number of 2000000
Hello,
In the file /admin/store/StoreSettings.aspx
Around line number 355
Change this code:
In the file /admin/store/StoreSettings.aspx
Around line number 355
Change this code:
to this:<asp:RangeValidator ID="NextOrderIdRangeValidator1" runat="server" Type="Integer" MinimumValue="0" MaximumValue="999999" ControlToValidate="NextOrderId" ErrorMessage="Next order number must be a numeric value." Text="*"></asp:RangeValidator>
<asp:RangeValidator ID="NextOrderIdRangeValidator1" runat="server" Type="Integer" MinimumValue="0" MaximumValue="2000000" ControlToValidate="NextOrderId" ErrorMessage="Next order number must be a numeric value." Text="*"></asp:RangeValidator>
-
- Lieutenant Commander (LCDR)
- Posts: 102
- Joined: Wed Apr 02, 2008 11:00 am
- Location: Stockholm, Sweden
- Contact:
Re: starting order number of 2000000
I think you need to change the ' MaximumValue="2000000" ' to something greater then 2 million since you want your orders to start at that value.
Best regards, Thomas
Best regards, Thomas