I have an issue where I have some ghost products within a parent product which I cannot delete nor change/use. From 2081 - 2085.
(https://i.imgur.com/5D93oJj.png)
So I tried to look in the db to see if I can find the product ID and delete it, but it cannot be found. :-\
Changing the product via the multivariant gives me the error below (even tried to migrate vendor, update tables,..):
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2081
vmError: You are not an administrator or the correct vendor, storing of product cancelled
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2083
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2082
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2084
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2085
vmError: VmTable #__virtuemart_products_nl_nl Check not passed. Neither slug nor obligatory value at product_name for auto slug creation is given 2109
When I open the product itself and add info like name, alias,... (the required stuff), it saves it with a new ID.
Anyone have an idea how to delete these ID's?
if the pids really don't exist in the product tables then ( is this a migration?) they might be still listed in the product_customfields table for that product
multvars are listed in a json format with the child ids
selectoptions=[
{
"voption": "clabels",
"clabel": "Colour",
"values": "Red\r\nGreen\r\nBlue"
},
{
"voption": "clabels",
"clabel": "Size",
"values": "S\r\nM\r\nL"
}
]|options={
"2071": [
"",
""
],
"2072": [
"Red",
"S"
],
"2073": [
"Red",
"M"
],
"2074": [
"Red",
"L"
],
"2075": [
"Green",
"S"
],
"2076": [
"Green",
"M"
],
"2077": [
"Green",
"L"
],
"2078": [
"Blue",
"S"
],
"2079": [
"Blue",
"M"
],
"2080": [
"Blue",
"L"
]
}|