[Skip to main content](#vessel-content)

#   Specific starting point order number format

##

- **[kwkness](/forum/user/1071-kwkness "View kwkness's Profile")**
- [![kwkness's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1071-kwkness "View kwkness's Profile") Topic Author
- [ Offline](/forum/user/1071-kwkness)

Less More

- Posts: 21
- Thank you received: 0
-
-

15 years 9 months ago [\#7820](#7820) by [kwkness](/forum/user/1071-kwkness "View kwkness's Profile")  *[Specific starting point order number format](/forum/4-how-to/7820-specific-starting-point-order-number-format#7820 "First off I would like to say thank you for all the great support and a fantastic product. I have been a linux user for years and really don't think I have ever paid for a piece of software. I...")* was created by *[kwkness](/forum/user/1071-kwkness "View kwkness's Profile")*

First off I would like to say thank you for all the great support and a fantastic product. I have been a linux user for years and really don't think I have ever paid for a piece of software. I purchased the essential version today without looking back. The support of the product is really what made it a no brainer. If anyone sees this please support this awesome company because they have earned it in my opinion.

I would like to set up my order number format to start with a specific number to match my accounting system. I searched around a bit and saw how to change to the code to {id size="5"}, which is the size of the format I want. But can I start it with 20130 and continue from there?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MjAtc3BlY2lmaWMtc3RhcnRpbmctcG9pbnQtb3JkZXItbnVtYmVyLWZvcm1hdD90bXBsPW1hcmtkb3du) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 9 months ago [\#7822](#7822) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Specific starting point order number format](/forum/4-how-to/7820-specific-starting-point-order-number-format#7822 "First off I would like to say thank you for all the great support and a fantastic product. I have been a linux user for years and really don't think I have ever paid for a piece of software. I...")*

For that, you should increment the order_id in the hikashop_order table like this:
[ 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)

The best way to have your comment seen by others interested in HikaShop is to post it on the joomla extensions directory:
[ extensions.joomla.org/extensions/e-commerce/shopping-cart/14275](http://extensions.joomla.org/extensions/e-commerce/shopping-cart/14275)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MjAtc3BlY2lmaWMtc3RhcnRpbmctcG9pbnQtb3JkZXItbnVtYmVyLWZvcm1hdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[kwkness](/forum/user/1071-kwkness "View kwkness's Profile")**
- [![kwkness's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1071-kwkness "View kwkness's Profile") Topic Author
- [ Offline](/forum/user/1071-kwkness)

Less More

- Posts: 21
- Thank you received: 0
-
-

15 years 9 months ago [\#7823](#7823) by [kwkness](/forum/user/1071-kwkness "View kwkness's Profile")  Replied by *[kwkness](/forum/user/1071-kwkness "View kwkness's Profile")* on topic *[Re: Specific starting point order number format](/forum/4-how-to/7820-specific-starting-point-order-number-format#7823 "First off I would like to say thank you for all the great support and a fantastic product. I have been a linux user for years and really don't think I have ever paid for a piece of software. I...")*

ok sorry I am in phpmyadmin, I see this when I edit

SELECT * FROM &#96;jos_hikashop_order&#96;

do I add

ALTER TABLE jos_hikashop_order AUTO_INCREMENT = 10000;

or just change the SELECT * FROM &#96;jos_hikashop_order&#96; to SELECT * FROM &#96;jos_hikashop_order AUTO_INCREMENT = 10000&#96;

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MjAtc3BlY2lmaWMtc3RhcnRpbmctcG9pbnQtb3JkZXItbnVtYmVyLWZvcm1hdD90bXBsPW1hcmtkb3du) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 9 months ago [\#7825](#7825) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Specific starting point order number format](/forum/4-how-to/7820-specific-starting-point-order-number-format#7825 "First off I would like to say thank you for all the great support and a fantastic product. I have been a linux user for years and really don't think I have ever paid for a piece of software. I...")*

You need to go in the SQL tab and paste the query below there and click on OK.
ALTER TABLE jos_hikashop_order AUTO_INCREMENT = 10000;

The following user(s) said Thank You: [s1m0n](/forum/user/14353-s1m0n "View s1m0n's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MjAtc3BlY2lmaWMtc3RhcnRpbmctcG9pbnQtb3JkZXItbnVtYmVyLWZvcm1hdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[kwkness](/forum/user/1071-kwkness "View kwkness's Profile")**
- [![kwkness's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1071-kwkness "View kwkness's Profile") Topic Author
- [ Offline](/forum/user/1071-kwkness)

Less More

- Posts: 21
- Thank you received: 0
-
-

15 years 9 months ago [\#7828](#7828) by [kwkness](/forum/user/1071-kwkness "View kwkness's Profile")  Replied by *[kwkness](/forum/user/1071-kwkness "View kwkness's Profile")* on topic *[Re: Specific starting point order number format](/forum/4-how-to/7820-specific-starting-point-order-number-format#7828 "First off I would like to say thank you for all the great support and a fantastic product. I have been a linux user for years and really don't think I have ever paid for a piece of software. I...")*

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE jos_hikashop_order AUTO_INCREMENT = 10000 LIMIT 0, 30' at line 2

I got this error, and I also want to double check that "10000" should be "20130" for my instance, right?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MjAtc3BlY2lmaWMtc3RhcnRpbmctcG9pbnQtb3JkZXItbnVtYmVyLWZvcm1hdD90bXBsPW1hcmtkb3du) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 9 months ago [\#7829](#7829) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Specific starting point order number format](/forum/4-how-to/7820-specific-starting-point-order-number-format#7829 "First off I would like to say thank you for all the great support and a fantastic product. I have been a linux user for years and really don't think I have ever paid for a piece of software. I...")*

Indeed. There should not be any LIMIT 0,30 in that query. Please use the query I posted previously.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MjAtc3BlY2lmaWMtc3RhcnRpbmctcG9pbnQtb3JkZXItbnVtYmVyLWZvcm1hdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.067 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
