We’ve created 7000+ products at our Shopify store since moving to this ecommerce platform. This is a lot of manual work to do! So in the process, we’ve developed a Google Spreadsheet template I’d like to share with you. It uses some quite advanced formulas (like ArrayFormula and Regexreplace) and requires some time to get it. However, we managed to teach our not so nerdy content manager to use it, which means you probably can do it too 😉
I’ve built a simplified public copy of our template, which can be found here. Feel free to copy and modify it to your needs. If you don’t use Brightpearl ERP, feel free to delete sheets ‘5’ and ‘5.1’ (cause they may slow down your doc a bit).
Next, I’m going to explain how to use the template.