My wife is working at the school store, which uses Square. I'm helping them set it up. The base app doesn't include inventory receiving, and the third-party packages are overly complex for what we need. I think I want to build an app for it.
Use case: We come in Monday morning and find that they sold out of M&Ms, Fritos and Coke at the basketball game over the weekend. Someone runs down the street to Costco and gets a couple of cases of each. We want to scan in each case and have the system add the correct number of individual items to inventory.
All the existing (built-in and third-party) solutions I can see assume you've got purchase orders you can receive in. We won't have those. There is an inventory API that has an endpoint for stock actions - eg: add X of item Y.
The ideal solution is to tap a button in the UI (second best, go to the desktop and launch the app) and I'm presented with a prompt to scan cases. I use the attached barcode scanner to scan the code on the case. The app looks up the item SKU and quantity for that case and executes the "receive inventory" stock action.
This implies I'll need a UI to add new rows to the lookup table for case barcodes linked to item quantity and SKU. Probably scan the case code, scan the item code, enter a quantity from an on-screen number pad.
The API is relatively straightforward. What I don't know is:
* The best language for writing the app.
* Where to store the lookup table.
* How/if to launch the app from within the Square app.
For a Square developer this is probably a 2-day project. I don't mind taking a couple of weeks to learn the tools along the way - never done iOS development - but if someone can point to an existing solution we've got a budget for something reasonable.
Use case: We come in Monday morning and find that they sold out of M&Ms, Fritos and Coke at the basketball game over the weekend. Someone runs down the street to Costco and gets a couple of cases of each. We want to scan in each case and have the system add the correct number of individual items to inventory.
All the existing (built-in and third-party) solutions I can see assume you've got purchase orders you can receive in. We won't have those. There is an inventory API that has an endpoint for stock actions - eg: add X of item Y.
The ideal solution is to tap a button in the UI (second best, go to the desktop and launch the app) and I'm presented with a prompt to scan cases. I use the attached barcode scanner to scan the code on the case. The app looks up the item SKU and quantity for that case and executes the "receive inventory" stock action.
This implies I'll need a UI to add new rows to the lookup table for case barcodes linked to item quantity and SKU. Probably scan the case code, scan the item code, enter a quantity from an on-screen number pad.
The API is relatively straightforward. What I don't know is:
* The best language for writing the app.
* Where to store the lookup table.
* How/if to launch the app from within the Square app.
For a Square developer this is probably a 2-day project. I don't mind taking a couple of weeks to learn the tools along the way - never done iOS development - but if someone can point to an existing solution we've got a budget for something reasonable.