Query system of what we already bought

We are a multi-brand clothing store and , from season to season, we buy clothes for the following season from suppliers. We need a query system to understand what we ordered in the past. On the basis of the request, then, we will decide whether it will be appropriate to order a particular item or not. Example: 1) We have already ordered 70 gray sweatshirts in size M. 2) When we'll go to make a new order (because we have different brands, i.e. nike adidas etc), we'll want to know how many gray sweatshirts in size M we have already ordered. 3) the system must allow us to question how many gray sweatshirts in size M we have already ordered and give me the result: 70. The result should also be accompanied by the photos we make to each individual item. Example: 1) Once the system returns me 70 as a result, we need to be able to browse through these 70 pics. We have both the data of the orders already made (grey, sweatshirt, size M), and the photos. I need to put all this together.