[Skip to main content](#vessel-content) # How to change next invoice number? ## - **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")** - [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author - [ Offline](/forum/user/23273-oloccina) Less More - Posts: 224 - Thank you received: 8 - - 7 years 9 months ago [\#302147](#302147) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") *[How to change next invoice number?](/forum/35-orders-management/896576-how-to-change-next-invoice-number#302147 "Hello, my invoices numbers reset every year, but I need to change the next invoice number that will be generated in phpmyadmin for my last invoice I see order_invoice_id: 4 order_invoice_number: 4 - 2019 see nimb.ws/CWYOcj should I just change this order_invoice_id value eg. to 10 if I want the next invoice number to be 11 ? Thank you")* was created by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")* Hello, my invoices numbers reset every year, but I need to change the next invoice number that will be generated in phpmyadmin for my last invoice I see order_invoice_id: 4 order_invoice_number: 4 - 2019 see [ nimb.ws/CWYOcj](http://nimb.ws/CWYOcj) should I just change this *order\_invoice\_id* value eg. to 10 if I want the next invoice number to be 11 ? Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NjU3Ni1ob3ctdG8tY2hhbmdlLW5leHQtaW52b2ljZS1udW1iZXI/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86295 - Thank you received: 14273 - - 7 years 9 months ago [\#302148](#302148) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to change next invoice number?](/forum/35-orders-management/896576-how-to-change-next-invoice-number#302148 "Hello, my invoices numbers reset every year, but I need to change the next invoice number that will be generated in phpmyadmin for my last invoice I see order_invoice_id: 4 order_invoice_number: 4 - 2019 see nimb.ws/CWYOcj should I just change this order_invoice_id value eg. to 10 if I want the next invoice number to be 11 ? Thank you")* Hi, Yes, you need to change the last order_invoice_id of the current year with the value you want minus 1 so that the next order will get the value you want. If you don't have yet any order with an order_invoice_id in the current year, you would need to create an empty order from the backend and confirm it so that it would generate the order_invoice_id and then change the value of the order_invoice_id for that order. The following user(s) said Thank You: [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NjU3Ni1ob3ctdG8tY2hhbmdlLW5leHQtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")** - [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author - [ Offline](/forum/user/23273-oloccina) Less More - Posts: 224 - Thank you received: 8 - - 7 years 9 months ago [\#302188](#302188) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") Replied by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")* on topic *[How to change next invoice number?](/forum/35-orders-management/896576-how-to-change-next-invoice-number#302188 "Hello, my invoices numbers reset every year, but I need to change the next invoice number that will be generated in phpmyadmin for my last invoice I see order_invoice_id: 4 order_invoice_number: 4 - 2019 see nimb.ws/CWYOcj should I just change this order_invoice_id value eg. to 10 if I want the next invoice number to be 11 ? Thank you")* I have already some invoices for 2019, but I want the next one to start from 1 again (without deleting the existing orders for 2019) Is it ok if I set to " 0 " all the order_invoice_id values for these invoices? see: [ nimb.ws/dEg5Ko](http://nimb.ws/dEg5Ko) Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NjU3Ni1ob3ctdG8tY2hhbmdlLW5leHQtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 7 years 9 months ago [\#302197](#302197) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[How to change next invoice number?](/forum/35-orders-management/896576-how-to-change-next-invoice-number#302197 "Hello, my invoices numbers reset every year, but I need to change the next invoice number that will be generated in phpmyadmin for my last invoice I see order_invoice_id: 4 order_invoice_number: 4 - 2019 see nimb.ws/CWYOcj should I just change this order_invoice_id value eg. to 10 if I want the next invoice number to be 11 ? Thank you")* Hello, Yes and no. Yes you can put the value that you want in the database ; but since you must have invoice ID and invoice number for them, the best is to give them real values. Otherwise you will have several orders with the same invoice id or invoice number. So best would be to set "1,2,3,4,5' for these orders, according to their invoice numbers. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NjU3Ni1ob3ctdG8tY2hhbmdlLW5leHQtaW52b2ljZS1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")** - [![oloccina's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar23273.jpg)](/forum/user/23273-oloccina "View oloccina's Profile") Topic Author - [ Offline](/forum/user/23273-oloccina) Less More - Posts: 224 - Thank you received: 8 - - 7 years 9 months ago [\#302226](#302226) by [oloccina](/forum/user/23273-oloccina "View oloccina's Profile") Replied by *[oloccina](/forum/user/23273-oloccina "View oloccina's Profile")* on topic *[How to change next invoice number?](/forum/35-orders-management/896576-how-to-change-next-invoice-number#302226 "Hello, my invoices numbers reset every year, but I need to change the next invoice number that will be generated in phpmyadmin for my last invoice I see order_invoice_id: 4 order_invoice_number: 4 - 2019 see nimb.ws/CWYOcj should I just change this order_invoice_id value eg. to 10 if I want the next invoice number to be 11 ? Thank you")* > Otherwise you will have several orders with the same invoice id or invoice number. I don't really care. These order invoices have already been processed in 2018. I just need the next invoice to be numbered 1. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NjU3Ni1ob3ctdG8tY2hhbmdlLW5leHQtaW52b2ljZS1udW1iZXI/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86295 - Thank you received: 14273 - - 7 years 9 months ago [\#302227](#302227) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to change next invoice number?](/forum/35-orders-management/896576-how-to-change-next-invoice-number#302227 "Hello, my invoices numbers reset every year, but I need to change the next invoice number that will be generated in phpmyadmin for my last invoice I see order_invoice_id: 4 order_invoice_number: 4 - 2019 see nimb.ws/CWYOcj should I just change this order_invoice_id value eg. to 10 if I want the next invoice number to be 11 ? Thank you")* Hi, Then, yes, set their order_invoice_id to 0 and the next order will have its invoice id set to 1. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NjU3Ni1ob3ctdG8tY2hhbmdlLW5leHQtaW52b2ljZS1udW1iZXI/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.120 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)