How make queries for custom development

I plan to implement item-level RFID tagging using stickers for my entire inventory, similar to the system utilized by retailers such as Miniso. The objective is to ensure that sold items pass through security gates without incident, while unsold items trigger an alert.