I'm selling digital products that each need a unique serial number to be registered within a software.
Currently I have these serials stored in a spreadsheet.
Does anyone know of a way to manage the allocation of these serials within Shopify?
Ideally — on order completion of a specific product — I need a serial to be allocated, sent out within the order confirmation email, struck off in the database so it doesn't get allocated again, and the database to be updated to show which customer the serial was allocated to.
I'd also need to be able to have different serial banks for different products.