[Skip to main content](#vessel-content) # Change the invoice number ## - **[rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile")** - [![rossdesigns's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7055-rossdesigns "View rossdesigns's Profile") Topic Author - [ Offline](/forum/user/7055-rossdesigns) Less More - Posts: 16 - Thank you received: 0 - - 14 years 4 months ago [\#56350](#56350) by [rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile") *[Change the invoice number](/forum/4-how-to/56350-change-the-invoice-number#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.")* was created by *[rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MzUwLWNoYW5nZS10aGUtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 14 years 4 months ago [\#56375](#56375) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Re: Change the invoice number](/forum/4-how-to/56350-change-the-invoice-number#56375 "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.")* Hello, I think that you'll maybe find your answer [ there](http://www.hikashop.com/fr/forum/4-how-to/42227-how-to-change-order-number-invoice-number.html) > 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MzUwLWNoYW5nZS10aGUtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile")** - [![rossdesigns's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7055-rossdesigns "View rossdesigns's Profile") Topic Author - [ Offline](/forum/user/7055-rossdesigns) Less More - Posts: 16 - Thank you received: 0 - - 14 years 4 months ago [\#56392](#56392) by [rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile") Replied by *[rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile")* on topic *[Re: Change the invoice number](/forum/4-how-to/56350-change-the-invoice-number#56392 "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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MzUwLWNoYW5nZS10aGUtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 14 years 4 months ago [\#56467](#56467) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Change the invoice number](/forum/4-how-to/56350-change-the-invoice-number#56467 "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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MzUwLWNoYW5nZS10aGUtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile")** - [![rossdesigns's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7055-rossdesigns "View rossdesigns's Profile") Topic Author - [ Offline](/forum/user/7055-rossdesigns) Less More - Posts: 16 - Thank you received: 0 - - 14 years 4 months ago [\#56508](#56508) by [rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile") Replied by *[rossdesigns](/forum/user/7055-rossdesigns "View rossdesigns's Profile")* on topic *[Re: Change the invoice number](/forum/4-how-to/56350-change-the-invoice-number#56508 "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.")* Thanks Nicolas. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MzUwLWNoYW5nZS10aGUtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[derekrv](/forum/user/8266-derekrv "View derekrv's Profile")** - [![derekrv's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8266-derekrv "View derekrv's Profile") - [ Offline](/forum/user/8266-derekrv) Less More - Posts: 3 - Thank you received: 0 - - 14 years 3 months ago [\#58239](#58239) by [derekrv](/forum/user/8266-derekrv "View derekrv's Profile") Replied by *[derekrv](/forum/user/8266-derekrv "View derekrv's Profile")* on topic *[Re: Change the invoice number](/forum/4-how-to/56350-change-the-invoice-number#58239 "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.")* 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&quot}" (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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MzUwLWNoYW5nZS10aGUtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 14 years 3 months ago [\#58241](#58241) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Change the invoice number](/forum/4-how-to/56350-change-the-invoice-number#58241 "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.")* 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. The following user(s) said Thank You: [derekrv](/forum/user/8266-derekrv "View derekrv's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MzUwLWNoYW5nZS10aGUtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.065 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)