Incremental Custom Field

Hi,

Ok, could you change the line: to: in the file components/com_hikashop/views/product/view.html.php and see if that helps ?

nicolas wrote: Hi,

Ok, could you change the line:

Code:

$catQuery = 'SELECT * FROM '.hikashop_table('category').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.category_id = b.category_id WHERE b.product_id IN ('.implode(',',$ids).') GROUP BY b.product_id';

to:

Code:

$catQuery = 'SELECT * FROM '.hikashop_table('category').' AS a LEFT JOIN '.hikashop_table('product_category').' AS b ON a.category_id = b.category_id WHERE b.product_id IN ('.implode(',',$ids).');';

in the file components/com_hikashop/views/product/view.html.php and see if that helps ?

Works like a charm...
Thank you!

Dear customer,

I red a lot about this issue, but there is something i don't get.
I created a date picker like:



but now i want to add this picker to the products of the category "reparatie".
What do you i have to do to see the date picker in:



extra info:
Most recent version of hikashop business (rsgsm.nl)

Hi,

You created a custom field of the table "product" and that will display the field when you edit your product.
If you want to display the field when the customer displays the product page, you instead need to create a custom field of the table "item" via the menu Display>Custom fields.

Thnx a lot. I should have misunderstood the explanation of the field types.

Hello, i read all this topics, but find no answer for my own problem.

I want to have 3 fields so that customers can put in a value.
Like this length x width = total dimension
The last field (total dimension) as an example 10m² must correspond to the price per sqm. so the customer can settle the adjusted price

Hello,
Note that you'll probably find a solution through that thread : www.hikashop.com/forum/product-category-...er-square-meter.html

You can sell you products per m2 by creating product per m2, but another solution can be to use the following plugin, and create a "width" and "length" custom ITEM fields which will be used with that plugin. So your that your customers will just have to set a width/length and the price will be automatically calculated.

Thanks i have created the length en width item fields.
its working, but automatically calculated not the price.

Any idea what's wrong??

Hi,

I'm sorry but I don't understand your sentence

its working, but automatically calculated not the price.

Please clarify.

And no ; we can't know what is wrong because we do not have any information about your website, your field configuration, if you have installed the plugin, if the plugin is published, if the fields are right named, etc.

Regards

Hi,
I installed the plugin and is published.
I make the item fields and they are published.
Only what's not working is calculating the price after i push the add to cart button.
I send some printscreens to clarify.

Hi,

The issue come from the "Kolom Naam", there it must be "width" and "length" and not "breedte" and "lengte".
That's why it is not working as expected.

If you want to keep these Kolom naam, so you can edit the plugin directly and replace the occurrences of "width" and "length".

Thank you after restart it works fine now.
:woohoo: :woohoo:

We have been using Hikashop for several years now and upgraded to 3.1.1 business this summer and it broke part of our site.

We sell 3 types of bus tickets.
1) Two have variants with the year, month and route along with a custom field asking for the card holder's name to put on the bus card.
2) The third has no variants and only asks for the card holder's name (it is just a book of tickets which can be used at any time).

Everything worked fine after the upgrade until we noticed that the card holder's name info was not being stored on the first two types of tickets (#1 which also ask for the year, month and route), while the card holder's name is saved on the third type (#2 the book) even though for all three, the card holder's name is required when adding the product to the cart.

All 3 products look to be setup the same and we cannot see any category or permission differences between them.

Additionally, when drilling down into an order, for #1 types, the field for the card holder's name is missing, while on #2, it is there (see attached).

This only broke since the upgrade to business. Any ideas? Thx.

Hi,

First, please update to HikaShop 3.2.0.
It contains a few patches for the custom fields.
Also, edit your custom fields and make sure that the display settings of the custom fields are correct.

How can I put an incremental auto field in the custom field entries section?
I need to number the tickets for a raffle
This field has started since 1
I also don't know how to add these custom fields to the invoice, since this option does not appear.I also don't know how to add these custom fields to the invoice, since this option does not appear.



Thnaks Nicolas

Hi,

There is already an incremental unique number for each entry.
It's the column entry_id in the hikashop_entry table.
For each entry added, an entry_id will be generated automatically.
You'll find that value on the right column of the entries listing in your backend:
monosnap.com/file/6XDC2RKpBO56ljVVW2uAhNVx63Bfjl