Sponsored Development: Interface with OSCommerce

This Wiki is read-only for reference purposes to avoid broken links.

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

Testers

ODM

Sponsors

ODM

Supporters

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