View source | View content page | Page history | Printable version   

Projects:Product Attributes/Functional Specification




The purpose of this project is to implement the same features Openbravo ERP has for product attributes. This is a valuable feature for clothes shops that need the size and color attributes to track the inventory, the serial number of electronic products, etc...

The synchronization of product attributes and inventory is detailed in the Improvement of Synchronization Functional Specification document.



Design Considerations


This functionality may not modify the current functionality of Openbravo POS and may not include complexity in the product if the Openbravo POS user decides not to use the product attributes functionality, i.e. If the user does not want to use the product attributes functionality he should not do extra steps, or find differences in the logic of the application or in reports. It is acceptable that this user may see new buttons, text fields or menu options related to attributes that he is not going to use.

This functionality must be capable to manage:


This feature in Openbravo POS depends in the product attributes implementation in Openbravo ERP. It will not contain all the functionality included in Openbravo ERP but the tables and fields used to describe attributes and the logic used must be the same in order to make it easier to synchronize data and to help users to understand the attributes functionality in both products.



Functional Requirements

User roles & profiles

System managers
Typically these users have a high level of professional education, are computer literate and receive training in the product and business process. These users perform administrative tasks, execute reports, and taking into account in business decisions.
Sales managers
Typically these users have a high level of professional education but might not be computer literate. These users performs operational tasks or high privileged tasks like perform refunds, receive goods, close the cash, ...
Generic employee
Typically these users do not have a high level of professional education and might not be computer literate. These users usually performs sales orders and take the money.

Business process definition

New windows to define attributes and attribute sets.

New dialog to assign attribute values in each inventory movement like sales.

Inventory reports redesign.

User stories

Functional requirements based on business processes

Requirement Importance Status Estimated time Comments
A window to administer the attributes and the attributes set available for products. Must have Not started 4d The window to administer attributes is a basic edition window that edit the attributes table. The window to administer attributes set is a basic edition window that edit the attributes set table. This window also have a panel that edit the attributes available in each attribute set.
A new field entry in the products window to assign the attribute set for each product. Must have Not started 2d This new field is a combo list that allows to select an attribute set or let the field empty.
A new dialog in the Sales window, Stock diary and Stock maintenance to allow to set the attributes values for each line. Must have Not started 4d This dialog displays all the attributes of the attributes set of the product line that allows to edit the attributes values of the line.

To allow to edit the value of attributes using not only a text field but also a drop down list Nice have Not started 4d This feature implies to modify the dialog that edit attributes values and a new window to edit the available values for each attribute.
Modify the inventory reports, Must have Not started 4d Warehouses, Current inventory, Current inventory broken, and Inventory diary to take into account the new attributes set values in the inventory tables.

User Interface Mockups

Technical Requirements

Tables needed

ATTRIBUTE (ID, NAME) Attributes available for products

ATTRIBUTEVALUE (ID, ATTRIBUTE_ID, VALUE) Available values for each attribute

ATTRIBUTESET (ID, NAME) Each set of attributes that can be assigned to each product

ATTRIBUTEUSE (ID, ATTRIBUTESET_ID, ATTRIBUTE_ID, LINENO) Table that relates the list of attributes of an attribute set.


ATTRIBUTEINSTANCE(ID, ATTRIBUTESETINSTANCE_ID, ATTRIBUTE_ID, VALUE) Each value of each attribute for each attribute set instance.

Tables modified

PRODUCTS(ATTRIBUTESET_ID) Add the attribute set field to products table

STOCKCURRENT(ATTRIBUTESETINSTANCE_ID) Add the attribute set instance to the stock current table

STOCKDIARY(ATTRIBUTESETINSTANCE_ID) Add the attribute set instance to the stock current table

TICKETLINES(ATTRIBUTESETINSTANCE_ID) Add the attribute set instance to the ticket lines table

Non-Functional Requirements

Open Discussion Items

Closed Discussion Items

Retrieved from ""

This page has been accessed 10,561 times. This page was last modified on 8 June 2012, at 05:29. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.