Change the invoice number

  • Posts: 16
  • Thank you received: 0
12 years 4 months ago #56350

HI,
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
12 years 4 months ago #56375

Hello,

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.

  • Posts: 16
  • Thank you received: 0
12 years 4 months ago #56392

Thanks for your response. I understand how to change the format of the invoice number.

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.

  • Posts: 82820
  • Thank you received: 13366
  • MODERATOR
12 years 4 months ago #56467

You can run a simple query via the SQL tab of your phpmyadmin :
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.

  • Posts: 16
  • Thank you received: 0
12 years 4 months ago #56508

Thanks Nicolas.

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

  • Posts: 3
  • Thank you received: 0
12 years 3 months ago #58239

YMMV, but this [ For example, {id size="5"} will result in 00123 for the order with the id 123.] doesn't work for me - I just tried it, and the shop simply puts that string (I've got {id size="5"}" (when I used the suggested string) and {id size=5} into both the web page order process, and in the subject of the email that the system sent me as a result of each order.

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.

  • Posts: 82820
  • Thank you received: 13366
  • MODERATOR
12 years 3 months ago #58241

That's a bug actually.

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.

Attachments:
The following user(s) said Thank You: derekrv

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

Time to create page: 0.081 seconds
Powered by Kunena Forum