Help with Brickstore or alternative software suggestions please

[Plumber]

I have a large project on the go and build sections in Studio,  not being the sharpest tool in the box I often make daft mistakes in Studio which just don't work in real bricks, so I design in Studio then build IRL to check, then modify the Studio model with any alterations needed (often multiple cycles)

These 'check builds can be done with any bricks I already have regardless of colour so I can make alterations before making BL orders that turn out un-needed

I recently spent some considerable time and effort to catalogue all my parts into a Brickstore database along with their locations in a new storage system.

The idea of the database was that I would down/upload the Studio model parts list into Brickstore and compare the uploaded model list with parts in main inventory to show if I have the parts needed in any colour and to have the locations (comments and remarks).

So tried this for first time today and it seems that Brickstore is not capable of this colour agnostic manoeuvre  It seems that if a field is not in the 'Edit/Copy Values...' dialogue then its value MUST be a match.

I can get parts quantities on hand and quantities short for order but only if all fields of the part record match i.e. colour (as well as status, condition etc). It seems my only option is to make a copy of my inventory and set both files with all parts colour N/A gives me locations for picking but no quantities on hand/needed which I would have to note down as picking or run a separate data merge from start.

So is it me? I'm not very IT literate so am hoping I've missed something obvious?

I imagined many people would check build in colour vomit before committing to large BL orders and therefore do something akin to what I am trying?

Assuming Brickstore cannot do this for me is there another way?  Can it be done in Bricklink? In conjunction with BL? I'm not a seller but I do have a 'closed' store as it seems to be the only way to obtain a key for BL/BS synchronisation.

 

 

 

[JesseNight]

I have never used BrickStore myself so I can't say much about it. Personally I find the Rebrickable website pretty convenient to catalogue my stuff simply by adding all the sets I own. It has a good comparing tool too, intended for people to see what they're missing to build custom MOCs but it can be used to compare any sets, MOCs, or your own collection or custom list.
I haven't gone much further than that, but I think you can easily make a custom list from missing parts to export to Bricklink for example.