=====Third Party Contributions=====

====osCommerce Interface====

Alan Jones - has contributed his work that allows webERP to be interfaced to osCommerce.
Updated September 2005 to work with webERP 3.01 database - it should be good for 3.03 since the major changes for lower casing and tax were all completed in 3.01 - many thanks Alan

Updated January 2009 by Geraint Jones. A few changes :

* All settings are now in conf.php
* The scripts are much more general (ie almost all hardcoded stuff
has gone)
* The scripts now work with WebERP v3.09
* The scripts now properly handle multiline orders
* Freight is fixed
* All the SQL is now safe (it is now getting escaped)

Anyway i really hope these scripts help someone other than me.

To get them running you need to edit conf.php

$mysql_host='localhost'; < Set this to your MySQL server
$mysql_user='root'; < Set this to the user for that server
$mysql_pass=''; < Set this to their password
$osc_db_name=''; < Set this to the name of the MySQL DB used by your
osCommerce install
$weberp_db_name=''; < Set this to the name of the MySQL DB used by your
WebERP COMPANY
$notify_email=''; < This is where you set the email address that things
get sent to
$shop_domain=''; < This is purely asthetic and just makes the email say
which domain they are for

You will also need to run the following SQL in your WebERP Company's DB
: "create table osc_order_sync (last_synced_order int);"
and you will be away to go - i have it running once a min from my crontab

Feel free to let me know if you use it.
~& [[http://www.weberp.org/uploads/ScreenShotUploads/osCommerceSync_1.-1.tgz Download osCommerce Sync Code]]
~& OR
[[http://sparx.net.nz/osCommerceSync_1.01.tgz Download osCommerce Sync Code]]

====Zen-Cart Interface====

Phil Daintree has created an interface that allows orders created in Zen-Cart to be imported together with customer details created in Zen-Cart. The application also has facilities to import Zen-Cart items into webERP and manage the mapping of Zen-Cart items to webERP item codes. This application does carry with it a small license cost.[[http://www.logicworks.co.nz Logic Works Web-site]]

====Spanish Translation of Manuals====

Marcos Garcia Trejo - has translated [[http://www.weberp.org/3rdPartyStuff/es_Manual-Pedidos.PDF Danie Brinks Order entry manual]].
He has also made a start on [[http://www.weberp.org/3rdPartyStuff/ManualSystemConventions.html Manual System Conventions]] and [[http://www.weberp.org/3rdPartyStuff/ManualSpecialUtilities.html Manual Special Utilities]] - thanks Marcos
Daniel J. Loayza M. has also translated a portion of the Manual and is available for download below:
[[http://www.weberp.org/wikidocs/images/guna_de_incio_rbpido_de_weberp_en_espasol.pdf guna_de_incio_rbpido_de_weberp_en_espasol.pdf]]

====German Translation of Manuals====

A German translation of the Manual has been made on this wiki!! Thanks Harald Ringehahn [[Inhaltsverzeichnis German Manual]]


====Chinese Translation of the Order Entry Manual====

Sing Major contributed his translation of Danie Brink's Order Entry Manual
[[http://www.weberp.org/3rdPartyStuff/WebERPChineseOEManual.pdf Download Chinese Order Entry Manual]]

====Starting From A New Empty Database====

Instructions for StartingAFreshSystem from an empty database
Contributed by Danie Brink

====Foreign exchange calculator====
A module that can be integrated with webERP to display an AJAX foreign exchange calculator in the footer.
GPL'd - FREE.
Link here: http://combatwombat.7doves.com/2009/03/13/new-project-forex

====synPOS Connector====

synPOS is an open source POS software written in Java. It can run standalone or connect to an ERP/eCommerce application. webERP connector is available at the projects website:

http://sourceforge.net/projects/synpos
Note: not updated since 2006. Not currently functional.

====Microsoft Access Helper/Reporting Application====

Hindra J has developed a cool reporting application that makes use of an ODBC driver for mysql - downloadable from www.mysql.com - this allows Access to "attach" the webERP tables that can then be used for reporting - this is an excellent way to import data as well - as described in the manual - but is a security risk and should not be made available to all.

[[http://hindraj.wikispaces.com/WebERPHelpers Screen shots of Hindra's application]]


====Allow Print Price Lists to print only items in stock====

Adds a selection dialog to PDFPriceList.php to choose to display "In Stock Items Only".

[[PDFPriceListInStock]]

====Improved GUI for Journal Entry====
(involves Ajax)

Changes the GUI for the journal entry page to

- find and autosuggest journal names
- add credit and debit sections (-1 x value entered)

http://moxx.in/downloads/GLJournal.zip

[[support@moxx.in Write to us if files are not available]]

====Joomla Shopping Cart Integration====
[[http://www.joomlamo.com/joomlamo/cartweberp.html Joomla Mo CARTwebERP download]]
**Other Joomla GUI interfaces to webERP for**:
- Inventory Pricing and change reorder levels
- Sales Order Importing
- Customer/Branch updates
- Display A/R Aging by Sales Person
- SugarCRM integration
- Salesman Dashboard
- Cell Phone Application - Enter quotes to webERP and email them from your cell phone!
[[mo@joomlamo.com If you add new webERP functionality using Joomla you can update either without migrating customized source code!]]
[[http://www.youtube.com/watch?v=XoJIsPVAEZ0 YouTube video for installing webERP on a hosted account]]