[Skip to main content](#vessel-content) # How to change id of variant values? ## - **[Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile")** - [![Lemon Tree's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9739-lemon-tree "View Lemon Tree's Profile") Topic Author - [ Offline](/forum/user/9739-lemon-tree) Less More - Posts: 23 - Thank you received: 0 - - 13 years 10 months ago [\#82305](#82305) by [Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile") *[How to change id of variant values?](/forum/2-general-talk-about-hikashop/76814-how-to-change-id-of-variant-values#82305 "I have created a characteristic called "Paperback or Hardcover", with 2 values: * Paperback * Hardcover The values have been given an ID of 4 and 5, and this gets appended to the product ID. I would like to change "4" and "5" to something more meaningful such as "P" and "H". Can I do this (by editting the database perhaps), and if I do, will it break anything? Or do I have to live with "4" and "5"?")* was created by *[Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile")* I have created a characteristic called "Paperback or Hardcover", with 2 values: 1. Paperback 2. Hardcover The values have been given an ID of 4 and 5, and this gets appended to the product ID. I would like to change "4" and "5" to something more meaningful such as "P" and "H". Can I do this (by editting the database perhaps), and if I do, will it break anything? Or do I have to live with "4" and "5"? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2ODE0LWhvdy10by1jaGFuZ2UtaWQtb2YtdmFyaWFudC12YWx1ZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 10 months ago [\#82348](#82348) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[How to change id of variant values?](/forum/2-general-talk-about-hikashop/76814-how-to-change-id-of-variant-values#82348 "I have created a characteristic called "Paperback or Hardcover", with 2 values: * Paperback * Hardcover The values have been given an ID of 4 and 5, and this gets appended to the product ID. I would like to change "4" and "5" to something more meaningful such as "P" and "H". Can I do this (by editting the database perhaps), and if I do, will it break anything? Or do I have to live with "4" and "5"?")* Hi, I think that would be wise to **let your variants id like that** because : - Your product's id are used by the **Hikashop System** - You won't be able to change your products id with something like "P" because every id have to be an **integer**. - .. Hope this will help you. The following user(s) said Thank You: [Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2ODE0LWhvdy10by1jaGFuZ2UtaWQtb2YtdmFyaWFudC12YWx1ZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile")** - [![Lemon Tree's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9739-lemon-tree "View Lemon Tree's Profile") Topic Author - [ Offline](/forum/user/9739-lemon-tree) Less More - Posts: 23 - Thank you received: 0 - - 13 years 10 months ago - 13 years 10 months ago [\#82512](#82512) by [Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile") Replied by *[Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile")* on topic *[How to change id of variant values?](/forum/2-general-talk-about-hikashop/76814-how-to-change-id-of-variant-values#82512 "I have created a characteristic called "Paperback or Hardcover", with 2 values: * Paperback * Hardcover The values have been given an ID of 4 and 5, and this gets appended to the product ID. I would like to change "4" and "5" to something more meaningful such as "P" and "H". Can I do this (by editting the database perhaps), and if I do, will it break anything? Or do I have to live with "4" and "5"?")* > Mohamed Thelji wrote: Hi, > > I think that would be wise to **let your variants id like that** because : > \- Your product's id are used by the **Hikashop System** > \- You won't be able to change your products id with something like "P" because every id have to be an **integer**. > \- .. > > Hope this will help you. Thanks, Mohamed Thelji. Yes, it does help. I learned the hard way not to change the variant ID's manually, because I lost them and had to recreate them :S Last edit: 13 years 10 months ago by [Lemon Tree](/forum/user/9739-lemon-tree "View Lemon Tree's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2ODE0LWhvdy10by1jaGFuZ2UtaWQtb2YtdmFyaWFudC12YWx1ZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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.126 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)