[Skip to main content](#vessel-content) # Multi Select Option in Variants Drop Down list ## - **[binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile")** - [![binoy_p_v's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") Topic Author - [ Offline](/forum/user/4135-binoy-p-v) Less More - Posts: 29 - Thank you received: 0 - - 14 years 1 month ago - 14 years 1 month ago [\#63655](#63655) by [binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") *[Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#63655 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* was created by *[binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile")* Hi Nicolas, We are ready to launch our project [ demo.aappakadai.com](http://demo.aappakadai.com) but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy Last edit: 14 years 1 month ago by [binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 14 years 1 month ago [\#63852](#63852) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#63852 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi, 1. That's not possible. No amount of modifications would allow that. It would require an important recoding of the code handling the characteristics. 2. You can do that by creating a custom field of the table "order" (business edition) via the menu Display->Custom fields The following user(s) said Thank You: [binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile")** - [![binoy_p_v's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") Topic Author - [ Offline](/forum/user/4135-binoy-p-v) Less More - Posts: 29 - Thank you received: 0 - - 14 years 1 month ago [\#63884](#63884) by [binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") Replied by *[binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#63884 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi, Please let me know if we could use checkboxes instead of radio button to achieve our requirement. Also let me know the files (display and controller) handles the characteristics feature so that i can try to do some code changes as my own. Regards, Binoy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 14 years 1 month ago [\#64014](#64014) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#64014 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* I don't think that you'll be able to change the radios into checkboxes. The file used to display the characteristics is : administrator/components/com_hikashop/types/charactersitic.php Changing the HTML to display checkboxes instead of radios is easy. The problem is that all the javascript behind the radio buttons will have to be rewritten to handle checkboxes. And that's really complex. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile")** - [![binoy_p_v's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") Topic Author - [ Offline](/forum/user/4135-binoy-p-v) Less More - Posts: 29 - Thank you received: 0 - - 14 years 1 month ago [\#64020](#64020) by [binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") Replied by *[binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#64020 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi Nicolas, Please let me know the Javascript related to the Characteristics radio button. Let me try to modify the javascript to achieve the requirement. Regards, Binoy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 14 years 1 month ago [\#64024](#64024) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#64024 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* The javascript is in that file too. The following user(s) said Thank You: [binoy\_p\_v](/forum/user/4135-binoy-p-v "View binoy_p_v's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")** - [![plantpotphil's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2189-plantpotphil "View plantpotphil's Profile") - [ Offline](/forum/user/2189-plantpotphil) Less More - Posts: 152 - Thank you received: 0 - - - 13 years 8 months ago [\#90999](#90999) by [plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Replied by *[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#90999 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi Nicolas, are there any plans to add this feature to Hikashop? (checkboxes) --- Create your own style of luxury [ bespoke furniture](http://www.clothierjones.com) online Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 13 years 8 months ago [\#91192](#91192) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#91192 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* You can already have checkboxes on your product pages using custom fields of the table "item" and of the type "checkbox". We don't plan on changing the characteristics dropdowns to checkboxes as I don't see why someone would want to select all the blue variants of a product to add all of them in the cart at once. In such cases, custom fields are probably more appropriated. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 7 months ago [\#147732](#147732) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#147732 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi, I created the export component for joomla. So I have to export products from database. I tried sql query to display data from database but it shows data with errors. Here's an example : Columns of table -> product_name | product_code | product_price | product_quantity | -> Sheath dress Deffinesse | cocktail dress-R | $ 55.00 | 1 | Then it should withdraw this product varint Columns in table -> Code | Size | Color | Quantity -> cocktail dress-2_35_40 | M | white | 1 | -> Cocktail dress-2_33_40 | S | white | 1 | In general, the request must give such kind of output Product Name -> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 1 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 2 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 3 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 4 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + Product Name -> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 1 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 2 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 3 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + It outputs this product variant 4 -> + + + + + + + + + + + + + + + + + + + + + + + + + + + It should output all these information above. Could you write me correct sql code for this, please? Best regards, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 12 years 7 months ago [\#147848](#147848) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#147848 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Please open a new thread for new questions. In order to load all the data of all the main products you can use such SQL: SELECT * FROM #__hikashop_product WHERE product_type='main'; In order to load all the data of all the variants of a main product you can use such SQL: SELECT * FROM #__hikashop_product WHERE product_parent_id=XXX; Then, to know the characteristic values of a variant you an use such SQL: SELECT * FROM #__hikashop_variant AS var LEFT JOIN #_hikashop_characteristic AS char ON var.variant_characteristic_id=char.characteristic_id WHERE var.variant_product_id=XXX; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 7 months ago - 12 years 7 months ago [\#148055](#148055) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#148055 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi thank you for answer i have also new question, i am use this sql query but i can't get correct result and so i am write own sql query and this work fine there is example: $sql = 'SELECT * FROM i1gmn_hikashop_product, i1gmn_hikashop_product_category, i1gmn_hikashop_price WHERE i1gmn_hikashop_product.product_id = i1gmn_hikashop_product_category.product_id AND i1gmn_hikashop_product.product_id = i1gmn_hikashop_price.price_product_id AND i1gmn_hikashop_product_category.category_id = 97 '; There is selectet product_name, product_code, product_price Table displays like this |Produc name|SSSSSSSS|$100| And i want that here display like this: Product information->|Produc name|SSSSSSSS|$100| Product variants->|XXXXXXXXX|SSSS_111| 35 | Product variants->|XXXXXXXXX|SSSS_111| 35 | And hier shows with variants product and how i can select one product and his variants->(product_code) and can you here add your sql code for this: $sql = 'SELECT * FROM i1gmn_hikashop_product, i1gmn_hikashop_product_category, i1gmn_hikashop_price WHERE i1gmn_hikashop_product.product_id = i1gmn_hikashop_product_category.product_id AND i1gmn_hikashop_product.product_id = i1gmn_hikashop_price.price_product_id AND i1gmn_hikashop_product_category.category_id = 97 '; I am try do but i can't it make help me please thank you. Last edit: 12 years 7 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 12 years 7 months ago [\#148190](#148190) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#148190 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi, You cannot do what you want in one SQL query. You'll need several of them with PHP in order to handle all that. That's because variants are not linked to categories but only to their main product via the product_parent_id column. So you would have to do as I said in my previous email with the first query on the product table for the main products and a second one for the variants of these products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 7 months ago [\#148241](#148241) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#148241 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi thank you for answer I've done what I wanted i can select all product with produc_code it work fine now and i am also want add size and color product but when i open sql table i1gmn_hikashop_characteristic there have one column which contains size and color i think it is not correct when i select size and color for each product i get uncorrect result for example product_name | product_code | size | color | SSSSSSSSSS |SSSSSSSS_5 | 35| SSSSSSSSSS |SSSSSSSS_5 | red| There is in one column size contains color and size because table i1gmn_hikashop_characteristic build uncorrect i want get result like this product_name | product_code | size | color | SSSSSSSSSS |SSSSSSSS_5 | 35| red| SSSSSSSSSS |SSSSSSSS_5 | 38||white| So and my question how i can divide column characteristic_value from table i1gmn_hikashop_characteristic because this is column contains color and size please can you give me php or sql code or tell me idea how i can divide this please? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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) - 12 years 7 months ago [\#148396](#148396) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#148396 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi, Please explain how you get these results. Otherwise it will be too difficult to help you correctly. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 7 months ago - 12 years 7 months ago [\#148941](#148941) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#148941 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi i am one month ago ask about topic translation but i am not get answer for my question so you asking access on FTP i give you through your E-@mail but you don't answer so my question when users go product page with language english and there are use filter price all products name translated on russian language so how i can fix this error please help me? this is link for site [ www.sevenrow.com/en/women/dresses](http://www.sevenrow.com/en/women/dresses) there if you use price filter all name products translated on russian language how i can fix this error? Last edit: 12 years 7 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 7 months ago [\#148992](#148992) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#148992 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hello, Are you using any SEF module ? if yes can you disable it and try it again ? If it still doesn't work, can you give me a temporary access to your back through a private message so that I can directly test it ? Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 7 months ago - 12 years 7 months ago [\#149530](#149530) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#149530 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi thank you for answer i am send login and password through private message i hope you will answer. Last edit: 12 years 7 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")** - [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile") - [ Offline](/forum/user/30192-myktybek) Less More - Posts: 39 - Thank you received: 0 - - 12 years 7 months ago - 12 years 7 months ago [\#149680](#149680) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile") Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#149680 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi sorry you checking back end i sent through your private massage login and password 2 days ago but you did not respond please give the answer of this error for our project on hold? Last edit: 12 years 7 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 12 years 6 months ago [\#151991](#151991) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Multi Select Option in Variants Drop Down list](/forum/4-how-to/63655-multi-select-option-in-variants-drop-down-list#151991 "Hi Nicolas, We are ready to launch our project demo.aappakadai.com but struck with a new change request from the client side. There are two change requests from client 1) Can we give multi select option in Variants Drop Down (Characteristics selection method) list or checkboxes instead of radio button for the selection of multiple characteristics ? - Let me know if we can do this using some code change /configuration change in hikashop 2) Can we give a booking/ordering remarks in checkout page as we are using Cash on delivery to method. So the Remark (Text Area) will help the customer to give more details on the shipping address or any other message they want to convey to us. Please help me in handling/implementing these change requests. Regards, Binoy")* Hi, Sorry for the delay. We are not able to reproduce the problem on our end. We would need a FTP access in order to debug the issue directly on the website. Would it be possible for you to provide that via our contact form ? [ www.hikashop.com/contact-us.html](http://www.hikashop.com/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzYzNjU1LW11bHRpLXNlbGVjdC1vcHRpb24taW4tdmFyaWFudHMtZHJvcC1kb3duLWxpc3Q/dG1wbD1tYXJrZG93bg==) 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.195 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)