Sales bot + inventory tracking
# 🤝help
w
I must create a commercial bot that must inquire about the customer’s existing stock and authorize the sale if and only if the product is available at the stock level. Since I’m out of ideas, please help me or direct me to a video that will allow me to make this bot
f
Hey @worried-country-47544 how is the customers stock and inventory stored?
If it is in a piece of software or DB you should be able to accomplish this with API calls
An API call to check availabilty... if yes... then proceed with sell and then update the inventory
c
Sara is definitely on point. You need to write an API call that GETs the current product existing stock after which you can set a boolean variable to "true" if it is in stock. You definitely need to have a strong Javascript foundation to understand syncing with an external database like Supabase/MongoseDB. An easier alternative (but not suitable for large scaling databases) would be to use Google Sheet/Airtable as a database with Zapier/make.com
w
Thank you for your message..... The stock data is in a Google Sheet. How do I do this?
c
it's completely frustrating, I'm trying to get information about records that exist even if it's not through the api and through the kb and it seems that nothing works no matter which way I try.
f
@worried-country-47544 as @cold-jewelry-54343 pointed out using the Zapier integration to do this can work very well for Google Sheets. Here is the documentation on how the Zapier integration works https://botpress.com/docs/cloud/channels/zapier/
c
It is indeed tricky. Feel free to make a help thread so we can think together how best to solve this
37 Views