[Skip to main content](#vessel-content) # Reset invoice numbers ## - **[Gregory](/forum/user/7268-gregory "View Gregory's Profile")** - [![Gregory's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7268-gregory "View Gregory's Profile") Topic Author - [ Offline](/forum/user/7268-gregory) Less More - Posts: 12 - Thank you received: 1 - - - - 14 years 5 months ago [\#48716](#48716) by [Gregory](/forum/user/7268-gregory "View Gregory's Profile") *[Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#48716 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* was created by *[Gregory](/forum/user/7268-gregory "View Gregory's Profile")* Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance The following user(s) said Thank You: [klimmbimm](/forum/user/739-klimmbimm "View klimmbimm's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Gregory](/forum/user/7268-gregory "View Gregory's Profile")** - [![Gregory's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7268-gregory "View Gregory's Profile") Topic Author - [ Offline](/forum/user/7268-gregory) Less More - Posts: 12 - Thank you received: 1 - - - - 14 years 5 months ago [\#48724](#48724) by [Gregory](/forum/user/7268-gregory "View Gregory's Profile") Replied by *[Gregory](/forum/user/7268-gregory "View Gregory's Profile")* on topic *[Re: Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#48724 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* Nobody knows ?? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")** - [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") - [ Offline](/forum/user/6276-tony-10uk-net) Less More - Posts: 127 - Thank you received: 12 - - 14 years 5 months ago [\#48744](#48744) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Re: Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#48744 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* The support on this forum is excellent, but there aren't any SLAs for replies. ![:-)](/media/kunena/emoticons/9.png ":-)") I haven't got the system in front on me, but when I looked at the database a while ago, most of the IDs are mySQL auto increment attributes. I'm guessing this is where the order number comes from. You need to be absolutely sure that you have cleared down all your test orders and then reset the auto increment value directly in mysql against the correct table and attribute. There will be loads on google for how to do this with mySQL depending on how you access your DB. But I've never done this with HikaShop so attempt at your own risk and see if it does what you want. A backup first would be a good idea ![:-)](/media/kunena/emoticons/9.png ":-)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) 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 5 months ago [\#48751](#48751) 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: Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#48751 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* Hello, tony@10uk.net is right, you should clean your "hikashop_order" table with a "TRUNCATE TABLE" and delete all your test orders in your hikashop's backend. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")** - [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") - [ Offline](/forum/user/6276-tony-10uk-net) Less More - Posts: 127 - Thank you received: 12 - - 14 years 5 months ago [\#48759](#48759) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Re: Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#48759 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* Watch out with TRUNCATE TABLE if you replicate your database. Probably fixed now, but mySQL couple of years back used to get into a right mess with the replication. I prefer.. ALTER TABLE <table name> AUTO_INCREMENT = 1; And as ALTER TABLE is DDL, you will prob have to do same to the replication DB. If you don't replicate, then no worries. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Gregory](/forum/user/7268-gregory "View Gregory's Profile")** - [![Gregory's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7268-gregory "View Gregory's Profile") Topic Author - [ Offline](/forum/user/7268-gregory) Less More - Posts: 12 - Thank you received: 1 - - - - 14 years 5 months ago [\#48827](#48827) by [Gregory](/forum/user/7268-gregory "View Gregory's Profile") Replied by *[Gregory](/forum/user/7268-gregory "View Gregory's Profile")* on topic *[Re: Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#48827 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* Merci, ça marche Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[klimmbimm](/forum/user/739-klimmbimm "View klimmbimm's Profile")** - [![klimmbimm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/739-klimmbimm "View klimmbimm's Profile") - [ Offline](/forum/user/739-klimmbimm) Less More - Posts: 45 - Thank you received: 2 - - 14 years 5 months ago [\#50259](#50259) by [klimmbimm](/forum/user/739-klimmbimm "View klimmbimm's Profile") Replied by *[klimmbimm](/forum/user/739-klimmbimm "View klimmbimm's Profile")* on topic *[Re: Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#50259 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* > tony@10uk.net wrote: I prefer.. > ALTER TABLE <table name> AUTO\_INCREMENT = 1; Which tables did you exactely alter to reset the invoice numbers? Is it "hikashop_order" only? So first, I would delete all my invoices in the backend and then du the ALTER TABLE, right? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 14 years 5 months ago [\#50365](#50365) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Reset invoice numbers](/forum/4-how-to/48716-reset-invoice-numbers#50365 "Hi, I made a lot of test and of course, invoice number in now reaching 44. My website will be online tomorrow and I would like to reset invoice number to start again with number 1. How can I do this ? Thank you in advance")* Yes, it's only that hikashop_order table. That's indeed what you have to do. The following user(s) said Thank You: [klimmbimm](/forum/user/739-klimmbimm "View klimmbimm's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ4NzE2LXJlc2V0LWludm9pY2UtbnVtYmVycz90bXBsPW1hcmtkb3du) 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.301 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)