BLOG

NEXT STEPS

Posts Tagged ‘OFBiz Tutorials’

OFBiz Tutorials: Manage Suppliers for a Product

Wednesday, January 26th, 2011

To continue on the various applications of the OFBiz Catalog Manager, today we will dive into the world of managing Manufacturers and Suppliers of specific products.

Many times there are more than one supplier for a product, so we will learn how to create a new supplier as a preferred or alternate supplier.  Once that supplier has been set up and is available in the Catalog Manger, we can then associate the product or products with the supplier.

Create Supplier(s)

Let’s first talk about prerequisite for managing this part of the catalog:

The user must at least have the role of catalog manager.  There are other roles that they can have that encompass catalog management, but they must have the ability to go here and manage this content.

The product(s) should already exist in the system.

Now that we know the requirements, we can begin creating a new supplier:
Go to “Catalog” component and click on “Products” tab.

ofbiz-tutorial-supplier-1

Fill in the search fields on “Find” Form to search existing products in system.

ofbiz-tutorial-supplier-2

Click on the “Find” button and the system will display a list of existing products based on search inputs.

ofbiz-tutorial-supplier-3
Click on “Product Id” displayed as search list on Products Page.

ofbiz-tutorial-supplier-4

Product details will be displayed on the “Edit Product” page.

Ofbiz Tutorial Supplier 5
Click on “Suppliers” tab.

ofbiz-tutorial-supplier-6

Click on “Create New Supplier” button in Add Supplier section.

ofbiz-tutorial-supplier-7

Fill in the following details in “Create New Supplier” form:
Group Name
Employees
Office Site Name
Address 1
Address 2
City
State
Zip/Postal Code
Country
Country Code
Area Code
Phone Number
Ext
Email

Ofbiz Tutorial Supplier 8
Click on the “Save” button.

ofbiz-tutorial-supplier-9

As a result of this, the supplier’s profile will get displayed on the “Product and Catalog Manager” Page.

Associate Supplier with the Product

Now that we have the supplier entered in, we can associate the supplier with the product(s).

To review, there are a few prerequisites to accomplish this:

The user must at least have the role of catalog manager.  There are other roles that they can have that encompass catalog management, but they must have the ability to go here and manage this content.

The product(s) should already exist in the system.

The Supplier(s) should already exist in the system.
If the above prerequisites have been met, we can associate the Supplier(s) to the product with the following steps:
Go to the “Catalog” component and click on the “Products” tab.

ofbiz-tutorial-supplier-1

Fill in the search fields on “Find” Form to search existing products in system.

ofbiz-tutorial-supplier-2

Click on the “Find” button and system will display the list of existing products based on search inputs.

ofbiz-tutorial-supplier-3

Click on “Product Id” displayed as search list on Products Page.

ofbiz-tutorial-supplier-4

Product details will be displayed on the “Edit Product” page.

Ofbiz Tutorial Supplier 5

Click on “Suppliers” tab.
ofbiz-tutorial-supplier-6

Fill in the following details in “Add Supplier” form:
Supplier Preferred Order
Supplier
Supplier’s Product Name
Supplier’s Prod Id
Available From Date
Expected Delivery Time in Days
Min Order Quantity
Last Price
Drop Ship (Select this check box only when supplier allows drop shipment for that particular product).

Ofbiz Tutorial Supplier 16

Click on “Add Supplier” button.
ofbiz-tutorial-supplier-17
At this point, the Added Supplier will get displayed on the Suppliers page.

Edit Supplier(s)

The last portion of managing the Supplier(s) for a product is being able to edit the Supplier details:

The prerequisites for this task are:

The user has the role of at least Catalog Manager

At least one Supplier has been associated with the product.

If these have been met, lets edit the Supplier details.
Go to “Catalog” component and click on the “Products” tab.
ofbiz-tutorial-supplier-1

Enter values in the search fields on “Find” Form to search existing products in system.
ofbiz-tutorial-supplier-2

Click on the “Find” button and the system will display the list of existing products based on search inputs.
ofbiz-tutorial-supplier-3

Click on the “Product Id” displayed as a search list on Products Page.
ofbiz-tutorial-supplier-4

Product details will be displayed on the “Edit Product” page.
Ofbiz Tutorial Supplier 5

Click on the “Suppliers” tab.
ofbiz-tutorial-supplier-6

Click on “Edit” link to edit the supplier on Supplier page.

Update existing supplier details and use the “Add Supplier” button to save the changes.
ofbiz-tutorial-supplier-17

Use the “Remove” button to remove existing suppliers.
ofbiz-tutorial-supplier-25

The expected outcome of this is that all the changes will be reflected on the “Supplier” page.

Stay in the know about OFBiz- More OFBiz tutorials to come in the not too distant future – stay tuned!

Tim Ruppert is Chief Operating Officer at HotWax Media, an OFBiz service provider, as well as an OFBiz project committer and active community member. Tim will join other HotWax Media employees and advisers in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

OFBiz Tutorial: Assign GlAccount to Organization

Wednesday, January 5th, 2011

Building off my last OFBiz tutorial, I will demonstrate how to Assign GlAccount to Internal Organization. Its an act of defining the Chart Of Accounts (CoA) for given internal organization. The same GlAccount can be assigned to one or more then one internal organizations. For example, the global CoA may contain 100 different GlAccounts but only 20 need to be used for your specific business. This means you need to only create assignments for GlAccounts you actively want to use.

Go to the “Accounting Manager” application and click on the “ Organization Gl Settings ” Menu.

Ofbiz-tutorial-Organization-1

List of avialable Internal Organization will be displayed. To manage Internal Organization accounting setup, click on Setup button. On the next screen select Chart of Accounts tab.

ofbiz-tutorial-Organization-2

To assign GlAccount, select GlAccount from drop down and just click on create assignment tab.

ofbiz-tutorial-Organization-3

The bottom part of screen shows all GlAccounts assigned to the internal organization.

ofbiz-tutorial-Organization-4

Stay tuned, for upcoming Ofbiz tutorials to learn how you can use open source ERP for managing your business.

- Anil

Anil Patel is Chief Development Officer at HotWax Media as well as an OFBiz project committer, PMC member, and active community contributor. He also studies karate! Anil will join other HotWax Media employees and advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

OFBiz Tutorial: Associating Product with Multiple Categories

Wednesday, December 8th, 2010

Building off of other OFBiz catalog manager tutorials that have been posted earlier, today we will look into how you can associate a product with multiple categories.  This will be broken down into two sections: adding a product into a category, and then updating the product category association.

Add Product to a Category

Let’s first talk about prerequisite for managing this part of the catalog:

The user must at least have the role of catalog manager.  There are other roles that they can have that encompass catalog management, but they must have the ability to go here and manage this content.

The data must be setup so that the product’s association type is modeled correctly in the system.  Basically what this is saying is that some association types, while they may look like they would fit in here, will not have the product show up correctly on the front end if you do not do this properly.

Now that we know that – let’s discuss associating a product with a category.

Go to the “Catalog” component and click on the “Advanced Search” Button within “Search Products”.

ofbiz-tutorial-cross-sell-1

Fill in the search values on the “Find” screen and click on the “Find” button.

Ofbiz Tutorial Cross Sell 2

A list of products will be displayed based on the search criterion.

Ofbiz Tutorial Cross Sell 3

Click on any of the products and the “Edit Product” page of the selected product will get displayed.

Ofbiz Tutorial Cross Sell 4

Click on the “Categories” tab.

categories-tab

Fill in the following details in the “Add Category for this Product” form :
category-look-up

  1. Category
    • Select “Category” from look up which contains following information :
      • Product category Type Id
      • Primary Parent Category Id
      • Category Name
      • Description
      • Show In Select
  2. From Date
  3. To Date
  4. Comments
  5. Sequence Number
  6. Quantity

category-fields

Click on the “Add” button after entering the information.

add-button

At this point the added “Category” will be displayed in “Categories” section with the following details:

  • Category
  • From Date
  • To Date
  • Comments
  • Sequence Number
  • Quantity

categories-section

Update Product Category Association

Now that you can add product to a category, let’s discuss how you can edit this information in OFBiz. The prerequisites are exactly the same as for adding product to a category except to edit it, you need to have the product associated with a category.

Here are the steps for updating the product category association:

Go to the “Catalog” component and click on the “Advanced Search” Button within “Search Products”.

ofbiz-tutorial-cross-sell-1

Fill in the search values on the “Find” screen and click on the “Find” button.

Ofbiz Tutorial Cross Sell 2

A list of the products will be displayed based on the search criterion.

Ofbiz Tutorial Cross Sell 3

Click on any of products and the “Edit Product” page of the selected product will get displayed.

Ofbiz Tutorial Cross Sell 4

Click on the “Categories” tab.
categories-tab

Following details will be displayed in “Categories” section of added category:

  • Category
  • From Date
  • To Date
  • Comments
  • Sequence Number
  • Quantity

categories-section

Update existing category details.

category-update

Click on the “Update” button to save the details.

ofbiz-tutorial-cross-sell-11a

Use the “Delete” button to delete the category association – if necessary.

delete-button

Now your updated category details will be displayed on the “Categories” section of “Category Members” page.

More OFBiz tutorials to come in the not too distant future – stay tuned!

Tim Ruppert is Chief Operating Officer at HotWax Media, an OFBiz service provider, as well as an OFBiz project committer and active community member. Tim will join other HotWax Media employees and advisers in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

OFBiz Tutorial: Adding GlAccount to Chart of Accounts

Monday, November 22nd, 2010

Today we will be diving into how one can add GLAccount to Chart of Accounts (CoA) in OFBiz using UI tools. Before you try the steps listed in this OFBiz tutorial, make sure you have a user account with Account Manager role assigned to it.

Go to the “Accounting Manager” application and click on the “Global GL Settings ” menu and then select “Chart of Accounts”, Existing GLAccount list will be shown.

A user can add a New GLAccount to CoA by clicking on the Navigate Accounts tab. The screen shows CoA in a tree structure.

The bottom part of the screen has a form for adding and editing GLAccount.

Fill in the required information for the new GLAccount, click on the “Add” button to add the GLAccount to your CoA. The new GlAccount will be added in Chart of Accounts, you can view it in the CoA tree.

Moving towards the Next Step which is editing GLAccount, Select GLAccount from CoA tree, GLAccount will be available for editing in edit form below the tree. Make necessary changes and save.

Stay tuned with the OFBiz tutorial to get more examples for your own Business Domain.

-Anil.

Anil Patel is Chief Development Officer at HotWax Media as well as an OFBiz project committer, PMC member, and active community contributor. He also studies karate! Anil will join other HotWax Media employees and advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

OFBiz Tutorial:Use Dependent Selects to Manage Country-State Select Boxes

Wednesday, July 14th, 2010

Javascript components for managing Dependent Selects is starting to find use in ecommerce applications we are developing. It all started with need for updating contents of State field, on change of Country in postal address forms.

More then a year ago we started using Ajax for updating State select box options on change of Country select box value. It was a step forward but I wasn’t satisfied. Recently I had time to build a Dependent Select javascript component that takes the process of managing dependent selects boxes to the next level. Please read my blog post, OFBiz Tutorial – Dependent Selects for Prototype, to know more about it. If you are wondering about a scenario from real world, Here you go.

Below is the piece of code from the Freemarker template for the Checkout page in OFBiz ecommerce application.  It renders Country and State select boxes with their options.

?View Code LANGUAGE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<div>
      <label for="shipToCountryGeoId">Country</label>
<select id="shipToCountryGeoId" class="required select dependentSelectMaster" title="shipToCountry" name="shipToCountryGeoId">
        <option title="${country.geoId}" value="${country.geoId}">${country.get("geoName")?default(country.geoId)}</option>
        <!--#list-->
      </select></div>
<div id="shipToStates">
      <label for="shipToStateProvinceGeoId">State</label>
<select id="shipToStateProvinceGeoId" class="required shipToCountry" name="shipToStateProvinceGeoId">
        <option class="${country.geoId}" title="${stateAssoc.geoId}" value="${stateAssoc.geoId}">&lt;#if shippingAddress.stateProvinceGeoId?has_content &amp;&amp; shippingAddress.stateProvinceGeoId?default("") == stateAssoc.geoId&gt; SELECTED <!--#if-->&gt;${stateAssoc.geoName?default(stateAssoc.geoId)}</option>
            <!--#list-->
          <!--#if-->
        <!--#list-->
      </select></div>

Following Javascript code will unobtrusively manage the relationship between Country select box (master) and State select box (slave),

?View Code LANGUAGE
1
2
3
$('checkoutPanel').select('.dependentSelectMaster').reverse().each( function (elt) {
  new Dependent( $$( '.'+elt.title ).first() , elt );
})

Where ‘checkoutPanel’ is Id of wrapper div that encloses checkout html form. Apply ‘dependentSelectMaster’ class to select boxes that have dependent slave elements, making them the master. Slave select box is related to its master using title and class attribute of elements, A select box is slave if it has a class applied to it that is equal to title of master select box.

The javascript code snippet traverses DOM tree looking for master select boxes. Using title attribute of master select it finds all the slaves and creates Dependent select relationship between them. Its all clean and simple.

Needless to say, you’ll need to include Prototype.js and DependentSelect.js in your webpage. I hope you will find this short OFBiz tutorial useful.

- Anil

Anil Patel is Chief Development Officer at HotWax Media as well as an OFBiz project committer, PMC member, and active community contributor. He also studies karate! Anil will join other HotWax Media employees and advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.