Multi Select Option in Variants Drop Down list

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

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

Hi Nicolas, are there any plans to add this feature to Hikashop? (checkboxes)

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,

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.

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?

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 there if you use price filter all name products translated on russian language how i can fix this error?

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.

Hi thank you for answer i am send login and password through private message i hope you will answer.

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?