How to achieve indoor Autonomous DIY Drone with APM 2.8 (without GPS)

Just to be clear: is this a flying or wheeled drone? I know it's commonly used for flying ones but that's not necessarily the case.

Modulated LEDs will help a lot with navigation indeed.

The hard part is counting inventory. How are you going to look in boxes? Or see whether there's a second layer of boxes behind it? That at least are normal warehouse arrangements. RFID doesn't get that far.