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,

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

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

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.

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

The javascript is in that file too.

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

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.

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 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;

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,

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.

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,

Please explain how you get these results.
Otherwise it will be too difficult to help you correctly.

Regards,

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?

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