Order numbers out of sync

Start
Prev
1
Next
End

MumsHealth
Topic Author
Offline

Posts: 67
Thank you received: 8
Hikashop Business

1 year 6 months ago #345863

-- HikaShop version -- : 4.6.2
-- Joomla version -- : ‎3.10

Hello,

We have our Order number format and Invoice number format both set to W{id} so the order and invoice number are the same.

Recently an employee accidentally created an order and then deleted it now the invoice id is always 1 lower than the order id.

For example:
Order number: W600
Invoice number: W599
ID: 600

Why is this the case if we are using W{id} as the format for both? Shouldn't this match the orders ID column?

Thanks,
Nathan

Please Log in or Create an account to join the conversation.

nicolas
Online

Posts: 81515
Thank you received: 13069
MODERATOR

1 year 6 months ago #345865

Hi,

{id} means {order_id} for the "order number format" and {order_invoice_id} for the "invoice number format".
The order_id is incremented when a new order is created.
The order_invoice_id is incremented when an order is confirmed (usually after a payment).
So if an order is created but not confirmed, the order_id will be incremented but not the order_invoice_id and thus if you use {id} for both formats you'll get a discrepency.
If you want the invoice number format setting to use the order_id, then you need to use {order_id} instead of {id}

Last edit: 1 year 6 months ago by nicolas.

Please Log in or Create an account to join the conversation.

MumsHealth
Topic Author
Offline

Posts: 67
Thank you received: 8
Hikashop Business

1 year 6 months ago #345886

Thank you very much. That makes sense.
Is there any risk to changing order/invoice number format now? Will it change old old orders or just the future ones?

Please Log in or Create an account to join the conversation.