Hello, i am looking for a solution to update my shopify inventory from google sheets. I have tried Zapier and Make, but none of it really does its job. I just need to somehow update products from my consignors to my store via SKU and SIZE. I dont have IDs in the sheets. Every product has many sizes and just ONE SKU (every variant has same) and thats really big problem to this automations. Please help me with that. Thank you.
Topic summary
A user is struggling to update Shopify inventory from Google Sheets where all product variants share the same SKU but differ by size, causing issues with automation tools like Zapier and Make.
Core Problem:
- Products have multiple size variants
- All variants use identical SKUs (no unique variant IDs)
- Standard automation tools can’t properly map updates to specific variants
Proposed Solutions:
Custom Script Approach:
- Use SKU + size combination as a unique identifier
- Build a Google Apps Script connecting directly to Shopify’s API
- One commenter offers to share script logic and sheet structure for consignor-style stock updates
Third-Party Apps:
- Matrixify: Supports scheduled imports from Google Sheets with tutorial documentation provided
- Mechanic: Offers custom scripting capabilities with a library of pre-built tasks for sheet imports
The discussion remains open with offers for hands-on assistance from community members.
I totally get the struggle, syncing inventory from Google Sheets to Shopify when variants share the same SKU can be a nightmare. Most automation tools (like Zapier or Make) expect unique variant identifiers, which is why they don’t map correctly in your case.
One approach that worked for me: use the combination of SKU + size as a unique key inside a custom script or small Google Apps Script that connects directly to Shopify’s API. That way, it updates only the matching variant, even if the SKU repeats across sizes.
I’ve set this up before for myself and other merchants using consignor-style stock updates. If you want, I can show you how to structure your sheet or the script logic to make it work reliably. Or if you go through it on your own and encounter hinges let me know I’ll be glad to come through for you.
@richie19 use either matrixify or the mechanic-app to custom script import automations.
Example matrixy doc Schedule import to Shopify from Google Sheets - Matrixify App
Example library tasks for mechanic https://tasks.mechanic.dev/?q=sheet
Reach out if you need a custom mechanic solution(
click profile pic on forums for options to connect)