[Skip to main content](#vessel-content) # Deleted variant keeps showing itself. ## - **[akooring](/forum/user/36601-akooring "View akooring's Profile")** - [![akooring's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36601-akooring "View akooring's Profile") Topic Author - [ Offline](/forum/user/36601-akooring) Less More - Posts: 3 - Thank you received: 0 - - 11 years 6 months ago - 11 years 6 months ago [\#197358](#197358) by [akooring](/forum/user/36601-akooring "View akooring's Profile") *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#197358 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* was created by *[akooring](/forum/user/36601-akooring "View akooring's Profile")* -- url of the page with the problem -- : [ www.elsenique.com](http://www.elsenique.com) -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever? Last edit: 11 years 6 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Reason: remove duplicate content Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 6 months ago [\#197379](#197379) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#197379 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* Hi, Deleted variants are deleted. However, the system will display the choice in the characteristic dropdown if it is needed for another variant. For example, if you have two characteristics: color (red and blue) and size (M and L). If you remove the blue L variant, it will still be selectable in the dropdowns on the product page as L is necessary for the red L variant and blue is necessary for the blue M variants. Now I don't know your specifics, so it might be something else. In that case, please describe precisely the problem and how you setup your product/variants and provide a link to it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[akooring](/forum/user/36601-akooring "View akooring's Profile")** - [![akooring's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36601-akooring "View akooring's Profile") Topic Author - [ Offline](/forum/user/36601-akooring) Less More - Posts: 3 - Thank you received: 0 - - 11 years 6 months ago [\#197431](#197431) by [akooring](/forum/user/36601-akooring "View akooring's Profile") Replied by *[akooring](/forum/user/36601-akooring "View akooring's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#197431 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* Thank you for responding. More specific to my problem is that I only want to show one variant. That is a variant for resizing. I tried one variant but I was not happy about the result so a made another one. The second one showed the things I wanted. I deleted the first one and the website was working with only one variant. However the deleted first variant is still showing on the product page, with empty fields. I managed to figure out with firebug that is the deleted first variant. I re checked but in the configuration of hikashop there only one variant remaining. It looks like the deleted variant is somewhere in the cache of hikashop. In joomla I wiped out the cache and empty the recycle bin. I am still stuck with this 'ghostly' variant on my product page. Example found here; [ elsenique.com/halssieraden/blauw-groen/product/226-141060-](http://elsenique.com/halssieraden/blauw-groen/product/226-141060-) Best regards Arie Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 6 months ago [\#197454](#197454) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#197454 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* Hi, You're talking about a characteristic, not a variant. Remove all the characteristics from your product, save the product, and add the characteristic you want again to the product and save it again. The system should then regenerate properly the variants of the product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[akooring](/forum/user/36601-akooring "View akooring's Profile")** - [![akooring's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36601-akooring "View akooring's Profile") Topic Author - [ Offline](/forum/user/36601-akooring) Less More - Posts: 3 - Thank you received: 0 - - 11 years 6 months ago [\#197627](#197627) by [akooring](/forum/user/36601-akooring "View akooring's Profile") Replied by *[akooring](/forum/user/36601-akooring "View akooring's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#197627 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* Okay that is the trick! Thank you Nicolas, great help. Best regards Arie Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")** - [![Cynthia-V's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") - [ Offline](/forum/user/36823-cynthia-v) Less More - Posts: 22 - Thank you received: 2 - - 11 years 6 months ago - 11 years 6 months ago [\#198062](#198062) by [Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") Replied by *[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#198062 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* I removed characteristics from the product and from product>characteristics, but still the dropdown field shows. Hikashop Business 2.4.0, Joomla 3.3.1, PHP 5.3.28, MySQL 5.5.39 URL: [ www.groentjecider.nl/index.php/webshop/product/3-flevocider](http://www.groentjecider.nl/index.php/webshop/product/3-flevocider) [ ![characteristics.png](/forum/attachment/23679) ](/forum/attachment/23679 "...cteristics.png") - [ ![characteristics.png](/forum/attachment/23679) ](/forum/attachment/23679 "...cteristics.png") [ ](/forum/attachment/23679?download=1 "...cteristics.png") Last edit: 11 years 6 months ago by [Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198067](#198067) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#198067 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* Hi, It looks like you still have something in your database which link the product with a characteristic (which does not exist anymore). Can you please check in your database, for the table "hikashop_variant" if you have some entries for the "variant_product_id = 3". If so, you have to delete them in order to clean the database. I created a ticket in order to see to reproduce your issue. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")** - [![Cynthia-V's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") - [ Offline](/forum/user/36823-cynthia-v) Less More - Posts: 22 - Thank you received: 2 - - 11 years 6 months ago [\#198176](#198176) by [Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") Replied by *[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#198176 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* Hi Jerome, I checked the database but cannot find a variant with id 3. Screenshot below shows all the values. [ ![product_variants.png](/forum/attachment/23692) ](/forum/attachment/23692 "...t_variants.png") Best regards, Cynthia - [ ![product_variants.png](/forum/attachment/23692) ](/forum/attachment/23692 "...t_variants.png") [ ](/forum/attachment/23692?download=1 "...t_variants.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198180](#198180) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Deleted variant keeps showing itself.](/forum/26-product-category-display/876172-deleted-variant-keeps-showing-itself#198180 "-- url of the page with the problem -- : www.elsenique.com -- HikaShop version -- : Business -- Joomla version -- : 3.4 Hikashop keeps showing a deleted variant in my products. The variant is empty but i found out that it is refering to a deleted variant 'size'. Is there a way to wipe out this variant forever?")* Hi, Okay, but I see that you have entries with the "variant_characteristic_id" empty ( 0 ). It is not a valid value for the variant so I'm wondering how you got this. If you still have the issue without these entries ; some access to your website will be required in order to perform some tests and understand why the loading of your product return an empty characteristic. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzYxNzItZGVsZXRlZC12YXJpYW50LWtlZXBzLXNob3dpbmctaXRzZWxmP3RtcGw9bWFya2Rvd24=) 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.286 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)