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

#   how to insert new columns in the products table?

##

- **[makles](/forum/user/2685-makles "View makles's Profile")**
- [![makles's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2685.JPG)](/forum/user/2685-makles "View makles's Profile") Topic Author
- [ Offline](/forum/user/2685-makles)

Less More

- Posts: 17
- Thank you received: 0
-
-

15 years 5 months ago [\#17425](#17425) by [makles](/forum/user/2685-makles "View makles's Profile")  *[how to insert new columns in the products table?](/forum/4-how-to/17425-how-to-insert-new-columns-in-the-products-table#17425 "Hi,  I read a lot around the forum but I didn't find what I need.  I'd like to insert new columns in this table:  I want to insert a region where a product come from, the category of the products and a link to the manufacturer. So 3 new columns editable from backend.  I created a custom field of the table &quot;product&quot; via the menu Display-&gt;Custom fields. But this added just the new fields in the product details page.  How can I do what I wish?  Thanks  HikaShop Essential 1.5.0")* was created by *[makles](/forum/user/2685-makles "View makles's Profile")*

Hi,

I read a lot around the forum but I didn't find what I need.

I'd like to insert new columns in this table:

[ ](http://www.spizzicando.com/index.php?option=com_hikashop&ctrl=category&task=listing&cid=10&name=vini&Itemid=160)[ www.spizzicando.com/index.php?option=com...name=vini&amp;Itemid=160](http://www.spizzicando.com/index.php?option=com_hikashop&ctrl=category&task=listing&cid=10&name=vini&Itemid=160)

I want to insert a region where a product come from, the category of the products and a link to the manufacturer. So 3 new columns editable from backend.

I created a custom field of the table "product" via the menu Display-&gt;Custom fields. But this added just the new fields in the product details page.

How can I do what I wish?

Thanks

HikaShop Essential 1.5.0

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE3NDI1LWhvdy10by1pbnNlcnQtbmV3LWNvbHVtbnMtaW4tdGhlLXByb2R1Y3RzLXRhYmxlP3RtcGw9bWFya2Rvd24=) 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: 86561
- Thank you received: 14307
-
-

15 years 5 months ago [\#17426](#17426) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to insert new columns in the products table?](/forum/4-how-to/17425-how-to-insert-new-columns-in-the-products-table#17426 "Hi,  I read a lot around the forum but I didn't find what I need.  I'd like to insert new columns in this table:  I want to insert a region where a product come from, the category of the products and a link to the manufacturer. So 3 new columns editable from backend.  I created a custom field of the table &quot;product&quot; via the menu Display-&gt;Custom fields. But this added just the new fields in the product details page.  How can I do what I wish?  Thanks  HikaShop Essential 1.5.0")*

You need to go in the menu Display-&gt;Views and edit the file listing_table of the view product. There, you will be able to add new columns and echo the data of your products custom fields in these columns.

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

- **[makles](/forum/user/2685-makles "View makles's Profile")**
- [![makles's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2685.JPG)](/forum/user/2685-makles "View makles's Profile") Topic Author
- [ Offline](/forum/user/2685-makles)

Less More

- Posts: 17
- Thank you received: 0
-
-

15 years 5 months ago [\#17482](#17482) by [makles](/forum/user/2685-makles "View makles's Profile")  Replied by *[makles](/forum/user/2685-makles "View makles's Profile")* on topic *[Re: how to insert new columns in the products table?](/forum/4-how-to/17425-how-to-insert-new-columns-in-the-products-table#17482 "Hi,  I read a lot around the forum but I didn't find what I need.  I'd like to insert new columns in this table:  I want to insert a region where a product come from, the category of the products and a link to the manufacturer. So 3 new columns editable from backend.  I created a custom field of the table &quot;product&quot; via the menu Display-&gt;Custom fields. But this added just the new fields in the product details page.  How can I do what I wish?  Thanks  HikaShop Essential 1.5.0")*

Thanks for the tip.

My knowledge of php and html is really poor. I tried to insert a new column (named "categoria"), writing this lines:

&lt;?php } ?&gt;
&lt;th class="hikashop_product_categoria" align="center"&gt;
&lt;?php echo JText::_(CATEGORIA);?&gt;
&lt;/th&gt;

what is wrong with that?

Thanks

HikaShop Essential 1.5.0

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE3NDI1LWhvdy10by1pbnNlcnQtbmV3LWNvbHVtbnMtaW4tdGhlLXByb2R1Y3RzLXRhYmxlP3RtcGw9bWFya2Rvd24=) 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: 86561
- Thank you received: 14307
-
-

15 years 5 months ago [\#17484](#17484) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to insert new columns in the products table?](/forum/4-how-to/17425-how-to-insert-new-columns-in-the-products-table#17484 "Hi,  I read a lot around the forum but I didn't find what I need.  I'd like to insert new columns in this table:  I want to insert a region where a product come from, the category of the products and a link to the manufacturer. So 3 new columns editable from backend.  I created a custom field of the table &quot;product&quot; via the menu Display-&gt;Custom fields. But this added just the new fields in the product details page.  How can I do what I wish?  Thanks  HikaShop Essential 1.5.0")*

You should not add the line &lt;?php } ?&gt;
Also, that will just display the column header.
You also need to add some code few lines below in the foreach in order to display the data of that column for each product:
&lt;td class="hikashop_product_categoria_row"&gt;
&lt;?php echo $this-&gt;row-&gt;categoria; ?&gt;
&lt;/td&gt;

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

- **[makles](/forum/user/2685-makles "View makles's Profile")**
- [![makles's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2685.JPG)](/forum/user/2685-makles "View makles's Profile") Topic Author
- [ Offline](/forum/user/2685-makles)

Less More

- Posts: 17
- Thank you received: 0
-
-

15 years 5 months ago [\#17488](#17488) by [makles](/forum/user/2685-makles "View makles's Profile")  Replied by *[makles](/forum/user/2685-makles "View makles's Profile")* on topic *[Re: how to insert new columns in the products table?](/forum/4-how-to/17425-how-to-insert-new-columns-in-the-products-table#17488 "Hi,  I read a lot around the forum but I didn't find what I need.  I'd like to insert new columns in this table:  I want to insert a region where a product come from, the category of the products and a link to the manufacturer. So 3 new columns editable from backend.  I created a custom field of the table &quot;product&quot; via the menu Display-&gt;Custom fields. But this added just the new fields in the product details page.  How can I do what I wish?  Thanks  HikaShop Essential 1.5.0")*

It works! (obiousvly)

Thanks a lot for the mini html lesson nicolas! ![:P](/media/kunena/emoticons/14.png ":P")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE3NDI1LWhvdy10by1pbnNlcnQtbmV3LWNvbHVtbnMtaW4tdGhlLXByb2R1Y3RzLXRhYmxlP3RtcGw9bWFya2Rvd24=) 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.074 seconds

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