Hi, a friend of mine is starting a record shop (old and new vinyl and cds) and i am helping him on the technical side. our objectives to start with are:
1) Have all stock coming in and going out recorded on a database that will allow for stock control, account reporting, profits, unit sales etc. 2) Have certain fields of the database available to debian terminals in the shop so that customers can browse the available stock (an possibly listen to clips too). 3) On a regular basis upload the available stock to our ISP so that online customers can browse the stock. There are no plans to have online payment at this time - telephone or email orders to start with. Therefore I would welcome any advice on the following: i) What database would you use (server will be debian but there will be at least one windows machine off of it). ii) In what language would you write the administrators screen for data entry and sales reports. iii) How should the shop browsing be organised, and similarly the online ISP browsing. Clearly it would be easier if I were to mirror the online website with one in the shop. I am aiming for minimum development time that will produce a nice simple but effective system for my friend. Any suggestions on custom software or exisiting systems much appreciated. Tom