[Skip to main content](#vessel-content) # Custom Order Number ## - **[ifeldman0](/forum/user/37170-ifeldman0 "View ifeldman0's Profile")** - [![ifeldman0's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37170-ifeldman0 "View ifeldman0's Profile") Topic Author - [ Offline](/forum/user/37170-ifeldman0) Less More - Posts: 7 - Thank you received: 0 - - 11 years 5 months ago [\#201852](#201852) by [ifeldman0](/forum/user/37170-ifeldman0 "View ifeldman0's Profile") *[Custom Order Number](/forum/35-orders-management/876986-custom-order-number#201852 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.23 -- Browser(s) name and version -- : Chrome 42 Our site has a custom format order number which includes the customer's Joomla ID number ({user user_cms_id}-{date format="mdY"}-{id size="4"}). When customers purchase products through the public-facing side of the site, the order numbers are correct. However, if an administrator tries to create an order for a customer through the administrator side of the website, the Joomla ID of the customer is not included in the order number, even after the order is assigned to the correct customer. Is there a way to "refresh" the order number after an order is created so that it contains the Joomla ID as intended?")* was created by *[ifeldman0](/forum/user/37170-ifeldman0 "View ifeldman0's Profile")* -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.23 -- Browser(s) name and version -- : Chrome 42 Our site has a custom format order number which includes the customer's Joomla ID number ({user user_cms_id}-{date format="mdY"}-{id size="4"}). When customers purchase products through the public-facing side of the site, the order numbers are correct. However, if an administrator tries to create an order for a customer through the administrator side of the website, the Joomla ID of the customer is not included in the order number, even after the order is assigned to the correct customer. Is there a way to "refresh" the order number after an order is created so that it contains the Joomla ID as intended? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Njk4Ni1jdXN0b20tb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) 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 - - 11 years 5 months ago [\#201881](#201881) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Order Number](/forum/35-orders-management/876986-custom-order-number#201881 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.23 -- Browser(s) name and version -- : Chrome 42 Our site has a custom format order number which includes the customer's Joomla ID number ({user user_cms_id}-{date format="mdY"}-{id size="4"}). When customers purchase products through the public-facing side of the site, the order numbers are correct. However, if an administrator tries to create an order for a customer through the administrator side of the website, the Joomla ID of the customer is not included in the order number, even after the order is assigned to the correct customer. Is there a way to "refresh" the order number after an order is created so that it contains the Joomla ID as intended?")* Hi, There is no interface in order to change the order number when you edit an order. There are two solutions: - You could edit the order entry in the hikashop_order tabel of the database via your phpmyadmin in order to change the value in the order_number column. - You could create a mass action via the menu System>Mass actions, set a filter on the order_id column equal to the id of your order and an action to update the values of the "order_number" column equal to the order_number you want and then just click on the "process" button of the mass action. Please do a backup before trying that as there is no going back and you could potentially mess up all your data if you make a mistake when using mass actions. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Njk4Ni1jdXN0b20tb3JkZXItbnVtYmVyP3RtcGw9bWFya2Rvd24=) 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.143 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)