Daily Etsy and Shopify Stock Mismatch Report

7 min setup
No coding required
Runs automatically

Inventory syncs fail quietly: a missing SKU or a skipped update and Etsy keeps selling stock Shopify says is gone. This workflow checks every active Etsy listing once a day, compares each product's Etsy quantity with the Shopify variant that has the same SKU, and adds a Google Sheets row for every mismatch, so you catch sync problems before a customer does.

schedule icon
Every morning
Get every active Etsy listing
Get each listing's SKUs and quantities from Etsy
Look up the Shopify variant with the same SKU
google sheets logo icon
Log the mismatch in Google Sheets

How it works

7 steps to catch Etsy and Shopify stock that doesn't match before you oversell

schedule icon

Every morning

App connector: Schedule • Time to complete: 1 minute

Run once a day at a time you choose.

Get every active Etsy listing

App connector: Etsy • Time to complete: 1 minute

Fetch all active listings in the Etsy shop.

Go through the Etsy listings

App connector: Loop • Time to complete: 1 minute

Go through the listings one at a time.

Get each listing's SKUs and quantities from Etsy

App connector: Etsy • Time to complete: 1 minute

Fetch the listing's inventory, with every product's SKU and quantity.

Look up the Shopify variant with the same SKU

App connector: Shopify • Time to complete: 1 minute

For each Etsy product with a SKU, find the Shopify variant with that SKU and its available quantity.

Keep only SKUs where the counts differ

App connector: Filter • Time to complete: 1 minute

Continue only when the Etsy quantity and the Shopify quantity don't match, or no Shopify variant has the SKU.

google sheets logo icon

Log the mismatch in Google Sheets

App connector: Google Sheets • Time to complete: 1 minute

Add a row with the date, SKU, Etsy listing title and ID, Etsy quantity and Shopify quantity.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to catch Etsy and Shopify stock that doesn't match before you oversell

Get setup in 7 minutes.

Use this template →

FAQs

Does this fix the mismatches?

No, it only reports them, so you can see whether your sync is working and fix the cause. Run it alongside whichever app or MESA template keeps your Etsy and Shopify stock in sync.

Why would a listing show up every day?

Usually the Etsy product has no SKU, a SKU no Shopify variant uses, or the item isn't covered by your sync. A short time gap after a sale can also show one mismatch that clears the next day.

Which Shopify quantity does it compare against?

The variant's available quantity across your locations. If only one location holds your Etsy stock, add a step that reads that location's inventory level instead.

Personalize this template

Customize this workflow even further:

Get a Slack summary instead
Swap the Google Sheets step for a Slack Send Message step that posts each mismatched SKU to a channel.
Ignore small differences
Change the filter to flag only differences of two or more units if a sale between checks causes false alarms.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

catch Etsy and Shopify stock that doesn't match before you oversell

7 min setup • Fully supported if you need help