A Customer of mine has recently purchased a new business which was about to go into liquidation
This business sells: Bathroom supplies ie
Toilets, Baths, Showers, Plumbing supplies (Pipes, connectors, Glue, Plugs) Sinks, Tiles etc
The previous owners have taken everything useful, IE server, tills, scanners, so starting from scratch with a building full of stock without a stock list or anyway to sell it.
Areas which need to be covered are :
Stock control, we need a wireless scanner to tour the building scanning each and every item and listing it in a database. we may also need some kind of bar code printer so we may attach the codes to individual items baths, toilets etc
We need a database which not only collects this data, but allows us to add the price paid for each item and the price we are selling it for, the Supplier who sold it to us, and the customer who bought it from us. Complete traceability.
We need a EPOS Point of sale Till with the ability to look up the stock database by searching for "Bath" or "Manufacturer" or Barcode. and the ability to print off customer invoices and receipts.
If possible, we expect to launch a full ecommerce site within the next 2 months, possibly using OS commerce...however, I thought it would be ideal if whoever can suggest the ideal system above would also know if it was compatible with Ecommerce so as to show current stock levels online, take payments and keep the inventory upto date.
This system has to be windows compatible so as reports can be accessed realtime through VPN to SBS 2003
And finally!, if at all possible SAGE accounts compatible importing data to Sage would be ideal for almost ready made accounts.
Its a lot to ask, Ive been searching all night for various solutions, so far can only find MS RMS however this will only be sold by a solutions provider, we cant afford to outsource!
Any helps much appreciated