[Skip to main content](#vessel-content) # Profile for alexsmirnov ## [![alexsmirnov's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar25100.jpg)](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") **[ Offline](/forum/user/25100-alexsmirnov)** - **User Type:** User - **Register Date:** 20 Jul 2013 - **Last login:** 1 year 3 weeks ago - **Time Zone:** UTC +0:00 - **Local Time:** 05:26 - **Posts:** 24 - **Profile views:** 120 - **Thank you received:** 1 - **Location:** [United Kingdom](https://maps.google.com?q=United%20Kingdom) - **Gender:** Unknown - **Birthdate:** Unknown > Seek and you shall find. - Posts # alexsmirnov's recent posts (24 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154105) | [Moving user to new group pending on his orders vol](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154105 "Hi guys, I would like to suggest one function which I hope you'll find only useful. Imho, Hika Shop Business users will greatly benefit if it would be possible to somehow automatically move a customer from his current Joomla user group to a new one once his total orders volume has reached a predefined threshold. What do you think? Is this feasible? Regards, Alex") Category: [Feature Request](/forum/50-feature-request "Suggest your feature requests and ideas for HikaShop") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154508 "merci") 12 years 5 months ago by [erickb](/forum/user/4069-erickb "View erickb's Profile") | Replies:12 Views:1521 | [Last Post](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154508 "merci") by [erickb](/forum/user/4069-erickb "View erickb's Profile") 12 years 5 months ago | | [](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144423) | [How to display number of confirmed orders](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144423 "-- url of the page with the problem -- : localhost -- HikaShop version -- : Business/Multi-vendor -- Joomla version -- : 2.5.18 -- PHP version -- : 5.4 Hi guys, I would like to display to a logged-in user a current quantity of all orders (that is orders placed by him and the rest of the customers) with the status "confirmed". What would be the code for this and where should I place it please? Regards, Alex") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 12 years 8 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144423 "Hi Mo. I feel I need a bit more time to compose my requirements. I'll post them here once they are ready. Cheers, Alex") 12 years 8 months ago by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") | Replies:2 Views:761 | [Last Post](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144423 "Hi Mo. I feel I need a bit more time to compose my requirements. I'll post them here once they are ready. Cheers, Alex") by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") 12 years 8 months ago | | [](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144361) | [How to display number of confirmed orders](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144361 "-- url of the page with the problem -- : localhost -- HikaShop version -- : Business/Multi-vendor -- Joomla version -- : 2.5.18 -- PHP version -- : 5.4 Hi guys, I would like to display to a logged-in user a current quantity of all orders (that is orders placed by him and the rest of the customers) with the status "confirmed". What would be the code for this and where should I place it please? Regards, Alex") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 12 years 8 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144423 "Hi Mo. I feel I need a bit more time to compose my requirements. I'll post them here once they are ready. Cheers, Alex") 12 years 8 months ago by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") | Replies:2 Views:761 | [Last Post](/forum/31-development/865942-how-to-display-number-of-confirmed-orders#144423 "Hi Mo. I feel I need a bit more time to compose my requirements. I'll post them here once they are ready. Cheers, Alex") by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") 12 years 8 months ago | | [](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137980) | [Custom field by the table "item" not seen](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137980 "-- url of the page with the problem -- :localhost -- HikaShop version -- : 2.2.3 Business -- Joomla version -- : 2.5.16 -- PHP version -- : 5.3.28 Hi felas, I've created a custom field by the "text area" type and by the "item" table. It gets displayed for a product just fine but the text that my test customer enters into it purchasing a product doesn't get displayed in his order history at the front end. As a super administrator, when I open this test customer order at the back end, I can see the text he entered into this custom field, but when I log in from the front end as this test customer and open his order via corresponding menu item, then this text is not there. Is this normal or am I missing something? Cheers, Alex P S All three "Display" options, - "Front-end", "Back-end Form" and "Back-end Listing", have been set to "Yes"") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137980 "Lovely job. Worked like charm.") 12 years 10 months ago by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") | Replies:2 Views:751 | [Last Post](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137980 "Lovely job. Worked like charm.") by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") 12 years 10 months ago | | [](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137936) | [Custom field by the table "item" not seen](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137936 "-- url of the page with the problem -- :localhost -- HikaShop version -- : 2.2.3 Business -- Joomla version -- : 2.5.16 -- PHP version -- : 5.3.28 Hi felas, I've created a custom field by the "text area" type and by the "item" table. It gets displayed for a product just fine but the text that my test customer enters into it purchasing a product doesn't get displayed in his order history at the front end. As a super administrator, when I open this test customer order at the back end, I can see the text he entered into this custom field, but when I log in from the front end as this test customer and open his order via corresponding menu item, then this text is not there. Is this normal or am I missing something? Cheers, Alex P S All three "Display" options, - "Front-end", "Back-end Form" and "Back-end Listing", have been set to "Yes"") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137980 "Lovely job. Worked like charm.") 12 years 10 months ago by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") | Replies:2 Views:751 | [Last Post](/forum/35-orders-management/864587-custom-field-by-the-table-item-not-seen#137980 "Lovely job. Worked like charm.") by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") 12 years 10 months ago | | [](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137934) | [How to retrieve product quantity per J user ID](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137934 "-- url of the page with the problem -- : localhost -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4.6 Hi there, After my HikaShop customer pays for a product, he will need to log in and fill in for me a small web form in which, as he fills it in, I will need one of his fields to be calculated based on the quantity of the HikaShop product he just purchased. I am using RSForms Pro to construct the form and one of their tutorials deals with similar task: it inserts into the form field a Cummunity Builder user first name with this code: // $user = JFactory::getUser(); $db = JFactory::getDbo(); $userId = $user->get('id'); // Is the user logged in? if ($userId) { // Grab the value from the database. $db->setQuery("SELECT `firstname` FROM `#__comprofiler` WHERE `user_id`='".$userId."'"); return $db->loadResult(); } // Could you advise what SELECT would help me to retrieve the quantity of the product from the last order of a logged in Joomla 2.5 user/HikaShop customer? Cheers, Alex") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137934 "Cheers, Nicolas. This query worked like charm.") 12 years 10 months ago by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") | Replies:2 Views:970 | [Last Post](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137934 "Cheers, Nicolas. This query worked like charm.") by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") 12 years 10 months ago | | [](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137788) | [How to retrieve product quantity per J user ID](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137788 "-- url of the page with the problem -- : localhost -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4.6 Hi there, After my HikaShop customer pays for a product, he will need to log in and fill in for me a small web form in which, as he fills it in, I will need one of his fields to be calculated based on the quantity of the HikaShop product he just purchased. I am using RSForms Pro to construct the form and one of their tutorials deals with similar task: it inserts into the form field a Cummunity Builder user first name with this code: // $user = JFactory::getUser(); $db = JFactory::getDbo(); $userId = $user->get('id'); // Is the user logged in? if ($userId) { // Grab the value from the database. $db->setQuery("SELECT `firstname` FROM `#__comprofiler` WHERE `user_id`='".$userId."'"); return $db->loadResult(); } // Could you advise what SELECT would help me to retrieve the quantity of the product from the last order of a logged in Joomla 2.5 user/HikaShop customer? Cheers, Alex") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137934 "Cheers, Nicolas. This query worked like charm.") 12 years 10 months ago by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") | Replies:2 Views:970 | [Last Post](/forum/35-orders-management/864560-how-to-retrieve-product-quantity-per-j-user-id#137934 "Cheers, Nicolas. This query worked like charm.") by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") 12 years 10 months ago | | [](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#137740) | [Moving user to new group pending on his orders vol](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#137740 "Hi guys, I would like to suggest one function which I hope you'll find only useful. Imho, Hika Shop Business users will greatly benefit if it would be possible to somehow automatically move a customer from his current Joomla user group to a new one once his total orders volume has reached a predefined threshold. What do you think? Is this feasible? Regards, Alex") Category: [Feature Request](/forum/50-feature-request "Suggest your feature requests and ideas for HikaShop") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154508 "merci") 12 years 5 months ago by [erickb](/forum/user/4069-erickb "View erickb's Profile") | Replies:12 Views:1521 | [Last Post](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154508 "merci") by [erickb](/forum/user/4069-erickb "View erickb's Profile") 12 years 5 months ago | | [](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#137669) | [Moving user to new group pending on his orders vol](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#137669 "Hi guys, I would like to suggest one function which I hope you'll find only useful. Imho, Hika Shop Business users will greatly benefit if it would be possible to somehow automatically move a customer from his current Joomla user group to a new one once his total orders volume has reached a predefined threshold. What do you think? Is this feasible? Regards, Alex") Category: [Feature Request](/forum/50-feature-request "Suggest your feature requests and ideas for HikaShop") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154508 "merci") 12 years 5 months ago by [erickb](/forum/user/4069-erickb "View erickb's Profile") | Replies:12 Views:1521 | [Last Post](/forum/50-feature-request/864539-moving-user-to-new-group-pending-on-his-orders-vol#154508 "merci") by [erickb](/forum/user/4069-erickb "View erickb's Profile") 12 years 5 months ago | | [](/forum/33-customers/864533-how-to-automaitically-move-customer-to-user-group#137666) | [How to automaitically move customer to user group](/forum/33-customers/864533-how-to-automaitically-move-customer-to-user-group#137666 "-- localhost -- HikaShop version -- : Business 2.2.3 -- Joomla version -- : 2.5.16 -- PHP version -- : 5.4.6 Hi guys, Is it possible with Hika Shop Business to automatically move a customer to a different already created Joomla user group once the volume of his orders reached a certain value, let's say, for example, $100? The closest to this I was able to find within the Hika Shop Business was the System ->"Mass actions", where I found the "Change the user group" action. Is it possible to somehow trigger this action once a user order in total reached, for example, $100? Merry Christmas Alex") Category: [Customers](/forum/33-customers "How to manage your customers and their access") Topic started 12 years 10 months ago, by [alexsmirnov](/forum/user/25100-alexsmirnov "View alexsmirnov's Profile") [Last Post](/forum/33-customers/864533-how-to-automaitically-move-customer-to-user-group#137682 "You'll have to write it :).") 12 years 10 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:3 Views:724 | [Last Post](/forum/33-customers/864533-how-to-automaitically-move-customer-to-user-group#137682 "You'll have to write it :).") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 10 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.171 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)