Update Shopify Inventory When an Etsy Order Comes In

6 min setup
No coding required
Runs automatically

When you sell the same products on Etsy and Shopify, an Etsy sale leaves your Shopify stock count too high until someone fixes it by hand, and that's how a sold-out item gets ordered twice. This workflow runs on every new Etsy order, matches each item to its Shopify variant by SKU, and subtracts the quantity sold from your Shopify inventory, so both shops show what you actually have on the shelf.

etsy logo icon
Etsy Receipt Created (Trigger)
Etsy Get List of Receipt Transactions
Shopify Retrieve Product Variant Details from SKU
Shopify logo icon
Shopify Adjust Inventory Level By Variant

How it works

6 steps to take every Etsy sale out of your Shopify stock the moment it happens

etsy logo icon

Etsy Receipt Created (Trigger)

App connector: Etsy • Time to complete: 1 minute

Run whenever a new order (receipt) is placed in the Etsy shop.

Etsy Get List of Receipt Transactions

App connector: Etsy • Time to complete: 1 minute

Fetch the line items on the new receipt, including each item's SKU and quantity.

Loop

App connector: Loop • Time to complete: 1 minute

Go through the receipt's line items one at a time.

Filter

App connector: Filter • Time to complete: 1 minute

Continue only if the line item has a SKU, since items without one can't be matched to Shopify.

Shopify Retrieve Product Variant Details from SKU

App connector: Shopify • Time to complete: 1 minute

Find the Shopify variant whose SKU matches the Etsy line item's SKU.

Shopify logo icon

Shopify Adjust Inventory Level By Variant

App connector: Shopify • Time to complete: 1 minute

Subtract the Etsy line item's quantity from that variant's available inventory at the Shopify location you fulfill Etsy orders from.

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 take every Etsy sale out of your Shopify stock the moment it happens

Get setup in 6 minutes.

Use this template →

FAQs

Does this also update Etsy when something sells on Shopify?

No, this workflow covers Etsy sales only. Pair it with the Update Etsy Listing Quantities When Shopify Inventory Changes template so Shopify sales and restocks reach Etsy too. With both on, Shopify is the source of truth for stock.

What happens if an Etsy item has no SKU or no matching Shopify SKU?

The filter skips line items without a SKU, and the Shopify lookup finds nothing when no variant has that SKU, so those items aren't adjusted. Add matching SKUs on both shops before turning this on.

How many MESA tasks does an order use?

About two per line item with a SKU (the variant lookup and the inventory adjustment) plus one to fetch the order's line items. Loop steps aren't billed as tasks.

Personalize this template

Customize this workflow even further:

Alert on missing SKUs
Add an Email or Slack step on the filter's other branch so you hear about Etsy items that couldn't be matched.
Log every adjustment
Add a Google Sheets Add Row step after the adjustment to keep a record of which Etsy orders changed Shopify stock.

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

take every Etsy sale out of your Shopify stock the moment it happens

6 min setup • Fully supported if you need help