Order Numbering

[bhill]

While testing I accidentally changed our next order number to a very high number (10000000) on our live site. I would like to change this back to much smaller number closer to where we were (413772) but Able will not allow a number lower than the last order number that came through. Anyone know a work around? I don't see us ever getting to 10000000 so it shouldn't be a concern to switch back to 420000 should it?

[jmestep]

If you have access to the database directly, you could try changing the order numbers in the 100... range in the ac_orders table to something lower, then resetting your next order number to something higher than that. Your customers might notice that their order number has been changed, though.

[bhill]

Thanks for the suggestion, since our Able is connected to a 3PL fulfillment software the order numbers need to match so that really isn't an option. Would it be possible to alter the code for: Admin/Store/StoreSettings.aspx.cs and change the logic to allow a order number lower than the current highest?

[jmestep]

I'm not sure what would happen, but you can experiment. The code that gets the next order number is in AC source code and I don't know if it looks in the order table in addition to getting the next order number from the setting for the next number or not.