At the present time I send emails to electronic test equipment brokers looking for new and used electronic test equipment to buy, 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 broker contact information I just need to automate the response process.
I'm looking to send emails requesting bid's on electronic test equipment from dealers and brokers in the electronic industry. I want the brokers to respond in the email form sent 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,Comments, and date received.
I than want the ability 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.