[Skip to main content](#vessel-content) # Is it possible to change the order number? ## - **[bg46250](/forum/user/652-bg46250 "View bg46250's Profile")** - [![bg46250's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/652-bg46250 "View bg46250's Profile") Topic Author - [ Offline](/forum/user/652-bg46250) Less More - Posts: 3 - Thank you received: 0 - - 15 years 9 months ago [\#4775](#4775) by [bg46250](/forum/user/652-bg46250 "View bg46250's Profile") *[Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#4775 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* was created by *[bg46250](/forum/user/652-bg46250 "View bg46250's Profile")* I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 15 years 9 months ago [\#4776](#4776) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#4776 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* Hi, You can increment the order id following that post: [ www.hikashop.com/en/support/forum/4-how-...mer-order-.html#2144](http://www.hikashop.com/en/support/forum/4-how-to/2142-change-customer-order-.html#2144) If you want to change the order number format, you can use the option "order number format" in the configuration. You can read more about that option in the documentation: [ www.hikashop.com/support/documentation/5...hop-config.html#main](http://www.hikashop.com/support/documentation/54-hikashop-config.html#main) This option is only available in the commercial versions of hikashop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bg46250](/forum/user/652-bg46250 "View bg46250's Profile")** - [![bg46250's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/652-bg46250 "View bg46250's Profile") Topic Author - [ Offline](/forum/user/652-bg46250) Less More - Posts: 3 - Thank you received: 0 - - 15 years 9 months ago [\#4777](#4777) by [bg46250](/forum/user/652-bg46250 "View bg46250's Profile") Replied by *[bg46250](/forum/user/652-bg46250 "View bg46250's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#4777 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* HOLY CRAP THAT WAS FAST!!! (caps intended) Thank you! Why can't every product have support like this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bg46250](/forum/user/652-bg46250 "View bg46250's Profile")** - [![bg46250's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/652-bg46250 "View bg46250's Profile") Topic Author - [ Offline](/forum/user/652-bg46250) Less More - Posts: 3 - Thank you received: 0 - - 15 years 9 months ago [\#4781](#4781) by [bg46250](/forum/user/652-bg46250 "View bg46250's Profile") Replied by *[bg46250](/forum/user/652-bg46250 "View bg46250's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#4781 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* AWESOME! Worked like a charm! Thanks again! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[adoewa](/forum/user/3502-adoewa "View adoewa's Profile")** - [![adoewa's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar3502.png)](/forum/user/3502-adoewa "View adoewa's Profile") - [ Offline](/forum/user/3502-adoewa) Less More - Posts: 35 - Thank you received: 0 - - - - [](http://www.adoewa.be) - 15 years 1 month ago [\#24612](#24612) by [adoewa](/forum/user/3502-adoewa "View adoewa's Profile") Replied by *[adoewa](/forum/user/3502-adoewa "View adoewa's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#24612 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* Nicolas, How can i reset this autonumber. For testing i created some orders, but now the site is online and we want to start from 001. Koen Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 15 years 1 month ago [\#24622](#24622) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#24622 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* You need to go in phpmyadmin and edit the tables hikashop_order and hikashop_order_product and truncate the tables. That will reset the auto increment to 1 and remove all your orders. The following user(s) said Thank You: [raeiken](/forum/user/31042-raeiken "View raeiken's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[adoewa](/forum/user/3502-adoewa "View adoewa's Profile")** - [![adoewa's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar3502.png)](/forum/user/3502-adoewa "View adoewa's Profile") - [ Offline](/forum/user/3502-adoewa) Less More - Posts: 35 - Thank you received: 0 - - - - [](http://www.adoewa.be) - 15 years 1 month ago [\#24864](#24864) by [adoewa](/forum/user/3502-adoewa "View adoewa's Profile") Replied by *[adoewa](/forum/user/3502-adoewa "View adoewa's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#24864 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* Nicolas.... What do you mean with truncate? Koen Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 15 years 1 month ago [\#24870](#24870) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#24870 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* I mean to run the truncate table query. Here is a video tutorial on that: [ www.youtube.com/watch?v=ZC0PcJKTXTY](http://www.youtube.com/watch?v=ZC0PcJKTXTY) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[alin](/forum/user/51267-alin "View alin's Profile")** - [![alin's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar51267.png)](/forum/user/51267-alin "View alin's Profile") - [ Offline](/forum/user/51267-alin) Less More - Posts: 117 - Thank you received: 6 - - 9 years 3 months ago [\#273804](#273804) by [alin](/forum/user/51267-alin "View alin's Profile") Replied by *[alin](/forum/user/51267-alin "View alin's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#273804 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* Hello! Tell me please do I need to clean hikashop_history table too? --- Sorry for my English, it's not my native language. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 9 years 3 months ago [\#273869](#273869) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Is it possible to change the order number?](/forum/4-how-to/4775-is-it-possible-to-change-the-order-number#273869 "I just installed this wonderful little trinket of goodness and have almost everything figured out. Thanks for the ease of use! However, I would like to change the order number to a six digit code. Is that possible? I'm just concerned that my customers will see A1, B2, C3, D4 and think, what the heck is that and then reconsider their purchase. Thanks in advance, Bryan")* Hi, If you truncate the hikashop_order and hikashop_order_product tables, then yes, you also want to truncate hikashop_history table. The following user(s) said Thank You: [alin](/forum/user/51267-alin "View alin's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3NzUtaXMtaXQtcG9zc2libGUtdG8tY2hhbmdlLXRoZS1vcmRlci1udW1iZXI/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.378 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)