Interface with NetSuite CRM / ERP

By mystcritic on 12 Dec 2007 at 18:58 UTC

Hi, does anyone have experience with interface Drupal with NetSuite CRM / ERP modules? Sample scenario - Users register in Drupal need to be sent to NetSuite as a customer or a contact, and when a customer or contact is disabled in NetSuite, the Drupal user gets disabled as well.

I am thinking that this can be accomplished by using webservices. Does Drupal have any out-of-box functionality to would make webservices interface development easier, or is there any other way to push and pull data from a hosted application like NetSuite?

Thanks!!

Comments

Drupal/Netsuite

jwickersham commented 21 November 2008 at 17:20

Have you had any success in exploring Drupal / Netsuite?

even i am intersted

ejaincom commented 17 March 2009 at 06:25

Hi,
Did anyone found a solution for the same,
Thanks,
abhi

Mark another interested user.

Evan.Dudley commented 8 June 2009 at 21:16

I three am also interested in finding a solution for connecting NetSuite and most Ubercart functions/actions.

Ditto

travisc commented 17 July 2009 at 01:09

I'm looking into this as well.

Also looking for NetSuite CRM integration

mrosenbaum commented 27 October 2009 at 15:02

Has anyone made any headway on this issue?

I'm interested in a solution

ozecho commented 23 November 2009 at 13:54

I'm interested in a solution to this as well...

Drupal as Front end to remote applications/databases

bg1 commented 9 December 2009 at 14:44

Could a web service consumer module work for this where views and forms could interact with remote web services?

Hey I am building a module

drupaledmonk commented 7 May 2010 at 11:31

Hey I am building a module which uses the PHPToolkit of netsuite for one of clients. His use-cases are very limited, if at all anyone interested in lending a hand, we can work together.

Subscribing, interested in

Summit commented 7 May 2010 at 11:37

Subscribing, interested in ecommerce/erp integration.
greetings, Martijn

Any updates

lukehamilton commented 29 May 2010 at 12:02

Any updates on this, I too am looking into this for my site?
Thanks
Luke

I've used the PHP Toolkit to

ozecho commented 11 June 2010 at 17:45

I've used the PHP Toolkit to integrate a drupal site to Netsuite to do a few things like
- create Contact records in Netsuite when someone signs up on Drupal
- create sales records in Netsuite when someone donates or buys something through paypal
- extract all Netsuite CRM records and populate Drupal node records
- extract all Netsuite Records of a particular type and syncronize them (just one way).

The thing I have come to realize is that its all pretty custom. ie. as soon as you modify Netsuite in anyway and have customfields defined, the webservices requires their internal name in order to get it to work to populate those fields.

In essence to create a single module I reckon is going to be tough, because Netsuite is so customizeable.

I guess it would be possible to create one for a Vanilla version of Netsuite, but I doubt it would solve most use cases when more information is required to be passed / accepted.

Just my two cents.

Yes thats very true, to

drupaledmonk commented 12 June 2010 at 06:06

Yes thats very true, to create a module to integrate is very tough with all the customizations that netsuite provides us. I completed the module for my client....but I dont think it will be of use for others. I hope some one comes up with something new.

HI ozecho, You said that you

chhavik commented 28 June 2012 at 05:55

HI ozecho,

You said that you have implemented few things using PHP Toolkit. Will it be possible for you to share your code as it would be a great help for us to start with the Drupal-Netsuite Integration.

Regards.

What are the steps to connect Drupal to netsuite?

Christian Le Fournis commented 19 August 2010 at 14:25

What are the steps to connect Drupal to Netsuite with the Phptoolkit?
Do you have a quick tutorial or similar, would be greatly appreciated.

Thank you.

Import the toolkit into your

drupaledmonk commented 21 August 2010 at 05:00

Import the toolkit into your custom module directory and start playing around with it in the module code.
Create a form for your self which will get data from the user in the drupal website. Then handle the data and post it to netsuite. A sample Use Case

include_once (drupaltonetsuite_path().'/PHPtoolkit.inc');
    	$myNSclient = new nsClient( nsHost::live );
	$email = "example@example.com";
	$password = "123";
	$account = "TSTDRV765234";
	$role = "3";

	// set request level credentials. (email, password, account#, internal id of role)
	$myNSclient->setPassport($email, $password, $account, $role);

        //Alternatively store it in the database and retrieve it.
	//include_once (drupaltonetsuite_path().'/login_info.inc');
	$customerFields = array (
		'isPerson'		=> false,
		'firstName'		=> $form_state['values']['first'],
		'lastName'		=> $form_state['values']['last'],
		'companyName'		=> $form_state['values']['company_name'],
		'phone'			=> $form_state['values']['phone'],
		'email'			=> $form_state['values']['email'],
		//'country' 		=> $form_state['values']['country'],
		'giveAccess'		=> false,
		'entityStatus'         => array('internalId' => '6'),
	);
	// create Customer record
	$customer = new nsComplexObject('Customer');
	// set fields
	$customer->setFields($customerFields);
	// perform add operation and store nsWriteResponse object in $addResponse variable 
	$addResponse = $myNSclient->add($customer);
	// handle add response
	if (!$addResponse->isSuccess) {
		echo "Lead couldnot be added in netsuite. Error: " .$addResponse->statusDetail[0]->message;		
	} else {
		echo "Lead has been successfully added";
	}

Globals

Andrew Udvare commented 1 December 2010 at 06:03

Had issues with globals regarding the PHPToolkit.

'Theoretical globals': http://groups.drupal.org/node/85444

/**
 * Properly include the PHPToolkit from NetSuite.
 */
function _ns_include() {
  global $myDirectory; // Theoretical globals
  global $version;
  global $endpoint;

  include_once drupal_get_path('module', 'ns_module').'/PHPToolkit/PHP_toolkit.php';
}

/**
 * @return nsClient object.
 */
function ns_client() {
  $mail = variable_get('ns_mail', '');
  $pass = variable_get('ns_pass', '');
  $account = variable_get('ns_account', '');
  $role = variable_get('ns_role', '');

  if ($mail == '' || $pass == '' || $account == '' || ($role == '' || !is_numeric($role)) {
    return NULL;
  }

  static $client;

  if (is_null($client)) {
    try {
      $client = new nsClient();
      $client->setPassport($mail, $pass, $account, $role);
    }
    catch (SoapFault $f) {
      watchdog('netsuite', t('SOAP error while initialising client. Message: %s.'), array('%s' => $f->getMessage()), WATCHDOG_ERROR);
      return NULL;
    }
    catch (Exception $e) {
      watchdog('netsuite', t('Error occurred initialising client. Message: %s.'), array('%s' => $e->getMessage()), WATCHDOG_ERROR);
      return NULL;
    }
  }

  return $client;
}

I was also wondering whether or not it is better to keep the client 'alive' all the time as a global variable.