Sponsored Development: Interface with OSCommerce

From ADempiere
Revision as of 08:51, 17 July 2007 by ODM ALP (Talk) (→‎Functional Specs)

Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

We are starting the work on this - if anyone cares to join, let us know

Summary

This feature will allow interaction between an existing OSCommerce site and ADempiere. This will be usefull to wait until ADempiere webstore matches the flexibility and featureset of OSCommerce.

Project Team

ODM

Coordinator

ALP

Assumptions

  • OSCommerce product catalog is manually synchronized with ADempiere Articles
  • Initial scope will not include the management of oscommerce "attributes".

Functional Specs

Behaviors to implement :

  • Export orders from OSC into ADempiere
  • Create new BP or update BP info in ADempiere (OSC overrides Compiere)
  • Export order status from ADempiere into OSCommerce : insert delivery notes info into OSCommerce
  • Export payments from OSC into ADempiere (imported payments will need to be confirmed manually - for control)

Issues to be addressed

  • OSCommerce delivery cost will need to be converted into an Article
  • Discounts / Coupons in OSCommerce will need to be managed in ADempiere
    • Suggestion to manage this : Article "Discount" with negative price (pros & cons ?)
  • OSCommerce attributes

Technical

  • What method of interaction between OSCommerce server and ADempiere server ?
  • Options :
    • OSCommerce posts (http) orders to ADempiere
    • ADempiere retrieves orders from OSCommerce (directly from Mysql)
    • Using a middleware for the transactions
  • Ideas:
    • Can Jitterbit help? See Jeff Davis' demo
    • Use Webservices. Pretty easy and fast to implement in php.
    • Give Posterita a look. It has a rich webstore that is already built by our bazaar members. - agreed, but this is a case where the Web store is already running on OSCommerce, also, from a "marketshare" perspective, there are thousands of OSCommerce webstores running on the web, giving them the option to use ADempiere as a backoffice would be quite a strong 'selling point'.

Developers

Testers

ODM

Sponsors

ODM

Supporters

  • Red1 07:22, 3 July 2007 (EDT)
  • already did this for other erp systems Jab doa 07:44, 3 July 2007 (EDT)

Alternative solution

We (rhlie) are currently working on an integration using UBL documents for integration. It works by sending xml documents from the OSC system (simple plugin in the order module). And then using jaxb to read them and convert them into adempiere objects. If we implement it this way we will be flexible enough to use the infrastructure with other systems, both internal and external.

Retrieved from "http://www.adempiere.com/index.php5?title=Sponsored_Development:_Interface_with_OSCommerce&oldid=26985"