Difference between revisions of "Product Attributes"

Revision as of 20:16, 28 December 2012

⇐ Table of Contents#System Administrator's Guide{{#if: Product Setup| | Product Setup }}{{#if: | | [[{{{3}}}]] }}{{#if: | | [[{{{4}}}]] }}{{#if: | | [[{{{5}}}]] }} | Product Attributes{{#if: Warehouse Setup| | Warehouse Setup }} ⇒

Product attributes provide additional information about a product that may be helpful in finding, selecting, or tracking certain products. Attributes are defined and grouped in sets that are applied to products. An attribute set can have an instance that is specific to one or more physical products.

Model

Product Attributes enrich the information about products and provide additional ways in which the products can be defined and managed. The attributes can be thought of as specifications of the product. A collection of attributes is called an attribute set and the attribute set is applied to specific products as required. The attribute set can include information on the lot, serial number, and guarantee date of the product.

Product attributes allow the product name, value, SKU and UPC fields to be kept short, since the information about the nature of the product can be defined in the attributes.

The attributes can also be used in product searches based on the attribute values. For example, find all resistors in stock that have a rating of 100KOhms and a rectangular two-terminal surface mount package (0201). An electronic manufacturer could easily have ten or more different products in inventory that match this search.

When attributes are defined for a product they can be for a variety of products or specific to a group of products. An example of a specific attribute is a serial number. Only one item in the entire inventory of that product has that attribute. This sort of information is called an Attribute Set Instance.

Instance attributes can apply to one or more specific items. There are three elements of instance attributes that can be assigned to an attribute set:

• a lot number or code
• a serial number
• a guarantee date

In addition, other information in the attribute set can be defined as an instance attribute.

Instance attributes are typically defined at the time that product or item enters or leaves the control of the company, such as at production, material move, inventory counts, material receipts, or material shipments. Some instance information, such as the specifications, can be defined and attached to the product and more specific information, like lot numbers, guarantee dates and serial numbers, can be defined at production or receipt.

Example: Fertilizer in Garden World

Garden World sells lawn fertilizer in 50 and 70kg bags. They want to expand this to a variety of formats (50 or 70 Kg bags, cubic yards), chemical specifications, and base compost (chemical, manure, mushroom, peat). Each product has a lot number and a guarantee date. Each of these things represents an attribute of the fertilizer product. Collectively, they represent an attribute set and, with a specific lot and guarantee date defined, they represent an instance of the attribute set.

The demo database has an attribute set defined for Fertilizer Lot and that needs to be expanded to include the format, chemical specs and base compost. This is done by defining attributes for each of these items as follows:

• Open the {{#if: Attribute|Attribute|Attribute }} Window window and create new attributes as follows:
  • New Attribute - Package
    • Name: Pkg
    • Description: Fertilizer Package
    • Attribute Value Type: List
    • Instance Attribute: checked
    • Attribute values
      • New Value - 50Kg
        • Key: 50Kg
        • Name: 50Kg
        • Description: 50 Kilogram bag
      • New Value - 70Kg
        • Key: 70Kg
        • Name: 70Kg
        • Description: 70 Kilogram bag
      • New Value - Cubic Yard
        • Key: CY
        • Name: CY
        • Description: Cubic Yard
  • New Attribute - Chemical - Nitrogen
    • Name: N
    • Description: Nitrogen
    • Attribute Value Type: Number
    • Instance Attribute: checked
  • New Attribute - Chemical - Phosphorous
    • Name: P
    • Description: Phosphorous
    • Attribute Value Type: Number
    • Instance Attribute: checked
  • New Attribute - Chemical - Potassium
    • Name: K
    • Description: Potassium
    • Attribute Value Type: Number
    • Instance Attribute: checked
  • New Attribute - Base
    • Name: Base
    • Description: Base Component
    • Attribute Value Type: List
    • Instance Attribute: checked
    • Attribute values
      • New Value - Chemical
        • Key: Chem
        • Name: Chem
        • Description: Chemical
      • New Value - Manure
        • Key: Man
        • Name: Manure
        • Description: Manure
      • New Value - Mushroom
        • Key: Mus
        • Name: Mushroom
        • Description: Mushroom
      • New Value - Peat
        • Key: Peat
        • Name: Peat
        • Description: Peat

Next, open the {{#if: Attribute Set|Attribute Set|AttributeSet }} Window and find the attribute set "Fertilizer Lot". Note that the attribute set contains a lot number and a guarantee date. Add the new attributes to this attribute set.

Clear the cache or log out and in before continuing.

Now, open the {{#if: Product|Product|Product }} Window and find the Fertilizer #50 product. Note that the attribute set is already defined as Fertilizer Lot. Click on the button in the Attribute Set Instance field and set the attributes for the Fertilizer #50 product. Specifically, set these to:

• Pkg: 50Kg
• N: 10
• P: 20
• K: 15
• Base: Chem

Note that the lot and guarantee dates do not appear on this window. They will be set later.

Now we have to make some fertilizer that meets these specs. We will do this with the {{#if: Production|Production|Production }} Window window. Create a new production header and save it. Then move to the {{#if: Production Plan|Production Plan|ProductionPlan }} Tab and select Fertilizer #50 as the product and a quantity of 20. Set the Locator to Fertilizer and save the record. Move back to the {{#if: Production Header|Production Header|ProductionHeader }} Tab and click the "Create/Post Production" button. This will pull the BOM from the product window and fill the {{#if: Production Line|Production Line|ProductionLine }} Tab.

Move to the {{#if: Production Line|Production Line|ProductionLine }} Tab and find the Fertilizer #50 product. Note that the Attribute Set Instance field is blank. Click the Attribute Set Instance button and a form will appear.

In this dialog, the lot number and guarantee date can be set and the logical place to do this is in the production process. Close the dialog and note that the Attribute Set Instance is filled in. Save the record.

Back on the {{#if: Production Header|Production Header|ProductionHeader }} Tab and click the "Create/Post Production" button again to complete the process. The new product will appear in the Fertilizer locator.

Open the Product Info window to see the attributes available.