# Online Store and Inventory App combined into a single app **URL:** \ **Category:** Project Showcase\ **Created:** [November 16, 2021, 6:46pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619 "2021-11-16T18:46:32Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![grumo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumo/32/34786_2.png) [@grumo](https://community.glideapps.com/u/grumo)\ **Post date:** [November 16, 2021, 6:46pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/1 "2021-11-16T18:46:32Z")
Hello Gliders! I’ve been manufacturing and selling my own [physical product](https://palocam.com) and keeping track of sales an inventory has been a challenge. Basically, a bunch of messy interconnected spreadsheets. So I decided to build a Glide app to keep all nice and tidy. I’ve been using this app for internal purposes for about 4 months but I thought it maybe useful to other people selling their own physical products too. Here is a video showing how it works: [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47542308b60c9cd9f54e79278795b9755d3d79db.jpeg "Mobile App to Sell Physical Products | SellApp") ](https://www.youtube.com/watch?v=L7uFS9iKhsk) The app can be used both as an online store and inventory tracking system. It automatically calculates how many parts you need to buy to replenish your stock and fulfill your production target. It is targeted to small hardware entrepreneurs who are manufacturing and selling their own gadgets. You can purchase a copy of the template at → [https://grumo.com/sellapp50off](https://grumo.com/sellapp50off) Cheers! ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [November 16, 2021, 6:54pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/2 "2021-11-16T18:54:11Z")
Great app Grumo 🤩 ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 17, 2021, 9:03pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/3 "2021-11-17T21:03:09Z")
Good APP and products!! I like your Palocam, a smart and useful solution in many cases. Are you its seller o manufacturer? Saludos Miguel! ---
**Author:** ![grumo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumo/32/34786_2.png) [@grumo](https://community.glideapps.com/u/grumo)\ **Post date:** [November 17, 2021, 10:04pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/4 "2021-11-17T22:04:52Z")
Thanks! My dad and I are original creators, manufacturers, and sellers of Palocam 🙂 ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 17, 2021, 11:41pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/5 "2021-11-17T23:41:08Z")
@grumo Good to know it but I still have the doubt: did you all develop the Palocam? How long can the Palocam‘s batteries last hanging on the pole? 😳 And going back to the subject of your APP, sorry 😉, I saw that your inventory is controlled by your GS, I have tried to do it 100% on Glide natively but have problems to sum/substract my quantities dynamically and automatically (I don’t want to load and read the whole historical sales to get it). When the Set Column action can work with a multiple relation, surely I will return to my APP and will finish it. Feliz noche! ---
**Author:** ![grumo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumo/32/34786_2.png) [@grumo](https://community.glideapps.com/u/grumo)\ **Post date:** [November 18, 2021, 9:17pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/6 "2021-11-18T21:17:40Z")
> [@gvalero](#): > > Good to know it but I still have the doubt: did you all develop the Palocam? Yes. I came with the original idea and developed the product from scratch with the help of my father (a very talented retired electrical engineer). > [@gvalero](#): > > How long can the Palocam‘s batteries last hanging on the pole? About 6 hours. It uses permanent magnets so the unit will stay attached to the pole even if the batteries run out. > [@gvalero](#): > > And going back to the subject of your APP, sorry 😉, I saw that your inventory is controlled by your GS, I have tried to do it 100% on Glide natively but have problems to sum/substract my quantities dynamically and automatically (I don’t want to load and read the whole historical sales to get it). I would rather use Glide’s native database too, but at least for now, it still is quite limited in functionality. Saludos! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [November 18, 2021, 9:37pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/7 "2021-11-18T21:37:28Z")
Awesome job @grumo! 👏🏼 ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 18, 2021, 10:10pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/8 "2021-11-18T22:10:47Z")
😳 … tu papá es un crack!! Saludos y éxitos. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 18, 2021, 11:26pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/9 "2021-11-18T23:26:30Z")
@gvalero you could check this out. I came up with an idea to update inventory on multiple rows once an order is completed. I limited the max amount of unique items to 20 items, but the quantity for each item can be unlimited. It’s heavy on column usage to build all the relations to update each product. (I’m not a fan of my method, but I couldn’t think of another way to update multiple rows at once purely in glide.) With some of the newer features, it could maybe be trimmed down a bit. Maybe it could give you some ideas for managing inventory within glide. > [@Shopping Cart Concept for demonstration purposes](https://community.glideapps.com/t/shopping-cart-concept-for-demonstration-purposes/33264): > > First of all, I want to say that I’m personally not a big fan of ecommerce type apps with Glide. There’s a lot of complexity to them and everybody has a different view for how they should work. Because of that, I generally don’t give advice on how to do things with them. Glide has said that ecommerce is not the direction they are focused on and I think Glide is short on some logic and functionality to properly handle the purchase and inventory side of things. With that said, I still made an … ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 19, 2021, 3:44pm UTC](https://community.glideapps.com/t/online-store-and-inventory-app-combined-into-a-single-app/34619/10 "2021-11-19T15:44:09Z")
Thanks Jeff! I have already read your thread about it and understood the workaround but as you wrote, there are many columns and tricks on the way and I try to avoid those solutions unless the solution is urgent or the APP is on production. You know that there have been improvements on Glide based on our suggestions or ideas from Glide team and most cases I’d rather to wait for this native solution instead of using a customized and complicated trick (I remember the case when the Joined List feature was born… I almost cried 😊). To sum up, I have problems with my conscience if I have to do this: 🤕 `Total = Var1+Var2+Var3+Var3+Var4+Var5+ ... +VarN` If we can do it easier and more efficient with: ```auto N=20, x =1 While (x<= N) { Total+= Var[x]; x++ } ``` The booking APPs are other cases like this. To try to fight and handle dates and arrays to have an order of available dates/hours is heavy using the standard Glide’s components (congratulations to the folks who tried this before). Now, using JS code on EC columns the solution is more decent and easy to maintain (my point of view) although I admit that not everyone knows about programming. Gracias de nuevo Jeff! Feliz día.