[Skip to main content](#vessel-content) # List of the customer's historical serials ## - **[Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile")** - [![Pajerchin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20592-pajerchin "View Pajerchin's Profile") Topic Author - [ Offline](/forum/user/20592-pajerchin) Less More - Posts: 29 - Thank you received: 0 - - 2 years 3 months ago [\#362260](#362260) by [Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile") *[List of the customer's historical serials](/forum/15-general-talk-about-hikaserial/908425-list-of-the-customers-historical-serials#362260 "-- HikaShop version -- : 5.1.0 -- HikaSerial version -- : 5 -- Joomla version -- : 5.1.1 -- PHP version -- : 8.2.19 Hi, When the order is created and confirmed - the customer can see his serials (after login in the User Data / Serials) = everything is OK But if the order is not created - and the Serial is created & assigned to the customer - then after customer login in the User Data / Serials = this serial is not listed The question: Is there a way to display customer's serials for him (in his profile after login) - if he doesn't created any order yet? It is needed if I would like to provide a list of previously purchased licenses for him...")* was created by *[Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile")* -- HikaShop version -- : 5.1.0 -- HikaSerial version -- : 5 -- Joomla version -- : 5.1.1 -- PHP version -- : 8.2.19 Hi, When the order is created and confirmed - the customer can see his serials (after login in the User Data / Serials) = everything is OK But if the order is not created - and the Serial is created & assigned to the customer - then after customer login in the User Data / Serials = this serial is not listed The question: Is there a way to display customer's serials for him (in his profile after login) - if he doesn't created any order yet? It is needed if I would like to provide a list of previously purchased licenses for him... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzkwODQyNS1saXN0LW9mLXRoZS1jdXN0b21lcnMtaGlzdG9yaWNhbC1zZXJpYWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 2 years 3 months ago [\#362267](#362267) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[List of the customer's historical serials](/forum/15-general-talk-about-hikaserial/908425-list-of-the-customers-historical-serials#362267 "-- HikaShop version -- : 5.1.0 -- HikaSerial version -- : 5 -- Joomla version -- : 5.1.1 -- PHP version -- : 8.2.19 Hi, When the order is created and confirmed - the customer can see his serials (after login in the User Data / Serials) = everything is OK But if the order is not created - and the Serial is created & assigned to the customer - then after customer login in the User Data / Serials = this serial is not listed The question: Is there a way to display customer's serials for him (in his profile after login) - if he doesn't created any order yet? It is needed if I would like to provide a list of previously purchased licenses for him...")* Hello, The fact that the customer can't see these serials depends on the "display serials for customer" setting : [ www.hikashop.com/support/documentation/1...ation.html#main\_main](https://www.hikashop.com/support/documentation/111-hikaserial-configuration.html#main_main) By default, we consider that an order which is not created should not let the customer see (and use) the serial. But, the serial can be "reserved", so when the order is "confirmed" the serial become visible (and if you cancel and confirm back the order, the serial stay the same). Afterwards, HikaSerial provides a customer interface to see the list of serials. Even if you create a serial manually in the backend, as long as the serial status is authorized to be display (the mentioned setting above), it will be visible in that listing. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzkwODQyNS1saXN0LW9mLXRoZS1jdXN0b21lcnMtaGlzdG9yaWNhbC1zZXJpYWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile")** - [![Pajerchin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20592-pajerchin "View Pajerchin's Profile") Topic Author - [ Offline](/forum/user/20592-pajerchin) Less More - Posts: 29 - Thank you received: 0 - - 2 years 3 months ago [\#362282](#362282) by [Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile") Replied by *[Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile")* on topic *[List of the customer's historical serials](/forum/15-general-talk-about-hikaserial/908425-list-of-the-customers-historical-serials#362282 "-- HikaShop version -- : 5.1.0 -- HikaSerial version -- : 5 -- Joomla version -- : 5.1.1 -- PHP version -- : 8.2.19 Hi, When the order is created and confirmed - the customer can see his serials (after login in the User Data / Serials) = everything is OK But if the order is not created - and the Serial is created & assigned to the customer - then after customer login in the User Data / Serials = this serial is not listed The question: Is there a way to display customer's serials for him (in his profile after login) - if he doesn't created any order yet? It is needed if I would like to provide a list of previously purchased licenses for him...")* Sorry, but based on your instruction I'm not able to list Serials for customer without order 1. Configuration Display status for customer: Assigned + Used + Reserved 2. Pack named "Test" Pack data: Pack SQL Data Pack Generator: - 3. Serial: Serial Data: LicXYZ Pack: Test Status: "Used" or "Reserved" or Assigned" ...not any effect Assign date: - Order number:- User: UserXY Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzkwODQyNS1saXN0LW9mLXRoZS1jdXN0b21lcnMtaGlzdG9yaWNhbC1zZXJpYWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 2 years 3 months ago [\#362288](#362288) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[List of the customer's historical serials](/forum/15-general-talk-about-hikaserial/908425-list-of-the-customers-historical-serials#362288 "-- HikaShop version -- : 5.1.0 -- HikaSerial version -- : 5 -- Joomla version -- : 5.1.1 -- PHP version -- : 8.2.19 Hi, When the order is created and confirmed - the customer can see his serials (after login in the User Data / Serials) = everything is OK But if the order is not created - and the Serial is created & assigned to the customer - then after customer login in the User Data / Serials = this serial is not listed The question: Is there a way to display customer's serials for him (in his profile after login) - if he doesn't created any order yet? It is needed if I would like to provide a list of previously purchased licenses for him...")* Hello, You're right ! The HikaSerial Serial listing is doing a query with a link with HikaShop orders. To fix that behavior, you need to edit the file under "components/com_hikaserial/views/serial/view.html.php" and change the lin Code: ' INNER JOIN '.hikaserial::table('shop.order').' AS hk_order ON serial.serial_order_id = hk_order.order_id '; By Code: ' LEFT JOIN '.hikaserial::table('shop.order').' AS hk_order ON serial.serial_order_id = hk_order.order_id '; Then, in the "serial / listing" view (via the override or edit manually the file which is in the "tmpl" sub folder) Replace Code: <td class="hikaserial_serial_ordernumber_value"> <a href="<?php echo hikashop_completeLink('order&task=show&cid='.(int)$serial->serial_order_id); ?>"><?php echo $serial->order_number; ?></a> </td> By Code: <td class="hikaserial_serial_ordernumber_value"> <?php if(!empty($serial->serial_order_id)) { ?> <a href="<?php echo hikashop_completeLink('order&task=show&cid='.(int)$serial->serial_order_id); ?>"><?php echo $serial->order_number; ?></a> <?php } else { echo JText::_('HIKASERIAL_NO_ORDER'); } ?> </td> And you should see serials without an order linked. (that modification will be in the next release). Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [Pajerchin](/forum/user/20592-pajerchin "View Pajerchin's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzkwODQyNS1saXN0LW9mLXRoZS1jdXN0b21lcnMtaGlzdG9yaWNhbC1zZXJpYWxzP3RtcGw9bWFya2Rvd24=) 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? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.160 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)