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

#   Change column name?

##

- **[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")**
- [![Lumiga's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31479.png)](/forum/user/31479-lumiga "View Lumiga's Profile") Topic Author
- [ Offline](/forum/user/31479-lumiga)

Less More

- Posts: 637
- Thank you received: 26
-
-
-

1 year 1 month ago [\#368923](#368923) by [Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")  *[Change column name?](/forum/25-install-update/909782-change-column-name#368923 "-- HikaShop version -- : 6.1.0 -- Joomla version -- : 5.3.4  Hi Hikashop team,  Is it possible to safely change the column name directly in the database, or would it be better to delete it and create a new one? I’m going to have a lot of custom fields later on, so clear naming is important to keep them organized. That’s why I’d like to change it. ;-)")* was created by *[Lumiga](/forum/user/31479-lumiga "View Lumiga's Profile")*

-- HikaShop version -- : 6.1.0
-- Joomla version -- : 5.3.4

Hi Hikashop team,

Is it possible to safely change the column name directly in the database, or would it be better to delete it and create a new one? I’m going to have a lot of custom fields later on, so clear naming is important to keep them organized. That’s why I’d like to change it. ![;-)](/media/kunena/emoticons/24.png ";-)")

[ ![screenshot-28.png](/forum/attachment/60885) ](/forum/attachment/60885 "screenshot-28.png")

---

Kind regards,
Lumiga

- [ ![screenshot-28.png](/forum/attachment/60885) ](/forum/attachment/60885 "screenshot-28.png") [ ](/forum/attachment/60885?download=1 "screenshot-28.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwOTc4Mi1jaGFuZ2UtY29sdW1uLW5hbWU/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86363
- Thank you received: 14296
-
-

1 year 1 month ago [\#368927](#368927) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change column name?](/forum/25-install-update/909782-change-column-name#368927 "-- HikaShop version -- : 6.1.0 -- Joomla version -- : 5.3.4  Hi Hikashop team,  Is it possible to safely change the column name directly in the database, or would it be better to delete it and create a new one? I’m going to have a lot of custom fields later on, so clear naming is important to keep them organized. That’s why I’d like to change it. ;-)")*

Hi,

Changing the name in the database is possible. However, you need to change both the field_namekey in the hikashop_field table and the name of the actual column of the custom field in the destination table(s).
Since your field is of the type "item" with the column name "shape", you want to edit the name of the "shape" column in both the hikashop_cart_product and the hikashop_order_product tables.

But yes, you can also delete the field and recreate it with the new column name.

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

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