Answers.Body: <p>Once you have created the sequence (starting at 1) with your sequence key/id you can manually reset/update the number in the <code>craft_sequences</code> table in the <code>next</code> column. Obviously if you reset the number, you could get duplicate order reference numbers though if you are not careful.</p>
  
  <p>Alternatively, you could just let the sequence start at <code>1</code> and use twig to add 11000 to the sequence number within the Order Reference Number Format.</p>
  
  <p>Your Order Reference Number Format would look like this: <code>11000+seq('mySeqId')</code></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-08T14:47:38.503Z
Answers.LastActivityDate: 2020-04-08T14:47:38.503Z
Answers.UserDisplayName: Luke Holder
Body: <p>Folks:</p>
  
  <p>I'm having trouble getting my head around friendly order numbers and sequencing. The client has asked for his sequence to start at 11 000.</p>
  
  <p>I can set up a sequence that starts at 1 based on the docs. I can get this to show on the email receipt. What I'd like to know:</p>
  
  <p>How can I get this to start at 11000 and be sure it rolls over to 12000 when orders hit that number?</p>
  
  <p>I'm guessing that whatever the code winds up being, it's set in the "Order Reference Number Format" field, correct?</p>
  
Tags: <plugin-craftcommerce>
Title: Friendly order number - start sequence at specific number
ThreadText: # Friendly order number - start sequence at specific number
  
  (Asked by: username_0 on 2020-04-08)
  
  Folks:
  
  I'm having trouble getting my head around friendly order numbers and sequencing. The client has asked for his sequence to start at 11 000.
  
  I can set up a sequence that starts at 1 based on the docs. I can get this to show on the email receipt. What I'd like to know:
  
  How can I get this to start at 11000 and be sure it rolls over to 12000 when orders hit that number?
  
  I'm guessing that whatever the code winds up being, it's set in the "Order Reference Number Format" field, correct?
  
  **Tags:** plugin-craftcommerce
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-04-08. Score: 3 | Accepted answer
  
  Once you have created the sequence (starting at 1) with your sequence key/id you can manually reset/update the number in the `craft_sequences` table in the `next` column. Obviously if you reset the number, you could get duplicate order reference numbers though if you are not careful.
  
  Alternatively, you could just let the sequence start at `1` and use twig to add 11000 to the sequence number within the Order Reference Number Format.
  
  Your Order Reference Number Format would look like this: `11000+seq('mySeqId')`
  
  
  ---
  
  