store individual inventory items in a table, how to assign them correctly

[S Ahmed]

Say I have 100 products in inventory, instead of having a counter I want to
create 100 rows per inventory item.

When someone purchases a product, how can I correctly assign that customer
a product from inventory without having any race conditions etc?

Thanks.