Currently you can filter shop items for "Also in my Collection" and "Also in my Wishlist". While "Also in my Wishlist" makes perfect sense, I would prefer to have a "Not in my Collection" filter. So I can check the contents of the shop without going through all the stuff I already have.

That would be a nice addition indeed!

An interesting request.

I will only add it to individual shops, not the global one -- it would find too many titles.

I tried the SQL tonight and it seems to be working.
=> Will be active when we move to the new server with PHP 8.2 and the new code base.

Note that I found a little discrepancy in the totals.

If shop has 100 items and your "not in collection" is 40, the "in collection" might not be 100 - 40 = 60 but a slightly higher count is you have duplicates in your collection. The duplicates will count multiple times in the matching.

Haven't found an easy fix to that without rewriting the whole SQL query.

Julien

Sounds like a good solution. For the global shop I only use the "In my Whishlist" feature. Everything else has too many results.

Indeed, with the shops inventory bigger than ever, matching a collection to the global inventory makes little sense now.

I'll remove it as well.

Julien