Appsheet Development - Inventory Location App
Budget: $30 – $250 USD
Hi, I need some help building a solution in appsheet for my retail shop.
We have the retail store and the warehouse is at the back. When we have excess stock (which we can't fit at front of store) we put the stock in the warehouse. The problem is that we don't know which box and where in the warehouse the stock is.
I actually found something that is very similar to what I need here - https://www.appsheet.com/samples/Autocreated-from-Google-Sheets?appGuidString=de7161ae-4b66-49fc-a7ea-2a37c8234d7b but it does require some customisations and links to the external data source for product info.
I can generate a csv file url which will be an up to date list of our products the information in the CSV file will be:
SKU:
Barcode:
Product Name:
Price:
Total Stock on Hand (this is the total stock at front and back):
I essentially need the following views
- New Box
- This should allow scan or manual input of box identifier e.g. A2, when adding a box it should check if that box number already exists and disallow adding if its a duplicate
- Once a new box is created, by default it should take you to the add stock screen with this box selected
- Add Stock
- Search and select box at top (keep this selected, unless changed manually)
- Scan items or select from search
- Enter quantity
- Click "Add to Box"
- (ideally this should be a quick process as sometimes 5-10 different products/SKUs will be put into 1 box, so it would be good to add multiple products without having to go to a new page each time)
- Show summary of stock added
- Remove Stock
- Choose box (scan or enter number)
- Once a box is selected it should show all the items in the box and the quantities
- Next to the quantities there should be a field to enter the amount being removed
- Click "Remove Stock" at bottom
- Show summary of stock removed
- Search inventory
- Allow to search by SKU, barcode (scan) or product name
- Once you select a product it should show the boxes that it exists (could be more than 1 box) in and have buttons to "remove stock" or "add stock". It should show all other product info from the CSV file like price, total stock, product name, barcode and SKU.
- Restock Needed
- If the Total Stock on Hand equals the Warehouse Stock, the product should show up on this screen.
- Essentially this means there is no stock at the front and all stock is at the back which means it needs to be restocked.
Ideally I would like to be able to show an image of the product on the app as well. This is not essential. I should be able to provide a url to an image for each product in the CSV file.
We have the retail store and the warehouse is at the back. When we have excess stock (which we can't fit at front of store) we put the stock in the warehouse. The problem is that we don't know which box and where in the warehouse the stock is.
I actually found something that is very similar to what I need here - https://www.appsheet.com/samples/Autocreated-from-Google-Sheets?appGuidString=de7161ae-4b66-49fc-a7ea-2a37c8234d7b but it does require some customisations and links to the external data source for product info.
I can generate a csv file url which will be an up to date list of our products the information in the CSV file will be:
SKU:
Barcode:
Product Name:
Price:
Total Stock on Hand (this is the total stock at front and back):
I essentially need the following views
- New Box
- This should allow scan or manual input of box identifier e.g. A2, when adding a box it should check if that box number already exists and disallow adding if its a duplicate
- Once a new box is created, by default it should take you to the add stock screen with this box selected
- Add Stock
- Search and select box at top (keep this selected, unless changed manually)
- Scan items or select from search
- Enter quantity
- Click "Add to Box"
- (ideally this should be a quick process as sometimes 5-10 different products/SKUs will be put into 1 box, so it would be good to add multiple products without having to go to a new page each time)
- Show summary of stock added
- Remove Stock
- Choose box (scan or enter number)
- Once a box is selected it should show all the items in the box and the quantities
- Next to the quantities there should be a field to enter the amount being removed
- Click "Remove Stock" at bottom
- Show summary of stock removed
- Search inventory
- Allow to search by SKU, barcode (scan) or product name
- Once you select a product it should show the boxes that it exists (could be more than 1 box) in and have buttons to "remove stock" or "add stock". It should show all other product info from the CSV file like price, total stock, product name, barcode and SKU.
- Restock Needed
- If the Total Stock on Hand equals the Warehouse Stock, the product should show up on this screen.
- Essentially this means there is no stock at the front and all stock is at the back which means it needs to be restocked.
Ideally I would like to be able to show an image of the product on the app as well. This is not essential. I should be able to provide a url to an image for each product in the CSV file.