Generate unique IDs and issue them to customers.
Generate & Issue IDs View inventory
MariaDB 10.11+ / PHP PDO