[Skip to main content](#vessel-content) # How to Manage Characteristics of a product ## - **[hemant](/forum/user/13902-hemant "View hemant's Profile")** - [![hemant's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13902-hemant "View hemant's Profile") Topic Author - [ Offline](/forum/user/13902-hemant) Less More - Posts: 4 - Thank you received: 0 - - 13 years 8 months ago [\#91422](#91422) by [hemant](/forum/user/13902-hemant "View hemant's Profile") *[How to Manage Characteristics of a product](/forum/4-how-to/78622-how-to-manage-characteristics-of-a-product#91422 "Hello, i am writting a code to insert Characteristics in hikashop table. suppose we have to varient Size: S M L color: red green blue i want to add this for a product. i am not using the joomla funtion or hikashop function. please tell me how to add varient for this product.")* was created by *[hemant](/forum/user/13902-hemant "View hemant's Profile")* Hello, i am writting a code to insert Characteristics in hikashop table. suppose we have to varient Size: S M L color: red green blue i want to add this for a product. i am not using the joomla funtion or hikashop function. please tell me how to add varient for this product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4NjIyLWhvdy10by1tYW5hZ2UtY2hhcmFjdGVyaXN0aWNzLW9mLWEtcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[winchester](/forum/user/6696-winchester "View winchester's Profile")** - [![winchester's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6696.jpg)](/forum/user/6696-winchester "View winchester's Profile") - [ Offline](/forum/user/6696-winchester) Less More - Posts: 14 - Thank you received: 4 - - - 13 years 8 months ago [\#91447](#91447) by [winchester](/forum/user/6696-winchester "View winchester's Profile") Replied by *[winchester](/forum/user/6696-winchester "View winchester's Profile")* on topic *[How to Manage Characteristics of a product](/forum/4-how-to/78622-how-to-manage-characteristics-of-a-product#91447 "Hello, i am writting a code to insert Characteristics in hikashop table. suppose we have to varient Size: S M L color: red green blue i want to add this for a product. i am not using the joomla funtion or hikashop function. please tell me how to add varient for this product.")* Let me get this straight... You are writing a script/code to create the Characteristics for a product by inserting directly into the HikaShop MySQL tables. Is this correct? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4NjIyLWhvdy10by1tYW5hZ2UtY2hhcmFjdGVyaXN0aWNzLW9mLWEtcHJvZHVjdD90bXBsPW1hcmtkb3du) 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: 86316 - Thank you received: 14276 - - 13 years 8 months ago [\#91617](#91617) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to Manage Characteristics of a product](/forum/4-how-to/78622-how-to-manage-characteristics-of-a-product#91617 "Hello, i am writting a code to insert Characteristics in hikashop table. suppose we have to varient Size: S M L color: red green blue i want to add this for a product. i am not using the joomla funtion or hikashop function. please tell me how to add varient for this product.")* That's quite complex. First, if the characteristic data is not in the hikashop_characteristic table, you need to add it there. Then, you need to link the characteristic and the value to the product via the hikashop_variant table. Then, you need to create one variant for each combination of values in the hikashop_product table (with the product_parent_id being the id of the main product. Finally, you need to link each characteristic value to the corresponding variants in hikashop_product via the hikashop_variant table. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4NjIyLWhvdy10by1tYW5hZ2UtY2hhcmFjdGVyaXN0aWNzLW9mLWEtcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hemant](/forum/user/13902-hemant "View hemant's Profile")** - [![hemant's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13902-hemant "View hemant's Profile") Topic Author - [ Offline](/forum/user/13902-hemant) Less More - Posts: 4 - Thank you received: 0 - - 13 years 8 months ago [\#91628](#91628) by [hemant](/forum/user/13902-hemant "View hemant's Profile") Replied by *[hemant](/forum/user/13902-hemant "View hemant's Profile")* on topic *[How to Manage Characteristics of a product](/forum/4-how-to/78622-how-to-manage-characteristics-of-a-product#91628 "Hello, i am writting a code to insert Characteristics in hikashop table. suppose we have to varient Size: S M L color: red green blue i want to add this for a product. i am not using the joomla funtion or hikashop function. please tell me how to add varient for this product.")* Hello winchester, ya you are right.. that is i want to do. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4NjIyLWhvdy10by1tYW5hZ2UtY2hhcmFjdGVyaXN0aWNzLW9mLWEtcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[hemant](/forum/user/13902-hemant "View hemant's Profile")** - [![hemant's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13902-hemant "View hemant's Profile") Topic Author - [ Offline](/forum/user/13902-hemant) Less More - Posts: 4 - Thank you received: 0 - - 13 years 8 months ago [\#91630](#91630) by [hemant](/forum/user/13902-hemant "View hemant's Profile") Replied by *[hemant](/forum/user/13902-hemant "View hemant's Profile")* on topic *[How to Manage Characteristics of a product](/forum/4-how-to/78622-how-to-manage-characteristics-of-a-product#91630 "Hello, i am writting a code to insert Characteristics in hikashop table. suppose we have to varient Size: S M L color: red green blue i want to add this for a product. i am not using the joomla funtion or hikashop function. please tell me how to add varient for this product.")* Hello nicolas, Thanks for your reply. i have done it same as you have mentioned. but i am not deleting records from hikashop_product & hikashop_variant table. as you delete the previous entry when any new characteristic are added. if i don't delete the records, there will be any problem in future ? Thanks Hemant Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4NjIyLWhvdy10by1tYW5hZ2UtY2hhcmFjdGVyaXN0aWNzLW9mLWEtcHJvZHVjdD90bXBsPW1hcmtkb3du) 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: 86316 - Thank you received: 14276 - - 13 years 8 months ago [\#91780](#91780) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to Manage Characteristics of a product](/forum/4-how-to/78622-how-to-manage-characteristics-of-a-product#91780 "Hello, i am writting a code to insert Characteristics in hikashop table. suppose we have to varient Size: S M L color: red green blue i want to add this for a product. i am not using the joomla funtion or hikashop function. please tell me how to add varient for this product.")* Hi, I'm not following you ? I never talked about deleting anything. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc4NjIyLWhvdy10by1tYW5hZ2UtY2hhcmFjdGVyaXN0aWNzLW9mLWEtcHJvZHVjdD90bXBsPW1hcmtkb3du) 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.118 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)