Serial Number on Admin Page

We are a music store (www.tapestrymusic.com) and use a bulk quantity update extension to adjust our quantities to match with our POS using comma delimited files. We are currently only able to update unserialized items and wanted to know if there was a module to add individual serial numbers to products so when we do a bulk update it will automatically update those items as well.

Cheers!

I'm not sure if there's a module, but this can be done with some relatively simple php/sql. Are the serial numbers preset or can they be random? I'd be happy to give you some code to set random serial numbers (with a defined style, i.e. all 6 digit #'s, etc)

Presumably nowadays every distinguishable product arrives with its own barcode, and presumably you already can scan barcodes. Numbers are numbers, in this instance they need only be unique relative to distinguishable products. That leaves sucking them into a field (column) aligned with another field (column) occupied by product identities. You can, for example, stack 'em, type 'em, scan 'em, and by hitting Enter suck 'em, one by one, perhaps two to five per minute offset by need to stop for sake of your sanity and not making mistakes.

Coupling that with code to help suck 'em in would probably elevate the rate of flow.