software strategy for shop
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
Reply to: