Can I create custom options in my pricing engines that will not be visible to the user when ordering but that will show on the order details once the order has been placed?

Using either the Pricing Calculator or Pricing Spreadsheet price engine methods, you can assign values to the order that will not be visible to the user when placing the order, but that will be included in the order data and visible on the order reports.

 

Both of the pricing engines below have the same options and values and appear identical when using the pricing engine, and produce the same output in the order reports. A value called Sheets is assigned as a pricing attribute based on user choices, and is included in the resulting order information.

The pricing calculator uses multiple calculator rows (21-28) that respond to different quantities by matching to a minimum and maximum quantity range. Based on the range of the quantity, a Pricing Attribute is chosen and included with the order. The Pricing Attributes are assigned with a format of LABEL=VALUE, so the pricing attribute is assigned as Sheets with the number of sheets indicated depending on the quantity entered. 

 

 

Note that the calculator rows and their minimum and maximums must match to the quantity the sheet is setup for, or an error will be seen when testing the calculator. Meaning that if we needed to raise the maximum quantity on the calculator to 64, we would need the appropriate number of new calculator rows created to assign the pricing attribute of sheets correctly to any amount.

 

The Price Attribute is included in the order data and the resulting order report under the Pricing/Product Attributes area for the order item:

You can download the pricing calculator Excel file here and use it as you like.

 

The spreadsheet calculator uses a calculation assigned to a field to pickup on the quantity in field C6 and divides that by 4 to get the number of sheets. In the setup for the price engine, that cell is referenced in the Attribute Cells area. When the client uses the calculator and enters a quantity, the Sheets value is calculated dynamically from the quantity, rather than having to use many calculator rows.

 

 

The Price Attribute is included in the order data and the resulting order report under the Pricing/Product Attributes area for the order item:

You can download the pricing spreadsheet Excel file here, and use it as you like, but the setup is different for a spreadsheet calculator and you will need the values below to set it up when creating the pricing engine.

 

 

Output Cells
C3
C4


Qty Parameters
B6,C6,E6:F6


Other Parameters
B10,B11,B12:B17,


Attribute Cells
B8,C8