Skip to main content

Hello,

We sell women's clothing and need Zapier to monitor sales levels in Shopify for each SKU. Is these 2 scenarios doable with Zapier? If yes, can someone give me some guidelines on how to create this automation?

Scenario 1:
1) IF the quantity of an SKU at Location A reaches 100,
AND that sales over the past 7 days for this SKU is inferior to 50
THEN Zapier should set the quantity of the same SKU at Location B to 0, prioritizing the sale of stock from Location A.

2) Once the stock at Location A is sold out, both locations would have a quantity of 0, which should trigger an email notification.

Scenario 2:
IF the quantity of an SKU at Location A reaches 100,
AND that sales over the past 7 days for this SKU is SUPERIOR to 50
THEN Zapier should NOT set the quantity at Location B to 0, as the item is selling well.

Could you confirm if Zapier can handle this kind of workflow?

Thank you.
Julie

Hi @Julie CH 

Filters can be used as Zap steps: https://zapier.com/apps/filter/help

 

Related Shopify Zap triggers and actions:

  • Trigger: Updated Inventory
  • Action: Update Inventory Quantity

 

You’ll have to determine where to derive the SKU Sales for N days.

May involve the Shopify API: https://shopify.dev/docs/api

  • API Request
  • Custom Action (with the help of AI)