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

#   Order Number code

##

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

Less More

- Posts: 240
- Thank you received: 13
-
-

1 year 3 months ago [\#367831](#367831) by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile")  *[Order Number code](/forum/25-install-update/909565-order-number-code#367831 "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.1  how can i set my order code generation number to start with 100001 (not 000001)")* was created by *[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")*

-- HikaShop version -- : 6.0.0
-- Joomla version -- : 5.3.2
-- PHP version -- : 8.1

how can i set my order code generation number to start with 100001 (not 000001)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwOTU2NS1vcmRlci1udW1iZXItY29kZT90bXBsPW1hcmtkb3du) 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: 86363
- Thank you received: 14296
-
-

1 year 3 months ago [\#367832](#367832) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order Number code](/forum/25-install-update/909565-order-number-code#367832 "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.1  how can i set my order code generation number to start with 100001 (not 000001)")*

Hi,

Go in your PHPMyAdmin and change the auto_increment of the hikashop_order table to 100000
Next order will be 100001 automatically.
[ stackoverflow.com/questions/5665571/auto...rement-in-phpmyadmin](https://stackoverflow.com/questions/5665571/auto-increment-in-phpmyadmin)

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

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

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

Less More

- Posts: 240
- Thank you received: 13
-
-

1 year 2 weeks ago [\#369106](#369106) by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile")  Replied by *[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")* on topic *[Order Number code](/forum/25-install-update/909565-order-number-code#369106 "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.1  how can i set my order code generation number to start with 100001 (not 000001)")*

can i do the same for product codes ?
i want each product code be a number like 1001, 1002, 1003 and so on

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwOTU2NS1vcmRlci1udW1iZXItY29kZT90bXBsPW1hcmtkb3du) 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: 86363
- Thank you received: 14296
-
-

1 year 2 weeks ago [\#369116](#369116) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order Number code](/forum/25-install-update/909565-order-number-code#369116 "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.1  how can i set my order code generation number to start with 100001 (not 000001)")*

Hi,

The product code is not generated by HikaShop. It's something you can enter in the "product code" input field of each product. So you can use the format you want without changing anything in HikaShop.

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

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

Less More

- Posts: 240
- Thank you received: 13
-
-

1 year 2 weeks ago [\#369117](#369117) by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile")  Replied by *[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")* on topic *[Order Number code](/forum/25-install-update/909565-order-number-code#369117 "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.1  how can i set my order code generation number to start with 100001 (not 000001)")*

I know
this is exactly what i want to do ... to create the product codes automaticly
somthing like auto increament of product ids

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwOTU2NS1vcmRlci1udW1iZXItY29kZT90bXBsPW1hcmtkb3du) 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: 86363
- Thank you received: 14296
-
-

1 year 2 weeks ago [\#369118](#369118) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Order Number code](/forum/25-install-update/909565-order-number-code#369118 "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.1  how can i set my order code generation number to start with 100001 (not 000001)")*

Hi,

Then, you can create a massaction with triggers "when product is created" and "when product is updated" and an action "update the values" on the "product_code" column with the mode "operation" and the value: product.product_id
This way, the product code will get the id of the product as value automatically.

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwOTU2NS1vcmRlci1udW1iZXItY29kZT90bXBsPW1hcmtkb3du) 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.061 seconds

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