Sponsored Development: Interface with OSCommerce

From ADempiere ERP Wiki

Jump to: navigation, search

Contents

Summary

Interface between Adempiere and OSCommerce has been completed and is in production since december 2007 (on [www.mensway.com])

Project Team

ODM

Coordinator

ALP

Assumptions

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

Use Case

  • Export orders from OSC into CSV file (interface in OSC admin)
  • Place exported Orders into FTP server
  • Adempiere process checks availability of new orders
  • When found, CVS orders file is processed by Adempiere
  • Orders are created as "draft" sales orders


Implemented behaviors

  • Customers contact info are retrieved from orders :

- if customer exists as Business Partner in Adempiere (control done on email address), then Customer address is updated from Order - if customer does not exist, then a new Business Partner is created

  • Discounts / Coupons in OSCommerce are transformed into Order lines
  • Delivery of custom essay is transformed into an Order Line
  • A single VAT Rate is taken into account


Limitations

  • Payments are not processed - they are entered manually in Adempiere (this allows a proper control of transactions by a human being)
  • Product catalogs needs to be synchronized manually between OSCommerce and Adempiere. For those considering to implement a "master/slave" synchronisation, 2 caveats must be addressed : images (and other attached documents) and product categories.
  • Multilingual issues have not been addressed


Developers

Testers

ODM

Sponsors

ODM

Supporters

  • Red1 07:22, 3 July 2007 (EDT)
Personal tools