I’ve been spending all week looking at Airtable and trying out options. I’m very impressed and excited to use its features. I’m also impressed with this forum. Many knowledgeable people here.
I am needing some help and I think those more experienced might be able to point me in the right direction. I don’t mind putting in the hard work and learning it, but this is so robust I don’t know how best to start.
To give some context, I design t-shirts. I currently have about 500 live designs between three different POD’s (Print-on-Demand) companies. I plan to start scaling up to around 2000 (or more) designs this year and I foresee Airtable really helping me stay organized.
I only need to worry about design and uploading the artwork. They handle all the printing, ordering, shipping, etc. That means I can create one art file and use that same file for several different t-shirt printing platforms. I don’t have to worry about tracking multiple files of the same design.
Currently, my thought it to set it my airtable like:
Main table to display all my designs, with some key dates and data between all three POD platforms I use.
Three additional tables (one for each POD) that link to the main table with the data I choose to see (keywords, titles, SEO tags, brand names, date uploaded, has it sold, etc).
For each POD there are a multitude of shirt styles (standard, long sleeve, sweater, hoodie, tank, coffee mugs, etc) and color options. As I make sales, I’d like to log that info so I can track which designs and colors are selling the best so that I know which other platform to upload to.
A 90 day countdown timer. If a shirt doesn’t sell in 90 days, give me a warning so I can make changes or remove it.
Currently I am a one man show, but I plan to hire a couple local designers so that I can better scale this business. They will also be given access to input data as they complete designs.
My struggle is knowing how best to organize/set up my airtable data. And I think linking table data is probably a good solution, but I might be limiting myself.
For example, I don’t know if I should be using tags (one for each POD), versus linking tables versus an option I may now be aware of. I’m trying not to over complicate it, but frankly, it’s a complicated problem to solve.
I would love any help, tips, resources that may help point me in the right direction, especially concerning the set up process given my goals.
Thanks in advance for any help.