News-Antique.com - Oct 11,2007 - For small dealers with a computer a spreadsheet is often the best way to list and manage tens to hundreds of items of stock. But displaying these lists to potential buyers on the web can be difficult and time consuming.
A new way to maintain a web based stock list has been developed by CollectFair, using a Microsoft Excel(R) format spreadsheet to hold the information. The system converts the spreadsheet to a web page, including a 'contact' form for enquiries. Automatic formatting of titles, columns and borders makes it easy to keep an up-to-date stock list on the web.
David Fletcher at CollectFair commented "For major dealers and sale rooms there are special software and database applications to manage stock, but for small or home based dealers these are too expensive and too complex. Using a spreadsheet to put a simple list of items, descriptions and asking prices on the web is much more practical."
Many computers come with a spreadsheet program already installed, so this is the natural place to keep a list of stock, prices, condition and so on. The new stock listing system will convert the list to a page on the internet, so potential buyers can browse and make contact. More details of how tens to hundreds of items of stock can be listed easily on-line are at www.collectfair.co.uk.