If you’ve ever had to update prices across a large catalog — for a promotion, a supplier cost change, or a seasonal sale — you know how much time it takes doing it manually through Shopify Admin.
I put together a small automation workflow using n8n and Google Sheets that handles this automatically. You update a spreadsheet, the workflow does the rest — no clicking, no errors, no wasted time. Every change gets logged with a status and timestamp so you always know what was updated and when.
Quick note — I don’t have a live Shopify store yet, so I built and tested this as a price change logger using Google Sheets only. The Shopify integration is one small step away: just swap one node for an HTTP request to the Shopify API and it’s fully live.
I wanted to share it with the community while I’m still learning. If anyone wants to try it or give feedback, drop a comment or DM me — happy to share the workflow and walk you through it.
I think this would be a good alternative to paid apps. I know there are some free ones that I’ve been testing that have been pretty good too, but all said and done, I would definitely try this out as well to compare!
This is a clever approach. One thing I like is that merchants can manage changes in a spreadsheet rather than editing products one by one.
Another option for merchants who want to keep everything inside Shopify is to use workflow automation. I built a workflow template in my app (JsWorkflows) that can perform bulk catalog price updates from a spreadsheet or other data source. Different approach, but solving a similar problem.
I’d be interested to see how your Shopify API implementation performs on larger catalogs.
Hi @saad20
It’s a great way to approach and the type of workflow automation that really scales for large catalogs. Managing bulk updates through a spreadsheet as the control layer is much more feasible, more so when combined with proper logging / traceability. When you want to connect Shopify, Get the Admin API product variant price endpoint is the key piece, and you want to add rate limit handling, and a rollback check. Good baseline here, and should save a ton of manual admin once fully wired up in a live shop.
