Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Is there a way to create a flow for when Amazon Seller Central is out of stock to Google Sheet?

Hey team,

I am new to Zapier. Right now, I have to manually use a FedEx excel report to update my inventory levels on Amazon asin by asin. I was curious to learn if anyone knows a way for me to get Amazon to auto create a daily report of all the products that are running low?

 

Thanks,

Simon

Hi @ctsimon 

The Amazon Seller Central Zap app integration only has 1 trigger available currently: New Order

https://zapier.com/apps/amazon-seller-central/integrations#triggers-and-actions

 

Hi @ctsimon 

The best solution would be to decentralize your inventory tracking. 

As @Troy Tessalone mentioned, there is a trigger available that fires when a new order is received. Lets imagine that you had a Google Sheet that you had every item you were selling on Amazon, as well as its qty and sku. 

You could then have an automation that looked at the order, found the sku in the Google sheet, and removed the appropriate qty from the spreadsheet, triggering a notification when the quantity got below a certain number. 

Ive built something like this for a shopify store, would be happy to help more just drop me a line here or at aaron@appency.com

 

Cheers!

@ctsimon 

If you’re going to use a decentralized inventory tracking approach as @AppGuyAaron, then I’d suggest using Airtable as your operational database, instead of GSheets: https://zapier.com/apps/airtable/integrations#triggers-and-actions

Airtable has Views with Filters that can be used to trigger Zaps (e.g. Inventory < 100): https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-views

Airtable has Automations: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-overview

@ctsimon 

 

@Troy Tessalone has a good solution with the Airtable views/automations. 

If you are not an AirTable guy however, Google Sheets will absolutely work for this. 

Zapier has a tool called Formatter which you can use to manipulate numbers. What you would want here was a Spreadsheet-Style Formula like such: 

7.Col$a is the inventory spreadsheet with the current qty and 4.Quantity was the number sold in the order

This gives you the new inventory quantity which you can then replace the old quantity with in your spreadsheet. You would then want a Filter to Only Continue If the new inventory amount is whatever you want your notification point to be (so if you wanted to be notified when your inventor reached 3 items you would do Inventory | (Text) Exactaly Matches | 3

Here is mine where I get notified when we completely run out of an item using (Number) Less Than | 1 and then being notified in Slack. 

 

 

Terms & Conditions