Cart Number vs. Order Number vs. Invoice Number

[Kurt Moskjaer Anders]

One of our clients have a problem with cart number, order number and invoice number not matching each other, which makes it very frustrating for their customers.

 

Is it possible to have these numbers aligned?

 

Thanks in advance

[bellini13]

the order number and the invoice number will be the same, the only difference is the invoice has a prefix.

so if the order number is 000035, then the invoice will be IN000035.

 

the cart number will be different, because not every cart becomes an order. so the cart number always increases much faster then order numbers.

[Kurt Moskjaer Anders]

Thank you for your response.

 

The reason I am asking, is because our client have a problem with the order number and invoice number not being the same, even though we have changed the start number for the invoice in order for them to match.

 

I don't know what could be the problem here.

[SpottedSparrow]

I have the same problem. The invoice number is definitely not always the same as the order number. It is different on more than 50% of my orders.

[bellini13]

sounds like at some point the invoice number was then changed using the back office (perhaps database update). or perhaps orders were deleted, but their invoices were not, and so the ranges got out of sync

[SpottedSparrow]

The real problem is that there is nothing in the back office to change the order number. Changing the invoice number, delivery slip number, etc. doesn't do much good if the order number always starts at 1 and cannot be changed.

[bellini13]

you can do it using phpmyadmin, you cannot do it from the back office.

http://www.prestashop.com/forums/topic/7478-how-to-info-change-starting-order-numbers/

[tomerg3]

The number are not the same, and for a reason.

 

1) Not every cart turns into an order - someone may create a cart, not complete the order, and then try it again from another browser / computer, and the old cart will still appear in the system, but will never get used.

 

2) Not every order has an invoice.

Only when an order is approved, an invoice is created, if you have an order status of "Awaiting check" an invoice will not be generated yet, and if a new order comes in with an "approved" status, it will generate the next invoice #

[Bazze]

Just as tomerg3 says. Depending on what order state is set, an invoice or delivery slip will not be generated.

 

A way to solve this could be to create a new order state for which an invoice and delivery slip will be generated for. Then create a custom module just including the the mandatory functions and a hook for the hook newOrder. In this hook you could change the order state to the custom order state you created earlier. This means that all new orders will get your custom state (and an invoice and delivery will be slip will be generated) and directly after get the correct order state since there is an order state change directly after the newOrder hook is called. Important to point out is that you do this when you first set up your shop or if you edit the AUTO_INCREMENT value in your database for the concerned tables.

[NewIntern]

my delivery slip number is different with the delivery number i have set in the back office. Anyone can help?

[lozal2244]

Hi, I did a module to have a diferent invoice number when you have the feature multistore enabled.

 

http://addons.prestashop.com/es/facturacion-contabilidad-modulos-prestashop/17583-numeros-de-factura-diferentes-por-cada-multi-tienda.html