IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Anyone here worked with Square POS?
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.
--

Drew
New I don't know anything about Square
But you probably want to start with Swift for iOS development.

Are you looking to store the information on the device or on a server? If on the device, there's SQLite for single-user stuff and Core Data for more complex stuff.
Regards,
-scott
Welcome to Rivendell, Mr. Anderson.
New There's no server (that we run)
There's an iPad in the store, and it connects to Square's service via internet. So I'll have to store local.

Is SQLite persistent? I thought it was in-memory only.
--

Drew
New Nope, file based.
It creates a .db file in the app's local file system.
Regards,
-scott
Welcome to Rivendell, Mr. Anderson.
New Tool/framework recommendation for the app dev?
--

Drew
New Not much of a choice when it comes to iOS development
You use yer XCodes on yer Macs.
Regards,
-scott
Welcome to Rivendell, Mr. Anderson.
New Yup, working through a tutorial now
--

Drew
New I have not used React Native but I hear it's good
We use React for web development and love it. If you're a JavaScript developer you might give it a try too.
Regards,
-scott
Welcome to Rivendell, Mr. Anderson.
New Or Delphi.
https://www.embarcadero.com/products/rad-studio/ios-development
--
Christian R. Conrad
Same old username (as above), but now on iki.fi

(Yeah, yeah, it redirects to the same old GMail... But just in case I ever want to change.)
New I've worked with POS of all kinds of shapes.
     Anyone here worked with Square POS? - (drook) - (9)
         I don't know anything about Square - (malraux) - (7)
             There's no server (that we run) - (drook) - (6)
                 Nope, file based. - (malraux) - (5)
                     Tool/framework recommendation for the app dev? -NT - (drook) - (4)
                         Not much of a choice when it comes to iOS development - (malraux) - (3)
                             Yup, working through a tutorial now -NT - (drook) - (1)
                                 I have not used React Native but I hear it's good - (malraux)
                             Or Delphi. - (CRConrad)
         I've worked with POS of all kinds of shapes. -NT - (CRConrad)

As Sam Goldwyn said, "I'm sick of the old cliches. Bring me some new cliches."
65 ms