John,
Sorry it took that long to respond. But looking at your orginal post, it's unclear whether All items have serial No.'s or not. I assumed they all do since typically Serial no.'s are provided by manufacturers. Otherwise, it's a misnomer which can be misleading.

Once you clear that issue, I can tailor my answer accordingly.