issue with invoice number vs order number

[adtastic]

The prestashop invoice number versus order number versus reference id is screwy as hell but even beyond that we are having an issue which we cannot figure out and need to find a way to fix or hack a better solution.

 

prestashop makes an order id which is a bunch of letters. then it also makes an order number which is... numbers. then it ALSO makes an invoice and subsequent invoice number.

 

So, a customer calls us and gives us an invoice number. we cannot look up the order by invoice number. there is no search field to look up an order by invoice number which is the first problem. having the customer dig out and find the bunch of letters of the reference number is cumbersome to them we can look by name but that is slower process. better to be able to simply plug in the invoice number since this is what the customer references. so this is the first problem which needs a solution.

Secondly, the invoice number is not the same as the order number. if it was that would solve our biggest problem. We even turned off invoices for a time so we could wait for the order number to catch up and we could change the next invoice number to match the next order number in order for the two to sync up because having them be the same number solves our problem on how we internally track orders outside of prestashop. But after a few weeks they are no longer synched again. DOES ANYONE KNOW WHY THEY WOULD GET OUT OF SYNC? We thought once it might have to do if we delete an order. Or maybe if we cancel an order. But seems this is not the reason. So why once these two are synced after a time they are out of sync again?

 

Personally, we'd like to do away with invoices altogether but we cannot. Because our internal system both for tracking, accounting and otherwise outside of prestashop compels us to need to print out each order. And it prints three pages long but if we print the invoice it is only one page so we are stuck using invoices for our tracking system.

 

But we need the invoice number to be the same as the order number always. How do we accomplish this?

personally if the invoice number was the same as the order number all would be fine, period.

[tdr170]

On the invoices tab you can set the next invoice # not sure why this happens but I have reset mine a couple of times.

[adtastic]

On the invoices tab you can set the next invoice # not sure why this happens but I have reset mine a couple of times.

 

yes, aware of this. however the problem is our current invoice number is 27596. Our current last order number is 27587. See the problem? We cannot set a new invoice number to coincide with the next order which would be 27588.

[tdr170]

OK so set the next order # in the database (ps_orders) to the same as the next invoice invoice do this by simply changing the auto_increment=27597.

This would at least get them back insync, strange as mine always seems to do the opposite invoice # falls behind.

 

I will have to do some testing at some point to see if I can find a cause.

Edited September 17, 2016 by tdr170 (see edit history)

[adtastic]

yes suppose that would work except it creates the issue of having a gap in between order numbers and somewhere down the line that might be a problem at least with respect to accounting.

[tdr170]

Not sure of any other choice at this point accounting will get over it when at least they start to match.