Bulk Assign/Edit Collections....? Need to check and correct collections for 8000+ products?

Hello all thanks for any help!

I have over 8000 products and I need to fix the collections some of them are listed in.

I know I can add a “collections” field to the CSV and assign collections that way but that doesn’t necessarily help me because I would have to do it individually for 8000+ listings. I don’t really have a way to sort my products to assign collections that way, it would be doing it manually for each one. Really what I’m trying to do is just fix some of the products that are in the wrong collections not necessarily assign new collections for all of them as most of them are in the correct collection.

What I would like to do is perhaps be able to download a CSV that has all my collections listed for each product, some belong to more than one collection actually, fix the incorrect collections and then upload it.

Unfortunately I’m not seeing any option to do that, from what I’m seeing it looks like I’m stuck scrolling through my collections individually one page at a time a correcting whichever ones are incorrect manually.

Does anyone have a better way to go about doing this?

Thank you!

Anyone?? thanks!