Invoice numbering system

  • Posts: 8
  • Thank you received: 0
9 years 10 months ago #187968

-- url of the page with the problem -- : schmuckiversum.de
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6

Dear Hikashop Team,

I am using Hikashop Essential for a client and at the moment he is running into problems concerning the numbering of the invoices. Hikashop seems to generate them randomly (we have J8, H3, G6 and similar numbers) and not continuos (like 001, 002, 003 and so on).

In Germany the finance office seems to be a but stubborn when it comes to invoice numbers, so is there way to make the invoice numbers continous?

Thanks alot,
best regards,

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 10 months ago #187973

Hi,

The order number or the invoice number are not random at all ; they are base on the "order id" and "invoice id" which are sequential numbers.
Please see our documentation for the order (and invoice) number format
www.hikashop.com/support/support/documen...nfig.html#main_order

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: Tormentor667

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

  • Posts: 8
  • Thank you received: 0
9 years 9 months ago #188297

Thanks, everything is so much easier when you know where to look :)

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

  • Posts: 33
  • Thank you received: 0
9 years 7 months ago #199664

This post is very helpful, however I need to start the sequential numbering at 4000. Is there a way to do that?

so it would be 4000, 4001, 4002, etc and would need to roll over to 4999, 5000

Can this be done?

thx

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

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
9 years 7 months ago #199706

Hi,

If you're talking about the order id ( for the tag {order_id} ), you can just change the auto_increment value of the hikashop_order table to 3999 and next order will have its order id at 4000:
www.hikashop.com/forum/4-how-to/7820-spe...at.html?lang=en#7825
If you're talking about the invoice id ( for the tag {order_invoice_id} ), you can create a first dummy order and change its order_invoice_id in the hikahop_order table to 3999 via phpmyadmin and next confirmed order will have its invoice at 4000.

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

Time to create page: 0.053 seconds
Powered by Kunena Forum