Developer forum

Forum » Ecommerce - Standard features » How to set order id counter to higher number

How to set order id counter to higher number

Stephen Anthony Jackson
Reply

Hi. I want to set the starting number of orderids to say 100 million, to be able to reuse a non-incremental column in the ERP, but prevent ever conflicting with orders made directly in the ERP.

Can I just bump the autoid by explicitly making a row in Ecomorders with orderid 100 million or is there a more approved way of doing this? 

Additional. I just noticed its anyway a string. Where is the counter stored in that case?

Addtional Additional: I found the setting in EcomNumbers. Think i'll mark my own post as answer ;)


Replies

 
Suzi Louring
Reply
This post has been marked as an answer

Hi Stephen

I think you can use this in SQL Firehose.
In this case I will update the number to 2000:

update ecomnumbers set [NumberCounter] = 2000 where [NumberType] = 'ORDER'

 

/Suzi

Votes for this answer: 1
 
Stephen Anthony Jackson
Reply

Thanks Suzi. I managed to find it anyway, exactly as you said

 

You must be logged in to post in the forum