Setting up a Point of sale Sheet

Jacob S

Good afternoon, 

 

I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc..

 

Then it came to mind that I should check here. 

I did speak with tech support and they directed me to a template names "Inventory Management."

 

It is very close to the idea what I could use. But I think I need to add a few things. My only question is how. 

What I would like it to have is a sales colunm.  If you do a google search on How to set up pos in excel yu'll see instruction on wikihow.com 

What I'd like it to do, is minus the item, and fill the profit colum and update the inventory colum etc..

I also would like to see if I could create a barcode from Item Number and scan a lable on the item.

 

But I'm not the only one that says its to vage, 

 

So, If anyone has any ideas?

or has set up a POS with smartsheet. I'd really appriciate your input. 

 

Thank in advance,

Jay

 

 

J. Craig Williams

Jacob,

 

To access and read the bar-code, you are going to need to integrate to a third party application. I'd start with AppSheet (since that is in my toolbox) but there are likely other possibilties.

 

I work with Richard Rymill at Smarter Business Processes (richardr@smarterbusinessprocesses.com) who provides free initial consulting if you are thinking of going that route.

 

Craig

Jacob S

Thanks, 

How about the rest of the things id like it to do?

Like the sales? And updating the inventory etc.. 

 

 

J. Craig Williams

I have not done POS but believe Richard has and based on quick Internet search, should be fairly straight forward.

Perhaps someone else has hands-on experience to share.

 

Craig

Jacob S

Hi, 

I'm sorry I'm new here on the disccusion forums. I don't think I know who Richard is.

 

One other question. Dose Smartsheet use the same formulars as excel?

J. Craig Williams

Jacob,

 

From the previous comment:

 

I work with Richard Rymill at Smarter Business Processes (richardr@smarterbusinessprocesses.com) who provides free initial consulting if you are thinking of going that route.

 

 

Sorry if that was not clear.

 

Smart has similar formulas in many cases, but is not a one-to-one match.

I keep this article bookmarked for the references at the bottom:

http://help.smartsheet.com/customer/portal/articles/775363

 

This is also pretty handy to have on hand:

 

https://www.smartsheet.com/solutions/smartsheet-formula-examples

 

I hope this helps

 

Craig