This is the template we use at TCB for keeping track of SKUs we have for all our inventory.
PRODUCT SKUs
This tab is where we keep all the SKUs for the physical products we sell, You will see a RAW Material section. This is the SKU the product gets before we press any design on it. Once we press the design, it becomes a finished product and we add a decimal and the design number at the end of the SKU.
COLOR FINISH KEY
The color/finish key is where we keep track of all the colors and finishes we have for all the products we offer. On the Raw Material SKU, the dash followed by the two numbers is the color & finish. This is how we can easily tell if it's white and glossy, matte, or shimmer, etc.
DESIGN KEY
Every time we add a new design to our shop, it gets assigned a number. This is how we know what number to add to the end of the Raw Material SKU once it has been pressed.
NOTE: We ONLY move inventory from RAW MATERIAL to FINISHED GOODS when we make extras to have on hand for shows, ready to ship, etc.
This is a simple template that you will likely need to build out to fit all your products/needs
Inventory Software We Use >> https://www.inflowinventory.com