[Skip to main content](#vessel-content)

#   Custom Field display

##

- **[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")**
- [![cberry1971's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13211-cberry1971 "View cberry1971's Profile") Topic Author
- [ Offline](/forum/user/13211-cberry1971)

Less More

- Posts: 241
- Thank you received: 5
-
-

13 years 8 months ago [\#89836](#89836) by [cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")  *[Custom Field display](/forum/4-how-to/78322-custom-field-display#89836 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")* was created by *[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")*

We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product_alias = xxx:

Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS

the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for "shirt size", "emergency contact", "contact phone" then I would like those three columns added to the query.

Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 8 months ago [\#89890](#89890) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#89890 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

Hi,

This is not an option in HikaShop, you will have to edit the file "administrator/components/com_hikashop/views/product/view.html.php" and the view "product / listing" (backend template) to do that.
It require good PHP and MySQL knowledge.

We have on our todo list to create a new view in the backend to display anything, you will be able to select the kind of things to display, what to display, filter the results with many many filters choice..

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")**
- [![cberry1971's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13211-cberry1971 "View cberry1971's Profile") Topic Author
- [ Offline](/forum/user/13211-cberry1971)

Less More

- Posts: 241
- Thank you received: 5
-
-

13 years 8 months ago [\#89943](#89943) by [cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")  Replied by *[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#89943 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

Ok. I am not sure how I am supposed to get all the info to complete orders out of the system then.

I can't get a list of "emergency contacts", "t-shirt sizes", etc. How does this get done for other users?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

13 years 8 months ago [\#90106](#90106) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#90106 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

Hi,

As Xavier said, it's not easy. You need to create your own view and do several queries to load all the data in PHP and then display it in your view. If you know PHP, that shouldn't be too difficult though.

First, you need to load all the confirmed orders for a product.
That can be done with such query:
SELECT * FROM #__hikashop_order_product as prod LEFT JOIN #__hikashop_order as order ON prod.order_id=order.order_id WHERE prod.product_code='my_product' AND order.order_status='confirmed'
(you need to change my_product by the code of your product)
You will get the orders number in the order_number column, the Product in the order_product_name column and the custom item fields in the corresponding column names

Then, you need to load the user of the orders with another query:
SELECT * FROM #__hikashop_user as user LEFT JOIN #__user as juser ON user.user_cms_id=juser.id WHERE user.user_id IN (XXX,YYY)
(you need to replace XXX, YYY etc by the ids of the user in the orders)
You can get the ids in the results of the first query in the order_user_id column.
You will get the Customer name in the name column and the Customer email in the user_email column.

With these two queries, you will have all the data for your view.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")**
- [![cberry1971's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13211-cberry1971 "View cberry1971's Profile") Topic Author
- [ Offline](/forum/user/13211-cberry1971)

Less More

- Posts: 241
- Thank you received: 5
-
-

13 years 8 months ago [\#91074](#91074) by [cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")  Replied by *[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#91074 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

thanks. a couple of corrections:

SELECT * FROM
__hikashop_order_product as prod
LEFT JOIN __hikashop_order as order
ON prod.order_id=order.order_id
WHERE prod.order_product_code='xxx' AND order.order_status='confirmed'

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")**
- [![cberry1971's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13211-cberry1971 "View cberry1971's Profile") Topic Author
- [ Offline](/forum/user/13211-cberry1971)

Less More

- Posts: 241
- Thank you received: 5
-
-

13 years 8 months ago [\#91137](#91137) by [cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")  Replied by *[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#91137 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

I am still struggling with this one. The SELECT * is capturing too many columns for my needs. I am trying to display this table for users' products..

However different products populate different columns in hikashop_order_product. So one product may have a custom field = tshirt size while another may not. I don't want to display tshirt size for the product which does not need that info.

How might I only select

- the appropriate columns for product 1 where product 1's category has columns
- the columns for product 2 where product 2's category has columns

My current query:

SELECT *

FROM _hikashop_product AS p

INNER JOIN _hikashop_product AS pp

ON p.product_id = pp.product_parent_id OR p.product_id = pp.product_id

INNER JOIN _hikashop_order_product op

ON pp.product_id=op.product_id

INNER JOIN _hikashop_order o

ON op.order_id=o.order_id

INNER JOIN _hikashop_user u

ON o.order_user_id=u.user_id

INNER JOIN _comprofiler AS cp

ON u.user_cms_id=cp.user_id

WHERE p.product_alias='10' AND o.order_status='confirmed'

Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 8 months ago [\#91148](#91148) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#91148 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

Hi there,

You have to use SELECT product_id, u.user_id (it's an example) instead of SELECT *
You should be able to get only the column you need.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")**
- [![cberry1971's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13211-cberry1971 "View cberry1971's Profile") Topic Author
- [ Offline](/forum/user/13211-cberry1971)

Less More

- Posts: 241
- Thank you received: 5
-
-

13 years 8 months ago [\#91198](#91198) by [cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")  Replied by *[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#91198 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

I understand that I can select specific columns. I would like something dynamic. It would select product_id and then ALL columns which are custom fields for that product id but not other custom fields for other products.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 8 months ago [\#91311](#91311) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#91311 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

Hi,

Like Eliot said, you have to specify what you need with for example:
SELECT p.product_id, pp.parent_product_id, pp.product_id, op.*, ... WHERE ...

And maybe add more conditions in the WHERE.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")**
- [![cberry1971's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13211-cberry1971 "View cberry1971's Profile") Topic Author
- [ Offline](/forum/user/13211-cberry1971)

Less More

- Posts: 241
- Thank you received: 5
-
-

13 years 8 months ago [\#93606](#93606) by [cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")  Replied by *[cberry1971](/forum/user/13211-cberry1971 "View cberry1971's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#93606 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

Is there any update on providing this sort of filtering in the next release? I know it has been on the TODO list.

Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 7 months ago [\#93833](#93833) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#93833 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

It will not be in the next release (2.1.1) which is a bug fix release, but we hope to develop that for the 2.2.0
Regards

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[theweasel68](/forum/user/13135-theweasel68 "View theweasel68's Profile")**
- [![theweasel68's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13135-theweasel68 "View theweasel68's Profile")
- [ Offline](/forum/user/13135-theweasel68)

Less More

- Posts: 48
- Thank you received: 0
-
-

13 years 7 months ago [\#94597](#94597) by [theweasel68](/forum/user/13135-theweasel68 "View theweasel68's Profile")  Replied by *[theweasel68](/forum/user/13135-theweasel68 "View theweasel68's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#94597 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

> Xavier wrote: We have on our todo list to create a new view in the backend to display anything, you will be able to select the kind of things to display, what to display, filter the results with many many filters choice..

Xavier, does this mean, you will add a feature, where all potential custom fields can be added to the front end without deep PHP knowledge? Thx

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

13 years 7 months ago [\#94621](#94621) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Field display](/forum/4-how-to/78322-custom-field-display#94621 "We are a event registration website. We need to provide a display on the front-end (or back-end) for our event organizers. I would ideally like to show in a table format based on product&#95;alias = xxx:  Oreder Number, Product, Customer Name, Customer Email, CUSTOM FIELDS  the last column(s) are the one I am struggling with... I would like to display all CUSTOM FIELDS associated with the product. So if the fields in one of my products asks for &quot;shirt size&quot;, &quot;emergency contact&quot;, &quot;contact phone&quot; then I would like those three columns added to the query.  Thank you. I am having a tough time giving our users (event organizers) easy ways to download (example) how many of each t-shirt size they need to order for their event or who the emergency contacts are for each customer.")*

No.

Xavier was probably referring to our future mass action system which will allow to generate listings of data with filters you would select yourself, being able to select what kind of data to display or do processing on the data filtered. That's a feature which will be added in the backend and it won't meet your requirements.

What you want is really something which will only be used for your specific case of events selling shop with different organizers of events. We can't add that by default in HikaShop. It's really something to be custom developed for you. We've already given advises on how to load the necessary data. All that's left is to display it in your view the way you want. If you know well PHP, that's shouldn't be a problem. Otherwise, I would recommend to find someone to help you with that project via our commercial jobs forum or joomlancers.com

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4MzIyLWN1c3RvbS1maWVsZC1kaXNwbGF5P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.072 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
