Incremental Custom Field

  • Posts: 83025
  • Thank you received: 13405
  • MODERATOR
10 years 3 months ago #172112

Hi,

Ok, could you change the line:

$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:
$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 ?

The following user(s) said Thank You: pepecortez

Please Log in or Create an account to join the conversation.

  • Posts: 171
  • Thank you received: 9
10 years 3 months ago #172183

nicolas wrote: Hi,

Ok, could you change the line:

$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:
$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!

Please Log in or Create an account to join the conversation.

  • Posts: 27
  • Thank you received: 0
9 years 4 months ago #211571

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)

Attachments:
Last edit: 9 years 4 months ago by Ziggy.

Please Log in or Create an account to join the conversation.

  • Posts: 83025
  • Thank you received: 13405
  • MODERATOR
9 years 4 months ago #211579

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.

The following user(s) said Thank You: Ziggy

Please Log in or Create an account to join the conversation.

  • Posts: 27
  • Thank you received: 0
9 years 4 months ago #211595

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

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
9 years 2 months ago #217961

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

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
9 years 2 months ago #217962

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.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
9 years 2 months ago #218108

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

Any idea what's wrong?? :unsure:

Please Log in or Create an account to join the conversation.

  • Posts: 26166
  • Thank you received: 4030
  • MODERATOR
9 years 2 months ago #218111

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


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
9 years 2 months ago #218180

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.

Attachments:
Last edit: 9 years 2 months ago by Joeri. Reason: vergot

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
9 years 2 months ago #218475

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".

The following user(s) said Thank You: Joeri

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 0
9 years 2 months ago #218546

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

Last edit: 9 years 2 months ago by Joeri. Reason: change answer

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0
7 years 3 months ago #277437

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.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 83025
  • Thank you received: 13405
  • MODERATOR
7 years 3 months ago #277575

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.

Please Log in or Create an account to join the conversation.

  • Posts: 267
  • Thank you received: 5
5 years 1 month ago #313523

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

Attachments:
Last edit: 5 years 1 month ago by dvddvd.

Please Log in or Create an account to join the conversation.

  • Posts: 83025
  • Thank you received: 13405
  • MODERATOR
5 years 1 month ago #313526

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.170 seconds
Powered by Kunena Forum