- Posts: 16
- Thank you received: 0
Change the invoice number
- rossdesigns
-
Topic Author
- Offline
I will soon be going live on my Hikashop site. I currently have a website which people buy my product from.
I want to change the invoice number that Hikashop issues for the next invoice to be inline with the last invoice from my current site, approx 188.
Request you advise where I can change the invoice number Hikashop will issue next.
Thanks.
Please Log in or Create an account to join the conversation.
- Posts: 12953
- Thank you received: 1778
I think that you'll maybe find your answer there
Order number format : This option enables you to set the format of order numbers. It is only available in commercial versions of HikaShop. By default, the order number uses letters and numbers interleaved together. this is represented here with the tag {automatic_code}. If you want to use the order number directly, you can use the tag {id}. In the tag id, you can specify the number of numbers with the size attribute. For example, {id size="5"} will result in 00123 for the order with the id 123. You can also use the date tag in order to insert date information. For example, {date format="m/Y"} will result in 02/11 for an order made in February 2011. You can combine them to generate pretty advanced order numbers like the format RE-{id size="5"}/{date format="m/Y"} used for German accounting which will result in RE-00123/02/11 for the order 123 made on February 2011.
Please Log in or Create an account to join the conversation.
- rossdesigns
-
Topic Author
- Offline
- Posts: 16
- Thank you received: 0
What I want to do is change the actual invoice number. I'm just using a four digit number and am up to invoice number 0022 after testing the site. I now want to change the invoice number so that the next invoice number issued is 0188.
I was hoping there is somewhere that I can change this number rather than make up a lot of practice invoices to get up to 0188.
Thanks,
Geoff
Please Log in or Create an account to join the conversation.
ALTER TABLE jos_hikashop_order AUTO_INCREMENT = 188;
Note that jos_ will have to be changed to the table prefix you're using on your website.
Please Log in or Create an account to join the conversation.
- rossdesigns
-
Topic Author
- Offline
- Posts: 16
- Thank you received: 0
Please Log in or Create an account to join the conversation.
I can (and will) live without the leading zeros, but someone needs to change the documentation....
Please Log in or Create an account to join the conversation.
If you replace administrator\components\com_hikashop\classes\config.php with the file in the archive enclosed, it will fix the problem.
That fix will be in next version of HikaShop.
Please Log in or Create an account to join the conversation.