Invoice number reset (new year)

Hi,

This won't work. In the "invoice number format", you have the "order_id" tag instead of "id" or "order_invoice_id". What the "invoice numver reset frequency" resets is actually the order_invoice_id, the order_id is never reset.
So you would have to change the format to use id or order_invoice_id.
Note however that when you do, your new orders' invoice number will probably not match with the previous ones. To avoid that, you would have to modify the order_invoice_id of the last order in the hikashop_order table via your phpmyadmin and set it to the order_id value of that last order. That way, for the next order, it will automatically use the the same id/number as it would have if basing itself on the order_id.

Hi,

The change I was talking in the hikashop_order is only if you have a discrepency in the numbering (the format itself won't be a problem), but it might not be the case, or you might not care about it.
So if the result is ok for you like that, then no need to change the database.

Hi,

If you want to change the invoice ids and numbers, you can either open the hikashop_order table via your phpmyadmin and change the values of each order manually, or you can do that with a "display the results" action on the order data and select the columns you want to see/change via the menu System>Mass actions.
Once you finish the changes, make sure that you configured the "Invoice number reset frequency" setting to "every year", otherwise, it will continue with 01632019 instead of picking up the new numbering of 2019.

Hi,

Yes, it's exactly that. If you change cells in the results table and validate it will update the database, as if you were doing it from phpmyadmin.
Note that it's not only 01632019 that you need to change. You need to change all the invoice ids and numbers created since the beginning of the year. Only after that will it be able to pick up from there. That's because the system works like that:
When an order is confirmed, it will load the highest invoice id amongst all the orders created since the beginning of the year and increment that value to set it as the invoice id of that newly confirmed order.

Hi,

If you get zeros, it means that these orders were never confirmed and went straight from created to cancelled. Thus, no invoice number was generated for them so you can ignore them.