Skip to main content
Question

How do I use Zapier to automate SKU sales monitoring and adjustment in Shopify?

  • July 31, 2024
  • 1 reply
  • 26 views

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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 31, 2024

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)