Sounds like you need one table for products and a related table (linked by productID) of product serial numbers.
You can then log in and track serial numbers with this related table.
A script can then be written that takes either the starting and ending serial number or the starting serial number and the number of items and creates new records in this related table.
Interesting concept. I will definately put some thought into that this weekend. Thanks for the suggestion, I do appreciate it!