We currently have are using a webid open source auction platform which utilizes a mysql database. Currently all our clients are required to register and login in every time to use the site. We also use a sugar crm that is populated with clients information such as name, company, address, email address, product interest and receive a newsletter.
We are looking to create a data connection between the mysql database on the auction site and the mysql database on the CRM so we can categorize and import client activity on the auction pages into their client contact in Sugar CRM.
The information would be by high level product category and stored for 90 days in the CRM before being erased in the CRM.
You will need to have a strong working level of mysql databases, php and have worked with Sugar CRM (as there will be some customization of fields). We also prefer that you have experience with Webid auction platform.
We are looking for a simple open source solution that can be customized to our needs in a short time period.