Startups Stack Exchange Archive

How do retail stores’ transactions logs look like?

I would like to build a service that does some predictive analysis for retail stores. However I have completely no idea how retail houses stores their data and what software they use. I have also no friends whatsoever in that business to ask them. Thus I’m asking here if you know how such logs look like. Do you know some of the most famous and used software? Is there some kind of a standard formatting for that data of how it looks like?

Edit: in order for my service to work, it needs to have data inserted to it. Not knowing the format for retail stores data would mean the customers have to adapt their data to my service, which no customer would be willing to do.

Answer 8701

I'm guessing you're referring to financial transactions.

There is no universal program but most of the big companies use one of the following systems: Infor, Oarcle, SAP, NetSuite. Here is a bigger list .

These are called ERP Systems. (Enterprise resource planning)

Most of them store their data in an ODBC compatible database, the most prominent beeing: SQL, Access, CSV/TXT, AS400 DB2, Excel, etc.

Edit: Making your system read directly from the database would be your best bet.


All content is licensed under CC BY-SA 3.0.