Forum

The forum is a free service supported by community members. Please consider opening a support ticket if you need timely help.

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09 Dec 2019 10:09 PM by  Steve L
orphan records
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages


Basic Member


Posts:281
Basic Member


--
09 Dec 2019 02:11 PM

    Hi Stephen,

    I have found some orphan records in the prductvariant and productvariantgroup tables.
    Is it ok to delete thes records direct in sql or is it better to to this with the "d" options in import upload.

    Regards, Ton

    0


    Veteran Member


    Posts:2955
    Veteran Member


    --
    09 Dec 2019 10:09 PM

    I suggest you just delete using the Import action. You should not have any orphan variants since there is a foreign key tied to a product (unbreakable).

    0
    You are not authorized to post a reply.