Deleting products with linked documents in Sanity Studio

Hi guys,
Yesterday I tryed shopify connect with sanity, and I removed the store and token but now I get this when I try to delete some of the products. How can resolve this?

You are trying to delete a document which is referenced by 2 other documents, which is not possible for security reasons. Open these documents in the studio, and remove the reference to the document you are trying to delete.

This is what the error message is telling you.

It can't be, There is no document with that ref ???

It is not even connected with shopify anymore

This has nothing to do with Shopify I'm afraid. It's about linked documents in your studio, as the dialog and the error indicate.

well how do I remove a reference? in my studio it looks like this:

Errr, do you have other document types? Like pages or something maybe? Or do you only have products?

No only products at this point

I found this

is there a media library somewhere I can acces ?

There is a plugin for it yes: https://www.sanity.io/plugins/sanity-plugin-media-library

media library gives me errors

and I still dont know how to fix the ref error

this is what I get when I click on the img Ref

the document with

_id

:

e1887e01-fd78-9a12-67fccbc43372

needs to be deleted in order to delete the product you are trying to delete. 🙂 In order to get all documents that have references you can put the following query into vision:

*[]{_id, title , "references":*[ references(^._id)]}[length(references)>0]

If the studio crashes when you attempt to access them with the GUI, you might have to delete them with a script instead. Is there any particular reason you want to delete these products or are you simply attempting to learn more about Sanity?

You might not have to delete the document with that

_id

, but you would need to unset the reference. In practical terms this means finding the links to other documents and deleting the links in the studio.

I hooked Shopify to it and it added some products to my studio that didnt go as planned and so I disconnected it but the ref is still there for some reason. I just put that query you gave me in vision and its not crashing. but I need to clean it up so I can add my own files.

I cant remove the files and it enoys me

This is a real problem if you cant remove it in the studio

the data is still in the back but you just cant reach it

nvm I deleted the whole dataset