Text box on product page gives SQL error

Hi,
Today I purchased Hikashop Business as I needed to add a box on the product page for a customer to specify customisation or colour. I went into Display -> Custom Field and created an item / text to be able to add to the product page.

When I add this to the product page and hit save, I get an error:
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL=SELECT product_code, product_id FROM jp_hikashop_product WHERE product_code IN ()

Joomla 3.3.0 & PHP 5.4.17

What am I doing wrong please?

Many thanks in advance,
Alison

This further information may help: after the error if you go into the product you can see it has inserted the text box which is at the bottom but it also inserts something blank with no value at the top.

On the front end, it only shows the text box, until you delete the text box characteristic and the blank no value one too, then the other characteristics do not show up in the front end at all.

Hi,

I am not able to reproduce the problem on my end, can you try to edit the file "administrator/components/com_hikashop/classes/product.php" and in the function "updateCharacteristics()" add:

					$variantCodes = array();

					foreach($completeVariants as $variant){

Thank you for the reply Xavier.

For some reason if I insert that code where you specify (if I am doing it correctly!) it makes Hikashop completely inaccessible in the back end (just a blank page although all other Joomla backend pages are available as usual) and the front end is also showing a completely blank site.

I upgraded to the Business version specifically for this feature so I really do need to get it working. :-/

Hi Nicolas
Thank you for your reply.
I think I have followed the instructions correctly and I have regenerated the variants / characteristics.
I tried to delete the custom field but I get the following error:

Hi Nicolas,
That's really helpful - thank you. Shortening the column name is working great. What's the maximum number of characters please?

I have tried creating a price override:

Hi again Nicolas, and thank you for your reply.

No matter what value I put in it does not affect the sales price of the product. I tried just entering "30" and "32" but then if you added the product to the basket, the price remained at whatever the default price was of the product. If I entered "30.00" and "32.00" then adding the product to the basket still remained at default price.
Basket showing

Hi,

Sorry I am maybe missing something, but you want to have a custom field which must change the product price, right ?
If it is, it is not possible by default, you have to create characteristics, and then edit the price in the variants, or create a plugin which will change the price dynamically depending on the value of this custom field.

Regarding the "error price", do you have set a user group for this price ? If yes, thanks to remove it, set the price to "0" and save.

Thank you. The error price has been resolved.

However I am confused by the conflicting advice regarding the custom field changing the error price. I will explain again and please can someone help otherwise I shall have to request a refund and look for an alternative ecommerce package.

Each customer purchasing a jacket will have three choices to make.
Option 1 will be to choose from 30 fabrics
Option 2 will be to choose another fabric from approximately 30
Option 3 will be the size - with 5 options.

I understand that the prices can be changed in the variants but due to the above options there will be TENS AND TENS OF THOUSANDS of variants to deal with - that is just ridiculous. Surely there is a way that only option 3 affects the price?

Hi,

If only the option 3 change the price, so yes, you can use custom fields for options 1 and 2, and use characteristics for the option 3 in order to have only 5 variants and so 5 different prices.

Thank you so much for making this clear. This works just fine for my requirements

One last question (hopefully!)

Now that the prices are variable according to size, on the category page with the products listed as thumbnails I really need it to say "FROM £xx.xx" under each item rather than just one price. Is that possible please?

Many many thanks Nicolas. I now have answers to all my questions and I do appreciate your patience in helping me.