AbleCommerce Shopping Cart Software

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?

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.

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?

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.