Building POS Integration with Mobile Web ERP Help

[ifixomaha]

We have used Square POS hardware for years and have an in-house ERP web app that we'd like to integrate with.

We're a computer repair shop.  We want to create tickets in our web app that contain catalog items, sub-total, local sales tax - then send that over to Square POS API.  It doesn't look like we can send itemized sales to Square POS.

We really want to continue using Square POS but we want to have full reporting in our sales dashboard that comes with itemized sales.

What is the best path to create a flow that gets itemized sales reporting with the Square POS API serving as our primary means for collecting payments?

Thank you!

[ashc]

Hey @ifixomaha and welcome to the Community.

Have you already checked out our Developer page? 

Tagging some Super Sellers who are API users here too for input if they have any:

@GoGoGuest @JupiterGames @LLCafe @ryanwanner @Minion @Ravenssong69 @page158 

[LLCafe · Accepted solution]

@ifixomaha You'd use the Create order endpoint on the Orders API Under Create Orders there is a line items attribute that you can use to add individual line items that should do what you're looking for. Then you can process payment using the Payments API after the order has been created. Once the order is paid it will show up in your reporting the same way your POS sales do.

[ashc]

Thank you @LLCafe! Appreciate you. 

[ifixomaha]

Thank you @LLCafe !

Can the items in the order we created ad hoc?

If so, I am assuming that we will not need to integrate our internal catalog with the catalog API in order to process orders through the orders API. Is this correct? If it is this will be a quick and seamless build on our end.

[LLCafe]

You can create ad-hoc but the reporting works better when you use the catalog. I think you can do a couple of tests using the sandbox and see if the sandbox reporting works how you'd like. 

[ifixomaha]

Since the sandbox does not allow us to use a square register how would you suggest we test this in sandbox? I understand that we can create orders in the sandbox but how do we process the sale in the sandbox if we are not using the register? Would we just use payments API for testing since that will still show up as a sales transaction for that store location? I assume sales processed through the Payments API are reported the same as sales that are processed through the POS. Should this be correct?

[LLCafe]

Correct, I usually use the Payments API for that testing.

[ifixomaha]

Thank you for your time and help. I will give this a shot today and see how it goes. I really appreciate your generous help.