Batch entry of new inventory items
I have my database set up so that one sku matches one title. I want to set it up so that I have a parent sku - for the title - and a child sku for each individual copy. I want to set it up so that if I enter one hundred copies of the same title that I only have to enter the details about one title and that it is duplicated 100 times to make one hundred new records - each one with a different child sku but the same parent sku.
Should I make the child sku be a unique number each time? Or could this lead to huge numbers?
How can I get the database to make one hundred records for each individual copy of the title?