Developer forum

Forum » Ecommerce - Standard features » Start new Order number

Start new Order number

E-mail notifications
Per Søgaard
Reply
Posted on 25/08/2015 10:42:00

We have made a copy of a ecom website for redesign.
Now it is ready for launch but order numbers on the online site have surpassed the copied site and quickpay will not accept orders since the order number has already been used.

Hov can we set the order number on the new site to start at a new number - continuing the order numbers from the old live site?


Replies

 
Kim Søjborg Pedersen
Posted on 25/08/2015 10:53:09
Reply
This post has been marked as an answer

Hi Per,
Have you looked at Management Center - Ecommerce - Advanced configuration - Auto-numbering ? and then you maybe need to set it in the database so it continues from the right number.

Votes for this answer: 1
 
Per Søgaard
Posted on 25/08/2015 11:26:41
Reply

Yes I have. It does not seem to be possible to change it - or I cant figure out how....?

 
Nicolai Høeg Pedersen
Posted on 26/08/2015 13:55:27
Reply
This post has been marked as an answer

In MC, Database, SQL Firehose fire this one:

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

Votes for this answer: 1
 
Per Søgaard
Posted on 26/08/2015 15:22:08
Reply

So if want keep all existing order number and start the new Ordernumbers from Order1200 i fire: 1200 instead of 1 ?

 

 
Nicolai Høeg Pedersen
Posted on 26/08/2015 16:35:08
Reply

Yes!

 
Per Søgaard
Posted on 26/08/2015 16:59:12
Reply

Changing the prefix i guess will also solve the problem?

 
Nicolai Høeg Pedersen
Posted on 26/08/2015 18:27:58
Reply

Yes

 
Michael Fløe Haug
Posted on 09/10/2017 11:48:05
Reply

Hi Nicolai,

Is this still awailable in DW9?

I also want to manipulate recurring order prefix and recurring order numbercounter. Can I do that - if yes how?

Thanks in advance
Michael

 
Michael Fløe Haug
Posted on 09/10/2017 12:38:47
Reply

I get the error message;

"The following exception message was returned by the server: A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause."

If I try it in DW9.

 
Morten Bengtson Dynamicweb Employee
Morten Bengtson
Posted on 09/10/2017 13:05:23
Reply

Hi Michael,

You can change the auto-numbering settings for recurring orders like this...

UPDATE EcomNumbers 
SET NumberCounter = 0, NumberPrefix = 'SomeCustomPrefix' 
OUTPUT inserted.*
WHERE NumberType = 'REC'

 
Michael Fløe Haug
Posted on 09/10/2017 15:22:20
Reply

Hi Morten

Nothing happens when I make the firehose...

UPDATE EcomNumbers SET NumberCounter = 1001, NumberPrefix = 'ABN' OUTPUT inserted.* WHERE NumberType = 'REC'

or

UPDATE EcomNumbers SET NumberCounter = 100001 OUTPUT inserted.* WHERE NumberType = 'ORDER'

...

Michael

 
Nicolai Pedersen
Posted on 09/10/2017 15:42:47
Reply

I think it is the bug in the SQL firehose, TFS#40062, fixed for 9.3.5 that causes this.

 
Michael Fløe Haug
Posted on 10/10/2017 08:11:30
Reply
Original message by Nicolai Pedersen posted on 10/9/2017 3:42:47 PM:

I think it is the bug in the SQL firehose, TFS#40062, fixed for 9.3.5 that causes this.

Is it possible that you could change the database on the solution for me - my customer is not keen on waiting for it?

 
Nicolai Pedersen
Posted on 10/10/2017 08:54:10
Reply

Sent this to service desk to help you out.

 

You must be logged in to post in the forum