Google Sheets as database. Design advice

[NicMarshallBBT]

Hi all,

I hope this is ok/relevant to post here as I attempt to reach out for advice.

I'm totally self taught database and inventory manager and am scratching my head over how to manage kits we're now selling. Has anyone else gone through this? Is there a best practice?

For example say I'm making and selling

• Product A: sunglasses
• Product B: sun hat
• Kit A: Sunglasses + Hat

I have serial numbers for each product and a system to record and therefore track their status. On individual items this works great, but I'm unsure how to transfer this up to a Kit. At the moment we're just recording the individual status per product, putting notes in for each product that its sold as a kit. Lots of repetition and feels obviously wrong.

I could just create a sheet listing all Kits (I guess this would be a SKU list?). But the kits are custom and a SKU number is only generated on sale, rather than manufacture. I can train my sales person in this but I'm unsure and reaching out to forums.

Thanks in advance, and again, I hope this is ok to post here.