Apache OFBiz offers a great deal of functionality, including:
Advanced e-commerce
Catalog management
Promotion & pricing management
Order management (sales & purchase)
Customer management (part of general party management)
Warehouse management
Fulfillment (auto stock moves, batched pick, pack & ship)
Accounting (invoice, payment & billing accounts, fixed assets)
Manufacturing management
General work effort management (events, tasks, projects, requests, etc)
Content management (for product content, web sites, general content, blogging, forums, etc)
Point Of Sales (POS) module using a rich client interface
Trunk: requires Java SDK version 1.6 (or greater)
To develop new module/ modify the existing module in ofbiz you should know the following skills.
FTL (Freemarker Template) for UI designing
Groovy scripting to perform DB operations
Minilang or Java to implement Ofbiz services
Along with this you should know the functionality of each module
As a developer we require one IDE to develop any application. We can use Eclipse as an IDE for OFBiz.
As we know ofbiz uses its own embedded database (Derby). We can also configure embedded database with Eclipse IDE to view/edit table structure and table data.