is 6 hours of spreadsheets a week just normal at $5k a month
I make soy candles. Etsy shop, Shopify storefront, handful of wholesale accounts around town. About $4,800 a month on a good month.
Every Sunday I do the exact same thing. Export the Etsy CSV. Export the Shopify report. Manually mash them together in Google Sheets because the date formats never match. Update my inventory tracker so I know what scents to pour next week. Cross reference wholesale invoices. Then go into my website and update the bestsellers section by hand because I never learned how to make that part of Shopify do it automatically. Six hours every single week. I dread Sundays now.
Zapier lasted about three weeks. Built a flow to pull Etsy orders into Sheets, it silently stopped when Etsy changed something on their end, and I burned a full weekend trying to fix it before giving up. Then I paid a guy on Fiverr $200 for a Looker Studio dashboard that looked incredible in his demo and completely fell apart the second my real data had a slightly different column structure. Opened it twice.
Lately I've been throwing things at the wall with AI tools. ChatGPT is fine for product descriptions but it obviously can't touch my actual spreadsheets. I tossed my two CSVs into MuleRun and it spit out a page with charts showing what was selling by scent and by channel, which was honestly more useful to me than that $200 Fiverr dashboard. But the credits system took me a while to figure out, it only covered that one week's snapshot, and the whole thing still felt like a science experiment more than a routine I could count on. The reconciliation part where I decide which wholesale orders to count against which production batches still needs my brain. I don't trust anything to make those calls.
I keep going back to doing it all by hand. Every other Etsy candle seller I talk to does the same thing, week after week, and none of us can tell if we're doing something wrong or if this is just what running a small product business actually looks like at this revenue.