Adempiere ERP/CRM Web Shop in Drupal

ar_howard's picture

We are currently implementing Adempiere ERP/CRM with an implementation partner in Australia.

In our implementation project, our marketing department want to have a Webstore integrated in with general website content (e.g. latest news with various shopping artifacts (specials, checkout links, buy this) spread around the website. Further down the track marketing may wish to "customise" the way the web site works for particular customer profiles (both for Adempiere sales, and for Web2.0 collaboration type applications).

We are looking at having some development work done around this to allow Adempiere's webstore integrated into a Web Content Management System (CMS) to achieve this - at this stage the CMS has not been chosen, but we need to do so shortly.

My thoughts around this are not to implement any of the existing Drupal shopping carts but to look to create nodes in Drupal that link back to the ERP/CRM system. The reason being that we want to drive the system behaviour through the very configurable Active Directory of Adempiere and keep a single data-entry interface for our end-users. This also means that we can still manage people who phone-in to place an order rather than use the web. We would use the PostgreSQL database for both Adempiere & Drupal.

We would need to link Drupal logins on the website Adempiere, even being able to look at tracking people's activity before they login (i.e. cookies where they are allowed) and then create records in the Adempiere system to recognise when people travelled the website. We want people to be able to browse the website and then freely shop whilst they go. When shopping, pricing may change once they login and we want to be able to draw people's attention to complementary/alternative products in their area of interest as well as appropriate specials.

Obviously we would need to engage the correct level of expertise to help make it happen and then we would like to share this back with both the Adempiere & Drupal communities.

I would be interested in other's thoughts about this idea, and any likely difficult areas, including gotchas.

Comments

Linking Adempiere to Drupal

Quetschn-mo's picture

We already have a Drupal system running and now we would like to realize a ERP system with Adempiere. So we are highly interested in the post above. Are there already solutions for a convenient way to connect Adempiere to Drupal?

Reagards,
qm

Almost released - Final testing now

ar_howard's picture

Hi qm,

We sponsored 2 organisations to do this for us - Adaxa and PowerfulCMS and the solutions are to be made available via their respective open source licences.

We are in the final stages of testing this functionality. It is based on a modified ubercart using SOAP calls to Adempiere.

You can contact these organisations via their websites http://www.adaxa.com.au and http://www.powerfulcms.com/

It would be great if others can help bring further improvements as our initial funding is exhausted.

Cheers,
Allan.

Look here for details of Adempiere/Drupal integration

ar_howard's picture

The adempiere website has documentation and code showing how this was achieved.

http://www.adempiere.com/index.php/Complex_Distribution_System:_Case_Study

New & Improved version

Joe Matthew's picture

A new improved version of this shopping cart in Drupal with all the product, pricing, warehousing and accounting functions in Adempiere can be seen at http://demo.egility.biz/. Information on eGility can be seen at http://www.egility.biz/

Adempiere Drupal Integration Video

Joe Matthew's picture

Here is a abbreviated video from the presentation at Drupal Con in Melbourne 2012 on the Adempiere Drupal ecommerce integration approach - http://www.youtube.com/watch?v=5q1hQec9-No

Building ERP and BI platforms in Drupal

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week