Tips for Checking Database Accuracy?

Has anyone found a good way to check if your database is correct, an inventory I suppose? I got kinda behind on keeping up for a while and I think it’s mostly correct but I worry some editions may be wrong etc. I have almost 4000 comics so like I don’t love the idea of scanning them all again but it also seems better than manually checking every comic. I considered doing a full export, deleting the database and rescanning everything so then I can compare exports but that feels extreme too. Putting this in general because the concept is really the same across the products so any thoughts welcome.

I did what you mention (Export, rescan and compare) but for my video game collection.
I found more than enough to make it worth it.
In addition i also added “condition” to all games, assisted the team to fix issues in the DB ++.
All in all i’m glad i did it, but it took a lot of time.

Not sure if it is any other way to do so. other than pick 100-300 ish random comics and see if they are correctly added.

1 Like

There is indeed no “inventory check” system.

It has been on our ideas list for years, but never made the cut (yet).

What would you expect from such a screen or system? Would you want to like “scan all items” again, and just “see” if they’re in your collection?

What would such a screen do if we made a feature out of it for you?

I think the ideal would be to have an almost temporary collection that you scan items into. Then you choose a comparison method, is this supposed to be the entire collection or are you inventorying a certain box. Then depending which option you did it gives you a comparison. So entire collection it would give you a break down of what you inventoried that wasn’t in the collection with options to add it, and what was in the collection but not the inventory with options to remove or maybe add a missing tag, etc. If you’re comparing by location it gives you that information but also the option to move things to that location that werent already tagged there and move things that did have that location but werent inventoried to a blank location. Then a last inventoried field that updates for each item that was scanned. So you can also filter look for things that haven’t had hands put on them recently, helpful if you’re not doing the whole collection at once. People who have to inventory things for a living might have better ideas than me.

1 Like

Thank you.

Right now in the Add screen if you scan an item, it will show up in “blue” if it is already in your collection. It doesn’t update some form of “touched” date though, as that doesn’t exist - but just thought this might come in handy for now as a workaround.