Home » Forums » Ubercart » Bounties
4 replies [Last post]
Tue, 08/18/2009 - 15:20
Sansui
Sansui's picture
Offline
Joined: 06/05/2008
Juice: 154
Was this information Helpful?

Need a quote for an ubercart/civicrm integration. There is an integration available for ubercart/civicrm, but it goes from a person placing an order in ubercart to creating a contact in civicrm, which is not what I need.

I already have the contact system in place - I want an integration with ubercart that will allow me to create invoices (or orders, if you will) and pull the contact information from the "main" civicrm address profile instead of using the separate address book created by ubercart. On civicrm contact lists, in addition to "view", "edit" and other links, there would be a link for "invoice" as well.

Finally, next to the link that says "view user record" on the contact record page, there would also be a "invoice user" link if that record has a drupal account attached.

Would need project completed sometime in the next 6-8 weeks if possible. If you can handle this project, please let us know what it would cost for your services, or if you need additional information to provide a quote.

I tried contacting dharmatech, who provided the original civicrm integration, but he seems to be MIA Sad

Top
Thu, 08/20/2009 - 10:27
#1 View page
Sansui
Sansui's picture
Offline
Joined: 06/05/2008
Juice: 154
Re: Need more advanced integration with civicrm / ubercart

Would really love if someone could quote us for this.

Tell me what you need to approach this project - screenshots, mockups? Will do whatever necessary to clearly define what's needed and provide a straightforward project

Top
Mon, 08/24/2009 - 10:01
#2 View page
Sansui
Sansui's picture
Offline
Joined: 06/05/2008
Juice: 154
Re: Re: Need more advanced integration with civicrm / ubercart

There seems to be some interesting and applicable information in this thread: http://www.ubercart.org/forum/development/900/pre_populating_shipping_ad...

Still looking for a programmer that can tackle this. Drupal 6.13 and Ubercart 2.x

Civicrm has an individual civicrm_address table, looks like this:

CREATE TABLE IF NOT EXISTS `civicrm_address` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique Address ID',
  `contact_id` int(10) unsigned default NULL COMMENT 'FK to Contact ID',
  `location_type_id` int(10) unsigned default NULL COMMENT 'Which Location does this address belong to.',
  `is_primary` tinyint(4) default '0' COMMENT 'Is this the primary address.',
  `is_billing` tinyint(4) default '0' COMMENT 'Is this the billing address.',
  `street_address` varchar(96) collate utf8_unicode_ci default NULL COMMENT 'Concatenation of all routable street address components (prefix, street number, street name, suffix, unit number OR P.O. Box). Apps should be able to determine physical location with this data (for mapping, mail delivery, etc.).',
  `street_number` int(11) default NULL COMMENT 'Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112.',
  `street_number_suffix` varchar(8) collate utf8_unicode_ci default NULL COMMENT 'Non-numeric portion of address number on the street, e.g. For 112A Main St, the street_number_suffix = A',
  `street_number_predirectional` varchar(8) collate utf8_unicode_ci default NULL COMMENT 'Directional prefix, e.g. SE Main St, SE is the prefix.',
  `street_name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main.',
  `street_type` varchar(8) collate utf8_unicode_ci default NULL COMMENT 'St, Rd, Dr, etc.',
  `street_number_postdirectional` varchar(8) collate utf8_unicode_ci default NULL COMMENT 'Directional prefix, e.g. Main St S, S is the suffix.',
  `street_unit` varchar(16) collate utf8_unicode_ci default NULL COMMENT 'Secondary unit designator, e.g. Apt 3 or Unit # 14, or Bldg 1200',
  `supplemental_address_1` varchar(96) collate utf8_unicode_ci default NULL COMMENT 'Supplemental Address Information, Line 1',
  `supplemental_address_2` varchar(96) collate utf8_unicode_ci default NULL COMMENT 'Supplemental Address Information, Line 2',
  `supplemental_address_3` varchar(96) collate utf8_unicode_ci default NULL COMMENT 'Supplemental Address Information, Line 3',
  `city` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'City, Town or Village Name.',
  `county_id` int(10) unsigned default NULL COMMENT 'Which County does this address belong to.',
  `state_province_id` int(10) unsigned default NULL COMMENT 'Which State_Province does this address belong to.',
  `postal_code_suffix` varchar(12) collate utf8_unicode_ci default NULL COMMENT 'Store the suffix, like the +4 part in the USPS system.',
  `postal_code` varchar(12) collate utf8_unicode_ci default NULL COMMENT 'Store both US (zip5) AND international postal codes. App is responsible for country/region appropriate validation.',
  `usps_adc` varchar(32) collate utf8_unicode_ci default NULL COMMENT 'USPS Bulk mailing code.',
  `country_id` int(10) unsigned default NULL COMMENT 'Which Country does this address belong to.',
  `geo_code_1` double default NULL COMMENT 'Latitude',
  `geo_code_2` double default NULL COMMENT 'Longitude',
  `timezone` varchar(8) collate utf8_unicode_ci default NULL COMMENT 'Timezone expressed as a UTC offset - e.g. United States CST would be written as "UTC-6".',
  `name` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`),
  KEY `index_location_type` (`location_type_id`),
  KEY `index_is_primary` (`is_primary`),
  KEY `index_is_billing` (`is_billing`),
  KEY `index_street_name` (`street_name`),
  KEY `index_city` (`city`),
  KEY `FK_civicrm_address_contact_id` (`contact_id`),
  KEY `FK_civicrm_address_county_id` (`county_id`),
  KEY `FK_civicrm_address_state_province_id` (`state_province_id`),
  KEY `FK_civicrm_address_country_id` (`country_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=492 ;
Top
Wed, 09/09/2009 - 13:21
#3 View page
Sansui
Sansui's picture
Offline
Joined: 06/05/2008
Juice: 154
Still looking Justageek, if

Still looking Smiling

Justageek, if you sign in, please check your PMs :]

Top
Sun, 09/13/2009 - 11:32
#4 View page
justageek
justageek's picture
Offline
Bug Finder
Joined: 10/29/2008
Juice: 189
sent you email

Sent you an email to gmail, we can get this finalized this week and hopefully get started!

Top