...
With an Emphasis on eCommerce
Written by: David E. Jones With feedback and contributions from Ruth Hoffman, Andy Zeneski, Si Chen, Chris Chesney, Hans Bakker, and Al Byers
Sponsored by:
Integral Business Solutions (http://www.go-integral.com)
Hotwax Media, Inc (http://www.hotwaxmedia.com)NOTE: this is the business setup guide for OFBiz, for the technical oriented one, look here.
Table of Contents
- Purpose and Goal of This Document
- Data To Gather for Setup
- General Terms and Information
- Business Setup Process
- General Company Setup
- Facility (Warehouse) Setup
- WebSite Setup
- Store Setup
- Catalog, Category, Product Setup
- Accounting Organization and Setup Process
- Marketing introduction
Purpose and Goal of This Document
Anchor | ||||
---|---|---|---|---|
|
In addition to being an excellent development framework and platform for enterprise information automation, OFBiz also features many great applications that can be used out of the box without a lot of customization. However, since it is enterprise class software, there are a lot of configuration options, settings, and data structures that require some level of familiarity.
...
NOTE: We recommend that you read this entire document before starting the process or making any changes. While you are reading it is helpful to look at the files and web pages in question so you can visualize better where things go and what they look like. Naturally you can ignore this, but a half hour studying this document could save you a lot of time late
Note on Typographic Conventions Used in This Documentunmigrated-wiki-markup
Text enclosed in a square box such as \ [\[ \ ]\] represents an OFBiz application browser tab selection.
Throughout the document the author has provided expert advice or other observations. These notations are indicated as follows:
...
Where OFBiz application manager web tools have individual page name or table name titles, the page names and titles are highlighted with a background color: This Is A Page
Data To Gather for Setup
Anchor | ||||
---|---|---|---|---|
|
- Company Party (Party Manager -> Find -> Profile; partyId: Company)
- Name
- Customer Service
- Telephone Number
- Email Address
- Correspondence Postal Address
- Warehouse Facilities (Facility Manager -> Facilities -> Facility)
- Title for each (ie Web Store Warehouse, or California Warehouse, or Burbank Distribution Center)
- Telephone Number
- Shipping & Receiving Postal Addresses (with names)
- Email Settings (general.properties)
- SMTP Server (relay host)
- SMTP Username (if needed)
- SMTP Password (if needed)
General Terms and Information
Anchor | ||||
---|---|---|---|---|
|
OFBiz "Manager" Applications
Anchor | ||||
---|---|---|---|---|
|
OFBiz provides a number of Manager applications, which make up the "back office" functions of the suite. These applications are not intended to be customer or public facing, but rather tools to be used to administer and manage the OFBiz software. Manager applications are, by default, accessible using standard URL addressing and built-in OFBiz security services.
Manager applications which will be referenced in this document include the:
"Catalog Manager" accessed at:
No Format |
---|
http://localhost:8080/catalog/control/main |
"Party Manager" accessed at:
No Format |
---|
http://localhost:8080/partymgr/control/main |
More technical web based tools, or tools for the OFBiz framework are available in the "Web Tools" application: http://localhost:8080/webtools/control/main
...
Once you are logged in to any of the OFBiz Manager Applications, tabs across the top will be in place to allow you to easily switch from one application to another, or to open them in a separate window or browser tab.
Other OFBiz Terms
Anchor | ||||
---|---|---|---|---|
|
In OFBiz a "Party" refers to a single entity such as a human being or a company or a family or even a group of friends. In other words, it can represent an individual (a Person) or a group of parties, including individuals and other groups (a Party Group).
The "Entity Engine" refers to the embedded OFBiz database access engine. Likewise there are other "engines" in OFBiz including the Service Engine which is another critical tool that is the foundation of the service oriented architecture for logic and processes in OFBiz.
Business Setup Process
Anchor | ||||
---|---|---|---|---|
|
General Company Setup
...
Anchor | ||||
---|---|---|---|---|
|
There is There is a Party with the ID "Company" that is configured as the default Party that represents the company that owns or is running the system. You can have multiple organizations configured in the system, but this one is referred to be default in the Demo Product Store (which we will be modifying and not replacing in a minute).
Company Contact Information
Anchor | ||||
---|---|---|---|---|
|
In the Party Manager "Find" page type in "Company" in the Party ID field and press enter. This will bring up the View Profile page for the Party.
...
You should also setup any telephone numbers and email addresses you want for your Company.
Facility (Warehouse) Setup
Anchor | ||||
---|---|---|---|---|
|
There is a Facility with the ID "WebStoreWarehouse" that we will be modifying in this step. This is the default fulfillment facility for the Demo Store (which we will be modifying and not replacing soon). You can create other Facilities here, but for this basic setup we will keep the single warehouse configuration and modify this warehouse in place.
...
There are various other things that can be setup here including more advanced options such as Facility Locations for inventory, and so on. This is also where you can go to manage picking/packing and shipping of orders, and the receiving of returns, purchase orders, and so on.
WebSite Setup
Anchor | ||||
---|---|---|---|---|
|
There is a WebSite already setup with the ID "WebStore". This ID is referred to in the webSiteId field of the web.xml file in the eCommerce webapp.
...
Note that the settings in the url.properties file can be overridden for each WebSite, as can be seen on the Edit Web Site page in the Content Manager.
Store Setup
Anchor | ||||
---|---|---|---|---|
|
There is a demo eCommerce store already setup with most of the options we need, so instead of creating a new one we will use that one and just change it's name and other options. The ID, which is 9000, will stay the same.
...
As we setup the store we will cover each tab in order and discuss options on that page and related options in configuration files:
Store Settings
Anchor | ||||
---|---|---|---|---|
|
Change the Store Name to something more applicable. This is mostly for internally referring to your store and won't be shown to the customer.
...
There are many other settings on the Store, most of which you won't want to touch. For more information on them see the Undersun documentation site or other such reference material
Store Role Settings
Anchor | ||||
---|---|---|---|---|
|
There are various reasons why you might want to associate a Party with a Store. The main one to consider is in order for a Party to take sales orders for a specific Store the Party must be associated with the Store in the "Sales Representative" role.
Promotional Settings
Anchor | ||||
---|---|---|---|---|
|
This is where you can associate promotions (setup in the Promos header tab) with the store, including effective dating, sequencing and so forth.unmigrated-wiki-markup
There are all example promotions and it is good to keep them in the database for future reference, but you can delete all of these store associations so they won't get in the way for this store. Just click on the "\[Delete\]" link for each one.
Catalog Settings
...
Anchor | ||||
---|---|---|---|---|
|
This tab shows all Product Catalogs associated with this Store. The demo data has two Catalogs associated by default, and you can remove both of them since we will be creating a new Catalog later. These two you can leave in the database as examples for future reference, but click on the "\[Delete\]" buttons here to remove the associations with the Store.
Web Site Settings
Anchor | ||||
---|---|---|---|---|
|
This tab shows all WebSites associated with this store, or that this store is associated with. You will see that the demo data already has this Store associated with the eCommerce Web Site, and the Order Entry Web Site.
Leave these defaults as they are.
If you have your own ecommerce webapp and have created a WebSite for it as described above, associate that WebSite with the store.
Sales Tax Settings
Anchor | ||||
---|---|---|---|---|
|
It is possible to use other tax calculation services or integrate with other tax calculation software, and there are others included with OFBiz, but the default one uses a simple OFBiz entity with records for different tax jurisdictions and effective dates.
...
For more complicated tax requirements and data that is kept up to date consider commercial options. There is a TaxWare integration in OFBiz, but this runs through JNI to talk to the native TaxWare libraries (ie non-Java) and requires a lot of maintenance to use over time. Another option available in OFBiz is support for the ZipSales tax database, which can be imported and then updates are imported on a regular basis.
Shipping Settings
Anchor | ||||
---|---|---|---|---|
|
Each Store may have one or more shipping options configured. Shipping options consist of shipping methods, shipping providers and rules which link methods, providers and cost estimate calculations. The OFBiz e-commerce demonstration data is preconfigured with a number of shipping methods including "Ground", "Air", "Next Day" and "None" and several well know shipping providers including, United Parcel Service (UPS), the United States Post Office (USPS). In addition, templates for cost estimate rules are provided to ease the customization process. Finally, OFBiz provides interfaces, and in some cases, rudimentary configuration guidance, to allow the e-commerce store to connect directly and communication with several major shipping providers.
...
From the Product Store Shipment Settings page, there are two main sub-page links:
- New Shipment Estimate
- New Shipment Method
The New Shipping Estimate link allows the user to apply a new estimate to the store for an existing shipping method. Shipping methods may have one or more estimates associated with them - ...For example, if the default configuration for "Guaranteed Next Day (UPS) should be changed from no surcharge for a specific feature group to a fixed surcharge for a feature group, this is the place to do it.
...
From either of these two pages you can get back to the summary of all of the cost information for these estimates with the View Estimates link.
UPS Online Rate Estimates
Anchor | ||||
---|---|---|---|---|
|
This is used during the checkout process to get an estimate from UPS based on the weights of products being ordered.
...
This is configured using various properties in the file:
No Format |
---|
${ofbiz install dir}/applications/product/config/shipment.properties |
file.
- UPS XPCI Access License Number
- o shipment.ups.access.license.number
- o Example: TEST262223144CAT
- o This license number is used for both the UPS shipment estimate online service and the UPS XPCI shipping interface services (described below)
- Shipper Default Pickup Type
- shipment.ups.shipper.pickup.type
- Example: 06
- Valid options:
- 01 - Daily Pickup
- 03 - Customer Counter
- 06 - One Time Pickup
- 07 - On Call Air Pickup
- 11 - Suggested Retail Rates (UPS Store)
- 19 - Letter Center
- 20 - Air Service Center
- Choose the option that represents your relationship with UPS. This affects the estimated rate you will get back since UPS varies their prices based on how you get your packages to them.
- Estimate split into packages
- shipment.ups.max.estimate.weight
- Example: "90" meaning 90 pounds
- This number is used as the max weight per package when the total weight is > than this weight the weights are split into packages not exceeding max.
UPS XPCI Integration
Anchor | ||||
---|---|---|---|---|
|
The UPS XPCI services provide for all interactions between a customer and UPS to register shipments, send weight/size information for each package, get actual prices from UPS, and get images for complete labels to print and affix to each package.
...
These services are integrated with the Shipment code in the Route Segments area and links in the user interface appear when the Carrier Party ID is "UPS".
ß This is configured using various properties in the file:
No Format |
---|
${ofbiz install dir}/applications/product/config/shipment.properties |
...
|
- UPS Shipper Number
...
- shipment.ups.shipper.number
...
- Example: 486915
...
- UPS Bill Shipper Account Number
...
- shipment.ups.bill.shipper.account.number
...
- Example: 486915
...
- UPS XPCI Access License Number
...
- shipment.ups.access.license.number
...
- Example: TEST262223144CAT
...
- UPS XPCI Access User ID
...
- shipment.ups.access.user.id
...
- UPS XPCI Access Password
...
- shipment.ups.access.password
...
- Setting to save files needed for UPS certification
...
- shipment.ups.save.certification.info=true
...
- shipment.ups.save.certification.path=/ofbiz/work/ofbiz/upscert
...
- This option is used to create the artifacts the UPS needs to certify client implementation. It is generally required for each customer to go through this process and for UPS to verify the results. Once this is done the shipment.ups.save.certification.info property should be set to false. For more information on this process, see the UPS XPCI documentation and additional information in the UpsServices.java file.
USPS Online Rate Estimates
Anchor | ||||
---|---|---|---|---|
|
This is used during the checkout process to get an estimate from USPS (the United State Postal Service) based on the weights of products being ordered.
...
For this to work the CarrierShipmentMethod.carrierServiceCode field must be populated (as it is in the DemoShipping.xml file). Examples include "Priority", "Express", etc.
This is configured using various properties in the file:
No Format |
---|
${ofbiz install dir}/applications/product/config/shipment.properties |
ß #
- USPS Connection URL & timeout in seconds
...
- shipment.usps.connect.url
...
...
- shipment.usps.connect.timeout
...
- Example: 60
...
- USPS Credentials
...
- shipment.usps.access.userid
...
- shipment.usps.access.password
...
- Estimate split into packages
...
- shipment.usps.max.estimate.weight
...
- Example: 70
Store Payment Settings
Anchor | ||||
---|---|---|---|---|
|
This page is used to configure the payment processing settings for the various Payment Method Types in OFBiz.
...
To setup Credit Card (and certain other payment types) processing just specify the services to use for each of the following processes:ß
- Payment Authorization Service
...
- Payment Capture Service
...
- Payment Re-Authorization Service
...
- Payment Refund Service
...
- Payment Release Authorization Service
All service definitions for the payment processing that are included with OFBiz are in the ${ofbiz install dir}/applications/accounting/servicedef directory.ß
- For CyberSource see the service definitions in the services_cybersource.xml file. This includes these services: cyberSourceCCAuth, cyberSourceCCCapture, cyberSourceCCRelease, cyberSourceCCRefund, and cyberSourceCCCredit
...
- For ClearCommerce see the service definitions in the services_clearcommerce.xml file.
...
- For PCCharge see the service definitions in the services_pccharge.xml file.
...
- For RiTA see the service definitions in the services_rita.xml file.
...
- For Verisign PayFlo Pro see the service definitions in the services_verisign.xml file.
...
- For ValueLink (gift cards) see the service definitions in the services_valuelink.xml file.
Payment Processor Details
Anchor | ||||
---|---|---|---|---|
|
While the payment services and high level settings are configured in the Store section of the Catalog Manager the detailed configuration for the various payment processing services are configured in the file:
No Format |
---|
${ofbiz install dir}/applications/accounting/config/payment.properties |
ß
- There are many comments in this file and sections for each of the major payment processing services.
...
- If you are using any credit card payment processor, be sure to check and if necessary change the properties near the beginning of the payment.properties file that follow the pattern: "payment.general.reauth.*.days".
PayPal Payment Setup
...
The PayPal details for OFBiz are setup in the payment.properties file and have the prefix "payment.paypal.".
The ones that always need to be changed for use of PayPal are:
ß payment.paypal.business - set to an email address on your PayPal account
ß payment.paypal.notify - just change domain name and port to the production values you are using
ß payment.paypal.return - set to the URL where you want PayPal to send customers once payment is complete, typically back to your ecommerce web site
ß payment.paypal.cancelReturn - set to the URL where you want PayPal to send customers when they cancel their payment
ß payment.paypal.image - set to the URL of the image or logo you want PayPal to display to help customers know that the payment is being received on your behalf
The other properties beginning with "payment.paypal." can be set, but unless you know what you are doing we recommending leaving them as-is.
In addition to the settings in the payment.properties file, there is also a setting that you must change on the PayPal web site in your account so that notifications will be sent back to OFBiz to verify payment:
1. Login to your account at PayPal.com
2. Click on the "Profile" link in the header, near the top-right of the page
3. In the "Selling Preferences" column click on the "Instance Payment Notification Preferences"
4. It will show you the current settings. To chance click on the "Edit" button.
5. Check the check box near the top of this page, just under the "Instant Payment Notification (IPN)" heading.
6. Enter the notification URL in the text box. This should be the same as the value of the payment.paypal.notify property in the payment.properties file.
7. Click on the "Save" button.
CyberSource Payment Setup
ß The CyberSource details for OFBiz are setup in the payment.properties file and have the prefix "payment.cybersource."
ß More details to come.
e-mail Settings
This page is used to configure the email messages to send for various events in the ecommerce system.
There is a record for each email in the system by default, but if there is an email that you don't want sent you can Delete the corresponding record here.
For those you do want to keep you will want to change the following fields for each email message, one at a time:
ß 2nd field, From Address, to your preferred customer contact email address
ß 4th field, Bcc Address, to any email address you would like to be copied on each email message
ß The other fields, like the 5th field, the Subject field, can be customized if desired.
If you want to modify any of the templates, we recommend that you copy the templates to your own location, change them there, then change the template locations on this page to point to your files.
Survey Settings
This page is used to configure surveys that are used for various things in ecommerce including random polls that show up on the side bars, special product related surveys to gather additional information about specific products or products in specific categories, surveys associated with the customer profile, and so on.
The demo surveys here can all be removed, though feel free to look at each one to see if it or something like it might be nice to have on your site.
General Settings Override
This page is used to configure product search keyword overrides. These overrides can redirect the user to a specific category, product, or OFBiz or arbitrary URL. For example, when a user searches for the word "gizmo" they are redirected to the Gizmos category (ID 100).
The demo data in place is just an example and should be removed to avoid accidental undesired behavior in product keyword searches on your site.
Catalog, Category, Product Setup
Catalog Setup
Rather than reusing existing Catalogs we will create a new one to associate with the Store we have been configuring, and it will be the only one associated with the Store (unless you want to create multiple Catalogs, of course).
To create a new Catalog:
1. Go to the "Main" in the Catalog Manager and click on the link labeled "Create New Catalog" near the top of the central area of the page.
2. Enter an ID for the Catalog in the Prod Catalog Id field (this cannot be changed later).
3. Enter a name for the Catalog in the Catalog name field.
Unless you know you want to use the special Quick Add categories in this Catalog, I recommend setting the Use Quick Add field to N.
4. The other fields are optional but can be used to customize the look and feel of this Catalog to distinguish it from others (if applicable).
5. Submit the form with the update button.
Once the new Catalog is created, go to the Stores tab and make sure this Catalog is associated with the Store we just configured.
While here, take a look at the Categories tab. We will soon be creating some Categories to use with this Catalog. There are many types here, but the main ones we will be concerned with are:
...
Anchor | ||||
---|---|---|---|---|
|
- Go to Accounting - Payment Gateway Config and select "PayPal Payment Gateway" from the list
- Please fill all those fields to made working correctly to work with PayPal:
Business Email : Email address of your business
Notify URL : PayPal Notify URL (example (http://yourServerName/ecommerce/control/payPalNotify)
Return URL : PayPal Return URL (example (http://yourServerName/ecommerce/control/orderhistory)
Cancel Return URL : PayPal Return On Cancel URL (example http://yourServerName/ecommerce/control/payPalCancel/main)
Image URL : Image To Use On PayPal (example (http://yourServerName/images/ofbiz_logo.gif)
Confirm Template : Thank-You / Confirm Order Template (example /order/emailconfirmation.ftl)
Redirect URL : PayPal Redirect URL (Sandbox http://www.sandbox.paypal.com/us/cgi-bin/webscr Production https://www.paypal.com/cgi-bin/webscr)
Confirm URL : PayPal Confirm URL (Sandbox https://www.sandbox.paypal.com/us/cgi-bin/webscr Production http://www.paypal.com/cgi-bin/webscr) - Once PayPal Payment Gateway has been configurated you have to go to Catalog - Stores - select your Store - Payments tab
- Edit the Payment Method Type Paypal and choose as Payment Gateway Config Id "PayPal Config".
As deprecated use you can alternatively change the configuration parameters into
No Format ${ofbiz install dir}/applications/accounting/config/payment.properties
The ones that always need to be changed for use of PayPal are:- payment.paypal.business - set to an email address on your PayPal account
- payment.paypal.notify - just change domain name and port to the production values you are using
- payment.paypal.return - set to the URL where you want PayPal to send customers once payment is complete, typically back to your ecommerce web site
- payment.paypal.cancelReturn - set to the URL where you want PayPal to send customers when they cancel their payment
- payment.paypal.image - set to the URL of the image or logo you want PayPal to display to help customers know that the payment is being received on your behalf
The other properties beginning with "payment.paypal." can be set, but unless you know what you are doing we recommending leaving them as-is.
In addition to the settings in the payment.properties file, there is also a setting that you must change on the PayPal web site in your account so that notifications will be sent back to OFBiz to verify payment:
- Login to your account at PayPal.com
- Click on the "Profile" link in the header, near the top-right of the page
- In the "Selling Preferences" column click on the "Instance Payment Notification Preferences"
- It will show you the current settings. To chance click on the "Edit" button.
- Check the check box near the top of this page, just under the "Instant Payment Notification (IPN)" heading.
- Enter the notification URL in the text box. This should be the same as the value of the payment.paypal.notify property in the payment.properties file.
- Click on the "Save" button.
Payflow Pro Payment Setup
Anchor | ||||
---|---|---|---|---|
|
Put payflow.jar from Payflow Pro's Java SDK in the directory in
No Format ${ofbiz install dir}applications/accounting/lib.
- Change the accounting build.xml and comments to not exclude verisign sources like here :
<!- <exclude name="org/ofbiz/accounting/thirdparty/verisign/**"/> -> - Confirm that applications/accounting/build/classes/org/ofbiz/accounting/thirdparty/verisign/PayflowPro.class was built and exists
- The installation of certificate is now no more necessary
- Go to Accounting - Payment Gateway Config and select "Payflow Pro Payment Gateway" from the list
- Please fill all those fields to made working correctly to work with Payflow Pro:
Certs Path : Path the the VeriSign Certificate (No more used from version v4)
Host Address : Address of the payment processor (example (Test pilot-payflowpro.paypal.com or Production payflowpro.paypal.com)
Host Port : Port of the payment processor (default is 443)
Timeout : Timeout (default is 80 seconds)
Proxy Address : Proxy Address
Proxy Port : Proxy Port (default is 80)
Proxy Logon : Proxy Logon
Proxy Password : Proxy Password
Vendor : Vendor of account information
User Id : PayFlow UserID of account information
Pwd : PayFlow Password of account information
Partner : PayFlow Partner of account information
Check Avs : Use Address Verification
Check Cvv2 : Require CVV2 Verification
Pre Auth : Pre-Authorize Payments (if set to N will auto-capture)
Enable Transmit : Set to false to not transmit anything
Log File Name : Log file name
Logging Level : Logging level
Max Log File Size : Max log file size
Stack Trace On : Stack trace on/off - Once Payflow Pro Payment Gateway has been configurated you have to go to Catalog - Stores - select your Store - Payments tab
- Edit the Payment Method Type Credit Card and after selected a Service Type (Authorize, Capture, ...) you can choose the Custom Method related to the Service Type choosen and as Payment Gateway Config Id "Payflow Pro Config".
As deprecated use you can alternatively change the configuration parameters into
No Format |
---|
${ofbiz install dir}/applications/accounting/config/payment.properties
|
Configure all the parameters starting with name "payment.verisign" in payment.properties including directory, vendor, partner, user and password all.
CyberSource Payment Setup
Anchor | ||||
---|---|---|---|---|
|
Put cybsclients15.jar, cybssecurity.jar and xalan.jar from CyberSource SDK in the directory in
No Format ${ofbiz install dir}applications/accounting/lib/cybersource.
- Change the accounting build.xml and comments to not exclude verisign sources like here :
<!- <exclude name="org/ofbiz/accounting/thirdparty/cybersource/**"/> -> - Confirm that applications/accounting/build/classes/org/ofbiz/accounting/thirdparty/cybersource/IcsPaymentServices.class was built and exists
- The installation of certificate is requested and you can follow the instructions into the CyberSource Certificate Update manual.
- Go to Accounting - Payment Gateway Config and select "CyberSource Payment Gateway" from the list
- Please fill all those fields to made working correctly to work with CyberSource:
Merchant Id : your merchant Id
CyberSource API version : target API version (now is 1.43)
Directory of the keys from CyberSource : Generate using online tools
Name of the keystore : keystore file name (default is "merchantID".p12)
Log transaction information : log activated true/false (default is true)
Log directory : Log directory (default is runtime/logs)
Log File Name : Log file name (default is cybersource.log)
Max log size : Megabytes allowed for the log file
Merchant Description : Shown on credit card statement Vendor
Merchant Description Contact Information : Shown on credit card statement Vendor
Auto-Bill In Authorization : Capture automatically true/false (default is false)
Use DAV In Authorization : May not be supported any longer
Use Fraud Scoring In Authorization : May not be supported any longer
Ignore AVS results : Ignore Address Verification Service true/false (default is false)
Disable AVS for Capture : May not be supported any longer
AVS Decline Codes : May not be supported any longer - Once CyberSource Payment Gateway has been configurated you have to go to Catalog - Stores - select your Store - Payments tab
- Edit the Payment Method Type Credit Card and after selected a Service Type (Authorize, Capture, ...) you can choose the Custom Method related to the Service Type choosen and as Payment Gateway Config Id "CyberSource Config".
As deprecated use you can alternatively change the configuration parameters into
No Format |
---|
${ofbiz install dir}/applications/accounting/config/payment.properties
|
Configure all the parameters starting with name "payment.cybersource" in payment.properties including directory, vendor, partner, user and password all.
Authorize.net Payment Setup
Anchor | ||||
---|---|---|---|---|
|
- The installation of certificate is requested and you can follow also use the instructions from Andreas Sterbenz's blog documented in Google Checkout Integration.
- Go to Accounting - Payment Gateway Config and select "Authorize Dot Net Payment Gateway" from the list
- Please fill all those fields to made working correctly to work with Authorize.net:
Transaction URL : Test/Production Transaction Url
Certificate Alias : Certificate Alias in the Keystore.
Authorize Dot Net API version : currently 3.1
Delimited Data : if the authorize.net response should delimited
Delimited Character : the delimiter to use in the response.
Method (only CC supported) : credit card processing.
Email to Customer : if should send an email to the customer for each transaction
Email to Merchant : if should send email to the merchant for each transaction
Test Mode : Forces the URL property to the test URL and adds more logging info to the logs
Relay Response : if should relay the reposnse to a different server
Transaction Key : Authorizer.net transaction key.
User Id : Your Authorize.net user id.
Pwd : Your Authorize.net password.
Trans Description : Your Transaction Description. - Once Authorize.net Payment Gateway has been configurated you have to go to Catalog - Stores - select your Store - Payments tab
- Edit the Payment Method Type Credit Card and after selected a Service Type (Authorize, Capture, ...) you can choose the Custom Method related to the Service Type choosen and as Payment Gateway Config Id "Authorize Dot Net Config".
As deprecated use you can alternatively change the configuration parameters into
No Format |
---|
${ofbiz install dir}/applications/accounting/config/payment.properties
|
Configure all the parameters starting with name "payment.authorizedotnet" in payment.properties.
RBS WorldPay Payment Setup
Anchor | ||||
---|---|---|---|---|
|
- Go to Accounting - Payment Gateway Config and select "RBS WorldPay Payment Gateway" from the list
- Please fill all those fields to made working correctly to work with RBS WorldPay:
Redirect URL : Test/Production Redirect Url
Worldpay Instance Id : Your Worldpay Instance Id.
Authorization Mode : Full-Authorize / Pre-Authorize.
Contact details not-editable : Will displace contact info on WorldPay in non-editable format
Contact details to be hidden : Will hide the contact info completely
Currency drop-down to be hidden : Will hide the currency info
Shopper language Id : locale to be used
Suppressed Language Menu : if should the language menu to be suppressed.
Delivery Address Editable : if should the delivery address editable.
Test Mode : Approve/Cancelled/Live Mode. - Once RBS WorldPay Payment Gateway has been configurated you have to go to Catalog - Stores - select your Store - Payments tab
- Edit the Payment Method Type Credit Card and after selected a Service Type (Authorize, Capture, ...) you can choose the Custom Method related to the Service Type choosen and as Payment Gateway Config Id "RBS WorldPay Config".
As deprecated use you can alternatively change the configuration parameters into
No Format |
---|
${ofbiz install dir}/applications/accounting/config/payment.properties
|
Configure all the parameters starting with name "payment.worldpay" in payment.properties.
Giftcards Setup
Anchor | ||||
---|---|---|---|---|
|
GiftCard creation:
- The giftcard is enabled in the productstore in the catalog as a payment method with several parameters.
- The productStore has a field called "Show Checkout Gift Options" this should be set to "Y"
- In the entity 'ProductStoreFinActSetting' it can be set if the card requires a pinCode. By default in the demodata this is set to "N"
- The giftCard can be bought or reloaded as product in the product catalog.
- If a giftcard is purchased a financial account is created for the new giftcard in addition to an invoice and payment and ledger transactions. For this to work you have to activate the 'eca' createFinAccountTrans in accounting/servicedef/secas.xml
Using the Giftcard as payment:
- The giftcard code which is listed in the financialAccount
- If the card is used with enough balance the Order gets rejected.
e-mail Settings
Anchor | ||||
---|---|---|---|---|
|
This page is used to configure the email messages to send for various events in the ecommerce system.
There is a record for each email in the system by default, but if there is an email that you don't want sent you can Delete the corresponding record here.
For those you do want to keep you will want to change the following fields for each email message, one at a time:
- 2nd field, From Address, to your preferred customer contact email address
- 4th field, Bcc Address, to any email address you would like to be copied on each email message
- The other fields, like the 5th field, the Subject field, can be customized if desired.
If you want to modify any of the templates, we recommend that you copy the templates to your own location, change them there, then change the template locations on this page to point to your files.
Survey Settings
Anchor | ||||
---|---|---|---|---|
|
This page is used to configure surveys that are used for various things in ecommerce including random polls that show up on the side bars, special product related surveys to gather additional information about specific products or products in specific categories, surveys associated with the customer profile, and so on.
The demo surveys here can all be removed, though feel free to look at each one to see if it or something like it might be nice to have on your site.
General Settings Override
Anchor | ||||
---|---|---|---|---|
|
This page is used to configure product search keyword overrides. These overrides can redirect the user to a specific category, product, or OFBiz or arbitrary URL. For example, when a user searches for the word "gizmo" they are redirected to the Gizmos category (ID 100).
The demo data in place is just an example and should be removed to avoid accidental undesired behavior in product keyword searches on your site.
Catalog, Category, Product Setup
Anchor | ||||
---|---|---|---|---|
|
Catalog Setup
Anchor | ||||
---|---|---|---|---|
|
Rather than reusing existing Catalogs we will create a new one to associate with the Store we have been configuring, and it will be the only one associated with the Store (unless you want to create multiple Catalogs, of course).
To create a new Catalog:
- Go to the "Main" in the Catalog Manager and click on the link labeled "Create New Catalog" near the top of the central area of the page.
- Enter an ID for the Catalog in the Prod Catalog Id field (this cannot be changed later).
- Enter a name for the Catalog in the Catalog name field.
- Unless you know you want to use the special Quick Add categories in this Catalog, I recommend setting the Use Quick Add field to N.
- The other fields are optional but can be used to customize the look and feel of this Catalog to distinguish it from others (if applicable).
- Submit the form with the update button.
Once the new Catalog is created, go to the Stores tab and make sure this Catalog is associated with the Store we just configured.
While here, take a look at the Categories tab. We will soon be creating some Categories to use with this Catalog. There are many types here, but the main ones we will be concerned with are:
- Browse Root (One): this category will be the parent category of all of the top level browse categories for the catalog. It will not be visible to the customer, but it's children will be the main or top-level browse categories.
- Promotions (One): the products in this category are listed on the default eCommerce Main page. Of course, that page can be customized to show other things, but if you are using the default OFBiz ecommerce templates main page, you should create a Promotions category to configure which products will be displayed there.
- Default Search (One): if a Default Search category is configured only the products in this category will show up in product search results. This category can also have Feature Categories and Feature Groups with it, and the Features in those groups will be used to populate the parametric search drop-downs on the Advanced Search page. Of course, when searching within a specific Category only the features associated with that category will be used for the parametric search drop-downs in the Advanced Search page.
...
- Purchase Allow (One): if a Purchase Allow category is configured only the products in that category will be available for purchase when this catalog is active. In that case if a product not in this category is put in the cart an error will be shown to the customer. In general for easier maintenance it is best to have this set to the same category as the Default Search category.
...
- View Allow (One): if a View Allow category is configured only the products in that category will be visible when this catalog is active. Other products will not show up in search results, category browsing, and if someone tries to view the product by ID it will report that no product is found for this ID. There is a performance impact associated with the use of this category, so alternatives might be desirable in certain circumstances. In general for easier maintenance it is best to have this set
...
- to the same category as the Default Search category.
Category Setup
Anchor | ||||
---|---|---|---|---|
|
As described in the Catalog Setup section there are various basic Categories that we need to create for our new Catalog. We will create four categories:
- A Browse Root Category
- A top-level browse Category to be a child of the browse root category
- A Promotions Category
- An "All Products" Category that will be setup as the Default Search, Purchase Allow and View Allow categories for our catalog.
To Create a Category:
- Go to the "Main" in the Catalog Manager and click on the link labeled "Create New Category" near the top of the central area of the page.
- Enter an ID for the Category in the Product Category ID field (this cannot be changed later).
- All of these categories can use the "Catalog" setting for the Product Category Type field.
- The other fields can be set, but are not necessary. Note that Category hierarchies do not use the Primary Parent Category field, instead they are done with the Rollup tab once the Category is created.
- Submit the form by clicking on the update button.
Once the Category is created go to the Content tab and look near the bottom of the page in the Override Simple Fields section to set a Description, and if desired also a Long Description.
For each of the categories that we are creating, go to the Catalogs tab in the Category section, or the Categories tab in the Catalogs section and associate them using the appropriate type(s) as described above.
For the top-level browse Category that will be a child of the Browse Root Category associate them using the Rollup tab for whichever one you create second. Both parent and child categories can be setup there.
Product Setup
Anchor | ||||
---|---|---|---|---|
|
Congratulations, you are finally to the point where you can start setting up products....
To create a Product follow a process similar to those described for other things, like Categories.
- Go to the main page of the Catalog Manager and click on the "Create New Product" link.
- If you fill in an ID it will make sure that ID is valid, and if so it will use that one. If you specify no ID it will generate one.
- Set an Internal Name that makes it easy for you to recognize the product. This name will be shown in the admin tools, but not to the customer.
- Note that if you are using the UPS or USPS or other online rate estimation utilities then you must have values in the "Weight" and "Weight Uom Id" fields.
- Submit the form to create the product.
Add Content to the New Product
Anchor | ||||
---|---|---|---|---|
|
- Click on the "Content" tab/button for the product you just created. Here you can setup text and images for your product.
- You will see some forms at the top for administering managed content (ie from the Content Manager) with the product. For more advanced product related content needs use this, but for more common and simple needs, this can be more difficult to administer and slower at run time.
- Near the bottom of the page is a section labeled "Override Simple Fields". Here you will typically want to specify a Product Name, Product Description, and Long Description. If you have images to associate with the product, you can specify their locations here, or upload them. Note that there are default locations for the images (can be quickly set by clicking on the "[.jpg]" or "[.gif]" buttons). We recommend using these locations, but of course you can put your images anywhere. These can be an absolute URL, or will be relative to the current server address, or the content URL prefix if one is specified in the url.properties file.
Add Prices to the Product
Anchor | ||||
---|---|---|---|---|
|
- Product pricing in OFBiz is very flexible. There are two main aspects to it: Prices and Price Rules. This is independent of promotions, which are applied after the price calculation is done.
- For basic operation you should have at least one type of price setup for each product: the Default Price. This is the price that is used when no rules apply.
- To add a Default Price go to the Prices tab for the Product, and use the form at the bottom of the page.
- The Product Price Type Id should be "Default Price", the Currency Uom Id should be whatever currency the price is in, and the Product Store Group Id can be left as Not Applicable, unless you are setting up multiple groups of stores that have different pricing.
- The From Date can be now or in the future, if you want the price to take effect in the future. The Thru Date is optional, but can be used to specify that this particular price expires at a certain date and time. Note that if there are multiple prices of the same type, etc that are active at once, it will use the one with the most recent From Date. This is useful when you want a temporary price to override the normal "Default" price of the product.
- If you are using price rules or may do so in the future you may also want to enter information such as the List Price and the Average Cost which are often used in the price calculations.
- Note that if a Minimum Price is set the price will never be less than that. So, even if the Default Price is to 2.00 and the Minimum Price is set to 3.00, then 3.00 will be used as the calculated price. The Maximum Price setting works the same way as the ceiling for the price.
Make sure to put each product in a browse category, and in the All Products category so that it can be searched for, viewed, and purchased in your catalog.
Also, if you want to know "How to localize Product and Categories descriptions"
Expert Recommendation: These are the basics, but there is a lot more information about products that you can, or may need to, setup. We recommend reviewing the more detailed documentation or engaging the services of an experienced consulting to help you through this.
Advanced Catalog Setup: Features, Promotions, Price Rules, Keyword Thesaurus, Features for special functionality or parametric search, Moderated (or unmoderated) Product Reviews, Configurable and Manufactured Products, Virtual and Variant Products, Inventory/Facility/Location settings, and so on
See the end-user documentation space for details on how to set these things up and what they mean. Also see this for more advanced options for Products, Categories, and so on.
Accounting data organization and Setup
Anchor | ||||
---|---|---|---|---|
|
(field/entitynames in brackets[])
General principles
- The general ledger of ofbiz consists out of a list of 'ledger buckets = glAccounts' with a non meaningfull ID: [glAccountId] and a meaningfull code [accountCode] and a meaningfull name [accountName] Initially, in the demo data, the account id and code are the same. When reorganizations are required these codes can be easily renamed without changing the glAccountId.
- The buckets are in a hierarchy where totals of the lower levels are added together and be shown at the higher levels, therefore every ledger bucket has a parent [parentGlAccountId]; with one exeption if the glaccount is a toplevel glAccount/bucket.
- Every glAccount has a account type id [glAccountTypeId] with a organization dependent second default glAccountId [GlAccountTypeDefault.glAccountId] to be able for the system to create the double booking. (Currently the system will do that always to "ACCOUNTS_RECEIVABLE" default glAccountTypeId for sales invoices).
- Transactions are created for several reasons like posting of invoices or payments, inventory movements and workeffort costs.
- GlAccount class is used for categorization and reporting.
General Setup (accounting -> global GlSettings)
- Company data and internal organizations
demo file at: /applications/accounting/data/DemoOrganizationData.xml - All glAccounts are predefined [GlAccount] and can be viewed on the globalGlSettings->chartOfAccounts screen.
demo file at /applications/accounting/data/DemoGeneralChartOfAccounts.xml - Load the Sales/purchase InvoiceItemType table and default glAccountId general setup for all organizations.
demo file at /applications/accounting/data/DemoGlSetupData.xml
Organizational Setup (accounting -> organizational settings -> setup).
- The predefined glAccounts are assigned to an organization [GlAccountOrganization] on screen chartOfAccounts (this file can only be loaded and not changed)
demo file at /applications/accounting/data/DemoGlSetupData.xml - if required override the invoiceItem type type assignement for a particular organization at the glAccountDefaults->SalesInvoice/PurchaseInvoice
- Enter/load the payment TYPE GlType Mapping file [PaymentGlAccountTypeMap] at
glAccountDefaults->PaymentTypeGlMapping - Enter/load the payment METHOD GlType Mapping file [PaymentMethodTypeGlAccount] at
glAccountDefaults->PaymentMethodTypeGlMapping
Creating ledger transactions.(to be completed)
- Sales invoice
- Purchase invoice
- Incoming payment
- Outgoing payment
- Inventary adjustment
- Workeffort costs
Marketing overview
Anchor | ||||
---|---|---|---|---|
|
text now maintained within ofbiz, check
Category Setup
As described in the Catalog Setup section there are various basic Categories that we need to create for our new Catalog. We will create four categories:
1. A Browse Root Category
2. A top-level browse Category to be a child of the browse root category
3. A Promotions Category
4. An "All Products" Category that will be setup as the Default Search, Purchase Allow and View Allow categories for our catalog.
To Create a Category:
1. Go to the "Main" in the Catalog Manager and click on the link labeled "Create New Category" near the top of the central area of the page.
2. Enter an ID for the Category in the Product Category ID field (this cannot be changed later).
3. All of these categories can use the "Catalog" setting for the Product Category Type field.
4. The other fields can be set, but are not necessary. Note that Category hierarchies do not use the Primary Parent Category field, instead they are done with the Rollup tab once the Category is created.
5. Submit the form by clicking on the update button.
Once the Category is created go to the Content tab and look near the bottom of the page in the Override Simple Fields section to set a Description, and if desired also a Long Description.
For each of the categories that we are creating, go to the Catalogs tab in the Category section, or the Categories tab in the Catalogs section and associate them using the appropriate type(s) as described above.
For the top-level browse Category that will be a child of the Browse Root Category associate them using the Rollup tab for whichever one you create second. Both parent and child categories can be setup there.
Product Setup
Congratulations, you are finally to the point where you can start setting up products....
To create a Product follow a process similar to those described for other things, like Categories.
1. Go to the main page of the Catalog Manager and click on the "Create New Product" link.
2. If you fill in an ID it will make sure that ID is valid, and if so it will use that one. If you specify no ID it will generate one.
3. Set an Internal Name that makes it easy for you to recognize the product. This name will be shown in the admin tools, but not to the customer.
4. Note that if you are using the UPS or USPS or other online rate estimation utilities then you must have values in the "Weight" and "Weight Uom Id" fields.
5. Submit the form to create the product.
Wiki Markup |
---|
Add Content to the New Product
1. Click on the "Content" tab/button for the product you just created. Here you can setup text and images for your product.
2. You will see some forms at the top for administering managed content (ie from the Content Manager) with the product. For more advanced product related content needs use this, but for more common and simple needs, this can be more difficult to administer and slower at run time.
3. Near the bottom of the page is a section labeled "Override Simple Fields". Here you will typically want to specify a Product Name, Product Description, and Long Description. If you have images to associate with the product, you can specify their locations here, or upload them. Note that there are default locations for the images (can be quickly set by clicking on the "\[.jpg\]" or "\[.gif\]" buttons). We recommend using these locations, but of course you can put your images anywhere. These can be an absolute URL, or will be relative to the current server address, or the content URL prefix if one is specified in the url.properties file. |
Add Prices to the Product
1. Product pricing in OFBiz is very flexible. There are two main aspects to it: Prices and Price Rules. This is independent of promotions, which are applied after the price calculation is done.
2. For basic operation you should have at least one type of price setup for each product: the Default Price. This is the price that is used when no rules apply.
3. To add a Default Price go to the Prices tab for the Product, and use the form at the bottom of the page.
ß The Product Price Type Id should be "Default Price", the Currency Uom Id should be whatever currency the price is in, and the Product Store Group Id can be left as Not Applicable, unless you are setting up multiple groups of stores that have different pricing.
ß The From Date can be now or in the future, if you want the price to take effect in the future. The Thru Date is optional, but can be used to specify that this particular price expires at a certain date and time. Note that if there are multiple prices of the same type, etc that are active at once, it will use the one with the most recent From Date. This is useful when you want a temporary price to override the normal "Default" price of the product.
4. If you are using price rules or may do so in the future you may also want to enter information such as the List Price and the Average Cost which are often used in the price calculations.
5. Note that if a Minimum Price is set the price will never be less than that. So, even if the Default Price is to 2.00 and the Minimum Price is set to 3.00, then 3.00 will be used as the calculated price. The Maximum Price setting works the same way as the ceiling for the price.
Make sure to put each product in a browse category, and in the All Products category so that it can be searched for, viewed, and purchased in your catalog.
Expert Recommendation: These are the basics, but there is a lot more information about products that you can, or may need to, setup. We recommend reviewing the more detailed documentation or engaging the services of an experienced consulting to help you through this.
Advanced Catalog Setup: Features, Promotions, Price Rules, Keyword Thesaurus, Features for special functionality or parametric search, Moderated (or unmoderated) Product Reviews, Configurable and Manufactured Products, Virtual and Variant Products, Inventory/Facility/Location settings, and so on
See the end-user documentation space for details on how to set these things up and what they mean. Also see this for more advanced options for Products, Categories, and so on.