Implement dynamic pricing

PRO This is a Pro only feature.

You can create a component whose pricing changes based on the type of material or size of component the user chooses. To implement dynamic pricing in your dynamic component:

  1. Create a component, such as a cabinet door.

  2. Context-click on the component. The component's context menu is displayed.
  3. Select the Dynamic Components > Component Attributes menu item. The Component Attributes dialog box is displayed. Notice that the top-level component is listed.
  4. Click on the add attribute button in the last row of the component. A drop-down list of attributes appears.
  5. Click on the Material attribute in the list. The field is populated with the word 'Material' and the field next to the Material attribute is opened for editing.
  6. Click on the Details button to the right of the Material value. A drop-down list of display rules appears.
  7. Select Users can select from a list from the 'Display rule' drop-down list. The Display label and a table appear. The following image shows the Display rule drop-down list, Display label field, and table.

  8. Replace the word Material with Wood Type in the 'Display label' field.
  9. Click the Add option icon in the List Option column of the table. A row is created with the field in the List Option column open for edit.
  10. Type Cherry in the 'List Option' field. This text will appear in a drop-down list in the Configure Options dialog box.
  11. Press the Tab key.
  12. Type Wood_Cherry_Original in the 'Value' field. This is the name of a specific material in the Materials Browser.
  13. Press the Tab key to accept the value.
  14. Plywood, Wood_Plywood_Knots

    15. The following image shows the attribute details panel with all completed fields:

  15. Press the Apply button. The attribute details panel closes.
  16. Click on the Add attribute button in the last row of the component. A drop-down list of attributes appears.
  17. Type Cost and press the Tab key. An attribute named 'Cost' is placed in a list of attributes called 'Custom.' The field next to the Cost attribute is opened for editing.
  18. Type =if(MATERIAL="Wood_Board_Cork", 40.00, if(MATERIAL="Wood_Cherry_Original",60.50,15.25))
  19. Press the Tab key to accept the formula. This formula assigns a cost for the door based on the material (wood) that is selected by the user.
  20. Click on the Close button.
  21. Context-click on the component. The component's context menu is displayed.
  22. Select the Component Options menu item. The Component Options dialog box is displayed. The following is an image of the Component Options dialog box for the Television dynamic component:

    23. Choosing different Wood Types from the drop-down list not only changes the SketchUp material applied to the component (to reflect the wood type), but changes the MSRP of the door to reflect the wood type.

    You can also use the CHOOSE and OPTIONINDEX functions in place of nested if statements (as in step 17). For example:
    MSRP =CHOOSE (OPTIONINDEX("MATERIAL"), 40, 60.50, 15.25)

    In the previous example, if the first choice in a drop-down list of materials is chosen (Cork), the price $40. If the second choice in a drop-down list of materials is chosen (Cherry), the price is $60.50. And, if the third choice in a drop-down list of materials is chosen (Plywood), the price is $15.25.

    Was this article helpful?