WHMCS 2 WHMCS utility change invoice numbers

[codemaster2008]

Here is what happened:

 

I got a brand new (clean) installation and set the payment gateways exactly as they were in the old installation. Everything was according to the utility documentation and it did copy all customers, products and transactions from the old installation to the new one.

 

The only problem is that it changed all invoice numbers and left me with two big problems:

 

1) The records won't match any printed invoice the customers may have.

2) The payment status on all orders are set to incomplete, once the invoice number in the order doesn't exist in the system.

 

Is it by design? That's terrible!

[WHMCS John]

The merge script is designed to merge two existing installations both containing data so it handles duplicate product and invoice IDs. It sounds like you just wanted to move your WHMCS install to a new location, which is totally different: http://docs.whmcs.com/Licensing

[codemaster2008]

Hi John,

 

Sorry but can you explain what you mean by "it handles duplicate product and invoice IDs"? I didn't get it.

So, does it change the invoice numbers or not when it merge the installations?

 

The link you provided didn't help but let's focus on my main question.

[WHMCS John]

Yes it does change the IDs because with the merge script you're supposed to be importing data into an installation which already contains products and invoices etc.

 

But as you weren't doing that you shouldn't used the Merge script, just backed up the existing database and restored it to the new location per the instructions I linked to.

[codemaster2008]

I see.

So here goes one sugestion:

Look for the invoice first and just change the ID if the same number already exist.

Another thing, if you are changing the number, add the old number to a note, so it becomes easier to track who is who.