Sponsored Development: Interface with OSCommerce
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
Contents
Summary
Interface between Adempiere and OSCommerce has been completed and is in production since december 2007 (on [www.mensway.com])
Project Team
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)
- already did this for other erp systems Jab doa 07:44, 3 July 2007 (EDT)
XT-Commerce
We did a XT-Commerce integration. Should work with on OS-Commerce with little modifications (some fields are missing in OSC). Its very basic (no attributes or attached documents eg.) but works for our cases. --Jab doa 03:44, 10 November 2007 (EST)
