So I own a screen printing and embroidery biz and i’m tinkering around with making my own software to make life a little easier. New to bubble so bare with me.
Just need some direction on setting up the database. As you can see I have your typical invoice, but from here i’d like to be able to click the add garment link to pop up the add a product image you see. In here is where I would like to search for a model number and have it populate what colors and sizes are available in this particular model number. Once I have entered in how many of each size it will essentially take that row that has quantities and add it to my invoice which from there I can then calculate a price.
What confuses me the most besides it all is that for example the 29M model number is available in black in sizes S, M, L, XL as shown in the image below, but then the color ASH is available in S, M, L, XL, XXL, 3XL … I need to populate my Add a product pop up with those inputs so I know that that particular color is available in say a XXL or not.
Below is the csv file from my supplier of all the items I can hopefully import one day. Do I just replicate my database after this?