At the present time I send emails to test equipment brokers looking for new and used electronic test equipment, when the broker responds via email I manually enter the information into Excel to track changes in prices and who has the specific item available. I have all the contact information I just need to automate the process.
I'm looking to send emails requesting bid's on electronic test equipment from dealers and brokers in the electronic industry. I plan the database to grow and provide a historical trend for buying and selling of the test equipment. I want the brokers to respond in the email form with price and availability of items I'm looking to acquire. I want the response information to automatically load an Access or MySQL database with the information, when the broker response arrives I want to send a return response to the broker that confirms their bid to insure the information is correct. The Access or MySQL database should provide the ability to track the following;
Broker Name, MFG, Model, Serial #, Options, Condition, Price, Quantity Available, and Comments
I than want to track the price changes as the database is populated. I need to track individual Mfg./Models. The lookup report format must be easy to use, my staff sell's and lease's test equipment and easy of use and access is a prime consideration.
I'm open to any suggestions, I have seen this type of application in action but could not find out any information from the developer as he works for a competitor of our company.
If this project can be delivered, I would like to incorporate the same concept for our clients to send an email form to our company that would list electronic test equipment they have for sale, the client information would be entered into a secondary database or possibly the same database discussed above for marketing lookup.