After a lot of testing, I settled on VTIger for my small business's CMR needs. Unfortunately, there really isn't much integration with Drupal. (The closest I found integration-wise was Sugar, but it didn't suit my needs as well as VTiger did.)
I dug through the VTiger API and existing Sugar and VTiger Drupal plugins (VTiger spun off Sugar) and the CRM API. A plugin is doable, but then I remembered Ubercart's Conditional Actions.
I created an experiment on my test server.
Conditional Action...
When customer completes checkout, execute custom php code.
I dropped in a very quick and dirty bit of php. (I'm a little embarrassed by my code, so I'll tell you about it rather than post it.)
The PHP contains an SQL SELECT ... INTO statement that specifies the VTiger database location and password. My quick test only populated table vtiger_contact with field lastname, but it did work.
I hope to work on this some more over the weekend, but before I start heading down the conditional action instead of module path, I thought I would check and ask two things:
1) Have any of you tried this before?
2) Would using this method in a production environment be insane?
