[Skip to main content](#vessel-content) # Long order number ## - **[afrttoh](/forum/user/4801-afrttoh "View afrttoh's Profile")** - [![afrttoh's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4801-afrttoh "View afrttoh's Profile") Topic Author - [ Offline](/forum/user/4801-afrttoh) Less More - Posts: 12 - Thank you received: 0 - - 14 years 10 months ago [\#33743](#33743) by [afrttoh](/forum/user/4801-afrttoh "View afrttoh's Profile") *[Long order number](/forum/4-how-to/33743-long-order-number#33743 "how can i make the order number longer insted of B1 somthing like B156456 ?")* was created by *[afrttoh](/forum/user/4801-afrttoh "View afrttoh's Profile")* how can i make the order number longer insted of B1 somthing like B156456 ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMzNzQzLWxvbmctb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) 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: 86359 - Thank you received: 14293 - - 14 years 10 months ago [\#33744](#33744) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Long order number](/forum/4-how-to/33743-long-order-number#33744 "how can i make the order number longer insted of B1 somthing like B156456 ?")* You need to go in your phpmyadmin and change the auto increment value of the jos_hikashop_order table by running a query like that: ALTER TABLE jos_hikashop_order AUTO_INCREMENT = 156456; Then, new orders will have their ID using 156456 and not 1 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMzNzQzLWxvbmctb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[afrttoh](/forum/user/4801-afrttoh "View afrttoh's Profile")** - [![afrttoh's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4801-afrttoh "View afrttoh's Profile") Topic Author - [ Offline](/forum/user/4801-afrttoh) Less More - Posts: 12 - Thank you received: 0 - - 14 years 10 months ago - 14 years 10 months ago [\#33745](#33745) by [afrttoh](/forum/user/4801-afrttoh "View afrttoh's Profile") Replied by *[afrttoh](/forum/user/4801-afrttoh "View afrttoh's Profile")* on topic *[Re: Long order number](/forum/4-how-to/33743-long-order-number#33745 "how can i make the order number longer insted of B1 somthing like B156456 ?")* that worked, thanks a lot. but for me was ALTER TABLE fewcn_hikashop_order AUTO_INCREMENT = 156456; Last edit: 14 years 10 months ago by [afrttoh](/forum/user/4801-afrttoh "View afrttoh's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMzNzQzLWxvbmctb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[obsolum](/forum/user/5383-obsolum "View obsolum's Profile")** - [![obsolum's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5383.png)](/forum/user/5383-obsolum "View obsolum's Profile") - [ Offline](/forum/user/5383-obsolum) Less More - Posts: 50 - Thank you received: 2 - - 14 years 9 months ago [\#36403](#36403) by [obsolum](/forum/user/5383-obsolum "View obsolum's Profile") Replied by *[obsolum](/forum/user/5383-obsolum "View obsolum's Profile")* on topic *[Re: Long order number](/forum/4-how-to/33743-long-order-number#36403 "how can i make the order number longer insted of B1 somthing like B156456 ?")* Hi, I'm not sure if this is the right topic to ask but I think my question is related. I upgraded to the Business version today (as a different user) and I'd like to use a custom order number format. However, I'm not sure if this can be done. What I'd like is for example: MYD-120135 where the 'MYD-' is static (the initials of the website name), '12' is the year, '01' the month and then '35' is a number that increments with each order. Is that possible? I know my way around MySQL databases so if I can solve it with a query or something then that'll work. I just need to know what I need to change exactly. Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMzNzQzLWxvbmctb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) 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: 86359 - Thank you received: 14293 - - 14 years 9 months ago [\#36443](#36443) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Long order number](/forum/4-how-to/33743-long-order-number#36443 "how can i make the order number longer insted of B1 somthing like B156456 ?")* Hi, You can do that by setting this format in the "Order number format" option of the configuration of HikaShop: MYD-{date format="ym"}{id} Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMzNzQzLWxvbmctb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[obsolum](/forum/user/5383-obsolum "View obsolum's Profile")** - [![obsolum's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5383.png)](/forum/user/5383-obsolum "View obsolum's Profile") - [ Offline](/forum/user/5383-obsolum) Less More - Posts: 50 - Thank you received: 2 - - 14 years 9 months ago [\#36478](#36478) by [obsolum](/forum/user/5383-obsolum "View obsolum's Profile") Replied by *[obsolum](/forum/user/5383-obsolum "View obsolum's Profile")* on topic *[Re: Long order number](/forum/4-how-to/33743-long-order-number#36478 "how can i make the order number longer insted of B1 somthing like B156456 ?")* Terrific! Every time I ask a question here the answer is so simple I feel ridiculous for asking. Thanks again for a wonderful product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMzNzQzLWxvbmctb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) 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.062 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)