Question

How To Detect And Increase Low Shopify Inventory Level Using Zapier?

  • 10 March 2023
  • 1 reply
  • 163 views

Userlevel 1

Hey guys,

I’m trying to use Zapier to automatically update inventory levels once a specific product gets to a low number.

For example, Zapier will help me do this by:

  1. New Shopify Paid Order - Once an order is made, Shopify will detect a low inventory count (1-3) and trigger the zap.
  2. Zapier Paths - Zapier will filter by specific product SKUs using line items to continue the zap.
  3. Update Shopify Inventory Quantity - If it’s the right SKU and the product inventory is low enough, Zapier will automatically increase the quantity by a random number (For ex. 1-10)
Step 1
Step 2
Step 3

 

However, there are a couple of issues I’m facing.

 

I only want Zapier to continue and to update inventory if it’s LOW ENOUGH. It doesn’t seem to have this option in the Update Inventory step or with the Paid Order step.

 

The next issue I have is that I don’t think Zapier is able to pick a random number between 1-10 to update quantity. 

 

Ideally I want Zapier to auto update inventory ONLY when it becomes too low and by a random fixed set of numbers without the use of a spreadsheet.

 

Is there any way for me to do this? Are my steps wrong? Or is this just not possible for me to do?

 

Thank you.

 


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

Userlevel 7
Badge +14

Hi @UMS Ecommerce 

Good question.

For the random number, you can use Formatter > Utilities > Pick from List (random)

 

For the Shopify Update Inventory, you’ll likely have to use the Shopify API: https://shopify.dev/docs/api/admin-rest/2022-04/resources/inventorylevel

App APIs can be used in Zaps with the Webhooks apps: https://zapier.com/apps/webhook/help

If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace