Multiple Location Inventory

AppSheet AppSheet Q&A
1

Hi

I was wondering if someone could help. I have an inventory app which was taken from one of the template apps available. I have figured out customisation and even a little additional column but what I would like to do is beyond my understanding (hence the post )

I would like to split my current stock inventory between 2 online shops (website & etsy) So I can keep track of when I need to renew listings or I am running low in one shop rather than having to check all the listings every day.

What I would like is to be able to select how much inventory is in one shop and have an overview page telling me when something is running low in that shop.

I would also need to keep the total amount of stock combined for both locations as a total so I know when I need to create more physical stock.

I hope that made sense. I am extremely new to AppSheet so understand very little.

Thank you kindly for any support.

Cheers
Sam

2

Shoud be easy enough to do. What tables do you have?

1 Like
3

The things in the tables tab are

Products
Sales (stock out)
Purchases (stock in)

I am VERY new to all this but ideally what I would like to do if I want to add stock in is scan the barcode of my product and choose the shop I put it in (Etsy or Webshop for example) and have the same option to stock out from the shop if I sell the item from there. I do also need to keep the total number of the product that I have so I know when I need to physically make more

Hope that makes sense
Thank you for your help

Cheers
Sam

4

Hi Sam

Lets schedule 5mins for a chat. Since I think that the structure of your App might be the problem

Simon@1minManager.com

1 Like
5

hi

Thanks for that … what suits you I am fairly flexible… I am based in the UK (for time zone purposes)

Cheers
Sam

6

I am curious to know how this was solved.

1 Like