Baselinker + Google sheets = inventory control

Hi. So there is an app Im using for an ecom business. We have a warehouse full of different products and everything is built with google sheets, including the product shelf locations. Now, since BaseLinker has an API and allows to integrate with various apps, how could I achieve this outcome: make BaseLinker ‘listen’ to the google sheet which has the basic product information (barcode, SKU, …) and the quantity, and once the quantity is updated (or a few times per day) Baselinker would update product quantities in the app based on google sheets quantities.

Baselinker is a fully functional WMS, why do you need Google Sheets, when baselinker has inventory control and much more already included?

because sometimes we just need to update the quantity for certain SKUS quickly (e.g. if someone buys a product from a physical shop), and doing so in google sheets would be a little faster with ctrl+F than searching for a product in a web app and changing the quantities there.

you can setup baselinker for lokal usage like a local store and have your stock level adjusted by just scanning the item that was sold.

i will look into that. Didn’t know it’s possible. But still - do you think this kind of integration with sheets is possible? i just want to know my options and then decide how to proceed.

yea so Baselinker API call will work + Google Sheets.

You can most likely go with " getExternalStorageProductsQuantity and/or updateExternalStorageProductsQuantity from the Baselinker API.