change invoice number

  • Posts: 19
  • Thank you received: 1
  • Hikashop Business
2 weeks 2 days ago #364286

-- url of the page with the problem -- : www.ubuntushop.biz
-- HikaShop version -- : 5.1.1
-- Joomla version -- : 5.1
-- PHP version -- : 8.3

i am still trying to change the invoice numers (coming from j2store). I can chnge them with mass action, but the next invoice number is again the old folow number.
Need simple howto

Attachments:

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

  • Posts: 19
  • Thank you received: 1
  • Hikashop Business
2 weeks 2 days ago #364287

my latest invoice numer in j2store was FA-907
so hikashop should continue with FA-908

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

  • Posts: 19
  • Thank you received: 1
  • Hikashop Business
2 weeks 2 days ago #364291

this the data from mariadb.
What to change?

Attachments:

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

  • Posts: 82823
  • Thank you received: 13370
  • MODERATOR
2 weeks 2 days ago #364303

Hi,

First, note that the format of the invoice number can be tweaked with the "Invoice number format" setting of the Hikashop configuration page:
www.hikashop.com/support/documentation/5...nfig.html#main_order
Supposing that you use {id} or {order_invoice_id} in the format, it means that the system will use the "order_invoice_id" value as base for the invoice number.
For example, if you have the format FA-{id}, and the order_invoice_id is 908, then, the invoice number will be FA-908
And regarding the order_invoice_id, to generate the next one, the system takes the biggest one among all the orders already in the database, and increment the value.
So, if you want the next order_invoice_id to be 908, you should make sure that no existing order has an order_invoice_id greater than 907 and that at least one order has an order_invoice_id set as 907.

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

  • Posts: 19
  • Thank you received: 1
  • Hikashop Business
2 weeks 1 day ago #364312

no, i do not understand. How to set next order_invoice_id or order_id?
Also, if i manual create an order, the id is FA-0025.
If I delete this order, and again make new order, the id is FA-0026
Should this be again FA-0025?

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

  • Posts: 4738
  • Thank you received: 644
  • MODERATOR
2 weeks 1 day ago #364313

Hello,

Nicolas, point you to these 2 settings which allows you to model your order number & the invoice number, here :
in HikaShop Configuration, then Main tab, and Order part



And about your question around order (or any element id) for managemenet purpose each command have to keep is own references, or it will leads to a lot of issue in your database.

Regards

Last edit: 2 weeks 1 day ago by Philip.

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

Time to create page: 0.076 seconds
Powered by Kunena Forum