Manage Inventory tied to Ecommerce store

I have created an app utilizing glide sheets that sells courses and products. The products are limited based on inventory on hand. I am needing help creating the relations necessary to manage the inventory based on purchases and then to show a SOLD OUT sign once the item is out of stock. Thanks

Assuming the items you sold are stored in another table, with a unique value to identify the item (let’s say the itemID), you can create a relation from the Items table to the Sales table using that itemID, do a rollup to count the items sold, subtract it from the original inventory to have the live inventory count.

Then show SOLD OUT when the live inventory count is less than 0.

1 Like

How do I create the sales page? I have ran a test cc through the stripe payment system but it never created the test sales page

So you are using the buy button and the native buying flow in Glide for this?

Yes I am using the stripe buy button and I have recreated my entire app utilizing google sheets since I see that is the most functional and popular choice.

Please use this to “duplicate” that Sheet so it’s visible to Glide.

However it will consume your row count.